Track jobs, employers, status, next action, and follow-up date in one place.
Job search
How to Make a UK Job Search Spreadsheet That Actually Helps
A simple job application tracker for UK sponsor-aware job searches, built around next actions, employer research, role fit, and follow-up dates.
Keep the spreadsheet small enough to update every day.
Separate active applications from saved roles and employer watchlists.
Add notes that help you take action, not notes you will never reread.
Review the sheet weekly and archive stale entries.
Use the tracker to improve your search pattern, not just store links.
Short answer
A useful UK job search spreadsheet needs fewer columns than most candidates think. Track the company, role, job link, location, status, fit score, application date, next action, follow-up date, and notes. The most important column is not "status"; it is "next action". A tracker only helps if it tells you what to do next: apply, ask a question, follow up, prepare for interview, save for later, or drop.
Why most job search spreadsheets fail
Most job trackers fail because they become archives. Candidates add dozens of links, colour-code everything, and then stop using the sheet because it takes too long to maintain. A good tracker should reduce decisions, not create admin. The purpose is to answer three questions quickly: What should I apply to today? Who needs a follow-up? Which employers are worth watching? If your spreadsheet cannot answer those questions in a minute, it is too complicated.
The core columns
Start with these columns: company, role title, role link, location, source, status, fit score, date added, date applied, next action, follow-up date, and notes. That is enough for most searches. Add optional columns only when they change your decisions. For example, you might add salary shown, recruiter name, interview stage, or CV version. Avoid adding columns for data you never use. Every extra field is another reason you might stop updating the sheet.
Use clear statuses
Use simple statuses that map to real actions. Good options are: saved, apply next, asked question, applied, follow up, interview, offer, rejected, archived. Avoid vague statuses like "maybe" or "interesting" unless they are paired with a next action. A saved role without a next action becomes clutter. An applied role without a follow-up date becomes easy to forget. The status column should tell you where the role sits; the next-action column should tell you what to do.
Add a fit score
A fit score helps you avoid applying in the order you found roles. Use a simple 1 to 5 score. A 5 means the role is close to your experience, level, location, and target function. A 3 means possible but uncertain. A 1 means weak fit or too much missing information. The score is not scientific. It is a forcing function that protects your time. When you only have an hour, start with high-fit roles that have a clear next action.
Track employer research separately
Do not mix every employer note into the active applications table. Keep a second tab for target employers. Include company name, sector, locations, relevant role families, careers page, last checked date, and watchlist status. This lets you build a reusable shortlist instead of starting over each time you search. A company can be worth watching even when there is no role to apply for today.
Keep notes action-focused
Good notes are short and usable. "Recruiter said hiring team reviews on Fridays" is useful. "Interesting company" is not. "Need salary band before applying" is useful. "Maybe good" is not. Write notes that future-you can act on without reopening every tab. If a note does not change the next step, leave it out.
Use follow-up dates carefully
Every applied role should have a follow-up date or a reason why it does not need one. Follow-up dates prevent old applications from disappearing. They also stop you from following up too soon because anxiety is driving the search. Use a consistent rhythm, such as one follow-up after a reasonable period, then archive if there is no response. The exact timing matters less than having a repeatable system.
Separate active, waiting, and archive
Keep active roles visible and old roles out of the way. You can do this with filters or separate tabs. Active means there is a useful next action. Waiting means you have applied or asked a question and are waiting for a reply. Archive means no action remains. Archiving is important because a spreadsheet full of stale roles makes the search feel larger than it is.
Use saved jobs from Sponsio
Sponsio can be the source of your cleaner job pool. Save roles that look relevant, then move the strongest ones into your spreadsheet with a fit score and next action. Use Sponsio's [jobs feed](/jobs/) for discovery and your spreadsheet for execution. That split keeps the product and the tracker doing different jobs: one finds opportunities, the other manages your decisions.
A simple weekly review
Once a week, sort by next action and follow-up date. Apply to high-fit roles that are ready. Send follow-ups where needed. Move unclear roles to ask-first or archive. Check target employers for fresh postings. Update your fit patterns: which roles are getting replies, which sources are stale, and which job titles match your CV best. The weekly review turns the spreadsheet from a list into feedback.
Spreadsheet template structure
Use three tabs. Tab one: active roles. Tab two: target employers. Tab three: archive. In active roles, keep only jobs that still have a next step. In target employers, keep companies worth checking again. In archive, keep closed roles so you can see what you tried without letting old entries crowd the current week. This structure is simple enough to maintain and flexible enough for a long search.
Common questions
What candidates usually need to confirm
What should I track in a job application spreadsheet?
Track company, role, link, location, source, status, fit score, date applied, next action, follow-up date, and notes.
Should I track every job I see?
No. Track jobs you might act on. A spreadsheet full of weak roles makes it harder to choose strong ones.
What is the most important column?
The next-action column. It turns a passive list into a working system.
Should I use Notion, Sheets, Airtable, or Excel?
Use whichever tool you will update consistently. The structure matters more than the software.
How often should I update the tracker?
Update active applications daily and review the full sheet weekly.