By Track the next action, not just the company
An internship application tracker should help you decide what to do next. A long list of companies records activity, but it does not necessarily help with deadlines, interview preparation, or follow-up. Add a specific next action to each active opportunity so that opening the tracker produces a useful task.
You can use a spreadsheet, notes application, or dedicated tool. Choose something you will consistently maintain. Start with a small number of useful fields rather than building a complicated system that takes longer to update than the applications themselves.
Download the free application tracker CSV — Open the file in Excel, Google Sheets, or another spreadsheet application. It contains column headings and one clearly labeled example row.
The essential tracker fields
| Field | Why it matters |
|---|---|
| Company, role, and official URL | Identifies the opportunity and source |
| Location and eligibility notes | Prevents repeated suitability checks |
| Published deadline and last checked date | Separates verified dates from assumptions |
| Application date and resume version | Records what you submitted and when |
| Status and last contact | Shows the current stage |
| Next action and action date | Makes the record useful today |
Record 'not stated' when the employer gives no deadline. Put your own submission target in a different column. Save the official posting URL when possible, and retain enough notes to understand the opportunity if the posting later disappears.
Use statuses with clear meanings
Saved → Preparing → Applied → Assessment → Interview → Offer → Closed Optional: Withdrawn, Rejected, No response
Define each status consistently. An acknowledgment is not an interview invitation; an assessment is not an offer. If you use 'No response,' define it as your own administrative label rather than implying that the employer made a decision.
Write specific actions. 'Prepare a two-minute explanation of my dashboard before Thursday's interview' tells you more than 'prepare.' 'Check the portal after the published response window' is clearer than an undated 'follow up.' Close or archive records when no further action is useful.
Follow employer instructions before sending a reminder
Use any timeline or contact instructions supplied by the employer. If the posting asks applicants not to contact the team, respect that request. A follow-up should have a clear purpose and should not be a repeated message sent simply because a reminder appeared.
Subject: Application follow-up — [Role], [Name] Hi [Name], I applied for [role and reference number] on [date] and remain interested in the opportunity. My experience with [relevant example] connects closely with the role's work on [responsibility]. If there is an update you can share about the process, I would appreciate it. Thank you, [Name]
Record the message and date after sending it. This avoids duplicate contact and helps you respond with the right context if someone replies. Keep private notes and contact details in an appropriately controlled personal tracker rather than a publicly shared sheet.
Run a weekly search review
- Check approaching verified deadlines and scheduled interviews.
- Complete overdue next actions or reschedule them deliberately.
- Archive inactive opportunities and correct outdated information.
- Inspect whether your target roles match your eligibility and evidence.
- Choose one improvement for the coming week.
If suitable applications rarely produce interviews, review clarity and relevance. If interviews repeatedly expose a weak project explanation, practice that explanation. Treat these as hypotheses to investigate rather than proof that you know the reason for a rejection. A few applications are too small a sample for reliable conclusions.
Keep enough history to avoid accidental duplicates and remember what each employer received. Your goal is a system that reduces uncertainty: where you applied, what happened, and what you should do next.
Common questions
- Spreadsheet or dedicated application tracker?
- Use whichever you will maintain. Accurate records, useful reminders, and visible next actions matter more than the tool.
- Should I delete rejected applications?
- Keep enough history to avoid duplicates and understand your search, then archive old records when they stop being useful.
- Can I use the CSV in Google Sheets?
- Yes. Import the CSV into your spreadsheet application, remove the example row, and begin adding your own opportunities.
Stop retyping the same application.
Save your answers once. ApplyAgents fills Workday, Greenhouse, Lever, and more.
Get 3 autofills freeNo credit card. You always click Submit.