Proper Spreadsheets

Templates › Personal

Job Application Tracker

Made for anyone job hunting.

Every application in one place: where it came from, what stage it has reached, and how your search is going overall. The summary carries a chart that redraws itself as you type.

Of the 10 columns, you fill in 8 and the other 2 work themselves out, and all 9 figures on the summary do too. There is room for 300 rows of your own.

£4.99one payment, yours to keep

  • Opens in Excel, Google Sheets and Numbers
  • Delivered straight away
  • No macros, nothing to install
  • Change it free before you buy

Payment is handled by Stripe. Your card details go to them and never to us. Sales are final, which is why every tab, column and calculation is shown on this page first.

Already have a spreadsheet of your own? Check it for mistakes, free.

The workbook's summary and the table behind it
A row typed into the real file. Every figure that changes is the spreadsheet's own arithmetic. What the film shows, in order:
  1. A new row is typed into the Applications tab, one cell at a time, in the white cells a person fills in.
  2. The shaded cells in that row fill themselves in.
  3. The figures on the Summary tab change to include the new row.
  4. The chart, Applications by stage, recounts with it.
The chart, drawn from the totals in the table beside it. See it full size
Where you type, and the shaded columns that work themselves out. See it full size

Everything inside, before you pay

This is the whole design: every tab, every column and how each calculated one is worked out. White cells are yours to fill in; the shaded ones work themselves out and are locked so a formula cannot be overwritten by accident. There is room for 300 rows. Open any tab to see its columns.

Applications

10 columns

One row per job you apply for. Update the stage as things move along. Ready for 300 rows, every one with its formulas in place.

ColumnWhat goes in itWorked out as
CompanyType any text.
RoleType any text.
SalaryAdvertised annual salary. Use the midpoint if a range was given.Type an amount in £.
Where FoundPick one: LinkedIn, Company Website, Job Board, Recruiter, Referral or Other.
Date AppliedType a date.
StagePick one: Applied, Screening, Interview, Offer, Rejected, Withdrawn or No Response.
Reached InterviewTick once you get an interview, and leave it ticked even if you are later rejected.Tick it when it applies.
Days Since AppliedFills itself in.

Worked out from this row's Date Applied.

The formulaIF(ISBLANK([date_applied]), "", TODAY()-[date_applied])
Chase UpFlags applications still at Applied after two weeks with no reply.Fills itself in.

Worked out from this row's Date Applied and Stage.

The formulaIF(ISBLANK([date_applied]), "", IF(AND([stage]="Applied", TODAY()-[date_applied]>14), "Chase", ""))
NotesType any text.

Summary

9 figures

How your job search is going, updated as you fill in the Applications tab.

FigureWorked out as
Total applications

The number of rows on Applications with Company filled in.

The formulaCOUNTA([Applications!company])
Still liveApplied, Screening, Interview or Offer.

Worked out from Stage on Applications.

The formulaCOUNTIF([Applications!stage], "Applied")+COUNTIF([Applications!stage], "Screening")+COUNTIF([Applications!stage], "Interview")+COUNTIF([Applications!stage], "Offer")
Got to interview

Worked out from Reached Interview on Applications.

The formulaCOUNTIF([Applications!interviewed], TRUE)
Response rateShare of applications that got any reply, including rejections.

Worked out from Company and Stage on Applications.

The formulaIFERROR((COUNTA([Applications!company])-COUNTIF([Applications!stage], "Applied")-COUNTIF([Applications!stage], "No Response"))/COUNTA([Applications!company]), 0)
Interview rate

Worked out from Reached Interview and Company on Applications.

The formulaIFERROR(COUNTIF([Applications!interviewed], TRUE)/COUNTA([Applications!company]), 0)
Offers received

The number of rows on Applications where Stage is “Offer”.

The formulaCOUNTIF([Applications!stage], "Offer")
Applications needing a chase

The number of rows on Applications where Chase Up is “Chase”.

The formulaCOUNTIF([Applications!chase_up], "Chase")
Applied this month

Worked out from Date Applied on Applications.

The formulaCOUNTIFS([Applications!date_applied], ">="&DATE(YEAR(TODAY()), MONTH(TODAY()), 1))
Average advertised salary

The average of Salary on Applications.

The formulaIFERROR(AVERAGE([Applications!salary]), 0)