How to Track Job Applications in a Spreadsheet
Why Track Your Job Applications?
During your job search, you'll apply to multiple roles across different companies, deadlines, and platforms. Without a system to track them, it's easy to lose track of where you've applied, what the next steps are, or whether you've sent a follow-up email. By the time you receive an interview request, you might not remember the details of the role or company.
A simple spreadsheet gives you complete control over your job search. You can see at a glance which applications are pending, which ones have progressed, and where you might need to follow up. This organized approach helps you stay focused and professional throughout your search.
What Information Should You Track?
Start by deciding what matters most to your job search. Here are the key columns to include:
- Company name – the organization you're applying to
- Job title – the specific role you're pursuing
- Application date – when you submitted your application
- Application method – how you applied (email, job board, company website)
- Contact name and email – the hiring manager or recruiter, if known
- Status – where the application stands (applied, no response, interview scheduled, rejected, offer)
- Notes – anything relevant, such as salary range, application deadline, or interview date
- Follow-up date – when you plan to check in if you haven't heard back
You might also include columns for salary expectations, location, contract type (permanent or temporary), or interview format. Include what's useful to you.
How to Set Up Your Spreadsheet
You don't need special software. A simple spreadsheet application works perfectly. Here's how to get started:
- Open a blank spreadsheet
- Create headers in the first row with the columns listed above
- Each new application gets its own row
- Fill in the information as soon as you apply
- Update the status column whenever you hear back or take action
Keep your spreadsheet on your computer, in cloud storage, or both. This way, you can access it whether you're at home or on the go.
A Practical Example
Let's say you're applying for graduate roles. Your tracker might look like this:
- Company: Brightwell Ltd | Job title: Graduate Business Analyst | Application date: 15 Sept 2026 | Status: Interview scheduled | Notes: Phone interview 20 Sept 2pm, HR contact Alex Morgan
- Company: Riverside Partners | Job title: Digital Content Officer | Application date: 18 Sept 2026 | Status: No response | Follow-up date: 2 Oct 2026 | Notes: Applied via company website
- Company: Mayfield Consulting | Job title: Graduate Consultant | Application date: 12 Sept 2026 | Status: Rejected | Notes: Not enough experience required
Tips for Staying Organized
Update regularly. The moment you hear back about an application, update your spreadsheet. Don't rely on memory.
Set reminders for follow-ups. If a job posting said they'd respond within two weeks, add a follow-up date to your calendar. Many good candidates don't hear back because companies are busy; a polite follow-up can work in your favour.
Keep copies of your application. Save the job description, the version of your CV you sent, and your cover letter in a folder named by company and date. When you're invited to interview, you'll have everything to hand.
Sort and filter your data. Once you have several entries, sort by status to see which applications are waiting for responses, or filter by company to see all applications at one employer.
Review weekly. Once a week, review your spreadsheet. Look for follow-ups you've missed, applications that have been silent for too long, and upcoming interviews you need to prepare for.
Use a Template to Save Time
If you want a ready-made spreadsheet with columns already set up and examples to guide you, our job application tracking template is designed specifically for UK graduates. It takes the guesswork out of setup and gives you a professional structure from the start.
Get Started Today
Tracking your job applications is one of the simplest ways to take control of your job search. A spreadsheet keeps you accountable, helps you follow up at the right time, and ensures you don't miss opportunities.
Ready to organize your applications? Visit our shop to find the job application tracker template.
Looking for ready-made templates and printables? Browse the shop.
Stay in the loop.
New templates and member-only offers, now and then. No spam. Unsubscribe in one click.