Excel Spreadsheet to Track Job Applications? Yes, Here’s How

How-to basics · Updated November 22, 2026

Yes, you can—and should—use an Excel spreadsheet to track job applications, because it gives you full control over your data, sorting, and status updates without relying on a third-party service. A simple table with columns for Company, Role, Date Applied, Status, and Next Step is enough to start, and you can expand it with formulas for automatic counts and conditional formatting for color-coded statuses. Below is a complete guide to building, customizing, and maintaining a job application tracker in Microsoft Excel for Microsoft 365 on Windows, with notes for Mac and Excel for the web.

Why Use a Spreadsheet Instead of a Job Board or App

Job boards like LinkedIn and Indeed store your application history, but they only show what you applied to through them. If you apply directly on a company website, through a recruiter, or via email, that record is lost. A spreadsheet centralizes every application in one place, regardless of where you submitted it. It also lets you track follow-up dates, interview feedback, salary ranges, and contact names—fields that most job portals don’t offer. Unlike a dedicated job tracker app, a spreadsheet is free, works offline, and doesn’t share your data with a third party.

Setting Up the Core Columns

Open a new Excel workbook and label row 1 with the following headers, starting at A1:

  • Company – the employer’s name
  • Role – the job title you applied for
  • Date Applied – use the format YYYY-MM-DD for easy sorting
  • Status – e.g., Applied, Interview, Offer, Rejected, Withdrawn
  • Next Step – what you need to do next (e.g., “Send thank-you email,” “Prep for phone screen”)
  • Follow-Up Date – when you plan to check in or expect a response
  • Contact – name and email of the recruiter or hiring manager
  • Notes – any details like salary range, referral source, or interview questions

Format the Date Applied and Follow-Up Date columns as dates (Home > Number Format > Short Date). This ensures sorting works correctly. For the Status column, consider creating a data validation list so you only enter consistent values: select the range (e.g., C2:C100), go to Data > Data Validation, choose “List” under Allow, and enter Applied,Interview,Offer,Rejected,Withdrawn in the Source box. This prevents typos and makes filtering easier.

Adding Automatic Counts with Formulas

To see how many applications are at each stage, use the COUNTIF function. Assume your Status column is D (with headers in row 1 and data from row 2 to row 100). In a cell outside your data (e.g., G2), enter:

=COUNTIF(D2:D100, "Interview")

This returns the number of cells in D2:D100 that equal “Interview.” For a dynamic count of all applications, use COUNTA on the Company column:

=COUNTA(A2:A100)

If you want to track how many applications you sent in the last 30 days, use COUNTIFS with a date condition. With dates in C2:C100, enter:

=COUNTIFS(C2:C100, ">="&TODAY()-30)

This counts dates that are on or after 30 days ago. The & concatenates the comparison operator with the calculated date. On a Mac, the formulas work identically; Excel for the web also supports these functions.

Conditional Formatting for Status Colors

Color-coding your Status column makes it scannable at a glance. Select the Status column (D2:D100), then go to Home > Conditional Formatting > New Rule. Choose “Use a formula to determine which cells to format.” Enter a formula that applies to the first cell of your selection, for example:

=$D2="Interview"

Click Format, choose a fill color (e.g., yellow), and click OK. Repeat for other statuses: =$D2="Offer" (green), =$D2="Rejected" (red), =$D2="Applied" (light blue). The dollar sign before D locks the column, so the rule applies across the row. On Mac, the menu path is Home > Conditional Formatting > New Rule as well; Excel for the web has the same feature under Home > Conditional Formatting.

Sorting, Filtering, and Pivot Tables

To quickly see only active applications, select the entire data range (A1:H100), then go to Data > Filter. Click the dropdown arrow in the Status column and uncheck “Rejected” and “Withdrawn” to hide those rows. For a more powerful summary, create a pivot table: select your data, go to Insert > PivotTable, choose “New Worksheet,” and drag “Status” to the Rows area and “Company” (or any field) to the Values area. The pivot table will show a count of applications per status. This is useful for spotting bottlenecks, like too many applications stuck in “Applied” with no follow-up.

Common Mistakes and How to Avoid Them

One frequent error is using separate columns for month, day, and year, which makes sorting and formulas awkward. Always use a single date column with a real date value. Another mistake is not updating the Status column after each interaction—set a weekly reminder to review your tracker. Also, avoid merging cells in the header or data area, because merged cells break filtering, sorting, and pivot tables. If you need a blank row for readability, use a border or a thick bottom border instead of an empty row, since blank rows can interrupt ranges in formulas.

Comparing Excel to Google Sheets and Dedicated Apps

Google Sheets offers the same core functionality and adds real-time collaboration, which is handy if you’re working with a career coach or a friend. The main difference is that Google Sheets uses =COUNTIF identically, but its conditional formatting is under Format > Conditional formatting, and it lacks some of Excel’s advanced functions like XLOOKUP (though it has its own =XLOOKUP as of 2022). Dedicated job tracker apps like Huntr or JibberJobber provide pre-built pipelines and browser extensions to save job postings, but they often charge a subscription and may not allow custom fields. A spreadsheet gives you full flexibility—you can add columns for portfolio links, interview questions, or even a checkbox for “Follow-up sent.”

Frequently Asked Questions

How do I track follow-up dates without missing them? Add a Follow-Up Date column and use conditional formatting to highlight dates that are today or overdue. Select the Follow-Up Date column, go to Home > Conditional Formatting > New Rule > Use a formula, and enter =$G2<=TODAY() (assuming G is your follow-up column). Choose a red fill. This will highlight any date that is today or earlier, reminding you to act.

Can I use Excel to track applications on my phone? Yes, if you save the workbook to OneDrive or SharePoint, you can open it in the Excel mobile app. The app supports basic editing, filtering, and viewing conditional formatting, but complex formulas and pivot tables may be limited. For full functionality, stick to a desktop or web browser.

What if I apply to the same company for multiple roles? Add a column called “Application ID” or just use the Company and Role combination as a unique key. If you want to avoid duplicates, use a formula like =COUNTIFS(A:A, A2, B:B, B2) to count how many times that company+role pair appears, and set a conditional formatting rule to highlight duplicates.

Is it safe to store personal data like interview notes in a spreadsheet? Yes, as long as you protect the file. Use a strong password (File > Info > Protect Workbook > Encrypt with Password) and avoid storing sensitive details like social security numbers. If you’re using Excel for the web, be aware that the file is stored in the cloud, so review your sharing permissions.

How do I move my data from LinkedIn or Indeed into Excel? Most job boards don’t offer a direct export, but you can manually copy the rows from your application history and paste them into the spreadsheet. For LinkedIn, go to your Jobs tab, click “Applied,” and copy each entry. Alternatively, you can use a browser extension that exports data, but verify its safety before installing.

Can I automate sending follow-up emails from Excel? Not directly, but you can use Excel’s built-in mail merge with Word to generate personalized emails. Set up a column for the recipient’s email and a column for the custom message, then use Word’s Mailings > Start Mail Merge > Email. This requires a bit of setup, but it’s a reliable way to batch follow-ups without third-party tools.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.