Job application tracker spreadsheet (free Excel + Sheets)

A job application tracker spreadsheet needs eight columns: company, role, posting URL, date applied, stage, resume version, contact, and next follow-up. Add a dropdown on the stage column, one conditional formatting rule to flag stale rows, and a few formulas, and you have everything the template sites are selling. You can download ours below, free and with no email gate, or build it yourself in about 10 minutes; the full build is on this page.

Download the template

Download the tracker (Excel, .xlsx). It opens in Excel as is. For Google Sheets, upload the file to Google Drive and open it with Sheets, or in a blank Sheet choose File, then Import, then Upload; the dropdown, the amber rule and every formula carry across.

What's in it: a Tracker tab with the eight columns below plus two computed columns (days since applied, and a DUE flag for follow-ups), a Dashboard tab with response rate, weekly pace, active pipeline, a count by stage and a line that tells you when you've passed 10 active applications and should move to a dedicated tracker, and a Start here tab that explains the three things people get wrong. Two example rows show the format; delete them. There is no salary column, no notes column and no macro, on purpose.

If you'd rather build it than trust a download, everything below is exactly what the file contains, formula for formula.

What goes in a job application tracker spreadsheet

Eight columns, A through H. Each one either triggers an action or explains a result; the reasoning behind the set is in our guide to how to track job applications.

Skip salary and notes columns for now. They're harmless, but neither ever tells you to do anything, and a lean sheet gets opened more often than a wide one.

How to build it in 10 minutes

1. Type the eight headers into row 1 and freeze the row (View, then Freeze, then 1 row).
2. Select column E and add the stage dropdown: Data, then Data validation, criteria "Dropdown", with the values Saved, Applied, Screening, Interviewing, Offer, Rejected.
3. Format columns D and H as dates (Format, then Number, then Date) so the math below works.
4. Add the stale-row rule. Select A2:H500, open Format, then Conditional formatting, choose "Custom formula is", and paste:

=AND($E2="Applied", $D2<>"", TODAY()-$D2>=14)

Pick an amber fill. Any application still sitting in Applied 14 days after you sent it now lights up on its own.

5. When you log an application, set the follow-up date in the same breath: in H2, enter =D2+7, then overwrite it with a real date whenever the posting gives you a timeline.

That's the whole build. A filter on row 1 (Data, then Create a filter) is a nice extra for sorting by stage or follow-up date.

How to use it

Five minutes a day: add anything you applied to, and clear any follow-up you sent by advancing its date or stage. Log the application the moment you submit it, not at the end of the day; postings vanish fast, and the URL in column C is often the only surviving copy of the job description you'll want before an interview.

Twice a week, run the 20-minute review from our tracking guide: scan stages, send the follow-ups that are due, and chase or close every amber row. The sheet only pays off if it's open when you apply, so pin the tab.

Formulas worth stealing

Four formulas turn the sheet from a list into an instrument. All four work in Google Sheets and Excel.

Response rate. The share of sent applications that got any human response, counting rejections, because a rejection is a response and belongs in the denominator's story:

=(COUNTIF(E2:E,"Screening")+COUNTIF(E2:E,"Interviewing")+COUNTIF(E2:E,"Offer")+COUNTIF(E2:E,"Rejected"))/(COUNTA(E2:E)-COUNTIF(E2:E,"Saved"))

Put it in a spare cell, format as percent. If it sits very low after 20 or so applications, the resume or the targeting needs work before more volume does.

Days since applied. In I2, fill down:

=IF($D2="","",TODAY()-$D2)

Sort by this column descending during your weekly review and the neglected rows surface themselves.

Overdue flag. In J2, fill down:

=IF(AND($H2<>"",$H2<=TODAY(),$E2<>"Offer",$E2<>"Rejected"),"DUE","")

Filter column J for "DUE" and you have your follow-up worklist for the day.

Applications this week. A pace check for a spare cell, useful when a search drags and you can't tell whether the problem is output or luck:

=COUNTIFS(D2:D,">="&TODAY()-7)

If the number sags for two straight weeks while the response rate holds steady, the fix is volume. If volume holds and responses don't, the fix is the resume.

Where spreadsheets break

We'll be straight about the limits, because we run into them with our own users constantly.

• The manual entry tax. Copying company, title, URL, and date for every posting takes a couple of minutes per job. At two applications a day that's manageable; at ten it's the reason the sheet stops getting opened.
• No capture. The sheet can't see the job boards. Every posting you don't log immediately is a posting you'll half-remember later, usually after it's been taken down.
• Resume version drift. Column F only works if you name files carefully and update it every single time. One "resume_final_v3_NEW.docx" and the audit trail is gone.
• No reminders. Conditional formatting highlights rows, but only while the sheet is open. It can't reach you. The system depends entirely on you showing up twice a week.

None of this makes the spreadsheet a bad choice. It makes it a choice with a ceiling.

Spreadsheet vs tracker app: the honest cutover point

Under 10 active applications, this sheet is enough, and we'd rather you use it than pay anyone, including us. A spreadsheet you maintain beats an app you abandon, and at low volume the manual entry tax stays affordable. The cutover triggers are the same three we give in the tracking guide: more than 10 active rows, the first follow-up you discover you missed, or the first time column F can't tell you which resume a company actually saw. When one of those hits, read our job application tracker comparison and pick a dedicated tool; which one depends on whether you need autofill, a resume builder, or match scoring.

FAQ

Google Sheets or Excel?

Google Sheets, unless your job search files already live in Excel. The formulas above work in both, but Sheets is free, autosaves, and follows you to any machine, which matters for a document you need to open daily for months.

Do I need a template, or should I build it myself?

Either works, and ours is the same thing both ways: the download above is exactly the build described here, eight headers, one dropdown, one formatting rule and four formulas, with nothing added. Most downloadable templates ship columns you'll never use, and every extra column is friction on the daily 5 minutes; if you grab a different template, delete the columns that never tell you to do anything.

How do I track rejections without them cluttering the sheet?

Set the stage to Rejected and leave the row alone; don't delete it. Rejected rows feed the response-rate formula and tell you which stage your search is losing at. If the clutter bothers you, filter the stage column to hide them during daily use.

Can the spreadsheet calculate my response rate automatically?

Yes; that's the first formula above. It counts every row that reached Screening, Interviewing, Offer, or Rejected and divides by everything you've actually applied to, excluding jobs still marked Saved. It updates itself as stages change.

If the manual-entry half is what wears you down, that's the half we automated. The ClickRoles free plan fills all eight fields when you save a job from any of 11 boards, with unlimited saved applications and 5 AI actions a month, for $0 with no card required. Start free and keep the spreadsheet as your exit strategy.