Resume Guide articles · Job search

Job application tracker in Google Sheets: a 15-minute setup

Skip the app comparisons. This setup gives you the exact columns, dropdown, colour rules and formulas for a free tracker that shows where your job search is stalling.

Updated November 2026. About 8 minutes to read.

Key takeaways

  • Ten columns are enough: company, role, job link, date applied, source, status, follow-up date, salary, contact and notes.
  • A status dropdown prevents the typos that break your formulas.
  • A second tab with COUNTIF formulas shows whether your search stalls at applications or at interviews.
  • Set a follow-up date 7 to 10 days after applying and let a colour rule remind you.
  • Record which resume file you sent, and save the job description before the posting disappears.

You can build a free job application tracker in Google Sheets in about 15 minutes: add 10 columns, a status dropdown, a colour rule for overdue follow-ups, and a small summary tab with two or three formulas. This article gives you the exact headers and formulas, set up so they work together when you copy them in order.

What columns should a job application tracker include?

Ten columns cover almost every job search. Add more only when a real problem calls for it.

Use these headers in row 1, in this order. The formulas later in this article depend on the order, so Status must be in column F and Date Applied in column D.

ColumnHeaderWhat goes in it
ACompanyThe employer's name
BRoleThe job title as posted
CJob LinkThe address of the posting
DDate AppliedThe day you applied
ESourceWhere you found it
FStatusWhere the application stands
GFollow-up DateWhen you plan to check in
HSalaryThe posted or quoted range
IContactThe recruiter or hiring manager
JNotesAnything else worth remembering

Optional columns worth adding

  • Resume Version: the exact file you sent, so you can reopen it when a recruiter calls. If you tailor your resume to each job description, this is the most useful extra column.
  • Next Step: your next action, such as "follow up Tuesday", so every open row has a task.
  • Referral: who passed your name along, if anyone.

Add them to the right of column J so the formulas keep working.

How do you build the tracker step by step?

Four steps, in this order: headers, dropdown, colours, summary.

Step 1: Set up the sheet

Open a new Google Sheet and rename the tab "Applications". Type the 10 headers into row 1, then choose View, Freeze, 1 row so they stay visible as the list grows.

Step 2: Add a status dropdown

Select column F, then choose Data, Data validation, Add rule. Under Criteria, pick Dropdown and enter these options: Applied, Screening, Interview, Offer, Rejected, Ghosted, Withdrawn.

A dropdown matters because the formulas count exact words. Type "Interveiw" once and that row silently drops out of your totals.

Step 3: Add colour rules

Select column F and choose Format, Conditional formatting. Add one rule per status using "Text is exactly": green for Offer, blue for Interview, grey for Rejected and Ghosted.

Then select column G and add a rule using "Date is before", then "Today", with a red fill. Any follow-up date that has passed now stands out. When you finish a follow-up, set the next date or clear the cell.

Step 4: Build a summary tab

Add a second tab named "Summary". This tab tells you where your search is stalling, which is the main reason to keep a tracker at all.

LabelFormula
Total applications=COUNTA(Applications!A2:A)
Interviews=COUNTIF(Applications!F:F,"Interview")
Offers=COUNTIF(Applications!F:F,"Offer")
Interview rate=(COUNTIF(Applications!F:F,"Interview")+COUNTIF(Applications!F:F,"Offer"))/COUNTA(Applications!A2:A)

Format the interview rate cell as a percent with Format, Number, Percent. Copy the Interviews row for any other status you want to count.

Which statuses and formulas should you use?

Keep statuses few and honest, and let two small formulas do the remembering.

Ghosted is the status people skip, and it is the most useful one. If you have followed up and heard nothing for about two weeks, move the row to Ghosted yourself. It keeps your open list real, and you can always change it back if they reply.

Two formulas help on the Applications tab. Add them in new columns to the right of your last column, in row 2, then copy them down.

  • Days since you applied: =IF(D2="","",TODAY()-D2)
  • A follow-up flag: =IF(AND(F2="Applied",D2<>"",TODAY()-D2>10),"Follow up","")

The flag shows "Follow up" on any row still marked Applied after 10 days. Change the 10 to suit your field. For what to write, see our guide on how long to wait and how to follow up.

What makes a tracker more useful?

A tracker should help you act, not just list companies.

Record the resume version you sent

Log the file name you submitted, such as Jane-Doe_Resume_QA-Lead.pdf. When a recruiter calls two weeks later, you can open the same file instead of guessing which bullets they read. Our guide to naming a resume file gives you a simple pattern.

Save the job description

Postings can disappear once a role is filled. Paste the full text into a linked document or a Notes cell when you apply, so you can reread the exact wording before an interview.

Set a follow-up date as you apply

Fill in column G the moment you apply, usually 7 to 10 days out. Once the red rule from Step 3 is in place, you no longer have to remember anything.

Read your numbers before changing anything

Many applications with few interviews usually point to your resume or your targeting. Interviews with no offers usually point to interview practice. Change one thing at a time so you can see what helped.

If interviews are the bottleneck, start with the resume

The free resume checker gives two scores: one for how screening software reads your file and one for how quickly a person finds your title, employer and dates. It needs no account, and the check runs in your browser, so your resume is not uploaded. Note the scores in your Notes column to compare versions.

Is Google Sheets or Excel better for tracking job applications?

Either works. Sheets is the easier default for most job seekers.

Excel is stronger with very large files and heavy formulas, and the desktop version works fully offline. A job search rarely needs that power. Sheets is free with a Google account, it syncs to your phone so you can update a status right after an interview, and you can share a view-only copy with a mentor in a couple of clicks.

The trade-off is that Sheets works best with an internet connection. For a tracker with a few hundred rows, neither tool will slow you down, so use whichever you already open every day.

Should you copy someone else's tracker template?

You can, but building your own takes about 15 minutes and leaves nothing you do not understand.

If you do copy a shared template, use File, Make a copy so you have your own version. Then run three quick checks:

  1. Read the formulas. A tracker is simple, so you should be able to follow every one.
  2. Look under Extensions, Apps Script. Be wary of any script you did not expect in a sheet holding your job search details.
  3. Search for words like "upgrade" or "unlock". They can be a sign that the free file is really an advert for a paid product.

When should you switch to a dedicated tracker app?

Only when keeping the sheet up to date takes more time than it saves.

A spreadsheet can stop being enough if you apply at very high volume and want job details captured from your browser automatically. Before you pay for an app, check what the free plan really includes, and whether the price is a subscription you will need to cancel.

Your tracker is only half of a job search. Resume Guide does not track applications, so keep using your sheet alongside it. For the resume side, the free resume builder needs no account and downloads a PDF, a Word file or plain text, and twenty designs are free on the templates page. Job seekers never pay a subscription; paid options are one-time, and the pricing page lists them.

Questions people ask

Short answers to the ones that come up most.

  • Can I use Google Docs instead of Sheets for a job tracker? Not well. A document has no dropdowns or formulas, so every status change and every count is manual. Use Sheets for the tracker, and Docs for saved job descriptions if you like.
  • How many columns is too many? If you keep leaving a column empty, delete it. Start with 10 and add one only when a real problem calls for it, such as needing to record which resume version you sent.
  • Do I need a paid app to track job applications? Usually not. Sheets gives you a searchable list, status counts and follow-up reminders for free. An app earns its place only if you apply at very high volume and want details captured automatically.
  • How often should I update my tracker? Update it each time you apply or hear back, and review the Summary tab once a week. A two-minute habit keeps the numbers honest and your follow-ups on time.
  • Why did my formula return an error or zero? Check that the tab is named Applications and that Status is in column F. A count of zero often means the status word in the formula does not match the dropdown option exactly.

More articles

From the same library. For shorter reads, see the resume guides.

Employers and their screening software differ. Treat this article as the default that works for most applications, and follow a specific posting's instructions whenever the two disagree.