Internship Tracker Spreadsheet (Free Google Sheets Template)

The minimum viable tracker:

Column	Example
Company	Acme Corp
Role	Software Engineering Intern
Date Applied	2026-05-01
Status	Applied
Follow-up Date	2026-05-12
Source	LinkedIn / Sorce / company site
Contact	recruiter@acme.com
Notes	Referred by [Person]

How to set up

1. Open a new Google Sheet.
2. Add the columns above as the first row.
3. Freeze the header row (View → Freeze → 1 row).
4. Add a status dropdown: Applied, Phone Screen, Interview, Offer, Rejected, Closed.
5. Color-code by status if you want.

Status field

• Applied, submitted, awaiting response.
• Followed up, sent a follow-up after 7-10 days.
• Phone screen, recruiter screen scheduled.
• Interview, first round and beyond.
• Offer, got an offer.
• Rejected, they said no.
• Closed, withdrew or role filled.

When to update

• After a batch of applications (e.g. Sunday night).
• After follow-ups sent.
• After recruiter contact.
• After every interview.

Batch weekly, don't update in real time.

Tips for internship hunting

• Apply early (October-November for summer internships at top firms).
• Track every application; even rejections give signal.
• Follow up at 7-10 days.
• Cast wide, 50-100 applications is normal for competitive programs.

How Sorce helps

Sorce auto-applies to 5M+ open jobs and internships, free swipes every day. Combine with a tracker to manage the volume.

For more: job application tracker, job tracker, how to follow up on a job application.