Job Application Tracker: How to Build One in a Spreadsheet

Picture this: a recruiter calls on a Tuesday afternoon, says “Thanks for applying to the operations role,” and you have no idea which operations role she means. You applied to six this month. You can’t remember which resume she saw, what the posting promised, or whether you already followed up. You say “Sure, great to hear from you,” and hope for the best.

A tracker fixes that moment. It’s a plain spreadsheet with one row per application, and it takes about two minutes per job once it’s set up. This guide shows you how to build one in Google Sheets or Excel, which columns earn their place, how to add drop-downs and a few simple formulas, and how to use the data to change your search.

Key takeaways

• One row per application, one tab for contacts, and a short list of statuses is enough.
• Update the sheet right after every action, then review it for 20 to 30 minutes once a week.
• A follow-up date column plus one formula tells you what to do each morning.
• Your own numbers (sources, resume versions, response rates) show what to change.
• Keep passwords and sensitive IDs out of the sheet, and be careful with offers that ask for them.

Why a tracker is worth the effort

Career centers keep giving the same advice for a reason. A tracking guide from the Tufts Friedman School career office says a log helps you follow up at the right time, avoid missed deadlines and duplicate applications, and spot patterns in your search. BeamJobs goes further and calls poor tracking the biggest common mistake in organizing a search, since it leads to missed follow-ups, deadlines and interviews.

For some people it’s also a legal record. If you collect unemployment insurance, your state may require proof of your job search. New York’s Department of Labor, for example, requires at least three work search activities each week and a written record of them, including dates, employer names and contact details, positions and contact methods. Rules differ by state, so check your own agency’s instructions. A well-kept tracker can feed that record, though you may still have to use the state’s form or portal.

Pick your tool

The best tool is the one you’ll open every day. Tufts lists four options: a spreadsheet, a dedicated tracking app, a notes app or a paper planner. Here’s how they compare.

Google Sheets is free and syncs to your phone. Excel has strong formulas and works offline. Apps add reminders but may be paid and hold your data on their servers. A notes app or notebook is quick but hard to sort and count.

This guide uses a spreadsheet because it’s free, flexible and lets you count things. The steps are nearly identical in Google Sheets and Excel. Where menus differ, both are noted.

The columns that matter

Start with the essentials and add a column only when you catch yourself wishing you’d written something down. Sources such as ClickUp suggest a starter set of job title, company, date applied, status, next steps and notes. Careerflow and Tufts add the source of the listing, the application method, the resume version and the contact person.

Here’s a set that covers all of that.

Column	What goes in it	Example
A. Company	Employer name	Riverbend Health
B. Role	Exact title from the posting	Operations Coordinator
C. Link	URL of the posting	Paste the full address
D. Source	Where you found it	Company site, job board, referral
E. Date applied	Day you submitted	10/06/2026
F. Resume version	File name you sent	Ops_Resume_v3.pdf
G. Status	One of your set statuses	Applied
H. Contact	Recruiter or hiring manager	Name and email
I. Follow-up date	When to nudge	10/13/2026
J. Next step	The one thing to do	Email recruiter
K. Posting saved	File name of saved copy	Riverbend_Ops.pdf
L. Notes	Anything else	Salary range listed, remote 2 days

Two columns deserve a closer look.

Resume version and posting saved

Careerflow recommends saving the full text of the job ad in case the posting is taken down, and linking to the exact resume and cover letter you used. Do both. When an interview invitation arrives three weeks later, the saved posting tells you what they asked for, and the file name tells you what they saw. If you tailor your resume for each role, this column is what keeps the versions straight. Our guide on tailoring your resume for every application covers how to do that without starting from scratch each time.

Next step

A status says where you are. A next step says what to do, such as “Prepare two examples and confirm time.” Fill it in every time and your weekly review writes itself.

Choose a short list of statuses

Statuses are where trackers get messy. If you write “Waiting,” “waiting to hear,” “Pending” and “no reply” in four different rows, you can’t filter or count them. Pick a short list and stick to it.

Tufts suggests tracking stages from applied through phone interview, in-person interview, offer, rejection or withdrawn. A slightly finer list works well:

1. Saved - you found it but haven’t applied
2. Applied - submitted
3. Screen - recruiter or phone screen scheduled or done
4. Interview - one or more interview rounds
5. Offer - you received one
6. Rejected - they said no
7. Withdrawn - you pulled out
8. No response - set this after the follow-up window passes

The “No response” status keeps old rows from looking alive. Many postings never lead to a conversation at all. If you want to know why, read about ghost jobs and how to spot them.

Set it up step by step

You can finish this in about 20 minutes.

1. Create a new spreadsheet used only for your job search. Name it something plain, like “Job Search 2026.”
2. Rename the first tab “Applications.” Type your column headings in row 1.
3. Freeze the header row. In Google Sheets, choose View, then Freeze, then 1 row. In Excel, choose View, then Freeze Panes, then Freeze Top Row.
4. Turn on filters. In Google Sheets, select the header row and choose Data, then Create a filter. In Excel, choose Data, then Filter. You’ll use this to see only active applications.
5. Add the drop-down for status (next section).
6. Add color rules (below).
7. Add a second tab called “Contacts” (covered later).
8. Enter your current applications. Backfill what you can find in your email and browser history, then start fresh from today.

Add drop-downs so entries stay clean

Drop-downs stop typos and keep your counts accurate. Google’s help page walks through it. In Google Sheets:

1. Select the cells in the Status column (for example G2 to G500).
2. Choose Insert, then Dropdown. You can also use Data, then Data validation, then Add rule.
3. Under Criteria, pick “Dropdown” and type each status as an item, such as Saved, Applied, Screen and so on.
4. Click Done.

In Excel, select the cells, choose Data, then Data Validation, set “Allow” to List, and type your statuses in the Source box, separated by commas.

Tip: type your statuses on a spare “Lists” tab and point the drop-down at that range, so one edit updates every row. Do the same for Source so you don’t get “LinkedIn” and “linkedin” as two things.

Color the statuses

In Google Sheets, choose Format, then Conditional formatting, and set one rule per status. In Excel, use Home, then Conditional Formatting. Keep it to four or five colors.

A few formulas that do the nagging for you

You don’t need advanced spreadsheet skills. Three small formulas cover most of what you need. The cell references below assume the layout in the column table, with data starting in row 2. Test each one on a few rows before copying it down.

Formulas to copy

• Auto follow-up date: in I2, type =E2+7. This sets a reminder date a week after you applied. Change 7 to match your plan. To skip weekends, use =WORKDAY(E2,5), which gives five business days.
• Days since applied: in a spare column, type =TODAY()-E2. It shows how long each application has been waiting.
• Overdue flag: =IF(AND(G2="Applied",I2<=TODAY()),"Follow up","") shows “Follow up” when a row is due.

The overdue flag is the most useful. Put it in an “Action” column and filter on it each morning.

For counts, use COUNTIF. For example, =COUNTIF(G:G,"Interview") tells you how many applications reached the interview stage. =COUNTA(A:A)-1 counts all rows, minus the header. We’ll use these in the review section.

If formulas feel like too much, sorting by follow-up date does most of the job.

What a filled-in sheet looks like

Here’s a small illustrative example. These companies and dates are made up.

Company	Role	Date applied	Status	Follow-up	Next step
Riverbend Health	Operations Coordinator	10/06	Applied	10/13	Email recruiter
Larkspur Logistics	Dispatch Planner	10/07	Screen	10/14	Prep for Thursday call
Brightline Foods	Procurement Analyst	10/08	Saved	n/a	Tailor resume, apply by Friday
Cedar Ridge Schools	Admin Specialist	09/22	No response	n/a	Close out
Northgate Supply	Inventory Analyst	09/29	Rejected	n/a	Note feedback, none given

Read it in five seconds: one email, one call to prepare for, one application to finish, two rows to ignore.

Build the contacts tab

Applications involve people, and you’ll meet more of them than you expect: recruiters, hiring managers, interviewers, and anyone who referred you. Careerflow suggests logging contact details and conversation notes, and setting reminders to follow up. A separate tab keeps that tidy without crowding the main sheet.

Suggested columns for the Contacts tab:

• Name
• Company
• Role or relationship (recruiter, interviewer, referrer, alumni contact)
• Email or LinkedIn link
• How you met or were introduced
• Last contacted (date)
• Next contact (date)
• Notes (topics discussed, what you promised)

The “Last contacted” column is the quiet hero. It stops you from emailing the same person three times in a week, and it reminds you to thank people who helped. If you’re asking friends or acquaintances for introductions, our piece on asking for a job referral without feeling awkward has scripts you can use, and the Contacts tab is where you track who you’ve asked.

Follow-up timing and a short script

How long should you wait? There’s no universal rule. Careerflow says to follow up after a “reasonable timeframe” without naming one. BeamJobs suggests about five to seven business days after applying. A week is a sensible default for an application, and the timing for interviews is shorter: send a thank-you within a day, and if the employer gave a decision date, wait until it passes before checking in.

A simple schedule to put in your sheet:

Event	When to follow up	Where to record it
Application submitted	About 5 to 7 business days later	Follow-up date column
Interview finished	Thank-you within 24 hours	Next step column
Employer’s stated deadline passes	1 to 2 business days later	Follow-up date column
No reply after your follow-up	Close the row as “No response” after another week or so	Status column

Follow up once, maybe twice, then move on. Write to a real person, such as the recruiter, when you can find one.

Application check-in

Subject: Following up on the Operations Coordinator application

Hello Ms. Alvarez,

I applied for the Operations Coordinator role on October 6 and wanted to confirm that my application arrived. I’m still very interested, especially in the vendor scheduling work described in the posting. If it helps, I’m happy to send additional information.

Thank you for your time.

Jordan Lee

Log it right away: change the follow-up date and write “Followed up 10/13” in Notes. For interview thank-yous and later check-ins, see our follow-up email templates.

Your weekly review

The tracker only pays off if you look at it. BeamJobs recommends a weekly progress check to see what’s working and adjust. Block 20 to 30 minutes at the same time each week, such as Friday morning or Sunday evening.

Here’s a checklist you can follow.

• Clean up. Fill gaps, fix statuses, and mark anything past its window as “No response.”
• Clear the follow-ups. Filter by the Action column and send what’s due.
• Plan next week. Choose how many new roles to apply to and note them as “Saved.”
• Check your contacts. Is anyone due a thank-you, an update or a reply?
• Count. Record this week’s totals (see next section).
• Pick one change. Adjust one thing for next week, not five.

Read your own data

After a few weeks, the sheet starts answering questions. You don’t need a big sample for it to be useful, but be careful about conclusions from small numbers. Ten applications can’t prove much. Treat the results as hints, not verdicts.

Here are four simple things to look at.

1. Response rate. Applications that led to any reply, divided by total applications. If it’s very low, the problem may be your resume, your targeting, or both.
2. Rate by source. Sort by the Source column. Do referrals or direct company applications lead to more replies than job boards? Many career writers, including BeamJobs, say networking tends to be the most effective method, and your data can confirm or challenge that for you.
3. Rate by resume version. If version 3 gets replies and version 2 doesn’t, look at what changed.
4. Where things stall. Many “Applied” but few “Screen” suggests a resume or fit problem. Many “Screen” but few “Interview” suggests a phone-screen problem. Many interviews but no offers points to interview prep.

Don’t over-read small numbers

Employers can reject you for reasons that have nothing to do with you, including internal hires, budget changes and posted jobs that were never filled. Use the data to decide what to test next, not to judge yourself.

Privacy and scam caution

A job tracker is a private document. Treat it like one.

• Skip passwords. Never store logins for job sites or email in the sheet. Use a password manager instead.
• Leave off sensitive IDs. Don’t put your Social Security number, bank details or date of birth in the file.
• Check sharing settings. In Google Sheets, make sure the sheet isn’t set to “anyone with the link.” If you share it with a mentor or career coach, send a view-only copy with personal details removed.
• Protect the account. Use a strong password and two-step verification on the account that holds the sheet.

The sheet also helps you spot scams. The Federal Trade Commission warns that real employers don’t ask you to pay to get hired, and that a check you must deposit and then send money back from is a fake check scam. It also notes that reshipping packages is never a real job, and it advises searching a company or recruiter’s name along with words like “scam” or “complaint.” Add a “Verified?” column to your tracker and mark each employer yes or no after you’ve checked that the company, the posting and the contact are real. If something feels off, our list of job scam red flags can help, and you can report fraud at ReportFraud.ftc.gov.

This is general information, not legal advice. For unemployment benefit rules, follow your own state agency’s instructions.

Common mistakes to avoid

• Updating in batches. If you wait until Sunday to log a week of applications, you’ll forget details. Update right after you act, as Careerflow stresses.
• Too many columns. A sheet that takes ten minutes per row won’t last. Trim it.
• Free-text statuses. Typing a new phrase each time breaks your filters and counts. Use the drop-down.
• Not saving the posting. The link dies, and so does your memory of the requirements.
• Skipping rejections. Log them. They stop you from reapplying by accident and show you patterns.
• Never looking at it. A tracker you don’t review is just a diary.

The bottom line

A tracker doesn’t get you hired. It keeps you from losing track of the chances you’ve already created, and it shows you what to change. Keep it small, update it fast and look at it weekly.

Your next steps:

1. Create a new sheet with the 12 columns above, or a shorter version.
2. Add a Status drop-down with your eight statuses.
3. Enter every application you can remember and save each posting.
4. Add the follow-up date formula and the Action flag.
5. Set a recurring 20-minute weekly review on your calendar.
6. Add a Contacts tab, and mark each employer as verified before you share personal details.