Job application tracker in Google Sheets: free template

Job application tracker in Google Sheets: free template

June 29, 2026

Table of Contents

A job application tracker in Google Sheets keeps every application in one place: the company, the role, the date you applied, where it stands and what to do next. Below is a free template you can copy to your Drive in one click or download as an Excel file, plus how to fill it in and keep it current.

The job application tracking spreadsheet has three tabs: Applications, where you log each job, Summary, which counts your pipeline and response rate by source, and How to use. It is free and needs no sign-up.

Job application tracker template in Google Sheets with status dropdown, source and follow-up columns

 

What's in the free job application tracker template

The Applications tab is a table with 14 columns and room for 200 applications. Five example rows show how a filled-in tracker looks. Delete them before you start.

ColumnWhat to writeWhy it helps
CompanyEmployer nameFind the application fast when a recruiter calls
Job titleTitle exactly as in the listingRecruiters often refer to the exact title
Location / remoteCity, hybrid or remoteFilter roles by where you can work
Job linkURL of the listingListings get taken down, the link is your record
SourceLinkedIn, Indeed, Company site, Referral, Job board, Recruiter, Other (dropdown)Shows which channels bring replies
Date appliedThe day you sent itStarts the follow-up clock
StatusSaved, Applied, Screening, Interview, Offer, Rejected, Withdrawn, No response (dropdown)One look at where each application stands
Contact nameRecruiter or hiring managerKnow who to follow up with
Contact email or LinkedInHow to reach themNo searching when it is time to write
Resume versionFile name of the resume you sentSee which version gets callbacks
Salary rangeRange from the listing or the recruiterCompare roles and prepare for the money talk
Next stepOne concrete actionYou always know what to do next
Follow-up dateFills in by itselfReminds you when to check in
NotesAnything worth keepingPrep for calls and interviews

The Follow-up date column uses a formula: seven business days after the date applied. When that date passes and the status is still Applied or Screening, the cell turns red.

The Summary tab updates as you edit the table. It shows how many applications sit in each status, how many follow-ups are due today or overdue, and for each source the number of applications, how many got a response (Screening, Interview or Offer) and the response rate.

 

How to use the job application tracker in Google Sheets

  1. Make a copy. Open the Google Sheets template and click Make a copy. The tracker lands in your Google Drive, and only you can edit it. If the copy prompt doesn't appear, open the sheet and choose File > Make a copy.
  2. Delete the example rows. Clear the five sample applications on the Applications tab. The formulas and dropdowns stay.
  3. Add a row right after you apply. Company, title, link, source and date are five quick fields while the listing is still open. Wait until evening and you will be reconstructing it from your inbox.
  4. Update the status when something happens. A screening call, an interview invite or a rejection email each means a new status from the dropdown. Workday portals use their own labels, so check what each Workday application status means before you change the status in your sheet.
  5. Review the Summary once a week. Check the follow-ups that are due, write to those contacts and look at which sources give you replies. If one channel has many applications and no responses, spend less time there.

 

How to customize the job application tracking template

Four changes that fit the template to your search:

  • Statuses. Rename or add stages to match your field, such as Take-home task or Final round. Click any Status cell, then the pencil icon at the bottom of the dropdown, and edit the list. If you add a status, add it on the Summary tab too, so it gets counted.
  • Follow-up timing. Follow-up date is set to seven business days after the date applied, weekends skipped. Want a different rhythm? Click a Follow-up date cell and change the 7 in its formula to 5 or 10.
  • Your own columns. Want to track something the 14 columns don't cover, such as who referred you or your interview dates? Add a column after Notes, at the right end of the table. Add only what you will fill in for every application.
  • Filters. Filter Status to Applied and Screening and sort by Follow-up date to get your to-do list for the week.

 

Using the job application tracker in Excel or Notion

Excel. Click Download for Excel or, in your copy, go to File > Download > Microsoft Excel (.xlsx). The columns, dropdowns, follow-up formula, status colors and Summary counts come with it. Excel suits you if you work offline or already keep everything in Microsoft 365.

Notion. A Notion job application tracker works well if you like board views, where each application is a card you drag between stages. You can rebuild the same columns as database properties. The trade-off is setup time: a spreadsheet is ready the moment you copy it.

 

Where a spreadsheet stops being enough

A job application tracker spreadsheet only knows what you type into it. When you apply to a few roles a week, that is fine. When you apply to ten or twenty, the logging starts to compete with the applying, and the rows you skip are the ones you forget to follow up on.

HirePilot connects the two steps. When you apply with the HirePilot extension on LinkedIn Easy Apply, Indeed or Workday, the application is written to the HirePilot job tracker on its own: job title, company, date and source. You move the card to the next stage yourself. Jobs you applied to elsewhere can be added by hand with Add Application.

"We built the tracker to work with the autofill, not separately from it. Every time someone applies through HirePilot, that row gets written automatically. Job title, company, date, source. Users tell us they forget it is even happening until they look at the board and see forty applications logged without any manual work." Viktor Shumylo, co-founder, HirePilot

HirePilot job tracker board with applications logged automatically by stage

The forms themselves are the other half. HirePilot autofill fills the form and drafts answers to job-specific questions from your resume. You review them and submit, so the time you used to spend typing goes to the roles and the people behind them.

 

FAQ: job application tracker template

How do you track job applications?

Log every application the day you send it: company, job title, link, source, date and status. Set a follow-up date for each one and review the list once a week. A spreadsheet like this template works for a few applications a week. At higher volume, a tracker that logs applications automatically saves the typing.

Is this job application tracker template free?

Yes. You can download the free job application template as .xlsx or copy it to Google Sheets, with no sign-up. Your copy belongs to you, and changes you make never reach the original.

How do I copy the template to my Google Drive?

Click Make a copy on the template link. Google asks you to sign in first if you aren't. Without a Google account, use the Excel download instead.

Can I use the job application tracker in Excel?

Yes. The .xlsx keeps the Status and Source dropdowns, the WORKDAY follow-up formula, the red overdue highlighting and the Summary formulas, so it works the same way in Excel.

What is the best free job tracking app?

It depends on how you search. A spreadsheet is free and fully yours to customize but needs manual entry. Notion gives you a board view after some setup. A dedicated tracker such as HirePilot logs applications automatically when you apply through its extension.

What should I do when a status hasn't changed in two weeks?

Send a short follow-up to the recruiter or hiring manager, note the date in the tracker and set the next follow-up date. If there is still no reply after a second message, mark it No response and move on.

 

Start tracking today

  1. Copy the Google Sheets template or download the Excel version.
  2. Delete the example rows and add every application you have open right now.
  3. Put a weekly review in your calendar and send the follow-ups the Summary tab shows.

If you apply to more than a few jobs a week, start a 7-day free trial of HirePilot and let the tracker fill itself as you apply.

Find your next job faster - without the chaos

Spend minutes, not hours, on applications. Stay organized, follow up confidently, and get noticed sooner.

Share this article

author

Viktor Shumylo

Viktor Shumylo is the co-founder of HirePilot, an AI-powered job search platform. He has 10+ years of experience building SaaS products and tools that help job seekers optimize resumes, streamline applications, and land interviews faster.

More articles by Viktor Shumylo