Build a Simple Job-Application Tracker That Tells You What to Do Next

Quick answer: Use one spreadsheet row per job opportunity. Record the employer, role, job ID, deadline, application status and submitted documents. Then add two essential columns: Next action and Action date. Keep employer deadlines separate from your own reminders, and review active rows weekly.

This setup is for first-time applicants, graduates, career changers and people returning to work. Start with a spreadsheet you already know how to use; the instructions below do not require a paid tracking service.

CareerOneStop recommends recording the positions you apply for and employers you contact. Stanford’s job-search action plan likewise recommends a tracking system that records submission, follow-up and interview dates. The structure below turns that record into a practical task list. (cloudfront.careeronestop.org)

1. Create one row per opportunity, not per activity

Start a sheet called Applications. Give each distinct opportunity one row, including jobs you are preparing to apply for.

Use the employer, job title and job ID together to identify it. Before adding another listing, search your sheet for those details. As a working rule, keep matching listings in the same row unless the employer’s instructions show they are separate opportunities.

Keep a short activity history inside that row rather than creating new rows for every email:

• October 19: Application submitted; receipt saved.
• October 22: Interview invitation received.
• October 23: Interview time confirmed.

For separate roles at the same employer, use separate rows. For a reposted role with a different job ID, note the earlier application and check the employer’s reapplication instructions before submitting again.

Practical check: Can you find the opportunity without remembering where you first saw it? If not, add the job ID or official posting link.

2. Add fields that support a decision or task

Use these columns as a starting point. The examples are illustrative, not real vacancies.

Field	What to record
Employer and role	The published employer name and job title
Job ID	The employer’s reference number, if supplied
Posting and portal	Official listing and application-account links
Employer deadline	Closing date, time and time zone as stated
Date applied	Actual submission date; leave blank until submitted
My status	Your consistent label from Section 3
Employer status	Exact portal wording, with the date checked
Documents	Links to the resume and other files actually submitted
Last contact	Date and brief factual summary
Next action	One specific task
Action date	When you will do that task
Notes	Instructions, confirmation reference and unresolved questions

If a posting gives no closing date, enter Not stated. Do not invent one. Set your own preparation or submission target in Action date instead.

Keep employer deadlines and personal reminders separate. “Submit by October 28” and “check portal on November 4” serve different purposes.

For timed events, record the time zone. If the employer has not stated one, make “Confirm time zone” your next action.

Keep optional fields—such as location, work arrangement or priority—only if they help you choose what to do. You can add them later.

3. Define statuses without guessing what employers mean

Use a short set of labels for your own workflow:

My status	Use it when…
Saved	You have found a role but have not started applying
Preparing	You are tailoring documents or completing the form
Submitted	You have evidence the application was sent
Action required	The employer requests a task or response
Interview scheduled	An interview date is confirmed
Awaiting update	You have completed the current step
Offer received	You have received an offer to review
Closed	There is a confirmed outcome, or you have stopped pursuing it

For Closed, add a reason: rejected, withdrawn, role canceled, offer declined, offer accepted or archived by personal choice.

Keep these labels separate from the employer’s wording. NIST explains that its application-status messages reflect stages in the process but may not explain how an application is being evaluated. It also says review timelines vary. Do not turn an ambiguous status into a prediction about your chances. (nist.gov)

In particular, do not mark an application rejected solely because you have heard nothing. If you choose to stop actively checking it, record Archived by personal choice—no decision received.

Practical check: “Submitted” should point to a receipt, confirmation screen or portal record—not merely a completed draft.

4. Link the exact documents you submitted

Create a private folder for each opportunity and link it from the tracker. Save the posting, submission confirmation and submitted documents together.

Use filenames that identify the role and version, for example:

• Resume_AdminAssistant_J104_2026-10-19.pdf
• CoverLetter_AdminAssistant_J104_2026-10-19.pdf
• Posting_J104_2026-10-18.pdf

These are suggested naming conventions, not employer requirements.

Keep the submitted version unchanged. If you revise your resume later, save a new file rather than replacing the earlier one. Before an interview, use the tracker to reopen the exact version the employer received.

Follow the particular application’s file instructions. For example, Greenhouse’s published documentation lists several supported document formats; that does not establish what every employer or application portal accepts. Greenhouse’s upload guidance is platform-specific.

Store portfolio links separately from private application files. Before sending a portfolio link, test access without being signed into your account. Before sharing the tracker with an adviser, check whether its document links expose more than you intend.

5. Schedule a next action—not an automatic follow-up

Write tasks that begin with a verb:

• Finish the employment-history section.
• Complete the requested assessment.
• Confirm the interview time.
• Check the official portal.
• Ask the named contact about the timeline.

“Waiting” is a status, not a task.

Use this order when choosing the action date:

1. Honor an employer deadline. Record the exact instruction and set a preparation reminder.
2. Use a promised update date. If it passes, check the employer’s stated contact process.
3. Check the official portal or FAQ.
4. If no timeline exists, set a personal review date. Decide then whether an inquiry is appropriate.

A reminder to review an application is not permission to send another message.

For federal applications, USAJOBS directs questions to the agency contact listed in the announcement. Its guidance warns that contacting an agency too early may not produce useful information because review takes time after a job closes. Do not apply that federal process as a universal timetable for private employers. (usajobshelp.opm.gov)

NIST provides a useful example of why “submitted” may not mean “finished”: it says some assessments arrive after submission and must be completed by their stated deadline. Track requested tasks separately from the initial application. (nist.gov)

When follow-up is permitted and appropriate, keep it brief:

Hello [name], I applied for [role, job ID] on [date]. You mentioned an update by [date], so I’m checking whether there is a revised timeline or anything further you need from me. Thank you.

Use only facts that apply. Do not invent a promised response date.

6. Worked example: turn four rows into today’s plan

Fictional example: The following employers, job IDs and events are invented for illustration. They are not vacancies or recruitment leads. Assume the review date is October 26, 2026.

This compact view shows selected columns; the full tracker would also contain posting, portal and document links.

Employer / role / ID	My status	Employer deadline	Last event	Next action	Action date
Fictional Employer A / Office assistant / J104	Preparing	Oct. 28	Draft completed Oct. 25	Check requirements and submit	Oct. 26
Fictional Employer B / Support trainee / J205	Submitted	Not stated	Receipt saved Oct. 19	Check portal and communication instructions	Oct. 29
Fictional Employer C / Scheduling assistant / J306	Interview scheduled	Interview: Oct. 30, 10 a.m. Eastern	Invitation confirmed Oct. 23	Prepare examples and interviewer questions	Oct. 27
Fictional Employer D / Operations trainee / J407	Action required	Assessment: Oct. 27, 5 p.m. Eastern	Instructions received Oct. 26	Complete assessment	Oct. 26

On October 26, the applicant should:

1. Review and complete Employer D’s assessment instructions because its deadline is nearest.
2. Finish Employer A’s application and verify submission.
3. Leave Employer B alone until its scheduled review unless a new message arrives.
4. Keep Employer C’s preparation task on October 27.

After submitting to Employer A, the applicant saves the confirmation, enters the submission date, changes the status and chooses a new review action.

The key habit is simple: finishing one task should leave the row with a clear next step—or a documented reason to close it.

7. Keep a short weekly review and a private tracker

Choose a recurring review time that fits your schedule. Use this order:

1. Check immediate commitments: deadlines, interviews and requested tasks.
2. Update evidence: receipts, portal wording and factual contact notes.
3. Resolve next actions: give every active row a task and date.
4. Check duplicates: compare employer, role and job ID.
5. Close completed opportunities: record the reason and retain useful files.
6. Plan the coming week: choose work you can realistically complete.

Stanford’s action plan recommends weekly job-search goals and tracking application milestones. Use those principles without turning your tracker into an application-volume contest. (careered.stanford.edu)

For privacy, keep the sheet restricted to people who need it. Do not store passwords, Social Security numbers, bank details, identity-document scans or sensitive medical information in it. Share a redacted copy with an adviser rather than your full working file.

Treat unexpected recruitment messages as claims to verify, not evidence that an application has advanced. The North Carolina Department of Justice warns that scammers may imitate recruiters and conduct convincing fake hiring processes. It recommends independently verifying employers and avoiding early disclosure of personal or financial information. Read its employment-scam alert.

8. Avoid maintenance mistakes and run the setup checklist

Watch for these mistakes:

• Updating only when you remember: make the tracker update part of submitting, replying or finishing an interview.
• Using color without text: write the status and deadline explicitly.
• Sorting one column alone: sort the entire table so each opportunity’s details stay together.
• Treating silence as a decision: distinguish confirmed outcomes from your own archiving choice.
• Replacing submitted files: preserve the version associated with each application.
• Adding too much detail: remove fields you never use to make a decision.
• Following up on every reminder: check instructions and contact history before sending anything.

Before relying on the sheet, complete this checklist:

• Each opportunity has one identifiable row.
• Unknown deadlines say “Not stated.”
• Employer deadlines are separate from personal action dates.
• Submitted applications have supporting evidence.
• Document links open the correct versions.
• Each active row has a next action and action date.
• Interviews and urgent deadlines are also on your calendar.
• Sharing permissions are restricted.
• A weekly review is scheduled.

Finally, open the tracker and ask: “What should I do next?” If you still need to reconstruct the answer from your inbox, rewrite the next-action fields before adding more columns.