What should a job application tracker include?

At minimum: company, job title, a link to the posting, the date you applied, the resume version you sent, a contact person, the current stage, the next step, a follow-up date and notes. Useful extras are the source of the job, location and work setup, the posted salary range, the application deadline and the reason for the outcome.

How do I make a job application tracker in Google Sheets?

Type the column headers into row 1 and freeze that row. Select the Stage column and use Insert, then Dropdown to add a fixed list of stages. Format the date columns as dates, then add a conditional formatting rule that highlights follow-up dates that are today or earlier. Finally, add a filter that hides Rejected and Closed rows so you only see live applications.

Is it better to track job applications in a spreadsheet or an app?

A spreadsheet is free, fully flexible and enough if you apply to a few roles a week and review it regularly. A tracker app saves time once volume rises: many can import a job from a link, remind you to follow up and keep the resume you sent with each application. Many apps have free plans, so you can try one before deciding.

When should I mark a job application as closed?

Close it when the employer says no, when you withdraw, or when two follow-ups go unanswered. A sensible pattern is one follow-up one to two weeks after applying and a final one a week or two later. Closing stale applications keeps your active list honest, and you can reopen one if the employer replies later.

How to Track Job Applications: Template and Weekly Routine

Q: What is the best way to keep track of job applications?

Keep everything in one place, either a spreadsheet or a job application tracker app, with one entry per application. Record the company, role, job link, date applied, resume version, contact, stage, next step, follow-up date and notes. Log each application the moment you submit it, then spend about 15 minutes once a week updating stages and sending the follow-ups that are due.

To track job applications, keep one row (or card) per job with ten fields: company, role, job link, date applied, resume version, contact, stage, next step, follow-up date and notes. Log each application the moment you submit it, give every open application a follow-up date, and spend about 15 minutes once a week updating stages and sending the follow-ups that are due. A spreadsheet works well while you apply to a handful of roles; a job application tracker app is worth it once you need reminders, a tailored resume per job and less copying and pasting.

Why tracking your job applications pays off

A tracker answers the questions that come up mid-search, often with a recruiter on the line:

“Which resume did I send them?” A recruiter calls about a job you applied to three weeks ago. If you tailor your resume for each role, you need to know which version they are reading.
“Is it time to follow up?” Without a date on file, follow-ups go out too early or never.
“Have I already applied here?” Applying twice to the same role looks careless.
“What’s actually working?” After a few weeks, your tracker shows which roles, sources and resume versions get replies.
“What did the posting say?” Job ads are often taken down once a role closes, and you’ll want the original description to prepare for an interview.

There’s a practical reason too. If you claim unemployment benefits, your tracker can double as the record you may be asked for. New York’s Department of Labor, for example, requires a Work Search Record for each week you claim, listing the employers you contacted, how you contacted them and the jobs you applied for. In Northern Ireland, nidirect tells Universal Credit claimants to record their work search activities in their online journal. Rules differ by state and country, so check the ones that apply to you.

What to track for each job application

These ten columns cover what almost every search needs. Each one helps you act, not just remember.

Column	What to put in it	Why it matters
Company	The employer’s name, plus the agency name if a recruiter posted the job	Stops duplicate applications and lets you sort by employer
Role	The exact job title from the posting, plus the job or requisition ID if one is listed	Companies often have several similar openings; the ID tells them which one you mean
Job link	The posting URL, and a link to a saved copy of the description	Postings disappear, and you’ll prepare for interviews from that text
Date applied	The day you submitted, always in the same date format	Drives your follow-up timing and shows how long each stage takes
Resume version	The file name of the resume (and cover letter) you sent	You can answer questions about it in an interview and reuse what got replies
Contact	Recruiter, hiring manager or referrer: name, title, and email or LinkedIn profile	Tells you who to follow up with and who to thank
Stage	One value from a fixed list, such as Applied or Interviewing (see below)	Lets you filter to live applications and count results
Next step	One concrete action, such as “Email recruiter” or “Prepare for panel interview”	Turns the tracker into a to-do list
Follow-up date	The date you’ll act if you hear nothing before then	The column that stops applications from going quiet by accident
Notes	Posted salary range, interview questions, names of people you met, anything unusual	Your memory in three weeks, exactly when you need it

A note on the resume column: in the UK, Ireland and New Zealand a résumé is called a CV, so call it “CV version” if that’s what you send. Either way, name your files so the name tells the story, such as Jordan-Lee-Resume-Acme-Product-Analyst.pdf, rather than resume-final-v3.pdf.

Optional columns worth adding

Source: LinkedIn, a company careers page, a referral or a job board. After a month, this shows where your replies actually come from.
Location, work setup and deadline: on-site, hybrid or remote, and any closing date.
Interest (1 to 3): so you spend your follow-up energy on the jobs you want most.
Outcome reason: “Rejected after phone screen” or “Withdrew, salary too low.” Patterns here teach you more than any single result.

Use a short, fixed list of stages

The stage column only works if it uses the same few values every time. Free text such as “heard back?” or “maybe interview” can’t be filtered or counted. A list like this covers most searches:

Saved: you plan to apply but haven’t yet.
Applied: submitted, no response yet.
Screening: a recruiter call or an online assessment.
Interviewing: any round with the hiring team.
Offer: you have an offer in hand.
Rejected: the employer said no.
Closed: you withdrew, or two follow-ups went unanswered.

Keep stage and next step separate. The stage says where the application is; the next step says what you’ll do about it. “Interviewing” with a next step of “Send thank-you note by Thursday” is far more useful than either one alone.

How to build a job search tracker spreadsheet

Google Sheets and Excel both work, so use whichever you already open every day. Setup takes about ten minutes:

Add the header row. Type the column names from the template below into row 1, one per cell, and freeze the row so it stays visible as you scroll.
Make Stage a dropdown. In Google Sheets, select the column and use Insert, then Dropdown (Google’s guide). In Excel, use Data, then Data Validation, and choose List (Microsoft’s guide). Dropdowns keep the values consistent, so filters and counts stay accurate.
Format both date columns as dates. Sorting by follow-up date only works when the cells hold real dates rather than text.
Highlight follow-ups that are due. Add a conditional formatting rule to the follow-up column with a custom formula such as =AND($I2<>"", $I2<=TODAY()), assuming the follow-up date is in column I. Every due row lights up when you open the sheet.
Create an “Active” filter. Hide Rejected and Closed so the sheet shows only what needs attention. Nothing is deleted, and you can switch the filter off any time.
Save each job description. Paste the text into a second tab, or save the page as a PDF in a folder named after the company, and link to it from the job link column.

Header row (one per cell): Company · Role · Job link · Date applied · Resume version · Contact · Stage · Next step · Follow-up date · Notes
Stage dropdown values: Saved, Applied, Screening, Interviewing, Offer, Rejected, Closed
Example row: Acme Health · Product Analyst (Job ID 4471) · link to posting · 2026-09-15 · Jordan-Lee-Resume-Acme.pdf · Priya Shah, Recruiter (LinkedIn) · Applied · Email Priya if no reply · 2026-09-26 · Salary range listed in ad; referred by Sam

Spreadsheet vs job application tracker app

How the two compare in practice:

Factor	Spreadsheet	Job application tracker app
Cost	Free with Google Sheets, or Excel if you already have it	Many have free plans with limits; paid plans add volume or AI features
Adding a job	Copy and paste each field by hand	Usually paste a link or clip the posting from your browser
Reminders	Only what you build with formatting or calendar events	Built-in follow-up reminders
Resume versions	A file name in a cell; the file lives somewhere else	Often stored with the application
Email updates	You change the stage by hand after reading your inbox	Some can read recruiter emails and update the status, if you connect your inbox
Flexibility	Total: any column, formula or chart you want	You work within the app’s fields and views
Views	Rows, filters and sorting	Usually a list plus a board (Kanban) view with a column per stage
Ownership	The file is yours, and can live offline	Your data sits with the provider, so check the export options

A spreadsheet is enough if you apply to a few carefully chosen roles a week, you like adjusting your own system, and you’ll genuinely open it every week. An app earns its keep when your volume rises, when you tailor a resume for each job and need to know which went where, or when you notice follow-ups slipping. Some people use a general tool such as Trello or Notion as a middle ground, with a card per application and a column per stage.

Dedicated trackers differ mainly in their free limits and extras. As of 2026-09, Huntr’s free plan tracks up to 100 jobs and includes its Chrome job clipper, and Simplify’s tracker updates automatically as you apply through Simplify. Pick the one whose free tier fits the number of jobs you expect to apply to, and check how easily you can export your data before you commit.

A weekly routine that keeps your tracker useful

A tracker only helps if it’s current. This routine takes about a minute per application plus 15 minutes once a week, for example on Friday afternoon.

Every time you apply (one minute)

Add the entry before you close the tab: company, role, link, date, resume version, stage set to Applied, and a follow-up date. Indeed suggests waiting seven to 14 days after applying before you follow up, so a date about ten days out is a sensible default. Logging “later” is how rows go missing.

Once a week (15 minutes)

Sweep your inbox. Look for recruiter replies, assessment invitations and rejections, and update each stage. A Gmail filter that sends job mail to its own label makes this quick (Gmail’s guide to filters).
Send the follow-ups that are due. Sort by follow-up date and work down the highlighted rows. Our follow-up email guide has timing and templates. After each one, set the next follow-up date.
Close what has gone quiet. If two follow-ups went unanswered, mark the application Closed and move on. You can reopen it if they reply.
Prepare for what’s coming. For anything in Screening or Interviewing, make sure the next step is specific and has a date.
Look for patterns. Count what you sent, what got a reply, and which source and resume version each reply came from. If tailored applications get answers and generic ones don’t, that tells you where to spend next week. Our guide on how to tailor your resume shows a quick method.
Plan next week. Pick the best Saved roles and block time to apply.

Weekly review checklist: Stages updated from inbox. Due follow-ups sent and new dates set. Stale applications closed. Next steps for live interviews dated. Replies counted by source and resume version. Next week’s applications chosen.

The best way to organize job applications beyond the tracker

Think of the tracker as the index. Everything else should be one click away from it.

One folder per company for the job description, the resume and cover letter you sent, and your interview notes.
One email label for job search mail, so replies aren’t buried under newsletters.
One calendar for interviews (and follow-up dates, if your tracker doesn’t remind you).
One place for people. Recruiters, referrers and interviewers belong in the contact column or a contacts tab, with the date you last spoke. If you’re asking for introductions, our guide to asking for a referral covers what to say.

Resist spreading your search across five tools: every extra place to check is a place things get missed.

How Leepo tracks job applications for you

If keeping the sheet current is what keeps slipping, Leepo is a job application tracker that takes over several of those columns for you:

Paste any job link (LinkedIn, company careers pages and more) and Leepo imports the role, the company and, when the posting lists it, the salary.
List and Kanban views with stages such as applied, interviewing and offer.
Follow-up reminders and quiet-application nudges, so an application that has gone silent gets flagged instead of forgotten.
One tailored resume per application. AI tailoring builds a resume for each job from your own experience, you accept the suggestions you want, and it stays with that application, which answers “which version did I send?”
Contacts saved against the application, with referral asks and follow-ups drafted to open in Gmail for you to send.
Optional Gmail sync (read-only): recruiter emails about applications you track update their status, so fewer stages need updating by hand.

The Free plan includes unlimited applications and resumes and 3 credits a month, which is enough to try the workflow. Pro is $19 a month, $6.99 a week or $45 a quarter, with your own Leepo address that updates statuses for you, the Gmail sync and 80 credits a month. Start free at leepo.ai.