How to Keep Track of Internship Applications

You won't lose an internship because your spreadsheet was ugly. You'll lose it because a deadline rotted while you weren't looking, or because a reply came back and you forgot to do the next thing. Once your list climbs past a couple dozen roles, memory stops working and you need a system. This post gives you the exact columns that actually drive action, a 15-minute weekly review that beats checking every day, and a way to tier your list so it has a shape instead of being one long anxious scroll.

Why most application trackers fall apart

Most trackers are a diary. They record the past (you applied here, you got rejected there) and stop. That's fine when you have five rows. It collapses the moment you have forty, because a diary never tells you what to do next. You open it, see a wall of "Applied," feel vaguely behind, and close it. Nothing moved.

The fix isn't a fancier tool. It's two ideas baked into the sheet itself: every live row should always say what its next action is, and when that action is due. A tracker that answers "what should I do right now" is a system. A tracker that only answers "what did I already do" is a graveyard. Everything below is built to keep yours on the living side of that line.

The columns that actually matter

Here's a set you can copy into a blank spreadsheet today. One line each on what it is and why it earns its place. Skip the columns at the end, because every column you add is a column you have to maintain, and a tracker that's a chore to update is a tracker you'll abandon.

• Company and Role. Obvious, but split them. You may apply to two roles at one company, and you'll want to sort by either.
• Tier. Reach, target, or safety. This one tag gives your whole list a shape (more on it in the next section).
• Channel. Where you found it or how you applied: school portal, a referral, the company careers page, a job board. Over a season this quietly tells you which sources actually convert, so you can do more of what works.
• Contact / referral. The name of anyone on the inside, plus how you know them. A blank here is a flag that this application could use a human before it goes in.
• Date applied. Fill it the moment you hit submit. This is what your follow-up timing counts from.
• Status. Where the role is in the pipeline. Keep the set tight (see below).
• Next action. The single most important column, and the one most guides leave out. What is the very next thing you need to do? "Follow up," "prep for screen Thursday," "ask Priya for referral," "nothing, waiting on them." If a row's next action is genuinely "wait," say so, so you don't keep re-deciding.
• Follow-up date. The other column that turns a log into a system. The date you'll chase a silent application or do the next-action thing. This is your reminder, built into the sheet, so nothing depends on you remembering.
• Link. The posting URL. Saves you re-hunting a role that's since dropped off the board, and lets you double-check details before an interview.

Together, next action and follow-up date are the whole difference between a diary and a system. With them, your weekly review is just "show me everything due this week." Without them, you're re-reading forty rows trying to reconstruct what's outstanding.

Columns to skip. Resist the urge to track which resume version you sent, whether you wrote a cover letter, or salary. For internships these are mostly noise: they bloat the sheet, slow down every update, and rarely change what you do next. If a detail won't drive an action, leave it out.

A status set that doesn't sprawl

Status only helps if the options are few enough to pick instantly. Use this tight set and resist inventing more:

• To apply (on your list, not submitted yet)
• Applied
• Screen (recruiter or phone screen scheduled or done)
• Interview
• Offer
• Closed (rejected, withdrawn, or ghosted past the point of caring)

Six options. Notice "Closed" covers rejection, your own withdrawal, and the silent ones you've given up on, so you're never agonizing over which flavor of "no" to log. The point of status is a one-second update, not a precise autopsy.

Tier your list: reach, target, safety

The mistake that quietly sinks a search is spraying applications with no sense of odds. Every role feels equally urgent and equally hopeless, so you either chase only the glamorous ones or fire off the same generic application everywhere. Tagging each row with a tier fixes that by giving your list a shape.

• Reach. Roles where you're a long shot: the brand-name programs, the ones with brutal acceptance rates, the postings that want a year more experience than you have. Worth applying to. Just don't build your hopes on them.
• Target. Roles where you're a realistic, solid fit. Your skills line up, the bar is real but reachable. This tier should be the bulk of your list, because it's where most offers actually come from.
• Safety. High-probability roles you'd genuinely still take. This is the tier students get wrong. Safety does not mean "bad" or "settling." It means a role where the odds are strongly in your favor and you'd be happy to do it: a smaller local company, a less-hyped team, a role that fits you almost too well.

Tiering is about probability and fit, not prestige. A no-name startup can be a reach if you're underqualified for it, and a famous company can be a target if you're a strong match for that specific team. Aim for a list that isn't all reaches. If every row is a moonshot, you don't have a strategy, you have a wish, and a spring full of rejections waiting to happen.

The weekly review (15 minutes, not daily)

Here's the rule: review your tracker once a week, not every day. The reason is plain. Daily checking is anxiety wearing the costume of productivity. Refreshing your inbox six times a day doesn't move a single application forward; it just teaches you to feel bad on a schedule. Real progress happens in batches, and a weekly pass is enough to catch everything that's actually time-sensitive.

Pick a regular slot. Sunday evening works for a lot of people because it sets up the week, but any fixed time you'll actually keep beats a "better" time you won't. Then run this, and you're done in about 15 minutes:

1. Sweep the silent rows into follow-ups. Scan for anything that's been "Applied" with no reply for roughly 10 to 14 days. That stretch of silence is the usual rule-of-thumb trigger for a polite nudge, so set a follow-up date and a next action on each one.
2. Advance statuses. Move rows that changed this week: heard back, scheduled a screen, got a rejection. Anything dead becomes "Closed."
3. Fill in every blank next action and follow-up date. No live row should have an empty next action. If you don't know what's next, that's the signal to decide right now, while you're looking at it, not at 11pm when an email lands.
4. Add this week's new opens. Pull in the fresh roles from your sourcing pass and tag each with a tier on the way in.

That's it. Ten or fifteen minutes, once a week, and your tracker is current and actionable for the next seven days. If you keep this habit, the sheet also becomes a quiet diagnostic: when you can read your funnel and see that applications go in but screens never come out, you'll know the problem is upstream of the tracker, in your applications themselves.

When to add a row vs. when to stop

New rows should come from your weekly sourcing pass, not from idle late-night scrolling. If you don't have a sourcing habit yet, set up a weekly sourcing routine first, because that routine is the thing that produces the rows this tracker organizes. The two loops run together: source for 30 minutes, review for 15, same day each week.

Cap your list at what you can actually personalize. There's no magic number, and a tracker with eighty copy-pasted applications is worth less than one with twenty-five you tailored. The honest tell that you've over-scoped is simple: when keeping the tracker current is more work than doing the applications, you added too many rows. That's not a sign you need a fancier tool. It's a sign to prune. Close the reaches you were never realistically chasing and put that time into the targets.

It also helps to know that roles open in waves from July into October and again through winter, so you don't need your whole list on day one. You can read the summer 2027 timeline for which industries open when, then add rows as their windows actually arrive instead of front-loading a list that goes stale before half of it is even open.

Frequently asked questions

How many internships should I apply to?

There's no single right number, and anyone who gives you one is guessing. Ranges vary: some university career centers suggest aiming for around 20 or more, and plenty of students apply to far more than that. The more useful framing is quality over count. Apply to as many well-targeted, personalized roles as you can genuinely sustain, and stop when adding another row means you can't tailor it. Twenty thoughtful applications beat eighty identical ones.

What's the best tool to track internship applications: spreadsheet, Notion, or Trello?

All three work. The tool genuinely doesn't matter; the cadence and column discipline do. Pick the one you'll actually open every week. A spreadsheet (Google Sheets or Excel) is the lowest-friction default, sorts and filters instantly, and is what most university career centers hand out as a template. MIT's career office, for example, offers a downloadable Excel tracker for exactly this. Use Notion or Trello only if you'll genuinely enjoy maintaining them, because the best tracker is the one you keep up to date.

How often should I update or review my tracker?

Two different rhythms. Update an individual row the moment something happens: log the date the instant you apply, change the status the instant you hear back. Review the whole sheet once a week, not daily. The per-row updates keep it accurate; the weekly review keeps it actionable. Daily reviewing just adds anxiety without moving anything forward.

Should I delete rejected applications?

No. Mark them "Closed" and keep them. Closed rows show patterns over a season (which channels convert, where you stall in the funnel) that you'd lose by deleting. They also stop you from accidentally re-applying to the same team months later, which happens more than you'd think. Columbia's career office similarly suggests keeping a running record of which roles you've applied to and when to follow up (Columbia CCE).

When should I follow up on an application I'm tracking?

About two weeks of silence is the common trigger. If you applied and haven't heard anything in roughly 10 to 14 days, a short, polite follow-up is reasonable. This is exactly what the follow-up date column is for: when you apply, set a date about two weeks out, and your weekly review surfaces it automatically so you never have to hold the timing in your head.

Do this today. Open a blank sheet, drop in the columns above, and tag every existing row with a tier. Then put a recurring 15-minute review on your calendar for the same time each week. That's the whole system. It isn't clever, and it doesn't need to be. The students who land roles aren't the ones with the prettiest tracker. They're the ones whose next action is never blank.