October 9, 2026 · By KoldReach

How to Build a Job Search Spreadsheet: Columns, Examples, and Templates

A job search spreadsheet can be enough to organize applications, deadlines, contacts, and next actions. The key is to design it around the decisions you need to make, not to recreate every detail of a recruiting system.

Set up one source of truth

Create one main sheet for opportunities and, if useful, a second sheet for contacts or reusable notes. Avoid separate files for each company; fragmentation makes it harder to see deadlines and duplicate applications. Protect private information and share the file only with people who need access.

Freeze the header row, turn on filters, and keep one row per opportunity. If you apply to two roles at the same company, give each role its own row and link the relevant contact in each row.

Recommended columns

Start with the fields below. Add columns only when they help you choose an action or remember important context.

Company | Role | Location or remote status | Job URL
Date found | Application date | Employer deadline | Status
Contact name | Contact role | Last contact date | Next action date
Next action | Interview stage | Resume version | Notes
Outcome | Outcome date | Lesson or follow-up

Copyable sample table

You can copy this structure into a spreadsheet and replace the example data:

Northstar | Operations intern | 2026-10-07 | 2026-10-20 | Preparing | — | — | Tailor resume | Emphasize process project

Use statuses and dropdowns

Create a dropdown for statuses such as Researching, Preparing, Applied, Screen, Interview, Offer, Rejected, Withdrawn, and Closed. Consistent values make filtering possible and prevent small wording differences from scattering your active work.

Use a separate dropdown for priority if that helps, but do not confuse priority with status. A low-priority application can still be active, and a high-priority role can be closed.

Add filters and simple reminders

Useful filters include applications due this week, roles with no next action, active interviews, and contacts needing a response. Sort dates from soonest to latest and keep an unfiltered view available so nothing disappears unexpectedly.

For reminders, use your calendar for hard deadlines and calls, then keep the next-action date in the spreadsheet as a searchable planning field. Conditional formatting can highlight dates that are overdue, but do not rely on color alone; the status and action text should remain clear.

Decide what belongs in a cell

Keep fields that can be filtered or acted on separate: put the next action in one column, its date in another, and explanatory context in Notes. For example, use “Send interview availability” and “2026-10-16” rather than hiding both inside a paragraph.

Use the notes column for the smallest context needed to act. Long email threads and full application documents belong in their original systems, with a link or short reference in the sheet.

Track contacts without losing opportunity context

If an employee, recruiter, or alum is connected to an application, record that connection in the same row. Add a short note about what was discussed and when you last contacted them. For a larger search, maintain a contact sheet with one row per person and link back to related roles.

A spreadsheet may become cumbersome when one person relates to many opportunities or when email follow-ups are difficult to reconcile. A dedicated personal CRM such as KoldReach can be a reasonable next step, but the spreadsheet remains a complete solution for many small searches.

A weekly spreadsheet review

Once a week, filter for deadlines and next actions in the next seven days. Update statuses from email, record new conversations, archive closed roles, and choose the three most important actions for the coming week. Review the notes for applications that need a tailored resume or interview preparation.

Do not use the review to judge your worth by the number of rows. Use it to make sure your time is going toward plausible roles and that you are following through on commitments.

What not to put in the sheet

Keep notes concise, factual, and focused on the next decision. A tracker is not a private archive of every thought in your job search.

Passwords, private login details, or sensitive personal identifiers.
Unverified rumors about a company or individual.
Large copies of resumes and correspondence that belong in their proper systems.
Notes you would not be comfortable reading months later.

Conclusion

A useful job search spreadsheet has one row per opportunity, consistent statuses, clear deadlines, contact context, and a next action. Start small, add only helpful fields, and review it every week. If the relationship side of the search outgrows the sheet, consider a dedicated tool without abandoning the simple habits that made the tracker useful.

Keep your next follow-up visible

KoldReach helps job seekers and students organize contacts, conversation context, opportunities, and Gmail follow-ups in one career-focused CRM.

Start free Explore the networking CRM