Free internship tracker for Google Sheets
Keep every internship you're looking at in one list: company, role, season, location, pay, deadline and where it stands. The tracker counts down to each deadline, tells you when to follow up, records which resume and documents you sent, keeps your career fair and alumni contacts with thank-you reminders, and lines up your offers so you can compare total pay.
Pro Want deadline flags, a daily to-do list and an offer comparison that counts rent? See Internship Tracker Pro →| Applicationsrowsandcells.com | |||||||||||||||||
| Deadlines, applications, contacts and offers for recruiting season.Free template | |||||||||||||||||
| Company | Role | Season | Location | Work style | Pay per hour | Deadline | Status | Applied | Resume version | Cover letter | Transcript | Referral | Days to deadline | Follow up on | Next action | Notes | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Kestrel Analytics | Data Science Intern | Summer 2027 | Chicago, IL | Hybrid | $34.00 | Sep 30, 2026 | Interview | Sep 12, 2026 | Resume v3 (data) | Jordan Lee | Sep 22, 2026 | Follow up now | Final round Oct 23 | ||||
| Northwind Logistics | Supply Chain Intern | Summer 2027 | Columbus, OH | On-site | $24.00 | Oct 1, 2026 | Rejected | Sep 15, 2026 | Resume v2 (general) | Closed | Form email Oct 9 | ||||||
| Brightline Health | Product Management Intern | Summer 2027 | Boston, MA | Hybrid | $38.00 | Oct 15, 2026 | Assessment | Oct 10, 2026 | Resume v3 (data) | Oct 20, 2026 | Waiting | Online test due Oct 21 | |||||
| Summit Outdoor Gear | Marketing Intern | Summer 2027 | Denver, CO | On-site | $21.00 | Oct 20, 2026 | Applied | Oct 12, 2026 | Resume v2 (general) | Chris Patel | Oct 22, 2026 | Waiting | Met at fall career fair | ||||
| Lumen Software | Software Engineering Intern | Summer 2027 | Remote | Remote | $45.00 | Oct 31, 2026 | Applied | Oct 14, 2026 | Resume v4 (software) | Oct 24, 2026 | Waiting | ||||||
| Harbor Credit Union | Finance Intern | Summer 2027 | Portland, ME | On-site | $22.00 | Nov 1, 2026 | Researching | 14 | Not due yet | Ask career center to review cover letter | |||||||
| Cedar & Pine Architects | Design Intern | Summer 2027 | Seattle, WA | Hybrid | $25.00 | Oct 24, 2026 | Researching | Prof. Alvarez | 6 | Due soon | Portfolio needed | ||||||
| Bluebird Media | Social Media Intern | Spring 2027 | Remote | Remote | $18.00 | Oct 12, 2026 | Researching | -6 | Deadline passed | Missed it, check for spring round | |||||||
| Granite State Bank | Audit Intern | Summer 2027 | Manchester, NH | On-site | $27.00 | Sep 25, 2026 | Offer | Sep 5, 2026 | Resume v2 (general) | Ruth Gomez | Decide on offer | Answer by Nov 1 | |||||
| Riverside Children's Museum | Education Programs Intern | Summer 2027 | Albany, NY | On-site | $17.00 | Nov 15, 2026 | Researching | 28 | Not due yet | ||||||||
| Atlas Robotics | Mechanical Engineering Co-op | Spring 2027 | Pittsburgh, PA | On-site | $30.00 | Oct 10, 2026 | Offer | Sep 20, 2026 | Resume v4 (software) | Decide on offer | Offer came Oct 15 | ||||||
| Meridian Consulting | Business Analyst Intern | Summer 2027 | New York, NY | Hybrid | $40.00 | Sep 28, 2026 | Applied | Sep 26, 2026 | Resume v3 (data) | Oct 6, 2026 | Follow up now | Case interview prep | |||||
| Greenleaf Foods | Sustainability Intern | Summer 2027 | Minneapolis, MN | Hybrid | $20.00 | Oct 5, 2026 | Withdrawn | Sep 18, 2026 | Resume v2 (general) | Closed | Unpaid weeks, passed | ||||||
| Orbit Games | QA Testing Intern | Summer 2027 | Austin, TX | Remote | $23.00 | Nov 30, 2026 | Researching | Sam Okafor | 43 | Not due yet | Referral offered at info session | ||||||
| Contactsrowsandcells.com | |||||||||||
| Type in the cream cells. Shaded cells are formulas and fill in on their own.Free template | |||||||||||
| Name | Company | Title | Where you met | Met on | Thank-you sent | Last contact | Check in by | Next step | Notes | ||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Jordan Lee | Kestrel Analytics | Recruiter | Career fair | jordan.lee@email.com | Sep 10, 2026 | Oct 8, 2026 | Oct 29, 2026 | Not yet | Asked about final round timing | ||
| Chris Patel | Summit Outdoor Gear | Brand Manager | Alumni | chris.patel@email.com | Sep 24, 2026 | Sep 24, 2026 | Oct 15, 2026 | Reach out | Referred me | ||
| Ruth Gomez | Granite State Bank | HR Generalist | Family friend | ruth.gomez@email.com | Aug 30, 2026 | Oct 12, 2026 | Nov 2, 2026 | Not yet | Thank her once I decide | ||
| Sam Okafor | Orbit Games | QA Lead | Info session | sam.okafor@email.com | Oct 14, 2026 | Send thank-you | Offered a referral | ||||
| Prof. Alvarez | School of Design | Professor | Class | alvarez@school.edu | Sep 2, 2026 | Sep 20, 2026 | Oct 11, 2026 | Reach out | Will write a reference | ||
| Mia Chen | Meridian Consulting | Analyst | Career fair | mia.chen@email.com | Sep 10, 2026 | Send thank-you | Business card in folder | ||||
| Dev Sharma | Lumen Software | Engineer | dev.sharma@email.com | Sep 29, 2026 | Sep 29, 2026 | Oct 20, 2026 | Not yet | Coffee chat went well | |||
| Offersrowsandcells.com | |||||||||||||
| Type in the cream cells. Shaded cells are formulas and fill in on their own.Free template | |||||||||||||
| Company | Role | Pay per hour | Hours per week | Weeks | Total pay | Housing or stipend | Travel or relocation | Total value | Location | Respond by | Days left | Notes | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Granite State Bank | Audit Intern | $27.00 | 40 | 10 | $10,800.00 | $0.00 | $0.00 | $10,800.00 | Manchester, NH | Nov 1, 2026 | 14 | Return offer possible | |
| Atlas Robotics | Mechanical Engineering Co-op | $30.00 | 40 | 16 | $19,200.00 | $0.00 | $1,000.00 | $20,200.00 | Pittsburgh, PA | Nov 20, 2026 | 33 | Co-op counts for credit | |
| Summaryrowsandcells.com | |||||
| Type in the cream cells. Shaded cells are formulas and fill in on their own.Free template | |||||
| Item | Value | ||||
|---|---|---|---|---|---|
| Today | Oct 18, 2026 | ||||
| Follow up after (days) | 10 | ||||
| Warn me about deadlines within (days) | 7 | ||||
| Check in with contacts every (days) | 21 | ||||
| Internships on your list | 14 | ||||
| Applications sent | 9 | ||||
| Still waiting to hear | 5 | ||||
| Interviewing now | 1 | ||||
| Offers (open or accepted) | 2 | ||||
| Rejected | 1 | ||||
| Heard back rate | 55.6% | ||||
| Deadlines coming up (apply now) | 1 | ||||
| Deadlines missed | 1 | ||||
| Follow-ups due | 2 | ||||
| Offers to decide on | 2 | ||||
| Thank-you notes to send | 2 | ||||
| Contacts to reach out to | 2 | ||||
| Next offer reply due | Nov 1, 2026 | ||||
What's inside
- One row per internship: company, role, season, location, work style, pay per hour, deadline, status and notes
- A countdown to every deadline, with Due soon and Deadline passed flags for roles you haven't applied to yet
- A record of what you sent each place: which resume version, cover letter, transcript and who referred you
- A follow-up date for every application still waiting, and a Next action that says what to do
- A contacts list for career fairs, info sessions and alumni, with thank-you and check-in reminders
- An Offers tab that works out total pay over the whole internship, plus housing and travel, with a reply-by countdown
How to use it
Download your copy
Click "Free download" to save the .xlsx file. It opens in Excel, or in Google Sheets: open a blank sheet (sheets.new) and choose File, then Import, then Upload.
Set your rules
On the Summary tab, type =TODAY() in the Today cell. Then set how many days to wait before following up, how early to warn you about deadlines, and how often to check in with contacts.
List the internships you want
Add each posting on the Applications tab with its deadline and the status Researching. Do this early in recruiting season, when postings open, so nothing slips past.
Apply and record what you sent
When you apply, change the status to Applied, add the date, and note the resume version and whether you sent a cover letter or transcript. Use these statuses: Researching, Applied, Assessment, Interview, Offer, Accepted, Rejected or Withdrawn.
Add people as you meet them
Put recruiters, alumni and anyone from a career fair or info session on the Contacts tab. Tick Thank-you sent once you've emailed them and fill in Last contact so the check-in date works.
Compare offers
When an offer comes in, add it to the Offers tab with the hourly pay, hours, weeks and any housing or travel money. Total value and Days left fill in, so you can see which offer pays more and when you need to answer.
Tips
Start in late summer
Many summer internships at larger companies open in August and September, a year ahead. Smaller employers and nonprofits often post in spring. Add roles as soon as you see them so the deadline countdown helps.
Name your resume versions
If you tailor your resume, save each version with a short name like v3 (data) and use that name in the Resume version column. Before an interview you'll know exactly what they read.
Send thank-you notes within a day
After a career fair or coffee chat, a short email the same day or the next helps people remember you. The Contacts tab shows anyone still waiting for one.
Ask before you accept
If an offer deadline comes before you hear from a company you prefer, it's normal to ask the first company politely for a few more days. Your career center can help with how to word it.
Questions
What should I track for internship applications?
At least the company, role, deadline, date applied and status. This tracker also keeps the season, location, work style, pay, which resume and documents you sent, any referral, and a follow-up date.
How does the deadline countdown work?
For anything still marked Researching, Days to deadline is the deadline minus the Today date on the Summary tab. Next action shows Due soon when the deadline is within your warning window (7 days in the sample) and Deadline passed after it.
How is the follow-up date worked out?
It adds your follow-up days (10 in the sample) to the date you applied, for anything marked Applied, Assessment or Interview. On that day Next action changes to Follow up now.
How do I compare internship offers?
On the Offers tab, Total pay is pay per hour times hours per week times weeks. Total value adds any housing stipend and travel or relocation money, so offers of different lengths line up fairly.
Can I track co-ops and spring or fall internships too?
Yes. Use the Season column for Summer 2027, Spring 2027, Fall co-op and so on, and sort or filter by it.
Is this internship tracker free?
Yes. Download the .xlsx file and open it in Excel or Google Sheets. There's no sign-up.
Pro version
Internship Tracker Pro
Every internship, deadline, document, interview and contact for recruiting season in one place, with a to-do list and a side-by-side offer comparison.
Never miss a deadline
Every posting counts down to its deadline and is flagged Due this week, Due soon or Missed. The Dashboard lists the next eight deadlines and what you still need to send for each.
Know what's ready to send
Mark the resume version, cover letter and transcript each application needs. A Ready flag shows which ones you can submit now and which are waiting on a document.
Know what to do today
Each internship gets a next action: apply now, prepare for an interview, send a thank-you, follow up or decide on an offer. The Dashboard puts them in order.
See which resume works
List your resume versions once on Materials. Each one shows how many places you sent it to, how many replied and how many gave you an interview.
Keep career fair contacts warm
Add recruiters, alumni and people from info sessions with where you met them. Thank-you and check-in reminders come up on their own, and you can see who referred you where.
Compare offers fairly
Put up to four offers side by side: hourly pay, hours, weeks, housing and travel money, and what rent would cost there. See what each one leaves after living costs, then a weighted score on what matters to you.
| Free | Pro |
|---|---|
| Applications list with a deadline countdown | Deadline status flags and the next eight deadlines on the Dashboard |
| Cover letter and transcript checkboxes | Needed, Sent or Not needed for each document, with a Ready flag |
| One follow-up wait for all | Follow-up wait set per stage, plus Gone quiet flags |
| · | Interview log with prep and thank-you reminders |
| Contacts with thank-you reminders | Contacts with where you met, check-in dates and referrals |
| · | Resume versions with reply and interview rates |
| Offers with total pay | Offers with living costs, pay after costs and weighted scores |
| · | Recruiting season week by week against your goals, with a chart |
| · | Dashboard with a season picker, to-do list and pipeline chart |
$12 one-time
9 tabs: Start Here, Dashboard, Applications, Interviews, Contacts, Materials, Offers, Season and Setup. You get two copies: one filled in with a sample recruiting season so you can see it working, and a blank one ready for your own.
Buy now- Instant download after checkout
- Works in Google Sheets and Excel
- Yours to keep and reuse every year