A useful job application tracker in Excel needs one row per role, consistent status labels, the last action you took, and the next date you must act. Start with the columns below, convert the range into an Excel table, add status drop-downs, and review overdue follow-ups twice a week. The point is not to document every detail. It is to answer three questions quickly: What is active, what needs attention, and what is working?
The simplest tracker that is still useful
Open a blank workbook and paste this header row into cell A1:
Priority | Company | Role | Job URL | Source | Location | Date Found | Date Applied | Status | Contact | Last Action | Follow-Up Date | Next Action | Resume Version | Notes
Use one row for one job. If you apply to two roles at the same company, create two rows. They have different job descriptions, contacts, timelines, and outcomes.
These 15 columns are enough for most searches:
- Priority: High, Medium, or Low based on fit and interest.
- Company and Role: The employer and exact title from the posting.
- Job URL: The original listing or company careers page.
- Source: Company site, referral, LinkedIn, Wellfound, recruiter, or another source.
- Location: Include Remote, Hybrid, or On-site if that distinction matters.
- Date Found and Date Applied: Separate discovery from action. A saved role is not an application.
- Status: Your controlled pipeline stage.
- Contact: The recruiter, hiring manager, founder, or referral contact.
- Last Action: A short factual note such as “Applied on company site” or “Emailed engineering manager.”
- Follow-Up Date: The next date the row deserves attention.
- Next Action: One concrete step, not a vague intention.
- Resume Version: The filename or version used for that role.
- Notes: Only information that changes a decision or future action.
Do not turn the workbook into a private intelligence database. Avoid storing passwords, identity documents, bank details, sensitive interview links, or anything else you would regret exposing if the file were shared accidentally.
Build it as an Excel table, not a loose grid
Select any cell in your data range and press Ctrl+T. Confirm that your table has headers, then name it Applications from the Table Design tab.
This small step makes the workbook easier to maintain. Excel tables add filter controls to every header and expand as you add rows. Microsoft also documents that table formulas can use readable column names, called structured references, which adjust when table data changes. See Microsoft’s guide to structured references in Excel tables.
Freeze the top row so the headers remain visible. Keep dates as real Excel dates, not text such as “next Friday.” Turn on Wrap Text for Last Action, Next Action, and Notes. Do not merge cells. Merged cells make filtering and sorting needlessly painful.
The result should look boring. Good. A tracker is operational infrastructure, not a mood board.
Use a fixed status pipeline
Free-typing statuses creates useless variations such as “Interview,” “Interviewing,” “Round 1,” and “Call scheduled.” Choose one set and stick to it.
A practical status list is:
- Interested
- Preparing
- Applied
- Contacted
- Recruiter Screen
- Interviewing
- Assessment
- Offer
- Rejected
- Withdrawn
- Closed
Put these values on a second sheet named Lists. Select the Status column in your Applications table, then use Data > Data Validation > List and point it to the status range.
Microsoft’s drop-down list instructions explain the exact controls. If the source list is also an Excel table, adding or removing a status updates the dependent drop-downs. Use the Stop error alert if you want Excel to reject values outside the list.
Your stages should describe what has happened, not how hopeful you feel. “Interviewing” means an interview is scheduled or underway. “Offer” means you received an actual offer. Priority captures your interest; Status captures reality.
Make follow-up dates do the remembering
The tracker earns its keep when it prevents promising applications from disappearing into your browser history.
After every action, update three cells:
- Last Action: What you did and when.
- Follow-Up Date: When you should inspect the row again.
- Next Action: The exact task you will do then.
For example:
Last Action: Applied on company site, 18 Aug
Follow-Up Date: 25 Aug
Next Action: Send a concise follow-up to Priya if there is no reply
The follow-up date is not a command to pester someone. It is a reminder to make a judgment. You might send a note, prepare for an interview, archive a closed role, or decide that silence is your answer.
If you need wording and timing guidance, use the more detailed guide on how to follow up on a job application. If you need the right contact first, see how to find a hiring manager’s email address.
Add two formulas that surface neglected applications
Add a column named Days Since Applied. In the first data row, enter:
=IF([@[Date Applied]]="","",TODAY()-[@[Date Applied]])
Format the result as a number. This shows age without forcing you to count calendar days manually.
Next, add a column named Action State:
=IF(OR([@Status]="Rejected",[@Status]="Withdrawn",[@Status]="Offer",[@Status]="Closed"),"",IF([@[Follow-Up Date]]="","Set date",IF([@[Follow-Up Date]]<=TODAY(),"Due","Scheduled")))
This formula does three useful things:
- Leaves finished rows alone.
- Flags active rows with no follow-up date.
- Marks rows due today or earlier.
If your Excel installation uses semicolons instead of commas in formulas, replace the separators. If you choose different status names, update the formula to match them exactly.
Now apply conditional formatting to the Action State column: red fill for Due, amber for Set date, and no fill for Scheduled. Microsoft confirms that conditional formatting rules can evaluate text, dates, blanks, values, or formulas.
Color is a signal, not a second status system. Avoid manually painting whole rows green, yellow, and red. Manual color quickly drifts away from the actual data.
Create a small dashboard that answers useful questions
Do not build a twelve-chart command center before you have twelve applications. Start with five counts on a Summary sheet.
=COUNTA(Applications[Company])
=COUNTIF(Applications[Status],"Applied")
=COUNTIF(Applications[Status],"Interviewing")
=COUNTIF(Applications[Status],"Offer")
=COUNTIFS(Applications[Action State],"Due")
Label them Total Roles, Applied, Interviewing, Offers, and Actions Due.
COUNTIFS can evaluate multiple criteria when you need a narrower question. Microsoft’s COUNTIFS documentation covers the syntax and explains that all supplied criteria must match for a row to be counted.
Once you have enough data, add counts by Source. That tells you whether company career pages, referrals, niche boards, recruiter conversations, or broad job boards are producing interviews. Measure progress by stage movement, not by the number of rows you managed to create.
An application count alone can reward the wrong behavior. If you send 60 weak applications and receive no screens, the answer is not automatically 120 weak applications. Review fit, resume positioning, source quality, and outreach. The guide on how many jobs to apply to per week gives a practical way to balance volume and quality.
Run the tracker with a two-pass weekly routine
The best spreadsheet is the one you actually update. Use two short passes instead of living in the file all day.
Pass 1: capture while you work
Add a row as soon as a role becomes genuinely interesting. At minimum, record Company, Role, URL, Source, Priority, and Date Found.
When you apply, fill Date Applied, Status, Resume Version, Last Action, Follow-Up Date, and Next Action before opening another listing. This takes less time than reconstructing the application later from email receipts and browser tabs.
Pass 2: review twice a week
Filter Action State to Due and Set date. Work from High priority to Low priority. Then inspect active applications with no movement.
For each row, choose one action:
- Follow up.
- Research or contact the decision-maker.
- Prepare for the next interview stage.
- Update the resume or work sample.
- Close the row and move on.
Excel tables place filters in the header row, and Microsoft’s sorting guide covers sorting by text, dates, values, and custom lists. A useful review sort is Priority first, then Follow-Up Date from oldest to newest.
End the review by checking your Source counts and interview movement. If one channel produces conversations, allocate more time there. If a channel produces only applications, question whether it deserves more effort.
Track safety signals without storing sensitive data
Add a short note when something about a listing or recruiter needs verification. Examples include a mismatched email domain, a job that is absent from the company’s careers page, an unexpected request to move to a private messaging app, or any request for payment.
Do the verification outside the spreadsheet. Visit the employer’s official site, locate the role independently, and contact the company through a published channel when necessary. The US Federal Trade Commission’s job scam guidance advises researching the company or recruiter and warns about fake-check and payment schemes. Never treat a polished logo or formal-looking offer letter as proof.
Record the conclusion, not sensitive evidence. “Verified on official careers page” is enough. You do not need to paste identity documents, personal financial information, or private correspondence into the tracker.
Excel tracker checklist
Use this checklist before trusting the workbook with your search:
- [ ] One role equals one row.
- [ ] The range is formatted as an Excel table named Applications.
- [ ] Status and Priority use controlled drop-down values.
- [ ] Dates are stored as real dates.
- [ ] Every active application has a clear Next Action.
- [ ] Every active application has a Follow-Up Date or a deliberate reason not to.
- [ ] Finished roles use a consistent final status.
- [ ] Conditional formatting highlights actions, not feelings.
- [ ] The Summary sheet shows stage movement and actions due.
- [ ] Source is recorded consistently enough to compare channels.
- [ ] Resume Version points to the file actually submitted.
- [ ] Sensitive personal and financial data stays out of the workbook.
- [ ] The tracker is reviewed at least twice a week.
When a spreadsheet stops being the right tool
Excel is excellent when you want control, portability, and a workflow you can inspect. Keep it if the file remains easy to update and reliably tells you what to do next.
Move beyond it when data entry becomes a second job, multiple inboxes hold the real status, or applications and outreach are happening faster than you can reconcile them. Do not automate judgment just because manual tracking is annoying. The useful dividing line is covered in what to automate in a job search and what to keep human.
If you want the sourcing, form submission, decision-maker outreach, follow-up, and pipeline reporting handled in one workflow, see how JobFinder AI works. Keep Excel if it serves you. Switch only when the maintenance cost is stealing time from research, conversations, interview preparation, and better applications.
Frequently Asked Questions
What columns should a job application tracker in Excel include?
Start with Priority, Company, Role, Job URL, Source, Location, Date Found, Date Applied, Status, Contact, Last Action, Follow-Up Date, Next Action, Resume Version, and Notes. Add a column only when it changes a decision or prevents a missed action.
Should I use Excel or Google Sheets for a job application tracker?
Use Excel if you prefer desktop files, strong table features, or already work in Microsoft 365. Use Google Sheets if easy browser access and real-time collaboration matter more. The workflow matters more than the brand: one row per role, controlled statuses, next actions, and regular reviews.
How often should I update my tracker?
Update the relevant row immediately after applying, emailing, interviewing, receiving a reply, or making a decision. Review all due and undated active rows twice a week. Waiting until the weekend makes small facts disappear and turns maintenance into archaeology.
What status labels should I use?
Use a short pipeline such as Interested, Preparing, Applied, Contacted, Recruiter Screen, Interviewing, Assessment, Offer, Rejected, Withdrawn, and Closed. Do not create a new label for every company’s hiring terminology.
How do I track follow-ups without annoying recruiters?
Use Follow-Up Date as a review reminder, not an automatic send date. When it arrives, inspect the context. Send a concise note only when you have a legitimate reason, then record the action and set the next review date. Stop when someone declines, asks you not to contact them, or the role closes.
Can Excel automatically show overdue applications?
Yes. Compare Follow-Up Date with TODAY() in a formula, exclude final statuses, and use conditional formatting to highlight rows due today or earlier. Keep the formula tied to named table columns so it expands with new applications.