How to Track Internship Applications in One Simple Spreadsheet

By mid October of my final year I had sent 38 internship applications, and when a recruiter called about one of them I could not remember which job she meant. I said something vague, she was polite, and I never heard back. Two weeks later I found the role in my inbox: a data team I would have loved, applied to on a Sunday night and completely forgotten.

If you are applying widely, you need a way to track internship applications that takes less than a minute per entry and tells you at a glance what to do next. A notes app and a scattered inbox will not do it past about fifteen applications. A simple spreadsheet will, and here is the version I wish I had built from the first one.

Why Your Inbox Is Not a Tracking System

Most students rely on email as their record. The problem is that a lot of the pipeline never reaches your inbox. Applications on company portals send a generic "thanks for applying" from a no reply address, or nothing at all. Career fair conversations live on a business card. Referrals happen in a direct message. When you try to reconstruct where you stand, you are piecing it together from five places.

There is also a timing problem. Internship cycles run on deadlines and follow up windows, and an inbox has no idea that a role you applied to 12 days ago is now due a polite nudge.

The Columns Worth Having

Keep it to one row per application and no more than ten columns. Every extra column is something you will stop filling in by week three.

That last column matters more than it looks. Postings disappear the moment a role closes, often just before interviews start. Save a PDF or a screenshot of every ad when you apply so you can reread the requirements before a call.

Use a Fixed List of Stages

If you type stages freely you end up with "applied", "Applied!!", "sent" and "submitted" meaning the same thing, and sorting breaks. Set up a dropdown with these options and nothing else:

1. Researching
2. Applied
3. Online test
4. Interview
5. Offer
6. Rejected
7. No response

Add colour rules so Interview and Offer rows turn green and Rejected rows turn grey. Within a few seconds of opening the sheet you can see where your energy should go.

The Next Action Column Does the Real Work

The column most trackers skip is the only one that changes your results. A list of what you have done is a diary. A list of what to do next, with dates, is a plan.

Every row must have a next action, even if it is "mark as no response on 2 Dec". Sort the sheet by next action date every Monday and work down the top five or six rows. For applications with no reply after about two weeks, a short follow up email to a named contact is reasonable. Keep it to three sentences and reference the exact role title.

Why the date should be a separate column

Writing "follow up next Tuesday" inside a text cell means you cannot sort by it. A real date column lets you filter to everything due this week in one click.

Counting Applications Is the Wrong Goal

Career advice often sets a target like "send 50 applications by December". I followed that and it made my applications worse. To hit the number I sent the same generic cover letter to every portal, and my response rate sat around 5 percent.

The tracker is more useful when it tells you which sources actually work. Add a quick count at the bottom: how many applications came from each source, and how many of those reached an interview. In my second cycle, cold portal applications converted at roughly 1 in 20, while referrals and career fair conversations converted at closer to 1 in 4. That is a reason to spend Saturday on working a career fair properly rather than on another dozen portal forms.

Keep Your Documents Next to the Tracker

Create one folder per application season with a subfolder for each company where you reached the test stage or beyond. Inside it, keep the exact CV and cover letter version you sent, named with the company and date. When an interviewer asks about a line in your cover letter, you can open the precise text in seconds instead of guessing which draft they saw.

If cover letters are the step you dread, writing a cover letter with no experience gives a structure you can adapt quickly for each row in the sheet.

A Weekly Twenty Minute Review

Pick a fixed time each week, such as Monday at 8 a.m. before lectures. In twenty minutes:

• Update the stage for anything that changed.
• Move rows with no reply after four weeks to No response.
• Complete or reschedule every next action due this week.
• Add any new roles you want to apply to as Researching, with their deadlines.

That routine is what stops a call from a recruiter catching you off guard.

Frequently Asked Questions

What is the best app to track internship applications?

A free spreadsheet in Google Sheets or Excel is enough for most students. Dedicated job tracking apps work too, but a spreadsheet lets you add the source analysis and custom stages that make the tracker actually useful.

Should I delete rejected applications from the sheet?

No. Keep them, greyed out. They show you which roles and sources are not working, and many companies reopen similar internships the following year, when your notes on contacts and timing become valuable.

How long should I wait before following up?

Around ten to fourteen days after applying is a sensible default, unless the posting gave a timeline. Follow up once, politely, then set a final date to mark the row as no response.

Build It Before Your Next Application

Open a blank spreadsheet tonight and add the ten columns, the stage dropdown and a sort by next action date. Then enter every application you have already sent, even the ones you half remember, and give each one a next action. It takes about half an hour, and from then on every new application costs you sixty seconds to log. When the recruiter calls, you will know exactly which job she means. More guides on the process live in our applications section.