May 7, 2026

9 min readKoru Team

Koru Blog

Job application tracker in Google Sheets: a simple setup

Set up a practical job application tracker in Google Sheets with the right columns, dropdown statuses, filters, example rows, and a weekly review.

job-searchtemplatesspreadsheetscareer-journal

A job application tracker in Google Sheets should be one tab with a frozen header row, a plain status dropdown, filters, dates, and one next-action column. Start with these fields: company, role, job link, date saved, date applied, status, resume version, role fit note, next action, next action date, contact, and notes.

That is enough to answer the questions that matter during an active search: what did I save, what did I send, what needs attention, and what should I prepare next?

You can download the starter CSV, import it into Google Sheets, and then add the few spreadsheet features that make it easier to maintain. Google Sheets supports file imports (Google Docs Editors Help), dropdown lists (Google Docs Editors Help), and sorting or filtering data (Google Docs Editors Help). Use those three features before you add formulas, dashboards, or color systems.

The point is not to make the job search look organized. The point is to keep enough context that you can follow up cleanly, tailor the next application, and prepare real examples before an interview.

Set up the Google Sheet in 10 minutes

Create a new sheet or import the CSV above. Then make these setup changes before you start adding applications.

Google Sheets setup checklist

Step	What to do	Why it helps
1	Put the 12 column names in row 1.	Keeps the tracker readable on day one.
2	Freeze row 1.	The headers stay visible as the list grows.
3	Add a dropdown to the status column.	Prevents five versions of the same status.
4	Turn on filters for the header row.	Lets you see only active, stale, or interview rows.
5	Format date columns as dates.	Makes follow-up timing easier to scan.
6	Keep one notes column.	Holds messy context without adding ten extra fields.

Use these status options first:

Saved
Applied
Screen
Interview
Offer
Rejected
Closed

If you need more detail later, add it after two weeks of real use. Do not start with "recruiter screen," "hiring manager screen," "technical round," "final round," and "waiting for feedback" as separate status values unless that detail changes what you do next.

Use these columns, not a full CRM

A job search spreadsheet gets hard to maintain when it tries to capture everything. Use the sheet for application admin. Keep deeper work evidence somewhere else.

Starter columns

Column	What to write	Example
Company	Company name	Northstar Analytics
Role	Exact role title	Customer Success Manager
Job link	Original posting URL	The job post you saved
Date saved	When you found it	2026-05-07
Date applied	When you submitted	2026-05-08
Status	One dropdown value	Applied
Resume version	Short internal label	`CSM-retention-v1`
Role fit note	Why the role makes sense	Strong match: onboarding and renewal risk
Next action	The next useful step	Prepare two customer-save stories
Next action date	When to do it	2026-05-10
Contact	Recruiter, referral, or hiring contact	Maya referral
Notes	Anything messy but useful	Mention Q3 expansion work in screen

The role fit note is easy to skip. Keep it anyway. If you cannot write one sentence on why the role fits, you may be looking at a weak match or a job post you have not read carefully enough.

For resume tailoring, do not paste generic keyword lists into the sheet. Pull language from the actual job description and connect it to work you can prove. The post on why resume keyword lists are useless goes deeper on that problem.

Three rows that show how the tracker should work

The sheet should tell you what to do next, not just what happened.

Situation	Weak row	Useful row
Saved role	"Saved PMM job."	"Saved Product Marketing Manager at Ledgerwise. Fit: launch planning and sales enablement. Next action: tailor resume to launch examples by May 9."
Applied role	"Applied, waiting."	"Applied to Customer Success Manager with `CSM-retention-v1`. Next action: prepare two customer-save stories before recruiter reply."
Interview booked	"Interview May 13."	"Phone screen May 13 with Sam. Prepare one renewal-risk story, one difficult-handoff story, and salary range notes."

That last row is where the tracker starts to connect to interview preparation. The spreadsheet names the role and deadline. Your work notes provide the examples.

Add filters that match real decisions

Filters are more useful than a dashboard at the beginning. Create simple views around decisions you actually make.

Active applications

Show rows where status is applied, screen, interview, or offer. This is the view for follow-ups and preparation.

Saved, not applied

Show rows where status is saved. This is the view for deciding what to tailor next.

Next action due

Sort by next action date. This is the view that stops follow-ups and prep tasks from disappearing.

Closed or rejected

Review only when there is a lesson worth keeping. Do not turn every rejection into a research project.

Skip charts at first. A chart that says you applied to 37 jobs does not help much if the next action column is empty.

The weekly review that keeps the sheet alive

Once a week, spend 10 minutes on the tracker. Do it before adding more roles.

01
Update every status
Move each row to the plainest accurate status. If nothing has changed, leave it alone.
02
Fill blank next actions
Every active row should say what happens next: tailor, apply, follow up, prepare, wait, or close.
03
Pick the strongest open role
Choose one active role and prepare evidence for it before you are invited to interview.
04
Close stale roles
If a saved role no longer fits, mark it closed. A smaller sheet is easier to use.

If weekly tracking is hard to keep up with, use the same rhythm as a career journal. The weekly career journal template is built around short Friday notes, and the habit works well beside a job-search sheet.

Do not store all your proof in the tracker

Google Sheets is good at pipeline admin. It is a poor place to write strong interview answers or resume bullets.

Tracker doing too much

One row contains the job link, recruiter name, resume version, interview notes, STAR answer draft, salary notes, company research, take-home assignment links, and a long reflection on whether the role feels right.

Cleaner split

The tracker holds the role, status, next action, and contact. Your career notes hold the work evidence: projects, results, difficult moments, decisions, and stories you can reuse.

Use this split:

Application-to-proof handoff

In Google Sheets	In your work evidence
Role title	Which past projects match the role
Resume version	Which proof belongs in that resume
Next action	Which story to prepare next
Interview date	Which examples to rehearse before then
Outcome note	What you learned for the next application

For behavioral interviews, the useful material is rarely "applied on May 8." It is the story behind your work: the situation, what you did, and what changed. Use behavioral interview prep without scripts when a row turns into an interview.

What to leave out until you need it

These columns look tidy, but they often make the sheet harder to maintain.

Column	Why to skip it early	Add it only if
Excitement score	Mood changes as you learn more.	You use it to choose between offers or interviews.
Full compensation model	Usually incomplete before a recruiter call.	You have confirmed numbers or ranges.
Company size	Easy to look up, rarely action-changing.	Size is part of your search criteria.
Detailed rejection taxonomy	It can invite over-analysis.	You get a clear reason you can act on.
Networking CRM fields	Easy to overbuild.	You are running a referral-heavy search.
Dashboard metrics	They reward volume, not quality.	You already update the tracker every week.

The best version of the sheet is the one you reopen. If a field does not change what you apply to, how you follow up, or what you prepare, remove it.

Copy-paste version

Paste this into Google Sheets, or use the CSV download.

Company,Role,Job link,Date saved,Date applied,Status,Resume version,Role fit note,Next action,Next action date,Contact,Notes
Northstar Analytics,Customer Success Manager,https://example.com/job,2026-05-07,2026-05-08,Applied,CSM-retention-v1,"Strong match: onboarding, renewal risk, enterprise accounts.",Prepare two customer-save stories,2026-05-10,Maya referral,"Mention renewal-risk work in screen."
Ledgerwise,Product Marketing Manager,https://example.com/job,2026-05-07,,Saved,PMM-launch-v2,"Good fit: launch planning and sales enablement.",Tailor resume to product launch examples,2026-05-09,,"Check whether role is remote before applying."
BrightPath Health,Operations Lead,https://example.com/job,2026-05-06,2026-05-06,Interview,Ops-scale-v1,"Fit: process cleanup, vendor handoff, support metrics.",Prepare handoff-conflict story,2026-05-12,Recruiter Sam,"Phone screen booked for May 13."
,,,,Saved / Applied / Screen / Interview / Offer / Rejected / Closed,,,,,,

This setup is intentionally plain. Sheets should help you manage the search. Your career journal app or work notes should hold the proof you will use when the search starts asking, "What have you actually done?"

Comparison

Koru vs Spreadsheets for Career Tracking

Compare Koru with Google Sheets and Excel for tracking career achievements. Learn why free spreadsheets often fail for career journaling and what makes purpose-built tools stick.

Career Development

Best Career Journal Apps in 2026

Compare the top career journaling apps for tracking achievements, preparing for interviews, and building your professional narrative. Tested and reviewed by career development experts.