Job Application Tracker in Excel: Step-by-Step Build

To build a job application tracker in Excel, type ten column headings in row 1, turn the range into an Excel table, add a drop-down list for Status, a "Days since applied" formula with TODAY(), a conditional format for overdue next actions, and a COUNTIF summary. Each step follows Microsoft's support pages.

If you want to know which columns to keep and why, read the method for tracking job applications. If you only want a ready layout, the job application tracker hub has one. This page is the Excel build. This site is not affiliated with Microsoft; "Excel" and "Microsoft" are used only to name the software.

Before you start

These steps cover Excel on Windows and Excel for the web. They follow Microsoft's support pages as read on 2026-11-12 and were not run in Excel by this site. The formulas are written by this site, using functions that Microsoft documents. Menu names follow Microsoft's pages, and where a page covers only the web version or only the desktop version, the step says so. A feature that no checked Microsoft page names is described without a menu path.

Step 1: Type the headings

In cells A1 to J1 of an empty sheet, type these ten headings in this order, one per cell:

Company, Role, Link, Date applied, Source, Contact, Status, Next action, Next action date, Notes

Also type Days since applied in K1, next to Notes, so that the table in Step 2 includes it. Columns then run A to K, so Date applied is column D, Status is column G and Next action date is column I. The formulas later in this guide use those letters, so keep the order.

Enter dates in the Date applied and Next action date columns as real dates. Microsoft's sorting page says all dates and times in a column must be stored as a date or time serial number for Excel to sort them correctly.

Here are three example rows (made-up, for layout only):

Step 2: Turn the range into an Excel table

Select a cell inside your headings and rows, then follow Microsoft's steps: Home > Format as Table, choose a style, confirm the range in the Create Table dialog, mark that your table has headers, and select OK. In Excel for the web the path is Home > Table > Format as Table, and the checkbox reads "My table has headers" (same page).

A table gives you four things this tracker uses, all described on Microsoft's overview of Excel tables:

• Filtering is enabled in the header row of every column.
• Alternate row shading (banding) helps you tell rows apart.
• Formulas can use structured references, which name the table and its columns instead of cell addresses.
• A formula entered in one cell of a column is applied to the rest of that column.

In Excel for the web you cannot change the default table formatting, per the same table page.

Now name the table Applications, because the summary in Step 6 refers to that name. Per Microsoft's structured references page, select any cell in the table to show the Table Design tab, type the name in the Table Name box and press Enter. Table names cannot contain spaces.

Step 3: Add a Status drop-down

Select the cells under the Status heading (column G). Microsoft's drop-down list page gives these steps for Windows: go to the Data tab on the Ribbon, then Data Validation. On the Settings tab, in the Allow box, select List. The page says you can type values separated by a comma directly into the Source box, so enter:

To apply,Applied,Interview,Offer,Rejected,No reply

Check "Ignore blank" if empty cells are fine, and check "In-cell dropdown". To block entries that are not on the list, pick Stop in the Style box on the Error Alert tab.

In Excel for the web, the path is Data > Data Tools > Data Validation, and the alert option is called Type instead of Style (same page). Microsoft says data validation works the same in the browser except that IME mode is not supported.

Step 4: Calculate days since applied

In K2, under the Days since applied heading, type this formula:

=IF([@[Date applied]]="","",TODAY()-[@[Date applied]])

TODAY() takes no arguments and returns the serial number of the current date. Subtracting the application date gives the number of days. The IF leaves the cell blank when Date applied is empty, so a "To apply" row shows nothing instead of a huge number.

The [@[Date applied]] part is a structured reference to the same row. Microsoft's structured references page lists @[Column Name] as a form that returns the cells in the formula's own row, and says Excel creates a calculated column and copies the formula down the entire column for you. The table does the copying, so you type the formula once.

Microsoft's TODAY page notes that if a cell's format was General when the function was entered, Excel changes the format to Date. If the column shows a date instead of a day count, set the column's number format to General or Number.

Step 5: Highlight next actions that are due

Select the Next action date cells from I2 down to the last row you expect to use, so that I2 is the active cell. Microsoft's conditional formatting page says that on the Home tab you click Conditional Formatting > New Rule, choose "Use a formula to determine which cells to format", and enter the formula in the "Format values where this formula is true" list box. Then click Format to pick a fill color. The rule applies to the selected range. Enter:

=AND($I2<>"",$I2<=TODAY(),$G2<>"Rejected",$G2<>"No reply")

Per the same page, the formula must start with an equal sign, and to have Excel adjust references for each cell you use relative references. Here $I2 and $G2 fix the column and let the row change, so each row tests its own date and status. The AND stops empty dates from lighting up and skips rows whose Status is Rejected or No reply. Rows with a next action date of today or earlier turn colored.

In Excel for the web, select the cells and use Home > Styles > Conditional Formatting > New Rule (same page). This rule uses plain cell references because no Microsoft page checked for this guide covers structured references inside a rule.

Step 6: Count applications per status

Pick a spare area outside the table, for example column M with column L left empty, and list the six statuses, one per cell, from M2 down. Beside each, in N2:

=COUNTIF(Applications[Status],M2)

Applications is the table name you set in Step 2. COUNTIF counts the cells in a range that meet a criterion, and the criterion can be a cell reference. Its criteria are not case sensitive. Copy the formula down the six rows.

This guide uses COUNTIF instead of a PivotTable because the counts sit in plain formulas you can read and edit, and the tracker has one question to answer: how many applications are at each status. PivotTable steps were not researched for this page, so nothing is claimed about them.

Step 7: Filter and sort from the headers

Because the range is a table, filter controls are automatically added to the table headers. Open the arrow on Status to show only Interview rows. To clear a filter, select the column's Filter button and choose Clear Filter.

To sort, select the filter button at the top of the column you want to sort on and pick the order. Sorting Next action date from oldest to newest puts the overdue rows first. In Excel for the web, a multi-level Custom Sort has no Sort On menu, which Microsoft says is not yet supported.

Step 8: Freeze the top row if you skipped the table

A table's headings stay in view while you scroll. If you keep a plain range instead, select cell A2 and go to View > Freeze Panes > Freeze Panes. Microsoft says Freeze Panes freezes the rows above and the columns left of the selected cell, so selecting A2 locks row 1. The Microsoft pages checked do not name a "Freeze Top Row" item and do not say whether freezing works in Excel for the web, so this guide gives neither.

For a plain range, a filter is turned on with Data > Filter after selecting any cell in the range, per the filter page.

Step 9: Save the file

Microsoft says that workbooks are saved as Excel Workbooks (.xlsx) by default. To save a first copy, use File > Save As, pick a location and name the file, per the save page. In a browser, changes are saved automatically, according to Microsoft.

Excel or Google Sheets

The differences that have a source: Microsoft says a workbook edited in a browser window saves changes automatically. Google's help page says offline editing requires the Chrome or Edge browser and the Google Docs Offline extension. If you would rather build in a browser document, the Google Sheets version of this tracker covers it.

Common mistakes

• Dates typed as text. Excel then sorts them incorrectly, per the sort page. Re-enter them as dates.
• Days column shows a date. Change the cell format to General or Number (Step 4).
• Status typed by hand with a different spelling. COUNTIF is not case sensitive, but a spelling variation is a different value. Use the drop-down and the Stop alert.
• A formula returns an error. Check that the heading text inside [@[...]] matches the column heading exactly, and that the table is named Applications (Step 2).
• Highlight missing. The rule must start with = and cover the date cells; recheck the range in the rule.

Sources

Checked 2026-11-12.

• Microsoft, Create and format tables
• Microsoft, Overview of Excel tables
• Microsoft, Using structured references with Excel tables
• Microsoft, Create a drop-down list
• Microsoft, TODAY function
• Microsoft, Use conditional formatting to highlight information in Excel
• Microsoft, COUNTIF function
• Microsoft, Filter data in a range or table
• Microsoft, Sort data in a range or table
• Microsoft, Freeze panes to lock rows and columns
• Microsoft, Save your workbook
• Microsoft, Change the default file format for saving workbooks
• Microsoft, Differences between using a workbook in the browser and in Excel
• Google, Work on Google Docs, Sheets, & Slides offline

Disclosure

trackyourjobsearch.com is published by the makers of AIHawk, a job application tool. The About page gives details.

Last verified: 2026-11-12