A job search tracker in Google Sheets is a free, cloud-based spreadsheet where you log every application, its status, follow-up dates, and contacts so nothing slips through the cracks. You build it by creating a structured table with dropdown columns for status, date columns for applied and follow-up, and conditional formatting to flag stale applications. Google Sheets works on any device, auto-saves, and lets you access your tracker from your phone during interviews or networking events.
Why Track Your Job Search in Google Sheets
You applied to 30 jobs last month. Three got back to you. Which ones? When did you apply? Who was the recruiter? If you cannot answer those questions in under 30 seconds, you are losing track of your own search.
A spreadsheet fixes this. Google Sheets specifically gives you three things that matter for job seekers: it is free, it lives in the cloud so you can open it from any device, and it supports formulas that do the remembering for you. You do not need to pay for a tracking tool, and you do not need to be a spreadsheet expert to set one up.
If you already use Excel, the concepts transfer directly. We have a separate guide on building a job application tracker in Excel that covers the same workflow with Excel-specific features.
The Columns That Actually Matter
Resist the urge to track 25 columns. You will stop updating it within a week. Here is the minimum set that stays useful:
- Company - the employer name
- Job Title - the role you applied for
- URL - direct link to the job posting or your application
- Date Applied - when you submitted the application
- Status - where it stands (dropdown, see below)
- Follow-Up Date - when to check in if you have not heard back
- Contact Name - recruiter, hiring manager, or referral
- Contact Email - email address if you have one
- Notes - anything else worth remembering
That is nine columns. You can add a "Source" column (where you found the listing) and a "Priority" column if you want, but do not go beyond eleven. The tracker works because it is fast to update. Every extra column is friction.
Step 1: Set Up the Sheet Structure
Open Google Sheets and create a new spreadsheet. Name it something obvious like "Job Search Tracker."
In row 1, type your column headers across columns A through I:
A | B | C | D | E | F | G | H | I
Company | Job Title | URL | Date Applied | Status | Follow-Up Date | Contact Name | Contact Email | Notes
Select the entire row 1, make it bold, and freeze it. To freeze the header row: click View > Freeze > 1 row. This keeps your headers visible as you scroll.
Step 2: Add a Status Dropdown
A free-text Status column becomes chaos within days. "Applied," "applied," "APPLIED," and "sent" will all coexist. Fix this with a dropdown.
- Select column E (Status) from row 2 downward.
- Go to Data > Data validation > Add rule.
- Under Criteria, select Dropdown.
- Add these options one by one:
- Researching
- Applied
- Phone Screen
- Interview
- Offer
- Rejected
- Withdrawn
Google's dropdown documentation covers the full process, including how to assign colors to each option so your statuses are visually distinct at a glance.
You can also choose "Dropdown from a range" if you want to maintain your status list on a separate tab. For most job seekers, manual entry is simpler.
Step 3: Format Your Date Columns
Columns D (Date Applied) and F (Follow-Up Date) should be formatted as dates. Select both columns, then click Format > Number > Date. This ensures Google Sheets treats your entries as real dates, not text, which matters for the formulas in the next step.
Enter dates in a consistent format. The YYYY-MM-DD format (like 2026-08-29) is unambiguous and sorts correctly.
Step 4: Add a Formula That Flags Stale Applications
This is where Google Sheets earns its keep. You want the tracker to tell you which applications need attention without you manually scanning every row.
Create a new column J called "Days Since Applied." In cell J2, enter:
``` =IF(D2="","",TODAY()-D2) ```
This calculates how many days have passed since you applied. The `IF(D2="",""...)` part keeps the cell blank when there is no date yet. The `TODAY()` function returns the current date and updates automatically every day.
Drag this formula down for all rows. To apply it to an entire column at once, use ARRAYFORMULA:
``` =ARRAYFORMULA(IF(D2:D="","",TODAY()-D2:D)) ```
Paste this in J2 and it will auto-fill every row below. Google's ARRAYFORMULA documentation explains how this function applies a single formula across a range.
Step 5: Add Conditional Formatting
Conditional formatting changes a cell's color based on its value. This is how you make your tracker scannable.
Flag applications that need follow-up:
- Select column F (Follow-Up Date), rows 2 through 500.
- Click Format > Conditional formatting.
- Under "Format rules," select Date is before > Today.
- Set the background color to light red.
- Click Done.
Now any follow-up date that has passed turns red. You know instantly which applications need a nudge.
Color-code your statuses:
- Select column E (Status), rows 2 through 500.
- Click Format > Conditional formatting.
- Add a rule: "Text is exactly" > "Interview" > green background.
- Add another: "Text is exactly" > "Offer" > dark green background.
- Add another: "Text is exactly" > "Rejected" > gray background.
Google's conditional formatting documentation covers all available rule types, including custom formulas that can format an entire row based on one cell's value.
Step 6: Build a Simple Dashboard
Create a second tab called "Dashboard." Here you put the numbers that tell you how your search is going.
Total applications: ``` =COUNTA('Tracker'!A2:A) ```
Applications by status: ``` =COUNTIF('Tracker'!E2:E, "Applied") =COUNTIF('Tracker'!E2:E, "Interview") =COUNTIF('Tracker'!E2:E, "Offer") =COUNTIF('Tracker'!E2:E, "Rejected") ```
Response rate (how many moved past "Applied"): ``` =COUNTIF('Tracker'!E2:E, "Phone Screen") + COUNTIF('Tracker'!E2:E, "Interview") + COUNTIF('Tracker'!E2:E, "Offer") ```
Divide that by your total applications to get a percentage. This number tells you whether your applications are getting traction or whether you need to rethink your approach.
Applications needing follow-up today: ``` =COUNTIFS('Tracker'!F2:F, "<="&TODAY(), 'Tracker'!F2:F, "<>") ```
This counts rows where the follow-up date has passed and the cell is not empty. Start here every morning.
Step 7: Use Checkboxes for Quick Actions
Google Sheets supports checkboxes in cells. Add a column K called "Followed Up?" and select the column, then click Insert > Checkbox. Now you have a one-click toggle for each application.
You can combine checkboxes with conditional formatting: when the box is checked, gray out the row. This visually moves completed items out of your attention.
Step 8: Set Up Notifications (If Available)
Google Sheets supports conditional notifications that send email when cell values change. Go to Tools > Conditional notifications to set a rule: when Status changes to "Interview," send yourself an email.
There is a caveat: conditional notifications are only available on certain work or school accounts. If you do not see the option, you are on a personal Google account and this feature is unavailable. You can work around this by checking your dashboard daily instead.
Also note: notifications do not trigger for data pulled in via IMPORTRANGE or other external sources. If you link trackers across spreadsheets, changes in the source sheet will not fire notifications in the destination.
Step 9: Keep It Updated
A tracker only works if you maintain it. Build a routine:
- When you apply: Add the row immediately. Do it right after you hit submit, not later.
- When you hear back: Update the status and contact fields.
- Daily: Check the "Applications needing follow-up" count on your dashboard. Send those follow-up emails.
- Weekly: Review your response rate. If it is below 10% after 20+ applications, your resume or targeting may need work.
If you are not sure how to write a follow-up that gets a reply without being pushy, our guide on following up on a job application without being annoying has templates and timing advice.
Job Search Tracker Checklist
Before you start applying with your new tracker:
- [ ] Header row created with 9 columns
- [ ] Header row frozen (View > Freeze > 1 row)
- [ ] Status dropdown added with 7 options
- [ ] Date columns formatted as dates
- [ ] "Days Since Applied" formula in column J
- [ ] Conditional formatting on Follow-Up Date (red for past due)
- [ ] Conditional formatting on Status (color-coded)
- [ ] Dashboard tab with total count and status breakdown
- [ ] Checkbox column for follow-up tracking
- [ ] Mobile access confirmed (open the sheet on your phone)
When a Spreadsheet Stops Being Enough
A Google Sheets tracker handles 50 to 100 applications well. Past that, you may want dedicated software. Our comparison of job search trackers vs AI job application assistants breaks down when to switch and what tools offer beyond a spreadsheet.
If you are applying at high volume and want the tracking, matching, and follow-up handled for you, JobFinder AI automates the pipeline: it finds roles that match your criteria, helps tailor applications, and tracks every submission in one dashboard. You can start free and decide whether the automation is worth the time it saves you.
Frequently Asked Questions
Is Google Sheets good for tracking job applications?
Yes. Google Sheets is free, cloud-based, and supports dropdowns, conditional formatting, and formulas that automate follow-up tracking. It works on any device with a browser, auto-saves, and handles up to several hundred application rows without performance issues. For most job seekers, it covers everything a paid tracker does.
Can I use Google Sheets on my phone during interviews?
Yes. Google Sheets has iOS and Android apps that sync with the web version. You can update your status, add notes, or check your follow-up dates from your phone. The mobile interface supports dropdowns and checkboxes, though conditional formatting rules set on desktop will still apply.
How do I share my job tracker with an accountability partner?
Click Share in the top right and enter their email. You can set them as a Viewer (read-only) or Editor (full access). Google Sheets supports real-time collaboration, so you can both edit simultaneously. This is one advantage over a desktop Excel file that needs to be emailed back and forth.
What is the difference between a Google Sheets tracker and an Excel tracker?
The workflow is the same, but Google Sheets is cloud-native (no file to email, auto-save, real-time collaboration) while Excel is desktop-first with more advanced features like Power Query and pivot tables. Google Sheets uses ARRAYFORMULA where Excel uses dynamic arrays, and Sheets has built-in conditional notifications (on work/school accounts). Our Excel tracker guide covers the same setup with Excel-specific syntax.
How many columns should my job tracker have?
Nine to eleven. The essential columns are Company, Job Title, URL, Date Applied, Status, Follow-Up Date, Contact Name, Contact Email, and Notes. Add Source and Priority only if you will actually use them. Every extra column is friction that makes you less likely to maintain the tracker.
Can I import data from another spreadsheet into my tracker?
Yes, using the IMPORTRANGE function. The syntax is `=IMPORTRANGE("spreadsheet_url", "Sheet1!A2:I100")`. On first use, Google Sheets prompts you to allow access. Note that imported data does not trigger conditional notifications, and changes to the source sheet may take a few minutes to reflect in your tracker.