How to Build a Job Application Tracker in Google Sheets: Free Template Setup and Tracking Tips?

Applying for several jobs can quickly become confusing. You may forget which CV you sent, lose track of interview dates, or miss a follow-up because the recruiter contacted you on a different platform.

A job application tracker in Google Sheets gives you one organised place to manage your job search. It is free, works on your phone or computer, and can be updated even when you are applying through different job boards in South Africa.

Why use Google Sheets to track job applications?

A spreadsheet turns your job search into a clear pipeline. Instead of relying on memory, emails, screenshots and browser history, you can see every application and its next action in one view.

A well-designed tracker helps you:

  • Remember application details, including the company, role and closing date.
  • Track different CV versions and cover letters.
  • Record recruiter and hiring manager contact details.
  • Prepare for interviews with dates, links and notes.
  • Follow up at the right time without sounding pushy.
  • Measure your progress, such as applications submitted, interviews secured and offers received.
  • Avoid duplicate applications to the same vacancy.

This system works for full-time jobs, internships, learnerships, graduate programmes, freelance opportunities and flexible remote work.

For more background, read this guide on how to track job applications with a simple spreadsheet.

Create your free Google Sheets job tracker

Start by opening Google Sheets and selecting Blank spreadsheet. Rename the file something easy to find, such as:

Job Search Tracker – 2025

You can also create one folder in Google Drive for your job search documents. Keep your tracker, CV versions, certificates and cover letters together, but avoid storing sensitive documents such as your identity document unless they are genuinely required.

Add the essential tracking columns

Rename the first sheet Applications. Add the following headings in Row 1:

Column Heading What to record
A Date applied The date you submitted the application
B Company Employer or recruitment agency name
C Job title Exact title from the vacancy
D Location City, province, hybrid or remote
E Source Job board, company website, referral or recruiter
F Job link URL to the vacancy
G Closing date Application deadline
H Status Current stage in the process
I Contact person Recruiter or hiring manager
J Contact details Email address or phone number
K CV version File name or version used
L Cover letter Yes, no or document link
M Interview date Date and time, if scheduled
N Follow-up date Date to check in
O Salary or stipend Advertised range, if available
P Next action The next step you need to take
Q Notes Requirements, feedback and reminders

These columns create a practical application tracking spreadsheet setup without making the tracker too complicated. You can add more fields later, but start with information you will actually use.

Create custom application status dropdowns

Typing statuses manually can lead to inconsistent labels such as “Applied”, “application sent” and “Submitted”. A dropdown keeps your data clean and makes filtering easier.

To create one:

  1. Select the cells in the Status column, such as H2:H500.
  2. Select Insert > Dropdown.
  3. Add these options:
    • Researching
    • Preparing
    • Applied
    • Shortlisted
    • Assessment
    • Interview scheduled
    • Interview completed
    • Follow-up required
    • Offer received
    • Rejected
    • Withdrawn
  4. Assign different colours to the options.
  5. Select Done.

Use Applied only after you have successfully submitted the application. This distinction helps you separate jobs you are considering from applications that are active.

Add a dropdown for application sources

You can also create a dropdown in the Source column with options such as:

  • Company website
  • Postings.co.za
  • LinkedIn
  • Indeed
  • Recruitment agency
  • Referral
  • Government portal
  • WhatsApp
  • Email

This will help you see which sources produce the most useful opportunities and interviews.

Add conditional formatting to see priorities quickly

Conditional formatting changes the appearance of a cell when it meets a rule. It is one of the most useful features in a Google Sheets job tracker because you can spot urgent actions without reading every row.

Highlight approaching deadlines

Select your closing date range, such as G2:G500, then choose Format > Conditional formatting.

Use a custom formula such as:

=AND($G2<>"",$G2>=TODAY(),$G2<=TODAY()+3)

Choose an orange or yellow fill. This highlights vacancies closing within the next three days.

To highlight overdue closing dates, add another rule:

=AND($G2<>"",$G2<TODAY(),$H2<>"Applied")

Use a red fill, but remember that some adverts remain open after the stated deadline. Confirm the vacancy before assuming it is no longer available.

Highlight follow-ups due

Select N2:N500 and add:

=AND($N2<>"",$N2<=TODAY(),$H2<>"Rejected",$H2<>"Withdrawn")

Use a light blue or purple fill. This creates a simple interview follow-up tracking sheet inside your main tracker.

Follow-up timing depends on the situation. For many applications, waiting around five to seven business days is reasonable unless the employer gave you a specific timeline.

Use formulas to track your job search

A few simple formulas can turn your spreadsheet into a basic job search data dashboard.

Create a second sheet called Dashboard. Add labels such as:

Metric Formula
Total applications =COUNTA(Applications!B2:B)
Applications this month =COUNTIFS(Applications!A2:A,">="&EOMONTH(TODAY(),-1)+1,Applications!A2:A,"<="&EOMONTH(TODAY(),0))
Interviews scheduled =COUNTIF(Applications!H2:H,"Interview scheduled")
Interviews completed =COUNTIF(Applications!H2:H,"Interview completed")
Offers received =COUNTIF(Applications!H2:H,"Offer received")
Follow-ups due =COUNTIFS(Applications!N2:N,"<="&TODAY(),Applications!N2:N,">0")

Make sure the sheet name in the formulas matches your actual sheet name. If your sheet is called “Job Applications” instead of “Applications”, update the formula accordingly.

Calculate your interview conversion rate

You can measure how many applications lead to interviews with:

=IFERROR(COUNTIF(Applications!H2:H,"Interview scheduled")/COUNTA(Applications!B2:B),0)

Format the result as a percentage. For example, if you submitted 40 applications and received four interviews, your conversion rate is 10%.

This number is not a judgement on your ability. It may be affected by the job market, role requirements, location, CV quality and whether the vacancy was genuine or highly competitive.

Track CV and document versions properly

Sending the same CV to every employer can weaken your applications. Instead, tailor your CV to the role and record the exact file name in the CV version column.

Useful file names might include:

  • Thandi_Mokoena_CV_Admin_2025.pdf
  • Thandi_Mokoena_CV_Customer_Service_2025.pdf
  • Thandi_Mokoena_CV_Data_Capture_2025.pdf

If you use Google Drive links, paste the document link into the relevant cell. However, check the sharing permissions before sending it. The employer should be able to view the document, but your wider personal files should remain private.

For applications where you do not meet every listed requirement, record the transferable skills you highlighted. This can support the advice in how to apply for a job when you do not meet every requirement.

Add interview preparation notes

When an application moves forward, update the same row rather than creating a separate record. Add details such as:

  • Interview date and time
  • Video meeting link or venue
  • Names and job titles of interviewers
  • Questions you expect to answer
  • Examples from your work or studies
  • Documents to bring
  • Salary information
  • Your questions for the employer

For an in-person interview in Johannesburg, Cape Town, Durban or another South African city, include travel time and transport costs in your notes. If you rely on taxis, buses or trains, plan a backup route in case of delays.

For remote interviews, test your data, microphone and camera in advance. A power bank or alternative connection can also help during load shedding.

Add job application deadline reminders

Google Sheets does not automatically send reminder notifications from a basic spreadsheet, but you can use several practical options:

  • Google Calendar: Add the closing date, interview and follow-up date as calendar events.
  • Phone reminders: Set an alert for important applications.
  • Google Tasks: Add next actions such as “send follow-up email”.
  • Apps Script: Advanced users can create automated email reminders, but test the script carefully before relying on it.

A useful routine is to check the tracker at the start or end of each job-search session. Review applications that are:

  • Closing soon
  • Waiting for a follow-up
  • Missing a required document
  • At interview stage
  • Still marked “Preparing” after several days

Use filters to manage a busy job search

Select Row 1 and choose Data > Create a filter. You can then filter your job search pipeline spreadsheet by:

  • Status
  • Location
  • Company
  • Closing date
  • Job source
  • Interview date
  • Remote or hybrid roles

For example, filter Status to show only Follow-up required. This gives you a short action list instead of a screen full of old applications.

You can also sort by closing date so the most urgent vacancies appear first. Be careful when sorting: select the full table range, not just one column, so that company details remain matched to the correct application.

Review your tracker every week

A tracker only works when you keep it current. Set aside 15 to 20 minutes once a week to clean it up.

Use this weekly process:

  1. Add new vacancies you are seriously considering.
  2. Update the status of applications that received replies.
  3. Add interview and follow-up dates.
  4. Remove duplicate vacancies.
  5. Check whether deadlines have passed.
  6. Record rejection feedback where available.
  7. Choose your next five to ten priority applications.

Your weekly review can reveal useful patterns. For example, you may discover that tailored applications perform better than quick submissions, or that a particular CV version receives more interview invitations.

Protect your personal information

Your tracker may contain recruiter details, salary information, application links and notes about your employment history. Keep the Google Sheet private and share it only with someone you trust, such as a career adviser.

Do not record unnecessary sensitive information such as:

  • Your banking details
  • Passwords
  • Full identity document numbers
  • PINs or one-time passwords
  • Copies of confidential employer records

Be cautious if a recruiter asks you to pay a fee, provide excessive personal information or send documents through an unverified channel. Read this guide on how to avoid job scams on South African job boards before continuing with an application.

Final tracking tips that make the system easier

Keep your tracker simple enough to update every day. A complicated spreadsheet that you avoid is less useful than a basic one you maintain consistently.

Key takeaway: record every application, choose one clear status, add the next action and review deadlines regularly. With this free Google Sheets setup, you can manage your applications more calmly, prepare better for interviews and make informed decisions about where to focus your time.

Leave a Comment