Job Application Tracker: Free Spreadsheet Template

You Applied to 47 Jobs Last Month. Can You Name 10 of Them Right Now?#

Be honest. You probably can't.

You applied on Naukri at 2 AM, then on LinkedIn the next morning, then your friend forwarded a Google Form link for some startup. Three weeks later, you get a call from "XYZ Technologies" and you have zero idea which role it was for.

This is not a small problem. This is THE problem that kills most job searches.

Here's what happens when you don't track your applications:

• You forget to follow up (and follow-ups are where 40% of offers come from)
• You apply to the same company twice with different resumes (HR notices, trust me)
• You can't prepare for interviews because you don't remember which JD you applied for
• You have no idea what's working and what's not
• Your job search feels chaotic, hopeless, and out of control

The fix is embarrassingly simple: a spreadsheet.

Not a fancy app. Not a ₹500/month SaaS tool. A Google Sheets spreadsheet that takes 5 minutes to set up and saves you hours of confusion.

In this post, I'm giving you the exact template I recommend to every job seeker I talk to. Plus the system for using it so it actually works.

Why Most People Don't Track (And Why They Should)#

Let's address the obvious: tracking feels like extra work when you're already exhausted from applying.

"I barely have energy to apply, and now you want me to maintain a spreadsheet?"

I get it. But here's the math:

Without tracking:

• Apply to 50 jobs → forget half → follow up on zero → get 1-2 callbacks → panic

With tracking:

• Apply to 50 jobs → follow up on 30 → get 8-10 callbacks → prepare properly → convert 2-3

The difference between getting a job in 2 months vs 6 months often comes down to follow-ups. And you can't follow up on what you can't remember.

A study by Jobvite found that candidates who follow up within a week of applying are 3x more likely to get an interview. Three times. That's not a small edge.

The Template: What Columns You Need#

Here's the exact spreadsheet structure. Open Google Sheets right now and create these columns:

Column 1: Date Applied

Format: DD/MM/YYYY (we're in India, let's use the right format).

Why it matters: You need to know when your follow-up window opens. Most recruiters take 7-14 days to respond. If you applied 3 weeks ago and heard nothing, it's time to follow up or move on.

Column 2: Company Name

Obvious, but write the FULL name. Not "TCS" and "Tata" in different rows for the same company. Pick one format and stick with it.

Column 3: Role / Position

The exact job title from the listing. "Software Engineer" is different from "Software Developer" is different from "SDE-1". Copy-paste from the JD.

Column 4: Source

Where did you find this job? Options:

• Naukri
• LinkedIn
• Company website
• Referral (note who referred you)
• Campus placement cell
• Internshala
• WhatsApp group
• Other (specify)

This column is gold after a month. You'll see patterns like "I got 5 callbacks from LinkedIn and zero from Naukri" or "all my interviews came through referrals." That tells you where to focus your energy.

Column 5: Job Link / Posting URL

Paste the actual URL. When you get a call two weeks later, you need to pull up the exact JD to prepare. If the listing gets taken down, you'll wish you had this.

Pro tip: also save a copy of the JD text in a Google Doc. Links expire. Text doesn't.

Column 6: Status

Use a dropdown with these options:

• Applied (just submitted)
• Follow-up Sent (you pinged the recruiter)
• Interview Scheduled (date confirmed)
• Interview Done (waiting for result)
• Offer (you got it)
• Rejected (explicit rejection)
• Ghosted (no response after 3+ weeks and follow-up)
• Withdrawn (you decided to pass)

Color-code this column. Green for offers and interviews, yellow for applied and follow-up, red for rejected and ghosted. Makes it easy to scan.

Column 7: Follow-up Date

The date you plan to follow up. Set this the moment you apply. Rule of thumb:

• Naukri/LinkedIn Easy Apply: Follow up after 5 business days
• Company website application: Follow up after 7 business days
• Referral: Follow up after 3 business days (your referrer might check too)
• Campus placement: Don't follow up individually (go through placement cell)

Column 8: Recruiter / Contact

If you can find the recruiter's name and email or LinkedIn, note it here. This is who you'll follow up with.

For Naukri applications, you can often see the recruiter name on the listing. For LinkedIn, check who posted the job.

Column 9: Salary Range

Note the range mentioned in the JD, or your expected range. This prevents you from wasting time on roles that pay 3 LPA when your minimum is 5 LPA.

Column 10: Notes

Anything else. "Used resume version 3", "referred by Rahul from college", "interviewer was really friendly", "they asked about React projects specifically."

This column becomes incredibly valuable during interview prep and salary negotiation.

Setting Up the Spreadsheet (5-Minute Guide)#

Step 1: Open Google Sheets. Create a new spreadsheet. Name it "Job Search Tracker 2026."

Step 2: Create the 10 columns listed above in Row 1. Bold them. Freeze the header row (View → Freeze → 1 row).

Step 3: Set up data validation for the Status column:

• Select the entire Status column (click the column header)
• Data → Data validation → Dropdown
• Add the 8 status options listed above
• This prevents typos and makes filtering easy

Step 4: Add conditional formatting for the Status column:

• Select the Status column
• Format → Conditional formatting
• "Text is exactly 'Offer'" → Green background
• "Text is exactly 'Interview Scheduled'" → Light green
• "Text is exactly 'Rejected'" → Light red
• "Text is exactly 'Ghosted'" → Gray

Step 5: Create a second sheet tab called "Stats." We'll use this for tracking your conversion rates (more on this below).

Step 6: Bookmark this spreadsheet. Pin the tab in your browser. Make it impossible to forget.

The Follow-Up System That Actually Works#

The spreadsheet is useless if you don't act on it. Here's the system:

Every morning (10 minutes):

1. Open the tracker
2. Filter by "Follow-up Date = Today"
3. Send follow-up emails/messages for those rows
4. Update the status

Every evening when you apply (2 minutes per application):

1. Add a new row for each application
2. Fill in all columns immediately (not "I'll do it later" because you won't)
3. Set the follow-up date

Every Sunday (15 minutes):

1. Review the week's stats
2. How many applied? How many follow-ups sent? How many callbacks?
3. Which sources are working? Which aren't?
4. Adjust strategy for next week

The Follow-Up Email Template

Keep it short. Recruiters get hundreds of emails.

Subject: Following up on [Role] application, [Your Name]

Body:

Hi [Recruiter Name],

I applied for the [Role] position at [Company] on [Date]. I'm very interested in this role because [one specific reason related to the JD].

I'd love the opportunity to discuss how my experience with [relevant skill] could contribute to your team.

Please let me know if you need any additional information.

Best regards, [Your Name] [Phone] [LinkedIn URL]

That's it. No life story. No five paragraphs about your passion. Short, professional, specific.

Want a personalized follow-up email? JobRise's Cold Email tool generates tailored follow-ups based on the job description and your resume.

Tracking Your Conversion Rates#

This is where most people never get to, and it's the most valuable part.

In your "Stats" sheet, track these numbers weekly:

After 3-4 weeks, you'll see your conversion funnel:

• Application → Callback rate: If this is below 10%, your resume needs work. Your JD matching might be off. Or you're applying to roles you're not qualified for.
• Callback → Interview rate: If callbacks don't convert to interviews, your phone screening needs work.
• Interview → Offer rate: If you're getting interviews but not offers, it's your interview prep.

This data tells you EXACTLY where to focus. Instead of "I'm not getting jobs" (vague, depressing), you have "My application-to-callback rate is 5%, which means my resume isn't matching JDs well" (specific, actionable).

The Source Analysis That Changes Everything#

After a month of tracking, sort your data by the Source column. You'll discover something like this:

Look at that. You spent the most time on Naukri and Internshala, but your best results came from referrals and company websites.

This is the kind of insight that changes your entire job search strategy. Stop mass-applying on Naukri. Start networking for referrals. Apply directly on company career pages.

You would never figure this out without tracking.

Common Mistakes with Job Trackers#

1. Making it too complicated

Don't add 25 columns. Don't create sub-sheets for each company. Don't build a Notion database with relations and rollups. The 10 columns above are enough. If your tracker is annoying to use, you'll stop using it by day 3.

2. Not updating in real-time

"I'll update it at the end of the week" means you'll forget half your applications. Update it the moment you click "Apply." It takes 90 seconds.

3. Not following up

The tracker is only useful if you act on the follow-up dates. Set a daily reminder on your phone for 10 AM: "Check job tracker follow-ups."

4. Tracking without analyzing

Don't just log data. Look at it every Sunday. Your conversion rates tell you what's working and what needs to change.

5. Applying to everything

When you have a tracker, you see exactly how many applications you're sending. If you're applying to 100+ jobs a month with no customization, that's a strategy problem. Better to apply to 30 jobs with tailored resumes than 100 with the same generic one.

Advanced: Automating Parts of the Process#

Once you've been tracking for a few weeks, you can level up:

Google Sheets Automation

• Use conditional formatting to highlight rows where follow-up date has passed and status is still "Applied" (these are overdue follow-ups)
• Formula: In a new column, use =IF(AND(G2<TODAY(), F2=\"Applied\"), \"OVERDUE\", \"\") where G is follow-up date and F is status

Email Templates

Save 3-4 follow-up templates in a Google Doc:

• First follow-up (5-7 days after applying)
• Second follow-up (14 days, slightly different angle)
• Thank you after interview
• Follow-up after interview (if no response in 5 days)

The "Batch Apply" System

Instead of applying randomly throughout the day:

• Morning (1 hour): Research and shortlist 5-8 jobs
• Afternoon (1 hour): Customize resume and apply to all of them
• Evening (30 min): Log everything in tracker, send follow-ups

This batching approach is faster and more organized than applying whenever you see a job.

Real Numbers: What Good Tracking Looks Like#

Here's what a well-tracked job search typically looks like for a fresher in India (2026):

Month 1:

• Applications: 40-50
• Follow-ups: 25-30
• Callbacks: 5-8
• Interviews: 2-3
• Offers: 0-1

Month 2:

• Applications: 30-40 (more targeted now)
• Follow-ups: 25-30
• Callbacks: 8-12 (better targeting)
• Interviews: 4-6
• Offers: 1-2

Notice the improvement in month 2. That's because tracking showed you what works: which job boards, which resume versions, which types of roles get responses. You stopped wasting time on what doesn't work.

For experienced professionals, the numbers are usually lower volume but higher conversion. 15-20 targeted applications per month, with a 20-30% callback rate if you're applying to roles that match your experience well.

The Psychological Benefit Nobody Talks About#

Job searching is brutal. The rejection, the ghosting, the silence. It messes with your head.

A tracker helps with this in a way you might not expect.

When you're feeling down ("nobody wants to hire me"), you open the tracker and see: you've applied to 35 jobs, followed up on 20, and have 3 active conversations. That's not "nobody wants you." That's a normal job search where you're making progress.

Without a tracker, all you remember is the rejections. With a tracker, you can see the full picture. Progress feels slow because you only remember the bad parts. Data shows you the real story.

Mobile Access#

Google Sheets works on your phone. This matters because:

• You'll get recruiter calls while you're out
• You can quickly check the JD and role before picking up
• You can add applications when you apply from your phone
• You can check follow-up dates while commuting

Keep the Google Sheets app installed and the tracker pinned.

When to Move Beyond Spreadsheets#

Spreadsheets work great up to about 100 active applications. Beyond that, you might want:

• Filters and views for different statuses
• Automatic reminders (Google Sheets can do this with Apps Script)
• Integration with email for follow-ups

But honestly? Most job seekers don't need anything more than a well-maintained spreadsheet. Don't over-engineer this. The system that works is the one you actually use.

Your 5-Minute Action Plan#

1. Open Google Sheets right now
2. Create the 10 columns listed above
3. Add your last 10 applications from memory
4. Set follow-up dates for each one
5. Send follow-up emails for any that are overdue
6. Tomorrow morning, check the tracker before you do anything else

The job search gets easier the moment you feel in control. A tracker gives you that control.

And when you're ready to write those follow-up emails, JobRise's Cold Email generator creates personalized, recruiter-ready messages based on the specific job description. Paste the JD, get a tailored email in 30 seconds.

Stop applying into the void. Start tracking, start following up, and start converting those applications into interviews."