Applying for jobs can quickly become confusing. You may send a CV to several companies, receive interview invitations, forget follow-up dates, or lose track of which CV version you used.
A simple spreadsheet can turn that scattered process into a clear job search system. Whether you are applying for work in South Africa, looking for remote income, or starting your first job after a learnership, this guide shows you how to build and use a practical job application tracker.
Why use a spreadsheet to track job applications?
A job application spreadsheet gives you one reliable place to record every opportunity. Instead of searching through emails, WhatsApp messages, job boards and downloaded documents, you can see your complete application pipeline at a glance.
A well-organised tracker helps you:
- Avoid missing deadlines for applications, assessments or interviews.
- Remember where you applied, including LinkedIn, PNet, Indeed, company websites or government portals.
- Follow up professionally without contacting an employer too early or too late.
- Prepare for interviews by keeping the job description and contact details nearby.
- Track results, such as interviews, rejections and offers.
- Identify patterns, including which CV version or job type produces the best response.
The goal is not to create a complicated business system. Your spreadsheet should make your job search easier, not become another task you avoid.
Choose the right spreadsheet tool
You can create a job application tracker in Google Sheets, Microsoft Excel, LibreOffice Calc or another spreadsheet application. Google Sheets is often the most convenient option because it is free, works on a phone, and saves automatically online.
This can be useful if you experience load shedding or move between devices. You can access the same file from a library computer, smartphone or laptop as long as you have an internet connection.
Before you begin, create a dedicated folder for your job search. Store your spreadsheet, CV versions, cover letters, certificates and interview notes in one place.
Create these essential application tracking columns
Start with one main sheet called Applications. Each row should represent one job application, while each column records a specific detail.
Use the following application tracking spreadsheet columns:
| Column | What to record | Example |
|---|---|---|
| Date applied | The date you submitted the application | 12 March 2025 |
| Company | Employer or organisation name | ABC Logistics |
| Job title | The role you applied for | Junior Administrator |
| Location | City, province, remote or hybrid | Durban, KwaZulu-Natal |
| Source | Where you found the vacancy | PNet |
| Job link | Direct link to the vacancy | Website URL |
| Closing date | Application deadline | 20 March 2025 |
| Status | Current stage of the application | Applied |
| Contact person | Recruiter or hiring manager | Thandi Mokoena |
| Contact details | Email address or telephone number | thandi@example.co.za |
| CV version | File used for this application | Admin CV v2 |
| Cover letter | Whether one was included | Yes |
| Follow-up date | When you plan to check in | 27 March 2025 |
| Interview date | Scheduled interview date, if applicable | 2 April 2025 |
| Salary details | Advertised or discussed amount | R12,000 per month |
| Notes | Important reminders | Requires Excel skills |
You do not need to fill every field immediately. However, try to record the company, role, date, source, closing date and status as soon as you apply.
Use clear status labels for your job search pipeline
A status column makes it easy to understand what needs attention. Keep the labels consistent so that you can filter and summarise your progress later.
Useful status options include:
- To apply — You have saved the vacancy but have not submitted an application.
- Preparing — You are tailoring your CV or writing a cover letter.
- Applied — Your application has been submitted.
- Acknowledged — The employer confirmed receipt.
- Assessment — You need to complete a test or screening task.
- Interview scheduled — An interview has been arranged.
- Interview completed — You attended the interview and are awaiting feedback.
- Follow-up needed — It is appropriate to contact the employer.
- Offer received — You received an offer and are reviewing it.
- Rejected — The employer declined your application.
- Withdrawn — You chose not to continue.
- No response — The employer has not replied after your follow-up.
These labels create an interview status tracking sheet as part of your wider job application tracker spreadsheet. If your list grows, use your spreadsheet’s filter function to display only interviews, follow-ups or applications still awaiting a response.
Build a simple spreadsheet template
You can copy the following structure into Excel or Google Sheets:
| Date applied | Company | Job title | Location | Source | Closing date | Status | CV version | Follow-up date | Interview date | Notes |
|---|---|---|---|---|---|---|---|---|---|---|
| 12 Mar 2025 | ABC Logistics | Junior Administrator | Durban | PNet | 20 Mar 2025 | Applied | Admin CV v2 | 27 Mar 2025 | — | Highlight Excel experience |
| 14 Mar 2025 | Bright Media | Social Media Assistant | Remote | 22 Mar 2025 | Interview scheduled | Marketing CV v1 | — | 29 Mar 2025 | Prepare portfolio |
Add one application per row. Do not combine several jobs in one cell, even if they are from the same company, because each role may have a different deadline, recruiter and outcome.
Add a separate sheet for contacts and follow-ups
A second sheet called Contacts and Follow-ups can help you manage communication. This is especially useful when you apply to many roles or speak with recruitment agencies.
Suggested columns include:
| Company | Contact person | Email or phone | Role discussed | Last contact | Next action | Next action date | Notes |
|---|---|---|---|---|---|---|---|
| ABC Logistics | Thandi Mokoena | Email address | Junior Administrator | 20 Mar 2025 | Send thank-you email | 30 Mar 2025 | Interview completed |
This application contact information tracker prevents useful details from getting lost in your inbox. It also helps you avoid sending a generic message when you need to follow up.
Keep messages brief and polite. For example:
Good day Thandi,
Thank you for the opportunity to interview for the Junior Administrator role on 29 March. I remain interested in the position and would appreciate any update on the next steps.
Kind regards,
Your name
Track CV and document versions
Using the same CV for every vacancy can reduce your chances of being noticed. Your spreadsheet should show which document you used so you can connect each application with the correct experience and keywords.
Create a Documents sheet with columns such as:
- File name
- Document type
- Target role
- Date created
- Main skills highlighted
- Where it was used
- Latest update date
For example, you might save files as:
Name_Admin_CV_v2.pdfName_Customer_Service_CV_v1.pdfName_Data_CV_v3.pdfName_Cover_Letter_Logistics.pdf
A resume version tracking spreadsheet is particularly helpful when you apply for different career paths. If you are changing direction, read this guide on how to identify transferable skills when changing careers before preparing several targeted CVs.
Add deadline and follow-up reminders
Your job application deadline tracker should make urgent tasks easy to spot. Record both the employer’s closing date and your own follow-up date.
You can use simple colour coding:
- Red — Deadline or follow-up is due within two days.
- Yellow — Action is due within one week.
- Green — Application is complete and no immediate action is required.
- Blue — Interview, assessment or other scheduled event.
- Grey — Closed, rejected or withdrawn application.
In Google Sheets or Excel, conditional formatting can apply these colours automatically. Even if you use manual colours, update them regularly so the visual information remains accurate.
A follow-up reminder tracker should not encourage repeated messages. In most cases, wait until the stated closing date has passed or allow roughly five to seven business days after applying, unless the employer gave different instructions.
Create a small job application dashboard
Once you have more than 15 or 20 applications, add a Dashboard sheet. It does not need to be advanced; a few totals can show whether your process is working.
Track figures such as:
| Metric | Example |
|---|---|
| Total applications | 32 |
| Applications this month | 14 |
| Interviews | 5 |
| Assessments completed | 3 |
| Offers | 1 |
| Rejections | 10 |
| Awaiting response | 13 |
| Interview rate | 15.6% |
You can calculate your interview rate by dividing the number of interviews by total applications and multiplying by 100. If your response rate is low, review your CV, application timing, job fit and use of keywords rather than simply sending more applications.
This job application pipeline dashboard also gives you encouragement. Five interviews from 32 applications may feel slow, but the numbers show that your approach is generating opportunities.
Follow a weekly spreadsheet routine
A tracker only works if you update it consistently. Set aside 20 to 30 minutes once or twice a week to review your applications.
Use this simple routine:
- Add new vacancies you want to pursue.
- Remove expired opportunities that you will no longer apply for.
- Update statuses after emails, calls, interviews or assessments.
- Check upcoming deadlines and follow-up dates.
- Prepare for interviews using the notes and job description.
- Record outcomes so you can learn from them.
- Review your results and adjust your search strategy.
Do not leave applications in the “Applied” status indefinitely. If there has been no response after a reasonable follow-up, change the status to “No response” and focus your energy on active opportunities.
Protect your personal information
Your spreadsheet may contain recruiter names, telephone numbers, salary discussions and links to private documents. Keep it secure, particularly if you use a shared computer or public Wi-Fi.
Follow these precautions:
- Use a strong password on your Google or Microsoft account.
- Avoid storing identity document numbers or banking details in the sheet.
- Keep copies of your CV in a private folder rather than a public sharing link.
- Check sharing permissions before sending the spreadsheet to anyone.
- Do not pay a “recruiter” for guaranteed employment.
- Be cautious if someone requests sensitive information before confirming a legitimate vacancy.
If you have already shared personal information with a suspicious recruiter, follow these immediate recovery steps after a recruitment scam.
Common mistakes to avoid
A spreadsheet can become unhelpful if it contains too much information or is not maintained. Keep the system simple enough to use every day.
Avoid these mistakes:
- Recording applications from memory instead of updating the sheet immediately.
- Using unclear statuses, such as “maybe” or “waiting,” without an action date.
- Saving job links without the company name or role.
- Ignoring closing dates because the vacancy is still visible online.
- Sending the same CV everywhere without checking the job requirements.
- Adding unnecessary columns that make the sheet difficult to scan.
- Failing to record rejections, which can hide useful patterns.
For more practical guidance, see this related free job application spreadsheet setup guide.
Key takeaway: make your job search visible
The best job application tracker is not the most complicated one. It is the spreadsheet you can update quickly, understand easily and use to decide what to do next.
Start with the essential columns, add deadlines and status labels, then improve the system as your search grows. With a clear record of your applications, you can spend less time wondering what happened and more time preparing strong, targeted applications for opportunities in South Africa and beyond.