Applying for several jobs can quickly become confusing. You may forget which CV you sent, lose track of interview dates, or follow up too early because important details are spread across emails, WhatsApp messages and job-board accounts.
A simple job application tracking spreadsheet gives you one reliable place to manage your job search. Whether you are applying for work in Johannesburg, Cape Town, Durban or remotely from South Africa, this system can help you stay organised, follow up professionally and spot your strongest opportunities.
Why should you track multiple job applications?
A spreadsheet does more than record the jobs you have applied for. It helps you manage your entire application pipeline, from finding a vacancy to receiving an offer or rejection.
Without a tracker, you may:
- Apply for the same role twice.
- Forget an application deadline.
- Send the wrong CV version.
- Miss a recruiter’s follow-up request.
- Forget when an interview is scheduled.
- Lose the job advert or salary information.
- Fail to follow up because you cannot remember the correct date.
A well-organised tracker acts as a resume submission log, follow-up email tracker and interview schedule organiser in one place.
Key takeaway: Your spreadsheet should reduce mental clutter, not create more administration. Start with the information you genuinely need and add extra columns only when they help you make better decisions.
What should a job application spreadsheet include?
You can create your tracker using Google Sheets, Microsoft Excel or another spreadsheet application. Google Sheets is useful if you want to access your applications from your phone, especially when applying from different locations or dealing with load shedding.
Use one row for each job application and include the following columns:
| Column | What to record |
|---|---|
| Date found | When you discovered the vacancy |
| Date applied | When you submitted the application |
| Company | Employer or organisation name |
| Job title | Exact position applied for |
| Location | City, province, remote or hybrid |
| Job advert link | URL to the vacancy |
| Source | Company website, job board, recruiter or referral |
| Closing date | Application deadline |
| CV version | Name of the CV or file used |
| Cover letter | Whether one was submitted |
| Contact person | Recruiter or hiring manager |
| Contact details | Email address, phone number or LinkedIn profile |
| Status | Saved, applied, screening, interview, offer or rejected |
| Follow-up date | Date you plan to contact the employer |
| Interview date | Confirmed interview date and time |
| Salary information | Advertised range or your expectations |
| Notes | Requirements, questions and next steps |
You do not need to complete every field immediately. Add the details you know when you save the vacancy, then update the row after applying or receiving a response.
How to create a simple application status tracker template
Start with a blank spreadsheet and create a header row using the columns above. Freeze the top row so the headings remain visible while you scroll through a long list.
Next, improve readability with basic formatting:
- Use bold text for column headings.
- Turn on filters for the header row.
- Widen columns so important information is visible.
- Wrap text in the notes column.
- Format application and interview dates consistently.
- Use a different colour for each application status.
- Keep links clickable rather than pasting long URLs across the sheet.
A useful status list could include:
- Saved – Interesting vacancy not yet submitted.
- Preparing – You are tailoring your CV or cover letter.
- Applied – Application successfully submitted.
- Under review – Employer or recruiter has acknowledged it.
- Screening – You have been contacted for an initial discussion.
- Interview – An interview has been scheduled.
- Assessment – You must complete a test or task.
- Offer – You have received an offer.
- Rejected – The employer has declined the application.
- Withdrawn – You decided not to continue.
Consistent labels make it easy to filter your spreadsheet and see which applications need attention.
A practical spreadsheet layout
Here is an example of how your tracker might look:
| Date applied | Company | Role | Location | Status | Follow-up date | Contact | Next action |
|---|---|---|---|---|---|---|---|
| 6 May 2025 | Example Retail | Store Supervisor | Pretoria | Applied | 15 May 2025 | careers@example.co.za | Send follow-up |
| 8 May 2025 | Digital Agency | Junior Copywriter | Remote | Interview | — | Lerato, recruiter | Prepare examples |
| 9 May 2025 | Construction Firm | Admin Assistant | Durban | Screening | 14 May 2025 | Sipho, HR | Confirm availability |
The next action column is especially helpful. It tells you what to do next instead of forcing you to reread every email.
For example, your next action might be:
- Tailor CV.
- Submit application.
- Confirm interview.
- Send thank-you email.
- Follow up with recruiter.
- Complete online assessment.
- Request feedback after rejection.
How to track application deadlines and follow-ups
Deadlines deserve their own attention. If a vacancy closes on 20 May, record that date as soon as you save the advert. You can then sort the spreadsheet by closing date and work on urgent applications first.
A simple colour system can help:
- Red: Deadline within two days.
- Orange: Deadline within one week.
- Green: Application submitted.
- Blue: Interview or assessment scheduled.
- Grey: Closed, rejected or withdrawn.
You can also create a reminder in your phone or calendar for important dates. This is useful for interview appointments, application deadlines and follow-up emails.
A reasonable follow-up date is often five to seven working days after applying, unless the advert gives different instructions. Do not follow up repeatedly or contact several employees at the same company about the same application unless there is a clear reason.
For more guidance, see How to Follow up on a Job Application Without Sounding Pushy.
How to record different CV and cover letter versions
Tailoring your application is often worthwhile, but it can become difficult to remember which documents you sent. Add a CV version column to your spreadsheet and use clear file names such as:
Name_Surname_Admin_CV.pdfName_Surname_Sales_CV.pdfName_Surname_Remote_CustomerSupport_CV.pdf
You can record the document name in the spreadsheet rather than storing the full file. Keep your final CV and cover letter in clearly labelled folders, such as:
- Job applications
- Admin roles
- Customer service roles
- Graduate opportunities
- Remote work
- Learnerships
This prevents you from accidentally sending an older CV or a cover letter addressed to another company.
If you are unsure how to tailor your CV naturally, read How to Make Your CV ATS-friendly Without Keyword Stuffing.
How to track recruiter contacts and interview information
When a recruiter contacts you, record their name, company, email address and the date of contact. This prevents you from searching through your inbox every time you need to reply.
For interviews, add a separate section in your notes or create a second worksheet called Interviews. Include:
- Company and job title.
- Interview date and time.
- Interview format, such as phone, video or in person.
- Interviewer’s name.
- Meeting link or physical address.
- Documents to bring.
- Questions to ask.
- Follow-up date.
- Your preparation notes.
If the interview is in person, record travel details and allow extra time for traffic or public transport delays. If it is online, check your data, device, camera and backup power beforehand. Load shedding can interrupt an interview, so plan a practical backup such as a charged phone, alternative location or reliable power bank.
How to use filters to find important applications quickly
Once you have more than 20 applications, scrolling through the whole sheet becomes inefficient. Filters allow you to display only the records you need.
Useful filters include:
- Show all applications with an upcoming deadline.
- Show applications with the status “Interview”.
- Show roles located in Gauteng.
- Show applications where no follow-up has been completed.
- Show remote positions.
- Show roles with a salary range above your minimum.
- Show vacancies from a particular job board.
You can also sort by follow-up date every morning or two to three times per week. This creates a manageable routine without requiring you to check every application individually.
Simple formulas that can improve your tracker
You do not need advanced spreadsheet skills, but a few formulas can save time.
To calculate how many days have passed since you applied, use a column called Days since application. In Google Sheets or Excel, a basic formula may look like:
=TODAY()-B2
Replace B2 with the cell containing your application date.
To count applications by status, you can use:
=COUNTIF(F:F,"Applied")
Replace column F with the column containing your status. You can create similar counts for interviews, rejections or offers.
A small summary section at the top of your spreadsheet might show:
| Measure | Example |
|---|---|
| Total applications | 24 |
| Active applications | 15 |
| Interviews scheduled | 3 |
| Offers received | 1 |
| Applications needing follow-up | 5 |
These figures help you understand your job search. If you have sent 30 applications but received no interviews, you may need to review your CV, target more suitable roles or improve how you meet essential requirements.
How often should you update the spreadsheet?
Update your tracker immediately after an important action. This takes less than a minute and keeps your information accurate.
Use this simple routine:
- Save the vacancy: Add the company, role, deadline and advert link.
- Before applying: Record the CV version, salary details and key requirements.
- After submitting: Change the status to “Applied” and save the submission date.
- After receiving a response: Add the contact person, message and next step.
- Before an interview: Record the appointment and preparation notes.
- After the outcome: Mark the application as an offer, rejection or withdrawal.
- Weekly review: Filter for overdue follow-ups and upcoming deadlines.
If you apply through government portals or submit a Z83 form, record the reference number and department in the notes. Those details can be difficult to recover later.
What should you avoid recording?
Your spreadsheet may contain personal and recruitment information, so protect it carefully. Do not store unnecessary sensitive data such as your ID number, banking details, passwords or copies of identity documents.
Keep access limited if you use a shared computer or cloud account. Use a strong password and avoid downloading job application documents onto public computers.
Be cautious if a recruiter asks for payment, banking information or excessive personal details before a legitimate hiring process. You can read How to Avoid Job Scams on South African Job Boards for practical warning signs.
Final tips for managing your job search
A spreadsheet cannot guarantee an interview, but it can make your applications more deliberate and professional. It helps you spend less time searching for information and more time preparing strong, tailored applications.
Keep your system simple enough to maintain. Review it regularly, follow up at sensible intervals and learn from the results.
Your best starting point is one blank sheet, one row per application and a clear next action for every active opportunity.