Tested Builds
Job application tracker dashboard showing applications sent, reply rate, follow-ups due and weekly charts
Available

Job Application Tracker Spreadsheet with Dashboard and Follow-Up Reminders

Track every application, interview, recruiter and follow-up in one Excel or Google Sheets workbook, with a dashboard that updates itself.

Buy for $9

Secure checkout. You get the download right after purchase.

Requirements

  • Microsoft Excel 2019 or later / Microsoft 365, or a free Google account for Google Sheets

Most job trackers are a list with a status column. This one answers the questions you actually have halfway through a search: what needs a follow-up today, which applications have gone quiet, how many reached an interview, and which job boards are worth your time.

It counts stages the honest way. A job that was rejected after an interview still counts as an interview, because the tracker records the furthest stage each application reached, not just its current status. Reply rate, interview rate and offer rate are worked out from that.

Type in the dark columns, leave the light ones alone, and the Dashboard tab does the rest.

Features

Dashboard

Sixteen live numbers (sent, active, reached interview, offers, reply rate, interview rate, average days to first reply, rejection rate) plus weekly, status and funnel charts.

Follow-up reminders

Uses your Next Action Date, or Date Applied plus a follow-up window you set. Overdue, due today and next 7 days are flagged and listed on the dashboard, earliest first.

No-reply flag

Open applications with no reply after your threshold (21 days by default) are counted and highlighted.

Interviews and contacts

Separate tabs linked by job ID. Company and role fill in automatically, and interview rounds feed the furthest-stage calculation.

Priority score

Fit, interest, pay against your target and freshness, weighted the way you choose. Blank inputs are skipped rather than counted as zero.

Source performance

Applications, interviews and offers by source, so you can see where your interviews actually come from.

What's included

  • job-application-tracker.xlsx (blank, 1,000 job rows)
  • job-application-tracker-example.xlsx (filled with a fictional job search)
  • job-application-tracker-quick-start.pdf (setup, daily routine, every number explained)
  • README.txt and LICENSE.txt (personal licence)

Verify your download: job-application-tracker-v1.0.0.zip SHA-256 ca77fe751e6f3a28eecc9df32570c8ce85817007c1e1d81eecb658a2406abbff

Tested, and known limits

  • Every dashboard number is checked against an independent calculation on the example data
  • Five deliberately broken formulas were each caught by those checks
  • Blank workbook opens with no errors (zeros and dashes, not #DIV/0!)
  • Recalculated in LibreOffice; only functions supported by Excel 2019+ and Google Sheets are used

Limits

  • Apple Numbers opens the file, but charts and some formulas may not work
  • The dashboard reads the first 1,000 application rows

Licence, updates and support

Licence

Personal licence: use it for yourself or your own business's internal work. No resale or sharing of the files. Using it with clients, or redistributing it, needs a commercial licence. Ask. Full terms.

Updates

Includes bug-fix updates to this version (1.x). Current version: 1.0.0. Changelog.

Support

Documentation included. Bug reports answered by email within 2 business days. One-to-one setup help isn't included. Report a problem.

Questions

Does it work in Google Sheets?

It's built to: it only uses functions both apps support. Upload the .xlsx to Google Drive and choose File → Save as Google Sheets. (Tested in Excel-compatible LibreOffice; a full Google Sheets check is in progress.)

Do I need to know formulas?

No. You type in the dark-header columns. The light columns marked fx calculate themselves.

What if I type over a formula?

Copy an fx cell from the row above and paste it back. The Quick Start PDF shows how.

Is my data private?

Yes. It's a file you keep. Nothing is sent anywhere.

How is this different from a free template?

The furthest-stage logic, the automatic follow-up schedule, the no-reply flag and the tested dashboard. Most free trackers are a status list you have to count by hand.

Related guides

Related products