Applying for jobs can quickly become difficult to manage. You may send your CV to several companies, receive recruiter calls, complete assessments and then forget when you should follow up.
A simple spreadsheet gives you one reliable place to record every application. Whether you are job hunting in South Africa, working around load shedding or applying for remote roles, this method helps you stay organised and follow up with confidence.
Why use a spreadsheet to track job applications?
A job search spreadsheet is more than a list of vacancies. It acts as an application status tracker, deadline calendar, recruiter contact log and interview follow-up record in one place.
Instead of searching through email messages or trying to remember which version of your CV you used, you can see the full history of each application at a glance.
A spreadsheet can help you:
- Remember closing dates and interview times.
- Track whether an application is submitted, shortlisted or rejected.
- Record recruiter names, email addresses and phone numbers.
- Save links to job adverts and company websites.
- Track which CV and cover letter version you used.
- Schedule polite follow-ups.
- Measure which job-search activities are producing results.
Key takeaway: The best system is not the most complicated one. It is the one you will update after every application.
Choose a spreadsheet tool that works for you
You can create your tracker in Google Sheets, Microsoft Excel or LibreOffice Calc. Google Sheets is often convenient because it is free, works on most devices and saves your changes automatically when you have an internet connection.
Excel or LibreOffice may be better if you need to work offline, particularly during connectivity problems or load shedding. You can update the document offline and synchronise or upload it later.
Whichever tool you choose, keep a backup copy. Save the file to a secure cloud folder or export it as an Excel file once a week.
Free job application spreadsheet template
Copy the following headings into the first row of a blank spreadsheet:
| Column | What to record |
|---|---|
| Date applied | The date you submitted your application |
| Company | The employer’s name |
| Job title | The exact position advertised |
| Location | City, province, remote or hybrid |
| Job advert link | The URL to the vacancy |
| Closing date | The application deadline |
| Application status | Saved, applied, screening, interview, offer or rejected |
| Contact person | Recruiter or hiring manager |
| Contact details | Email address or phone number |
| CV version | The file name or version used |
| Cover letter | Whether one was included |
| Interview date | Date and time of an interview |
| Follow-up date | When you plan to contact the employer |
| Salary range | Advertised or discussed amount |
| Notes | Requirements, questions and next actions |
You do not need every column from the beginning. Start with the essentials and add fields as your job search develops.
A practical starter version could include:
Date applied | Company | Job title | Location | Job advert link | Status | Contact person | Follow-up date | Notes
Example of a completed tracker
| Date applied | Company | Job title | Location | Status | Follow-up date | Notes |
|---|---|---|---|---|---|---|
| 12 March 2025 | Cape Digital | Customer Support Agent | Remote | Applied | 20 March 2025 | Used CV – Customer Support v2 |
| 13 March 2025 | Mzansi Retail | Store Administrator | Johannesburg | Interview | 19 March 2025 | Prepare Excel examples |
| 15 March 2025 | Bright Finance | Data Capturer | Cape Town | Screening | 22 March 2025 | Recruiter: Thandi, email received |
Use consistent wording for statuses. For example, choose Applied rather than switching between “sent”, “submitted” and “application done”. Consistency makes filtering and counting much easier.
Step-by-step setup for your application tracker
Step 1: Create the main worksheet
Open a new spreadsheet and name the first tab Applications. Enter your chosen spreadsheet tracking columns across the first row.
Make the heading row bold and freeze it so the column names remain visible while you scroll. In Google Sheets, select View, then Freeze, and choose one row.
Keep the sheet clean by using short headings. If a heading is too long, use a note or explanation in the first row rather than making the entire column difficult to read.
Step 2: Add dropdown menus for application status
A dropdown menu prevents spelling differences and keeps your data organised. Add options such as:
- Saved
- Preparing
- Applied
- Screening
- Assessment
- Interview
- Final interview
- Offer
- Rejected
- Withdrawn
- No response
In Google Sheets, highlight the status column, select Insert, then Dropdown. In Excel, use Data Validation to create a list.
You can also apply colours carefully. Green might represent an offer, blue an interview, yellow a follow-up and grey a closed application. Do not rely on colour alone, because the written status should always remain clear.
Step 3: Add dates and deadlines
Record the date you applied and the closing date separately. This helps you distinguish between applications that were submitted early and those sent close to the deadline.
Add a follow-up date whenever the employer provides a response timeframe. If no timeframe is given, a polite follow-up after about five to seven business days may be reasonable, unless the advert states otherwise.
For a useful application deadline calendar, sort the sheet by closing date or create a separate tab called Deadlines. This can be especially helpful when you are applying for internships, graduate programmes or roles with fixed recruitment windows.
Step 4: Record your CV and cover letter versions
Many candidates adjust their CV for different roles. Record the exact file name in the CV version column, such as:
Thabo_Mokoena_CV_Admin_v3.pdfThabo_Mokoena_CV_CustomerSupport_v2.pdfThabo_Mokoena_CV_Data_v1.pdf
This is known as resume version tracking, even when you use the South African term “CV”. It helps you prepare for interviews because you can review the experience and skills you presented to that specific employer.
If you are changing industries, it is also useful to review your step-by-step guide to identifying transferable skills before creating a new CV version.
Step 5: Add recruiter and company information
Record the person who contacted you, where they work and how you communicated. Your recruiter contact log might include:
- Recruiter or hiring manager name.
- Email address and telephone number.
- Date of contact.
- Channel used, such as LinkedIn, email or phone.
- Important instructions or promised next steps.
Be careful with personal information. Store the spreadsheet in a private account, avoid sharing it publicly and do not record unnecessary identity or banking details.
Step 6: Add notes after every interaction
Your notes should help you remember what happened without forcing you to reread an entire email thread. Write brief, useful details such as:
- “Recruiter said interviews will take place next week.”
- “Role requires Saturday shifts.”
- “Asked about experience with Sage accounting.”
- “Send portfolio before second interview.”
- “Salary discussed: approximately R18,000 per month.”
An application notes organizer is particularly valuable when you are managing ten or more active applications. Keep notes factual and professional, because you may need to refer to them several weeks later.
Create a simple follow-up reminder system
A tracker only works if it prompts action. Use the follow-up date column to record when you need to send an email, check an application portal or prepare for an interview.
You can highlight overdue dates with conditional formatting. For example, apply a rule that colours a follow-up date red when it is earlier than today and the status is not “Rejected”, “Withdrawn” or “Offer”.
You may also create a separate Actions tab with three columns:
| Action date | Company | Action required |
|---|---|---|
| 20 March 2025 | Cape Digital | Send polite application follow-up |
| 21 March 2025 | Bright Finance | Prepare for screening call |
| 22 March 2025 | Mzansi Retail | Send interview thank-you message |
This prevents your main tracker from becoming overloaded with reminders.
Track interviews and follow-ups properly
When you receive an interview invitation, update the status immediately. Add the interview date, platform or venue, interviewer’s name and any preparation tasks.
After the interview, record the date you sent your thank-you or follow-up message. Keep it brief and specific by mentioning one relevant part of the conversation.
For example:
Thank you for discussing the Customer Support Agent role with me today. I enjoyed learning how your team supports customers across South Africa, and I remain interested in contributing my experience with email and telephone support.
Do not send repeated messages every day. One professional follow-up is usually better than several rushed emails.
Use filters to find information quickly
Filters are one of the most useful spreadsheet features for a busy job search. You can filter the tracker to show:
- Applications currently at interview stage.
- Roles in Gauteng, Western Cape or KwaZulu-Natal.
- Remote and hybrid vacancies.
- Follow-ups due this week.
- Applications using a specific CV version.
- Companies that have not responded.
- Roles with a stated salary range.
You can also sort by date applied, closing date or status. Make sure you select the full table before sorting so the company details do not become separated from the correct application.
Add basic job search metrics
After a few weeks, your spreadsheet can show patterns in your search. You do not need a complicated job search metrics dashboard; a few basic numbers can guide your next steps.
Track:
- Total applications submitted.
- Number of screening calls.
- Number of interviews.
- Number of offers.
- Applications by job category.
- Response rate by platform.
- Average time between application and response.
For example, if you submit 30 applications and receive three interviews, your interview rate is:
3 interviews ÷ 30 applications × 100 = 10%
These figures are not a judgement on your ability. They help you decide whether to improve your CV, target different roles, adjust your salary expectations or spend more time networking.
Common mistakes to avoid
A tracker can become less useful if it contains too much information or is not updated regularly. Watch out for these problems:
- Recording applications from memory: Add each application immediately after submitting it.
- Using inconsistent statuses: Choose standard dropdown options.
- Ignoring closing dates: Sort by deadline at least twice a week.
- Forgetting the advert link: Save it before the listing disappears.
- Tracking without taking action: Review follow-ups and interviews every morning or evening.
- Adding sensitive information: Keep identity numbers, banking details and passwords out of the sheet.
- Using an unclear file name: Save the tracker as
Job_Application_Tracker_2025and keep dated backups.
If you use a public computer, log out of your Google or Microsoft account and avoid downloading your tracker to a shared device.
A 10-minute weekly review routine
Set aside ten minutes at the end of each week to keep your system accurate. This small habit can prevent missed deadlines and forgotten conversations.
Follow these steps:
- Add any applications, calls or interviews missing from the tracker.
- Update every current status.
- Check deadlines for the next seven days.
- Review overdue follow-ups.
- Prepare questions or documents for upcoming interviews.
- Count applications and responses for the week.
- Adjust your CV or search strategy if results are weak.
For additional career planning, you can revisit this guide on identifying transferable skills when changing careers and compare those skills with the roles in your tracker.
Final takeaway: keep your system simple
You do not need expensive job-search software to stay organised. A free spreadsheet with clear columns, consistent statuses and regular reminders can give you control over your applications.
Start with ten essential fields today, then improve the tracker as your search grows. The goal is not to build a perfect spreadsheet—it is to make your next application, follow-up and interview easier to manage.