Job Search Spreadsheet Template for Google Sheets and Excel
Build a job application tracker in Google Sheets or Excel with a copyable starter table, status options, follow-up dates and links to submitted resume files.
On this page
A useful job-search spreadsheet answers three questions: what did I apply for, what did I submit and what should I do next? It can work for a small search or a long one if the records are clear and maintained.
Below is an in-page template you can copy into Google Sheets or Excel, with a fictional starter row and setup instructions. There is no downloadable workbook on this page. Adapt the columns to your search, then use the file and posting records to prepare for conversations.
Keep one record for each application
Assign a stable application ID such as J001 to each distinct application. Use the same ID for its saved posting and submitted documents. A row number is a poor identifier because sorting or inserting rows changes its position.
Record the employer’s job or requisition ID when available, especially when one company advertises similar roles. Before applying again, check whether it is the same opening, a new requisition or a renewed posting. Do not assume every duplicate automatically leads to rejection.
A tracker can remind you of an agreed next step, but it cannot make an employer respond. Follow the contact instructions and timeline provided. If applications are portal-only or the employer says not to follow up, do not use a calendar reminder as a reason to bypass that instruction.
A practical starting set of columns
The thirteen columns below cover a basic workflow. Add or remove fields according to what you actually use; there is no correct universal column count. Keep private contact information and notes limited to what is needed for the search.
| Column | What to record | How it helps |
|---|---|---|
| Application ID | A stable value such as J001 | Connects records even after sorting. |
| Company | Employer name | Groups applications without confusing separate openings. |
| Job title | Title and requisition ID, if available | Distinguishes similar roles. |
| Job link | Original posting URL | Provides a reference alongside a dated saved copy. |
| Salary range | Disclosed range, currency and pay period, or Not stated | Keeps comparable terms; do not invent missing pay. |
| Contact | Authorized contact or application channel | Records whom to contact and any instructions. |
| Status | Saved, Applied, Screening, Interview, Offer, Accepted, Rejected, Withdrawn or Closed | Shows the current stage; define any extra statuses consistently. |
| Date applied | Actual submission date | Separates a saved opportunity from a submitted application. |
| Next action | A specific task, or Awaiting response | Makes open work visible without inventing a follow-up obligation. |
| Next action date | Task due date or personal review date | Helps prioritize; it is not an employer deadline unless confirmed. |
| Submitted resume | Link or path to the exact submitted file | Preserves what the employer received. |
| Priority | Your own High, Medium or Low judgment | Organizes attention; it is not a hiring probability. |
| Notes | Brief context, timeline and links to related records | Supports preparation without duplicating every document. |
For a pending application, distinguish a task you control from waiting on someone else. “Send the requested portfolio by Friday” is an action. “Check the portal next week” is a personal review reminder. Neither means the employer has promised a response.
When a step is completed, record the relevant result and set the next action if there is one. Clear obsolete dates on closed applications so they do not keep appearing as overdue work.
Copy this starter table into a blank sheet
| Application ID | Company | Job title | Job link | Salary range | Contact | Status | Date applied | Next action | Next action date | Submitted resume | Priority | Notes |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| J001 | Fictional Cedar Studio | Operations assistant — DEMO-01 | Replace with posting URL | Not stated | Application portal | Applied | 2026-10-01 | Review portal status | 2026-10-08 | Replace with submitted file link | Medium | Fictional example. Saved posting in J001 folder; no follow-up contact invited. |
Set up the tracker in Google Sheets
- Copy the starter table into cell A1 of a blank Applications tab. Confirm that the header occupies one row across columns A–M. If your browser pastes it into one cell, enter the thirteen headers from the table manually. Replace or delete the fictional row.
- Freeze row 1 using View → Freeze → 1 row. Select the application range and use Data → Create a filter. When sorting, include the whole record range so dates and file links stay with their application.
- Select the Status cells below the header and use Data → Data validation to create a dropdown with your chosen statuses. Do not include the header as a status value.
- Format Date applied and Next action date as dates, then check that a test sort orders them chronologically. Use one display style, such as YYYY-MM-DD. A date-looking text value may still sort as text.
- Add optional Contacts and Job Descriptions tabs, linked by Application ID. Use those IDs rather than row numbers. Keep saved documents in folders you can locate reliably.
- Use color only as an extra cue, with readable status text retained. Share the tracker and linked files only with intended people and check their permissions.
Set up the same tracker in Excel
Paste the starter table into A1, verify the columns and replace the fictional row. Convert the application range to a table with headers so its filters operate on complete records. In Excel for Windows, Ctrl+T opens the table dialog; menu options vary by version.
For a status dropdown, select the cells and use Data → Data Validation → List, with your status values or a reference to their range. Microsoft’s dropdown instructions cover platform differences. Its sorting guide explains range and table sorting. Avoid sorting a single data column independently of the other application fields.
For Sheets, the official guides cover dropdowns, freezing rows and filters and sorting. Choose the spreadsheet you can access and maintain, considering sharing, offline needs and the version available to you.
Keep an exact copy of each submitted resume
A spreadsheet can track resume versions when the links point to reliable files. Keep your editable source separate from the file you actually submitted. Once you apply, do not overwrite that submitted copy with later edits.
One possible folder structure is J001-Cedar-Studio-Operations-Assistant, containing the saved posting, submitted resume and any cover letter. A filename such as J001-resume-submitted-2026-10-01.pdf records purpose and date. Use the format the employer accepted; PDF is not compulsory. Put a direct file link or reliable local path in the tracker and test that you can open it.
When you improve a reusable bullet, update your master resume separately. Keep the submitted version as historical evidence. If you send a replacement, save it as a new file and record when and how it was sent. The tailoring guide explains how to select relevant experience without inventing qualifications.
Save a dated copy of the posting
A job link can change or disappear. Alongside the URL, keep a dated copy of the information you are allowed to retain, including duties, qualifications, location, pay terms and requisition ID. Do not rely on a live link as the only record.
Use an Application ID to connect a saved text or PDF copy with the tracker. For a Job Descriptions tab, columns such as Application ID, Capture date, Source URL and Posting text are sufficient. The saved copy records what you saw at that time; it does not prove that the vacancy is still open or that its terms have not changed.
Before an interview, compare the saved posting with any newer information from the employer. It can help you prepare relevant examples, but it cannot reveal hidden ATS filters or explain an employer’s decision.
Decide whether another tracking tool would help
There is no application-count threshold at which spreadsheets stop working. Consider a different tool if recurring maintenance problems outweigh the effort of switching. First check whether a simpler sheet or better file links would resolve them.
- You repeatedly lose the connection between an application and its submitted documents.
- You need reminders or views that you do not want to maintain in the workbook.
- You are duplicating records across tools and no longer know which one is current.
- Collaboration or mobile access is difficult in your current setup.
Before switching, test a few sample records. Confirm that the new tool preserves the information you need, opens the correct files and lets you retrieve or export your records. Check how it handles deleted postings, editing, sharing and account access; do not assume any service stores every snapshot permanently.
Roleframe is our product and includes job-tracking and resume workflows. Compare its current features and limits with your needs. A spreadsheet remains a reasonable choice when it works for you, and changing tools does not itself improve hiring outcomes.
A short maintenance routine
After applying: record the submission date, exact document link and confirmation details you need. Check that the status says Applied rather than Saved.
At your next search session: review due actions, complete or reschedule them deliberately and clear stale tasks. Add new information from emails or calls without treating silence as a rejection unless you have defined a separate closed-for-your-own-planning status.
Periodically: check for duplicate IDs and broken links, back up or export the tracker and review who can access it. Keep factual notes rather than unnecessary personal information about contacts. If sharing with a coach, make sure linked resumes and notes have the intended permissions too.
Look for patterns cautiously. Different roles, timing and small sample sizes can affect response rates. A tracker can help you ask better questions about your search, but rejection or silence alone does not prove that a particular resume feature caused the outcome.
Frequently asked questions
- How do I make a job-search tracker in Excel?
Use the starter table, replace the fictional row and format the application range as a table with headers. Add a status dropdown through Data Validation and use real date values. Sort whole records, not one column by itself.
- Can I use Google Sheets?
Yes. Copy the headers into a blank sheet, freeze row 1, add a filter and create a status dropdown. Check date formatting and sharing permissions. Choose the tool that fits your access and collaboration needs.
- How do I track many applications?
Use one stable application ID per record, consistent statuses, reliable document links and a regular review routine. Record next actions where there are real tasks; a waiting application can have a personal review date instead. No fixed application count requires changing tools.
- How do I know which resume I sent?
Save the exact submitted file separately from your editable source and link it to the application ID. Do not overwrite it after applying. If you send a replacement, retain both and record the new submission.
- Should I keep rejected applications?
They can provide useful history and prevent confusion, but keep only the information you need and set a retention approach that suits you. Do not infer a rejection reason from a status alone or treat a small sample as proof of what caused it.
- Is there a workbook to download here?
This page provides an in-page starter table and setup instructions, not a downloadable workbook or shared Google Sheet. Copy the table or enter its headers, then replace the fictional data.
- Should every submitted resume be a PDF?
Follow the employer’s requested or accepted format. Save the actual file you submitted as the record, whether PDF or another accepted format. Check the exported layout and any fields populated by the application system.
Ready to start your new resume?
Writing a resume takes time, and even a polished one can miss what a hiring manager is looking for. Roleframe helps you build a clear, ATS-safe resume in minutes and tailor it to the job you want.
