Skip to content
Applicant Tracking Sheet cover: a sample sheet with applicants, in interview and offers out and a bar chart, beside the Dashboard, Roles and Applicants tabs

Applicant Tracking Sheet

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Style
Bold
Difficulty
Beginner
Updated
November 13, 2026

Every slide (5)

Overview

Recruiters and hiring managers use the Applicant Tracking Sheet to follow each candidate from the first look at a resume to the final offer. The Roles tab lists every open position with its openings, the number filled so far and a target start date. The Applicants tab records each candidate on a separate line, with their role, the date they applied, a pipeline stage that runs from Applied through Hired or Rejected, a rating out of five, the recruiter and the next step date. The Dashboard counts applicants by role and by stage and shows the openings left.

Begin by entering each open role on the Roles tab with its number of openings. Add applicants as they arrive and pick the matching role in the Role column so each count lands in the right place. Move people along as they progress, and fill in the next step date so anything running late turns red. Use the same rating scale for every applicant so the comparison within a role stays fair.

Useful for

  • Track applicants for several open roles at once
  • Count hires against openings for each role
  • Spot applicants whose next step date has passed

What's included

  • 4 tabs: Dashboard, Roles, Applicants, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Roles: a table
  • Applicants: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Roles tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How do I keep applicant names private?

Keep the file in a folder that only the hiring team can open. In Google Sheets, share it with named people rather than anyone with the link. Every sample name is invented, so swap in real applicants and clear the demo rows first.

Can I add a stage such as Reference check?

Yes. Add the stage to the list of options for the Stage column, and give the new stage its own line in the Applicants by stage table on the Dashboard so the chart picks it up.

What should a rating of 3 mean?

Pick the meaning before you start and write it down for the panel. A common scale reads 5 as a strong match, 3 as meeting the core requirements and 1 as not a fit. If every reviewer reads each number the same way, ratings line up across candidates.

  • #recruitment-plan
  • #applicant-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More recruitment plan templates

See all 11

Also in Human resources

All human resources templates
Get this template

Preparing your template…