How to Build a Job Application Tracker With Free Tools

Applying for several jobs can quickly become confusing. You may forget which version of your CV you sent, miss an application deadline, lose a recruiter’s email or fail to follow up after an interview.

A job application tracker gives you one organised place to record every application and the next action required. You do not need paid software or advanced technical skills. A spreadsheet, a cloud folder and a few email labels can be enough for a reliable system.

This approach is useful for Nigerian jobseekers applying to local companies, remote employers, graduate programmes, international organisations and opportunities advertised on different websites.

What a job application tracker should do

Your tracker should help you answer five questions quickly:

• Which jobs have you applied for?
• What is the closing date or next deadline?
• Which CV, cover letter or portfolio did you submit?
• What stage is each application at?
• What should you do next, and when?

A good tracker is not a replacement for careful applications. It is a memory and planning tool that reduces avoidable mistakes.

Choose a free tool

The easiest option is Google Sheets because it works in a browser and on many phones, saves changes online and can be shared with yourself across devices. You can also use Microsoft Excel if you already have access to it, or a basic spreadsheet application on your computer.

Use a cloud storage service such as Google Drive or OneDrive to keep your CVs, cover letters and certificates together. If you prefer a notes or database application, a free plan may also work, but check its current storage and feature limits before depending on it.

For most beginners, Google Sheets plus organised folders is the simplest setup.

Step 1: Create the main spreadsheet

Open a new spreadsheet and name it something clear, such as Job Applications 2026. If you prefer an evergreen file name, use Job Application Tracker.

Create these column headings in the first row:

• Company
• Job title
• Location
• Work type — onsite, hybrid or remote
• Source — company website, LinkedIn, job board, referral or another source
• Application link
• Date found
• Deadline
• Date applied
• Status
• Next action
• Follow-up date
• Contact person
• Documents sent
• Interview date
• Notes

You can add or remove columns based on your job search. For example, a developer may add a column for a coding test, while a content creator may add one for a portfolio link.

Step 2: Use consistent status labels

Choose a small set of status labels and use the same wording every time. This makes the spreadsheet easier to scan and filter.

Useful labels include:

• Considering
• Preparing
• Applied
• Assessment
• Interview scheduled
• Interview completed
• Follow-up due
• Offer received
• Rejected
• Withdrawn

Do not mark an application as “Applied” until you have completed the submission and received confirmation where available. If you started an application but have not submitted it, use “Preparing”.

You can make statuses easier to recognise with simple colours. For example, use one colour for active applications, another for interviews and a third for closed applications. Colour should support the text, not replace it, because you may view the sheet on a small phone screen or have difficulty distinguishing colours.

Step 3: Add each opportunity immediately

When you find a promising vacancy, record it before opening another one. Add the company, title, location, closing date, source and application link. If there is no stated deadline, write “Not stated” and create your own review date.

Record the original vacancy link, but do not rely on it as your only copy. Job adverts can be removed or edited. Copy important details into the Notes column, including:

• Required qualifications
• Years of experience requested
• Key skills and keywords
• Required documents
• Application instructions
• Any unusual questions or tests

Be careful with vacancies shared through social media or messaging apps. Confirm that the opportunity also appears on the employer’s official website or another trustworthy source. Never pay a “registration”, “shortlisting” or “processing” fee simply because someone promises employment. Do not share your password, one-time password, bank PIN or other sensitive account information with a recruiter.

Step 4: Organise your application documents

Create one main folder called Job Search. Inside it, create subfolders such as:

• CV versions
• Cover letters
• Certificates
• Portfolio
• Applications submitted
• Interview preparation

Use descriptive file names instead of vague names such as “CV final final”. For example:

• Amaka_Okafor_CV_Marketing_Manager.pdf
• Amaka_Okafor_Cover_Letter_Company_Name.pdf
• Amaka_Okafor_Portfolio_Link.txt

Before submitting, save the exact documents you sent in the relevant folder. Then record their names in the Documents sent column. This is especially helpful when you have different CV versions for technology, administration, communications or international applications.

Check sharing permissions on cloud files. A recruiter should receive only the document or link intended for them, not your entire personal folder.

Step 5: Track the next action

Every active application should have a next action. Examples include:

• Complete online assessment
• Send requested certificate
• Prepare answers for interview
• Follow up by email
• Check application portal
• Ask a referee for permission

Add a date beside the next action. Without a date, “follow up later” is easy to forget.

Use the spreadsheet’s date format consistently. You may also sort the sheet by Follow-up date each morning or at the beginning of each week. If you use Google Calendar, create a reminder for important interviews, tests and follow-ups. The calendar is for alerts; the spreadsheet remains your complete record.

Step 6: Create an email system

Make an email label or folder called Job Applications. Add related labels such as:

• Applications sent
• Assessments
• Interviews
• Offers

When you submit an application, keep the confirmation email and place it under the correct label. If an employer contacts you from a new address, record the sender and the relevant details in your tracker.

Search for terms such as the company name, job title or “interview” before assuming that no response has arrived. Check spam and promotions folders, but treat unexpected attachments and links carefully.

A simple weekly review

Set aside 15 to 30 minutes once or twice a week to maintain the tracker. During the review:

1. Remove duplicated entries.
2. Check deadlines coming soon.
3. Update statuses from new emails.
4. Complete overdue follow-ups or reschedule them.
5. Archive rejected or withdrawn applications without deleting useful notes.
6. Prepare documents for interviews and assessments.
7. Check whether each new vacancy is legitimate.

Keep the system current even when there is no positive response. Rejections and withdrawals can reveal which roles, industries or application methods are taking most of your time.

Example of a tracked application

Suppose you find a customer-support role on a company’s official website. You record the title, location, deadline and link, then save the job description in your notes. After tailoring your CV, you submit the application and enter the date applied. Your status becomes “Applied”, your next action is “Check for response”, and your follow-up date is set for a reasonable time after the stated process or closing date.

If the employer invites you to an interview, change the status to “Interview scheduled”, add the date and record any preparation instructions. After the interview, write down the questions you remember and the agreed next step. This creates a useful record without relying on memory.

Protect your tracker

Your spreadsheet may contain personal information, application history and links to private documents. Use a strong account password and enable available account security features. Do not publish the sheet publicly, and avoid storing passwords, bank details, identity numbers or one-time codes in it.

Back up important documents periodically. If you use a shared computer or phone, sign out after using your email and cloud storage.

The practical takeaway

A job application tracker works when it answers one simple question: what is the next useful action for each opportunity? Start with a spreadsheet, organised documents and email labels. Add every vacancy promptly, save the exact files submitted, record deadlines and review the tracker regularly. A simple system maintained consistently is more valuable than an advanced tool that you stop using after a few days.