Job Application Tracker Spreadsheet: Google Sheets Template

Free job application tracker templates

Google SheetsMake a free copyExcel (.xlsx)Free download

×

Most people start a job search with a spreadsheet and abandon it somewhere around application thirty. Not because the spreadsheet was wrong, but because filling it in is a small tax charged at the exact moment you least want to pay it: you have just finished a twenty-minute application, you are tired of your own work history, and the last thing you want is to retype the company name into a second window. So you skip one. Then five. A month later the sheet says twenty-two applications and your inbox says sixty, and you have no idea which is real.

So the relevant question isn't "what's the perfect job application tracker spreadsheet template." Whatever design you choose, everything is working fine on day one. The real questions are which columns remain worth having at week six, and how those rows get inserted into the process.

What the spreadsheet is actually for

A tracker is there to answer those four questions you will genuinely have, usually at an inopportune time:

• Had I ever applied here? Asked when the "similar role" pops up in a job board with a slight variation in job title, two weeks on.
• What did I apply for, exactly? Asked when you get a call from a recruiter about a job posting you don't remember, for a company you applied to four times.
• Who has gone quiet? Asked on a Sunday night when you are trying to remember who you need to follow up with.
• Are any of these working? Asked whenever you want to understand if it's the CV, your targeting, or just sheer volume.

Any column that answers one of those stays. Any column that doesn't is icing you'll cease keeping, and a sheet you're not maintaining is worse than no sheet, because you'll rely on it.

The columns that earn their place

Salary is worth a mention. People leave it out because most listings leave it out, and then a hiring manager starts with "what are you looking for" and you are negotiating from memory. Write down whatever the listing did say, even if that is a wide range. It gives you something to point to.

Set it up in four steps

1. Decide where it lives before you design it

A spreadsheet in your Google Drive is better than a tracker on a job board, for a boring reason: two years from now you will be able to see it, download it, and share a filtered view with someone helping you. A job tracker within a product account lives and dies with that account.

2. Fix your status values on day one

Free-text status is where your trackers are most likely to be killed, since "waiting", "no reply yet" and "ghosted?" all mean the same thing, and none of them filter. Choose a small set of statuses, and keep it stable while you search. Something like: Skipped, Bookmarked, Not Applied, Applied, Interviewing, Rejected, Offer. Seven choices is more than enough, and every one corresponds to a different decision.

3. Add one derived column, not six

Days since applied, based off the date column, is the single most helpful function a spreadsheet can perform that a notebook can't. Sort by it and your follow-up task list is generated automatically. Don't be tempted to add scoring, weighted fit percentages or a colour-coded funnel chart in week one. Those are projects that seem like job-hunting without actually being job-hunting.

4. Decide how rows get created

This is the step people skip, and it is the one that determines whether the sheet survives. Copy-pasting four fields per application is about a minute of work. At two hundred applications that is three hours of retyping, spread across exactly the moments when your patience is lowest.

=AND($I2="APPLIED",$A2<>"",TODAY()-$A2>=14)

T1:AA1 (headers): Domain, WeekApplied, WeekInterviewed, Responded, DaysToResponse, WeekdayIfSubmitted, WeekLogged, WeekModified

T2  Domain:
=ARRAYFORMULA(IF(AppUrl="","",IFERROR(REGEXEXTRACT(SUBSTITUTE(SUBSTITUTE(LOWER(AppUrl),"https://",""),"http://",""),"^(?:www\.)?([^/?#]+)"),"")))

U2  WeekApplied (Monday of the week, for jobs at Applied or beyond):
=ARRAYFORMULA(IF((AppDate<>"")*REGEXMATCH(UPPER(TRIM(AppStatus&"")),"^(APPLIED|INTERVIEWING|REJECTED|OFFER)$"),AppDate-WEEKDAY(AppDate,3),""))

W2  Responded (1 if it reached Interviewing, Rejected or Offer):
=ARRAYFORMULA(IF((AppDate<>"")*(AppModified<>"")*REGEXMATCH(UPPER(TRIM(AppStatus&"")),"^(INTERVIEWING|REJECTED|OFFER)$")*((AppModified-AppDate)>=0),1,0))

X2  DaysToResponse:
=ARRAYFORMULA(IF(W2:W5000=1,AppModified-AppDate,""))

Y2  WeekdayIfSubmitted (1 = Sunday ... 7 = Saturday):
=ARRAYFORMULA(IF((AppDate<>"")*REGEXMATCH(UPPER(TRIM(AppStatus&"")),"^(APPLIED|INTERVIEWING|REJECTED|OFFER)$"),WEEKDAY(AppDate),""))

Z2  WeekLogged:
=ARRAYFORMULA(IFERROR(IF(AppDate<>"",AppDate-WEEKDAY(AppDate,3),""),""))

Status breakdown, B6 filled down to B12 (A6:A12 hold Skipped, Bookmarked, Not Applied,
Applied, Interviewing, Rejected, Offer):
=COUNTIF(AppStatus,A6)
A13 "Other/unrecognized", B13:
=COUNTA(AppStatus)-SUM(B6:B12)

Work mode, J6 to J8 for Remote, Hybrid, Onsite, then Unknown in J9:
=COUNTIF(AppWorkMode,"Remote")
=COUNTA(AppCompany)-J6-J7-J8

Days to first response (buckets 0-3, 4-7, 8-14, 15-30, 31-60, 60+):
=COUNTIFS(X2:X5000,">=0",X2:X5000,"<=3")
=COUNTIFS(X2:X5000,">=61")

Applications by day of week (1 = Sunday ... 7 = Saturday):
=COUNTIF(Y2:Y5000,2)

Applications per week: the list of weeks, then a count per week:
A51: =SORT(UNIQUE(IFERROR(FILTER({Z2:Z5000;AA2:AA5000},{Z2:Z5000;AA2:AA5000}<>""),"")))
B51: =ARRAYFORMULA(IF($A51:$A300="","",COUNTIF(U2:U5000,$A51:$A300)))

Manual, template, or automatic

Common mistakes

• No URL column. The posting gets pulled, the recruiter asks which role, and you're recreating it from a job title you think you remember. Save the URL with the row.
• Company names spelled three ways. "Acme", "Acme Inc." and "ACME Corp" are three different rows to a filter and one employer to you. Pick the form the posting used and stick to it.
• Logging the date you discovered it, not the date you applied. All your subsequent calculations are off by however long it sat in your tabs.
• A notes column that becomes a journal. If the note is wider than the row, it belongs somewhere else. Remember, notes are for the referral name and the promise you made, not the story.
• One sheet a month (or per type of job). Divide the record and you lose the one thing this sheet is best for: have I already applied here? Filter one sheet instead.
• Backfilling from memory on Sunday. The row you write four days later is missing the salary, the link and the exact title. Those were the bits you would have kept.

The part that decides whether it survives

A tracker template isn't a design problem. All the layouts shared here can be put together in less than an hour each, and the sixteen columns above will support nearly everyone. What separates the sheet you're still using in month three from the one you've abandoned is whether a row appears without you sitting down to create it. The rest is formatting.

Why this site exists. Job Application Tracker for Google Sheets is a browser extension that does the admin described above: it records every application you submit into a spreadsheet in your own Google Drive (and pre-fills the exact sixteen columns above for each submission), displays a Status badge on postings you have viewed previously, and auto-fills repeat fields on supported application forms from your previously saved answers, without any AI assistance. It supports Chrome, Firefox, and Edge.