How to Track Job Applications: A Simple System for Freshers

Last updated: 11 October 2026 · By the Asuraa Team

Quick answer: Track job applications in one spreadsheet with one row per application, a fixed status dropdown, a date for every action and a weekly review. Key columns are company, role, source, job link with a saved job description, date applied, status and next action. In Google Sheets, add dropdowns via Insert, Dropdown and highlight overdue follow-ups with a conditional formatting custom formula.

Key takeaways

• A fresher's job tracker needs one row per application, a fixed status list, a date for each action and a weekly review.
• In Google Sheets, a status dropdown can be added through Insert, Dropdown or through Data, Data validation.
• A conditional formatting custom formula such as =AND($G2="Applied",TODAY()-$F2>=7) can highlight applications due for follow-up.
• Asuraa's October 2026 job market report found only 3.1% of open listings stated a salary, and Bengaluru held 43.6% of open jobs.
• TCS states that its hiring emails come only from @tcs.com, so recording each recruiter's email domain helps spot impersonation.

Once you are past ten applications, memory stops working. You forget which company sent a test link, which recruiter promised a call, and which role you already applied to twice. A simple tracker fixes that, and it also shows you which parts of your search are working. This guide gives you the columns, a ready-to-build Google Sheets setup, and a weekly routine that takes about 15 minutes.

How should a fresher track job applications?

Use one spreadsheet with one row per application, a fixed set of status values, a date for every action, and a weekly review. Google Sheets or Excel is enough; the system matters more than the tool. Each row should tell you, at a glance, where that application stands and what you need to do next.

Keep it to the columns you will actually fill in. A tracker with 25 columns gets abandoned in a week; one with 10 to 12 gets used.

What columns should a job application tracker have?

These twelve columns cover what freshers need without becoming a chore.

The salary column will often stay empty. Asuraa's October 2026 job market report found only 3.1% of open listings on the platform stated a salary, so "not stated" is the normal entry.

How do you build the tracker in Google Sheets?

You can set it up in about ten minutes. Follow these steps:

1. Create the header row with the twelve columns above and freeze it so it stays visible as you scroll.
2. Add a Status dropdown. Select the Status column, then use Insert, Dropdown (or Data, Data validation, Add rule) and type your status values. Google's Sheets help on dropdowns explains both routes.
3. Use these status values: Saved, Applied, Test, Interview, Offer, Rejected, Withdrawn, No response.
4. Colour by status. Select the sheet, open Format, Conditional formatting, and add a rule per status, for example green for Offer and grey for Rejected. Google's conditional formatting help covers the steps.
5. Flag follow-ups automatically. Add a conditional formatting rule with "Custom formula is" and enter =AND($G2="Applied",TODAY()-$F2>=7), assuming Status is column G and Date applied is column F. Rows pending for a week or more will highlight.
6. Catch duplicates. Add another custom formula rule on the Company column such as =COUNTIF($A$2:$A$500,A2)>1. Google's help uses the same COUNTIF pattern to highlight duplicates; check that the second row is a different role, not a repeat.
7. Add a summary block at the top or on a second tab with counts per status using =COUNTIF(G:G,"Interview") and similar.

Should you use a spreadsheet, a notebook or a portal's built-in tracker?

Use a spreadsheet as your master record, even if portals also show your applications. Each option has real strengths:

• Job portal dashboards update status automatically for applications made on that portal, which saves typing. But each portal only shows its own applications, so referrals, campus drives and careers-page applications are missing.
• A paper notebook is quick and distraction-free, and some people remember things better when they write them. It is hard to sort, filter or count, though.
• A spreadsheet takes a little setup but brings every channel into one place and lets you count outcomes by source.

A practical mix: let portals track their own status, and copy each application into your sheet the same day.

What should your weekly tracker routine look like?

Spend 15 minutes once a week, on the same day, updating and reviewing. A simple routine:

1. Update every status from your inbox, portal notifications and calls.
2. Do all due follow-ups. Send short follow-up emails for highlighted rows. Our job application email templates include a follow-up you can reuse. Gmail's schedule send lets you queue up to 100 emails at once, per Gmail help, so you can write them in one sitting and send them on a weekday morning.
3. Close dead rows. Mark applications with no reply after about three weeks as "No response" so they stop cluttering your view.
4. Check your ratios. Count applications, tests and interviews by source and by resume version.
5. Plan next week. Decide how many applications to send and which sources to focus on.

Which numbers in your tracker actually matter?

Two ratios tell you most of what you need: replies per application, and interviews per test. If many applications get no reply, the problem is usually targeting or the resume. If you get tests but few interviews, the problem is preparation.

Use the Source column to find your best channel. If referrals produce replies far more often than portals, spend more time on getting referrals. Use the location column too. Asuraa's report found Bengaluru accounted for 43.6% of open jobs on the platform, followed by Delhi NCR at 13.8% and Hyderabad at 9.7%, so a search limited to one smaller city may simply have fewer rows to work with.

What do most guides on application tracking get wrong?

Most guides focus on recording applications and forget to record the job description itself. Postings are often removed once a role fills or a drive closes, and by the time you get an interview call two weeks later, the link may be dead. Save a PDF or paste the full text into a linked document when you apply. That copy is what you will prepare from, and it is your reference if a role or offer differs from what was advertised.

The second gap is safety. Recording the sender's email domain catches impersonation early. TCS, for example, says on its recruitment fraud alert page that its hiring emails come only from @tcs.com, never from free email services, and that it never asks candidates for payment. If your tracker shows a "TCS recruiter" writing from a Gmail address, you have spotted a scam before it costs you anything.

When should you stop tracking a role?

Stop actively tracking when you receive a rejection, withdraw, or hear nothing for about three weeks after a follow-up. Mark the row and move on, but keep it in the sheet. Those closed rows are your data: they show which roles, sources and resume versions work for you.

If you are still building the list of places to apply, our guide to finding jobs as a fresher and our fresher jobs and internships guide cover the channels worth adding to your Source column.

Related guides

• Fresher Jobs and Internships in India: Where and How to Get Hired (2026)
• How to Use Asuraa to Find Jobs Faster: A Step-by-Step Guide
• Cold Email to Recruiters: Templates for Freshers
• How to Get a Job Referral in India: Messages That Work

FAQ

What is the best way to track job applications?

Use a single spreadsheet in Google Sheets or Excel with one row per application, a fixed status dropdown, dates for each action and a next-action column. Review it once a week. Dedicated apps work too, but a spreadsheet is free, flexible and easy to analyse when you want to see which sources or resume versions get replies.

What columns should a job application tracker have?

Twelve columns cover most needs: company, role, source, job link with a saved job description, location and work mode, date applied, status, next action and date, recruiter contact and email domain, resume version, salary if stated, and notes. Fewer columns are fine if you will not maintain them; consistency matters more than detail.

How do I get Google Sheets to remind me to follow up?

Use conditional formatting with a custom formula. If Date applied is column F and Status is column G, select your rows, open Format, Conditional formatting, choose Custom formula is, and enter =AND($G2="Applied",TODAY()-$F2>=7). Rows still marked Applied a week or more after applying will highlight automatically.

How many job applications should a fresher send per week?

There is no fixed right number; quality and fit matter more than volume. Pick a number you can tailor properly, track it, and adjust after two or three weeks based on your reply rate. If replies are low, improve targeting and your resume before increasing volume. Your tracker's source and resume-version columns show where to change.

Why should I save a copy of each job description?

Job postings are often removed once a role is filled or a hiring drive closes, sometimes before your interview. A saved PDF or text copy lets you prepare for the exact skills listed and gives you a reference if the role or offer later differs from what was advertised. Link the copy in your tracker row.

Final thoughts

A tracker turns a stressful, scattered search into a weekly routine you can improve. Set up the twelve columns, review every week, and keep feeding it good-fit roles from Asuraa's free job search, filtering by city, work mode and experience level.