Why spreadsheets break down at scale

A spreadsheet works fine for the first 10 applications. By application 30, it breaks down in predictable ways.

Manual entry means you forget to log applications when you're in the flow of applying. No reminders means follow-up dates pass silently. Version conflicts between your laptop and phone mean you're working from stale data half the time. And when a recruiter calls out of nowhere about an application you barely remember, you have no quick way to pull up which resume version you submitted or what the job description said.

The fix is not a fancier spreadsheet. It's a tracking system that requires minimal input and surfaces the right information at the right time.

The 5 fields every application tracker needs

These five fields cover the entire job search lifecycle. Everything else is optional:

  1. Company: Company name. Include the specific team or division if it's a large company with multiple open roles.
  2. Role: Exact job title from the posting. Job titles at large companies are frequently non-standard — "Growth Marketing Manager" at one company may be "Senior Demand Gen Lead" at another. The exact title matters for follow-up emails.
  3. Date applied: The date you submitted, not the date you started the application. This is what you use to calculate follow-up timing.
  4. Status: A five-stage pipeline — Applied / Phone Screen / Interview / Offer / Rejected. Every application is always in exactly one stage. Update this the moment the stage changes.
  5. Next action date: The date you've committed to doing something about this application — follow up if no response, send a thank-you note, prepare for an interview. If there's no next action date, the application is in limbo and will never progress.
The minimum viable log entry:

When you submit an application, add one row: Company, Role, today's date, "Applied," and a follow-up date 7 business days from today. That's it. 30 seconds. The tracking system only works if you do it immediately — doing it "later" is how applications fall through the cracks.

The follow-up timing that actually works

Most candidates either never follow up or follow up too aggressively. Both are mistakes.

After submitting an application: Wait 7 business days. If no acknowledgment, send one polite email directly to the recruiter or hiring manager (not the generic HR inbox). Subject line: "Application — [Role Title]." Three sentences: you applied, you remain interested, you're happy to provide any additional information. Never follow up more than once at this stage.

After a phone screen: Send a thank-you email the same day. If you haven't heard back in 3–5 business days, send one follow-up asking about timeline. That's it.

After an interview: Thank-you email the next business day is non-negotiable. If you haven't heard back after 5 business days beyond the timeline they gave you, one follow-up is appropriate. After that, move on mentally — applications that go quiet after interviews rarely revive, and chasing them burns energy better spent on active opportunities.

Tracking which resume and cover letter you used

When a recruiter calls, they may reference something specific from your application materials. If you've been customizing your resume and cover letter (which you should be), you need to know which version went to which company.

The simplest system: name files by company and date. "Acme-Corp-Resume-Jun24.pdf" and "Acme-Corp-Cover-Jun24.pdf." Keep a folder per company. This takes 10 seconds when you're saving the file and saves significant scrambling when a recruiter calls.

If you're applying to many roles where your resume is the same, you only need to track cover letters — they're what vary most. Add a "Cover letter version" column to your tracker with a one-line summary of the angle you took (e.g., "led with growth metrics" or "emphasized team leadership").

Tracking referrals separately

Referrals convert to interviews at a rate 5–10x higher than cold applications. They deserve their own tracking logic.

For referred applications, add two extra fields: who referred you and their relationship to the hiring manager. This matters because your follow-up strategy changes entirely. If your referral is a close colleague of the hiring manager, you can ask your referral to check in on your behalf after a week. If they're a more distant connection, that's a bigger ask.

Don't CC your referral on follow-up emails automatically — ask them first whether they're comfortable being looped in. Some referrals prefer to stay out of the hiring process after making the introduction.

Reading status progression to calibrate your pipeline

Applications that go quiet after the phone screen tell you something different from applications that go quiet after the first interview. Phone screen silence usually means you didn't clear the basic filter — skills, salary expectations, or something in your background didn't match. Interview silence usually means you were competitive but not the top choice.

Track where in the pipeline your rejections cluster. If you're getting phone screens but not interviews, the problem is your verbal presentation — how you talk about your experience, your answers to screening questions. If you're getting to interviews but not offers, the problem is either deeper interview skills or positioning relative to other candidates. The data tells you where to improve.

How JobPilot handles tracking automatically

JobPilot is a Chrome extension that works on LinkedIn, Indeed, Glassdoor, and other job boards. When you generate a cover letter from any job listing, it automatically logs the application to your dashboard — company, role, date applied, and initial status. No separate entry required.

The dashboard shows all your applications in pipeline view with status and next action dates. Free plan covers the basic dashboard and 3 cover letters per day. The $9.99/month Basic plan removes the cover letter limit and adds the full dashboard with follow-up reminders. Pro at $19.99/month adds AI-powered cover letters optimized for ATS.