An internship application tracker is one sheet with your usual stages plus three additions: when each role opened, the online assessment (OA) due date, and a season end date after which open applications move to Closed. Apply in waves as roles open, not when you feel ready, and log an OA the day its invite arrives. The base columns and formulas for a job search sheet cover the rest.
How is an internship season different from a normal job search?
A season runs on the company's calendar, not yours. Rutgers' computer science career guide says large tech and quant firms often open in June or July and hire heavily from July to September, while banks and healthcare open around August to October. The University of Toronto's CS ambassadors describe US postings going live in July or August of the previous year. Put together, openings can come as early as June or July the year before, so record the date each role opened rather than trusting a single calendar.
Many companies review applications as they arrive, and Rutgers says applying as soon as a role opens, and finishing the OA sooner, can increase your chance of an interview.
| Aspect | Experienced search | Internship season |
|---|---|---|
| Timing | Apply when you're ready | Apply as each role opens |
| Review | Whenever the team gets to it | Rolling, so early helps |
| Extra deadline | A take-home, sometimes | An OA, with its own due date |
What do you add to a normal tracking sheet for a season?
Three columns, on top of the base sheet.
| Column | What goes in it | Why |
|---|---|---|
| Opened / deadline | The date the role opened, or its stated deadline | Shows which roles you're late on |
| OA due date | The date the OA is due, with the sent date in Notes | Poor tracking makes OAs easy to miss |
| Wave | 1 big tech and quant, 2 banks and others, 3 spring | Lets you filter what's open now |
Where does the online assessment go in the five stages?
Keep the five stages (Saved, Applied, Interviewing, Offer, Closed) and treat the OA as part of Interviewing, tracked through the OA due date column and a line in Notes. Some templates give the OA its own stage between Applied and Interview, and that's fine in a sheet if OAs start to pile up. We'd start without it, because a sixth stage is one more thing to keep current, and the due date already tells you what's urgent.
How do you work the waves?
Apply when a role opens, for the reason above. Rutgers calls July through November the window that matters most, so that's when the weekly pass below earns its time. Careerflow warns that poor tracking can make you miss OAs, so block time for each OA as soon as the invite lands.
Once a week, spend 20 minutes on this:
- Sort by
OA due date. Anything due this week comes first. - Sort by days quiet and look at the oldest Applied rows.
- Check the careers pages of companies still marked Saved, and add the opened date when one goes live.
If an OA clashes with exams, ask for more time. Toronto's guide says you can request an extension on OAs and calls deadlines "extremely fluid". Put the answer in Notes.
Nobody publishes a dependable number for how many internship applications is enough. Find your own after the first wave: count the rows by stage and see how many of them are still quiet after 14 days.
A worked example: one CS student, one October week
All names and dates below are made up. It's Monday 12 October 2026. Days quiet is the days since you applied or last heard anything, whichever is later.
| Company | Stage | Opened / deadline | OA due | Wave | Days quiet |
|---|---|---|---|---|---|
| Harbor Cloud | Applied | 2026-07-20 | 1 | 63 | |
| Brightside Software | Interviewing | 2026-09-14 | 2026-10-15 | 2 | 3 |
| Northgate Bank | Saved | Not open yet | 2 |
Brightside is only 3 days quiet because the OA invite arrived on 9 October, and that invite is what resets the count. Its OA is due in three days, so it outranks everything else, even though Harbor Cloud has been quiet far longer. If the OA clashes with a midterm, today is the day to ask for that extension.
Harbor Cloud gets one follow-up and stays at Applied. Northgate Bank needs nothing except a look at its careers page next week.
When does a quiet internship application go to Closed?
A quiet row gets flagged for a follow-up after 14 days, and when to follow up on a quiet application covers what to send. Closing it is a separate decision, and in a season you make it once, in advance.
Pick a season end date now. We'd put it after the spring cut-off, not earlier: Rutgers says to keep applying through at least April. On that date, every row still at Applied moves to Closed with the reason "No reply".
Until then, a quiet October row isn't a no. Rolling review means it may simply not have reached the front of the queue.
What to do with your internship applications this week
- Count your rows by stage, so you know where the season stands.
- List every OA that's due, earliest first, and block the time for each.
- Ask for an extension on any OA that collides with exams.
- Send one follow-up to your oldest quiet application, then go back to the open roles.
That's enough for a week. If you've finished an interview and the company has gone silent, what to do if an interview round goes quiet is the next read.
Keep the quiet ones from slipping away
If you've applied to a long list of internships and couldn't say which went quiet, a sheet only helps when you open it. HighCircl Tracker is coming soon, with early-bird access if you subscribe for updates. Once it's out, any application with no reply after 14 days gets flagged, with a follow-up already drafted. You copy it and send it yourself from your own mail app.
FAQ
What should an internship application tracker include?
The usual stages and columns from the job search spreadsheet guide, plus three season columns: when the role opened, the OA due date and the wave.
How many internship applications should I send?
There's no reliable published number, and it varies by school, field and how early you start. After your first wave, count the rows by stage and see how many are still quiet after 14 days. That's your own rate.
How do I track online assessments?
Log the invite date and the due date the day the email arrives, and note any extension you asked for. Sort by due date once a week so the earliest comes first.
Should I use a spreadsheet or Notion?
Either. The season additions are three columns, so any tool that holds dates and a stage dropdown works. Rutgers recommends a spreadsheet for counting how many applications you've sent.
When do software internship applications open?
Rutgers says large tech and quant firms often open in June or July and banks around August to October. Toronto says US postings can go live the July or August before. Track the date each role opened.