What should I track in a job-application spreadsheet?
Quick answer
Track each opportunity with the employer, role, posting link or reference, where you found it, key dates, current status, relevant contact, and a specific next action with a due date. Add preparation notes, such as the résumé version used or interview topics to review. Keep the sheet lean: skip sensitive personal details and record only contact information that helps you manage the application.
The question, the details, the next step.
I’m making a spreadsheet to keep track of applications. What columns should I start with so I can tell what needs attention?
Give each application one row, then include fields that answer four questions: What is the opportunity? How did I find it? What has happened? What should I do next?
A useful starter set is:
- Employer and role title
- Job-posting link or reference to the saved posting
- Source, such as an employer careers page, referral, or job board
- Date found and date applied
- Status
- Contact name and professional contact method, if relevant
- Next action and due date
You can also add a few preparation fields: résumé version, materials sent, interview date, and brief notes. Start with these rather than trying to anticipate every detail you might need.
What should I put in the status column? I don’t want it to turn into vague notes.
Use a short, consistent label for the stage, and keep explanations elsewhere. For example: To review, Preparing, Applied, Interviewing, Waiting, Offer, Closed. Define what each means for your own tracker. “Waiting” might mean you completed the latest step and are expecting a response; “Closed” might mean you decided not to continue or the process ended. These are suggested labels, not universal employer terminology.
If you need more context, add a brief note such as “phone screen completed.” Avoid putting an entire conversation history in the status cell; that makes the sheet harder to scan. Consistent labels also make it easier to group similar applications.
How do I track dates and next actions without creating a lot of extra columns?
Separate dates that answer different questions. “Date found” tells you when you saved the opening; “Date applied” records when you sent the application; “Next-action due” reminds you when to do something. Add interview dates when scheduled. If a posting lists a deadline, include it only if useful, and label it clearly so it isn’t confused with your own follow-up date.
For the next action, write a verb and an object, not just “follow up.” For example: “Prepare two examples for the interview” or “Check whether the application needs a writing sample.” If you plan to contact someone, record the task and a date you choose—not an assumed response date. If there’s no useful task to plan yet, leave the field blank rather than guessing.
Can you show me how one row might look? I’m also unsure what contact details are worth saving.
Here’s a hypothetical example. Replace the sample entries with your own:
Employer: [Employer] Role: [Project Coordinator] Posting: [Saved posting link or reference] Source: Employer careers page Date found: [Date] Date applied: [Date] Status: Applied Contact: [Relevant professional contact, if known] Contact method: [Work contact method provided for this process] Materials: [Résumé version or file label] Next action: Prepare a short example of project coordination Next-action due: [Date you choose] Notes: [Brief, job-related detail to revisit]
Save only contact details that help manage the application, such as a recruiter’s name or a work contact method provided for the process. Don’t use the tracker to collect unrelated personal details about other people or sensitive information about yourself. A clear file label or link may be enough; avoid duplicating private documents in the sheet.
What’s a simple way to keep the spreadsheet useful after I start adding lots of roles?
Review active rows from time to time. Check whether the status reflects what happened, whether dates or contact details need updating, and whether the next action is still useful. Mark completed or discontinued applications as closed rather than deleting their history, if you want to retain a basic record. You can move closed rows to a separate tab to keep the active list lean.
Use notes for decisions and preparation, not a transcript of every message. Before sharing the sheet, remove or replace details the recipient doesn’t need. A useful tracker helps you act; it doesn’t need to become a second copy of every application document.
A practical checklist
Create one row per role; include employer, title, posting reference, and source.
Record relevant dates, such as found, applied, deadlines, and scheduled interviews.
Choose a small set of status labels and use them consistently.
For each active application, add a specific next action and a date to revisit it.
Save only job-relevant contact details and notes; avoid unnecessary sensitive information.
Review active rows periodically and move finished applications to a closed section if useful.
A few more useful answers
Should I include salary expectations in my application tracker?
Only if recording them helps you manage a particular application. Label the field clearly and keep it optional; avoid adding unrelated financial or personal details.
Do I need a separate row for every interview?
Usually, one row per role is easier to scan. Add interview dates in a dedicated field or brief note; use a separate log only if you need more detailed preparation notes.
What if I don’t know a contact person or follow-up date?
Leave the contact blank or mark it “not provided.” Don’t guess a name or invent a follow-up date; set a next action only when you have a useful step to take.