Job Application Tracker Template: Columns, Examples, and Setup

A useful job application tracker needs more than company, role, and status. At minimum, track the company, role title, job link, date applied, current stage, last contact, next action, follow-up date, contact, and resume or CV version.

You can copy the structure below into Excel, Google Sheets, Notion, Airtable, or another system. You can also download the complete free job application tracker spreadsheet or try the free online tracker.

Job application tracker template

Company	Role	Job link	Applied date	Stage	Contact	Last contact	Next action	Follow-up date	Resume version	Notes
Northstar Software	Implementation Director	careers.example/123	Sep 2	Applied	Maya Chen	Sep 2	Review if no reply	Sep 12	Services-v4	Remote, customer delivery focus
Harbor Health	VP, Customer Success	careers.example/456	Aug 28	Recruiter screen	Jordan Lee	Sep 4	Prepare leadership examples	Sep 8	CS-leadership-v2	Interview with recruiter
Atlas Data	Professional Services Lead	careers.example/789	Aug 20	Waiting	Sam Patel	Aug 29	Send final follow-up	Sep 6	PS-general-v3	Hiring manager reviewing

Use fictional sample data in a blank template so you can see how the fields work before replacing it with your own applications.

What each tracker column is for

Company

Use the employer’s recognizable name consistently. Avoid variations such as “IBM,” “IBM Corp,” and “International Business Machines” unless they refer to different entities. Consistent naming makes filtering and duplicate detection easier.

Role title

Save the exact advertised title. You can add your own role category in another column if you want to group similar positions.

Job link

Keep the original posting URL, but do not rely on it as the only copy of the role. Listings are often removed after applications close. Save the job description or a useful snapshot as well.

Applied date

Use the date the application was actually submitted. A role that is only being considered should have a stage such as Saved and no applied date.

Stage

Choose a small set of stages that describe where the application is now. A practical starting list is:

• Saved
• Applied
• Recruiter screen
• Interview
• Assessment
• Offer
• Rejected
• Withdrawn
• Closed

Do not create so many stages that updating the tracker becomes work in itself.

Contact

Record the recruiter, hiring manager, referral, or other useful person connected to the role. Include an email address or profile link when appropriate.

Last contact

This is the last meaningful interaction, not merely the last time you opened the record. Examples include application submitted, recruiter replied, interview completed, or follow-up sent.

Next action

Every active application should have either a clear action or an explicit waiting state. Useful actions include:

• tailor resume
• submit application
• reply with availability
• prepare interview examples
• send thank-you note
• follow up with recruiter
• review after closing date

“Wait” is too vague unless it includes a date to review again.

Follow-up date

Use this for the date you intend to act, not the date you hope the employer responds. Read the job application follow-up guide for suggested timing.

Resume or CV version

Record the exact filename or link. This prevents confusion during interviews and helps you understand which positioning produced responses.

Notes

Keep notes concise and useful. Capture role priorities, salary information, location expectations, interview feedback, and decisions. Do not turn the cell into a complete diary.

Optional columns

Add optional fields only when you will use them:

• source, such as company site, referral, recruiter, or job board
• salary range
• workplace arrangement
• location
• priority
• role fit
• application deadline
• requisition ID
• interview date
• outcome reason
• days since last activity

A tracker with 30 empty columns is not automatically better than one with 12 useful ones.

Useful spreadsheet formulas

Assuming the applied date is in column D and the stage is in column E:

Days since applying

=IF(D2="","",TODAY()-D2)

Applications submitted

=COUNTIF(E:E,"Applied")

Applications reaching interview

=COUNTIF(E:E,"Interview")

Follow-ups due today or earlier

If the follow-up date is column I:

=COUNTIFS(I:I,"<= "&TODAY(),I:I,"<>")

Spreadsheet applications may interpret spacing or separators differently, so test formulas in your chosen tool.

Add conditional formatting

Use formatting to surface action, not decorate the sheet.

• Highlight follow-up dates that are today or overdue.
• Dim rejected, withdrawn, and closed applications.
• Highlight blank next actions for active roles.
• Flag applications with no activity for a chosen number of days.

Avoid assigning too many colors. A tracker should be understandable without remembering a complicated legend.

Use one row per role

If you apply to two roles at the same company, use two rows. The stages, contacts, job descriptions, resume versions, and outcomes may differ.

Do not combine several positions into one company record. That makes recruiter emails and interview history difficult to match later.

Review the tracker weekly

Once a week:

1. Add roles or messages that are missing.
2. Update stages.
3. Close applications that have ended.
4. Check follow-ups due.
5. Confirm every active role has a next action or review date.
6. Look for patterns in sources, role types, and responses.

The template is only useful when it supports this routine.

When to move beyond a spreadsheet

A spreadsheet may be enough for a smaller search. A dedicated job application tracker becomes more useful when you want recruiter emails, job descriptions, resume versions, interview preparation, and next actions connected to the same application.

Start with the simplest system you will maintain. The objective is not to build the perfect spreadsheet. It is to know where each opportunity stands and what you need to do next.