To track job applications so nothing slips, keep a single list with one row per application, record the same few details each time, and look at it every day for a follow-up or next step. A spreadsheet or a printed log works equally well as long as you use it consistently.
A job search can run for weeks or months, with dozens of postings, versions of your resume, emails and interviews. Memory fails quickly. This guide shows what to record, which statuses to use, how to plan follow-ups and how to keep the system light enough that you will actually use it.
Why tracking pays off
When you send several applications a week, the details blur. You may forget which resume version you used, who emailed you back, or which company asked for a portfolio sample by Friday. A tracker solves three problems:
- Missed deadlines and follow-ups. You see what is due today at a glance.
- Repeated work. You do not apply to the same job twice or forget you already spoke with a recruiter.
- Clear patterns. After a few weeks you can see where applications stall and adjust.
It also eases stress. A job search can feel shapeless, and a simple list gives you something concrete to move forward.
What to record for every application
Keep it short. You are building a tool, not a diary. These columns cover most needs:
| Column | Why it helps |
|---|---|
| Company | Sorting and searching |
| Role title | Helps when two roles are at the same company |
| Link to posting | Postings disappear, so save the text or a screenshot too |
| Date applied | Your timeline |
| Source | Job board, referral, company site, recruiter |
| Resume or cover letter version | So you can repeat what works |
| Status | The current stage (see below) |
| Contact | Name and email of recruiter or hiring manager |
| Pay range | If listed, for later comparison |
| Next step | One short action |
| Follow-up date | The most important column |
Do not store passwords for job portals in a shared or unprotected file. Use a password manager instead.
Choose a short list of statuses
Too many statuses create more work than value. Six or seven are enough:
- Saved: you found the job and may apply.
- Applied: the application is sent.
- Screening: a recruiter has replied or scheduled a call.
- Interviewing: you are in one of the interview rounds.
- Offer: you have received an offer.
- Closed: rejected, withdrawn or no response after your last follow-up.
A dropdown menu for status keeps your entries consistent and makes filtering easy.
Set up a daily and weekly routine
A tracker is only as good as your habit. Try this rhythm.
Every application, same day
Log it as soon as you hit send, while the details are fresh. Paste the link, note the resume version and set a follow-up date. If you wait until the weekend, you will forget something.
Every morning, ten minutes
Sort by follow-up date and handle what is due. That might mean sending a short email, preparing for an interview or marking a job closed. Add new leads to "Saved".
Every week, thirty minutes
Review the full list. Count how many applications you sent, how many replies you received and how many interviews you scheduled. Set a modest weekly goal, for example "ten tailored applications", that fits your life. Tailored beats mass-sent.
Plan your follow-ups
Following up shows interest and often gets your application a second look. Some practical points:
- Follow instructions first. If a posting says "no calls" or gives a date for hearing back, respect it.
- Choose a default gap. Many job seekers check in roughly one to two weeks after applying, but use your own judgement and the timeline in the posting.
- Keep it short. Two or three sentences: who you are, which role, a polite question about the timeline.
- Limit the number. One or two follow-ups are enough. After that, mark the application closed and move on.
- Thank interviewers. Send a short thank-you note after each interview and record the date.
Put each follow-up in your tracker as a date. Conditional formatting that turns overdue dates red makes it hard to miss.
Track interviews separately
Interviews generate more information than one row can hold. Keep a second sheet or page with:
- Date, time and format (phone, video, on-site)
- Names and roles of interviewers
- Questions you were asked and how you answered
- Questions you want to ask next time
- Anything you promised to send
- Whether the thank-you note is sent
This helps you prepare for the next round and gives you material for future interviews.
Compare offers calmly
If more than one offer arrives, put them side by side. List pay, benefits, commute or remote options, growth opportunities and anything else that matters to you. Give each factor a weight that reflects your own priorities, then see how the options score. It will not make the decision for you, but it brings your thinking into the open.
Networking counts too
Many openings come through people. Keep a short list of contacts: name, how you know them, when you last talked and when you plan to reach out again. A quick message to a former colleague takes five minutes and can be tracked the same way as an application.
Mistakes to avoid
- Waiting to log things. A tracker that is a week behind is useless.
- Too many columns. If you stop filling them in, remove them.
- No saved copy of the posting. Listings vanish after the application closes.
- Ignoring rejections. Mark them closed so the list stays honest and manageable.
- Treating the tracker as a score. It is a tool, not a measure of your worth.
Frequently asked questions
How to track job applications in a spreadsheet?
Create one row per application with columns for company, role, link, date applied, status, contact and next follow-up date. Add a dropdown for status and sort by follow-up date each morning.
How to keep track of my job applications without getting overwhelmed?
Log each application the same day you send it, use a short list of statuses, and review the sheet once a day for ten minutes. Keep notes brief; the goal is knowing what to do next.
How often should you follow up on a job application?
There is no single rule. Many job seekers check back about one to two weeks after applying, or on the date the employer gave. Read the posting, follow any instructions and keep follow-ups polite and short.
Can I use Google Sheets or Excel to track job applications?
Yes. Both work well because you can sort, filter, add dropdowns and highlight overdue dates. Choose whichever you open most often, and keep a backup copy.
Should I track job applications on LinkedIn or Indeed instead?
Job sites keep their own application lists, but they only show what was applied through them. A separate tracker covers every source, including emails, referrals and company websites.
What should I write down for each interview?
Note the date, who you spoke with, the questions asked, what you promised to send and when you sent your thank-you message. Add one or two follow-up thoughts while it is fresh.
A ready-to-use option
If you prefer not to build the sheet yourself, our Job Application Tracker offers a ready system: an Excel workbook with sheets for applications, interviews, offers, networking and a dashboard, plus a 20 page printable job search planner in US Letter and A4. Overdue follow-ups turn red, so you can see what needs attention first. Use it, or copy the ideas above into any spreadsheet you like.