Free Job Application Tracker Spreadsheet
Download a ready-made spreadsheet to track your UK job applications. Available in Excel, Google Sheets, and CSV. Free, no sign-up required.
- Free Excel, Google Sheets & CSV template
- 10 columns: company, status, salary (£), follow-up date, source
- Covers Reed, LinkedIn, Indeed, Totaljobs, CV-Library
- Switch to ApplyArc when you're ready for AI tools + Kanban
Download Your Free Template
Google Sheets
Free, cloud-based, real-time sharing
RoadmapExcel (.xlsx)
Offline use, advanced formatting
CSV
Universal. Import into any tool
What's in the Spreadsheet
How to Use Your Job Tracker Spreadsheet
Download the template
Choose Excel, Google Sheets, or CSV format. All three contain the same columns and conditional formatting.
Customise for your job search
Add or remove columns based on your needs. Consider adding 'Cover Letter Sent', 'Interview Type', or 'Referral' for more detail.
Log every application immediately
Fill in the company, role, date, and URL as soon as you apply. Don't let applications pile up. Tracking in real time is key.
Set follow-up reminders
Add a follow-up date after applying. Check your spreadsheet daily so promising applications do not disappear into a backlog.
Review weekly and adjust
At the end of each week, review your pipeline. Are you applying enough? Getting interviews? Adjust your strategy based on the data.
Move to ApplyArc when ready
When your spreadsheet gets unwieldy (30+ applications), export it as a CSV backup and add your active roles to ApplyArc manually for visual Kanban boards, AI tools, and follow-up reminders.
5 Spreadsheet Mistakes UK Job Seekers Make
#1. Not logging applications immediately
You apply on Reed, tab back to your spreadsheet... and forget. By the next day, you can't remember if you applied to that Totaljobs listing or just saved it. Fix: keep the spreadsheet open while applying. Log each one within 60 seconds of submitting.
#2. Missing the follow-up column
Most spreadsheet templates skip follow-up dates. Without them, you rarely chase up. Add a 'Follow-up Date' column and check it every morning.
#3. Tracking too few details
Company name and job title aren't enough. You need the salary range (in GBP), the source (Reed, LinkedIn, Indeed), and the recruiter's name. When you get an interview call, you need to know which role they're talking about.
#4. Never reviewing the data
Your spreadsheet tells a story. If you've applied to 25 marketing roles and gotten 0 interviews, your CV positioning is wrong. If Reed applications convert better than LinkedIn, focus more on Reed. Review weekly.
#5. Keeping it going past 30 applications
Spreadsheets work well for a small active search. Past 20 to 30 applications, they become a chore: scrolling through rows, manually checking follow-up dates, and copy-pasting salary data. That is when a dedicated tracker like ApplyArc earns its place.
What a Spreadsheet Can't Do (But the AI Coach Can)
A spreadsheet stores your data. ApplyArc's AI Career Coach reads it and gives you advice. Here's what changes when you move beyond rows and columns.
Pattern detection
The Coach spots patterns you might miss in a spreadsheet. Applying to 20 roles with no interviews? It can suggest changes to your CV or targeting strategy.
Follow-up drafting
Instead of staring at a 'Follow-up Date' cell and writing an email from scratch, the Coach drafts the follow-up for you using the role context.
Cover letter generation
Paste a job description, and the AI generates a tailored cover letter. No spreadsheet can do that. Free users get 5 AI generations per month.
Interview prep
Got a Tesco or Deloitte interview? The Coach generates competency-based questions using the STAR format. It reads your application notes and personalises the prep.
Start with the spreadsheet. Switch to ApplyArc when you hit 20+ applications and want AI help. Add your live roles manually and keep the spreadsheet as an archive.
Which Spreadsheet Format Should You Choose?
Google Sheets
Best for most UK job seekers
- Free with any Google account
- Access from phone, tablet, or laptop
- Share with a career coach or mentor
- Auto-saves every change
- Conditional formatting works well
Downside: Needs internet connection to edit
Excel (.xlsx)
Best for offline and advanced users
- Works without internet
- Advanced pivot tables and formulas
- Better for data analysis
- Compatible with most UK employers
- Familiar to most professionals
Downside: Requires Microsoft 365 or LibreOffice
CSV
Best for importing into tools
- Opens in any spreadsheet app
- Smallest file size
- Universal backup format
- Works with Python, R, or other tools
- No formatting lock-in
Downside: No conditional formatting or formulas
When to Upgrade from a Spreadsheet
| Feature | Spreadsheet | ApplyArc (Free) |
|---|---|---|
| Visual Kanban board | No | Yes |
| Follow-up reminders | No | Yes |
| AI cover letters | No | Yes, 5/month free |
| Quick job capture | Manual copy and paste | Save jobs in a few clicks |
| Import from CSV | N/A | No, add active roles manually |
| Price | Free | Free (Pro: £19/mo) |
| Best for | < 20 applications | Up to 100 jobs on Free, 500 on Pro |
Frequently Asked Questions
A good job tracker spreadsheet should include columns for: company name, job title, date applied, application status (Applied/Interview/Offer/Rejected), contact person, follow-up date, salary range, job URL, and notes. The template above includes all of these plus conditional formatting.
Spreadsheets work well for tracking fewer than 20 applications. Once you go beyond that, a dedicated tool like ApplyArc offers advantages: visual Kanban boards, follow-up reminders, cover letter generation, and direct job entry. You can start with the spreadsheet and switch to ApplyArc when you're ready; keep the CSV as a backup and add your active roles manually.
There's no CSV importer, so keep your spreadsheet as a backup and add your active applications manually. You can add jobs from LinkedIn, Indeed, Totaljobs, Reed, and other UK boards as you go, and you only need to carry over your live pipeline.
Google Sheets is best if you want free cloud access from any device. Excel is better for offline use and advanced formatting. CSV is the most portable format. It works with almost any spreadsheet tool and doubles as a clean backup of your search history. We provide all three formats.
For manual tracking, copy the job URL and details into your spreadsheet after each application. With ApplyArc you can add jobs from Reed, Totaljobs, CV-Library, Indeed UK, LinkedIn, or other sites in a few clicks.
Yes. The spreadsheet template on this page is completely free. ApplyArc also offers a free plan with up to 100 jobs, a Kanban board, and 5 AI generations per month. No credit card required.
Track enough applications that nothing gets lost, but not so many that every role becomes anonymous. A spreadsheet handles a small active search well; beyond roughly 20 to 30 applications, a dedicated tracker like ApplyArc is easier to manage.
Yes. Always track unsuccessful applications. They help you spot patterns: are you dropping out at the same stage? For the same type of role? This data is valuable for adjusting your strategy. In a spreadsheet, set the status to 'Unsuccessful' and add notes on the reason if known.
Update it every day during an active job search. Log new applications immediately after submitting. Check follow-up dates daily. Do a weekly review to assess your pipeline and adjust your strategy. Daily updates prevent the 'spreadsheet backlog' problem.
A job tracker is a personal tool for job seekers to organise their own applications (spreadsheets, ApplyArc, Huntr). An ATS (Applicant Tracking System) is employer software to manage incoming candidates (Workday, Greenhouse, Lever). This page is about personal trackers. Tools for YOUR job search, not for hiring teams.
Yes. The template works for any country. The salary column defaults to GBP (£) but you can change it. If you're applying to both UK and EU roles, add a 'Country' or 'Location' column to filter by region. ApplyArc handles multi-region tracking natively if you upgrade later.
Yes. Speculative applications, where no role is advertised, are common in the UK, especially for SMEs and startups. Log them with a status of 'Speculative' and set a follow-up date for 10 working days. Because there may be no public vacancy to revisit later, your notes and follow-up date matter more.
Ready for more than a spreadsheet?
Move up from the spreadsheet to visual Kanban boards, AI cover letters, reminders, and a Career Coach that sees your full pipeline and suggests what to do next. Free plan included.