Skip to content
Internship Application Tracker cover: a sample sheet with applications, in interviews and offers and a column chart, beside the Dashboard and Applications tabs

Internship Application Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Style
Modern
Difficulty
Beginner
Updated
November 13, 2026

Every slide (5)

Overview

The Internship Application Tracker suits students and new graduates applying for summer and term internships. The Applications tab records each company and role with its season, work style, monthly stipend, applied date, current stage and next step. The Contacts tab keeps the people who can refer you, when you last spoke and the date to chase. The Dashboard counts applications, interviews and offers, the average stipend and how each season is progressing.

Apply early in each season, because many programs fill before the posted closing date. Update the stage the same day you hear back, and write the next step with a date so the list says what to do today. Compare offers by stipend and work style together, and log every referral on the Contacts tab with a thank-you note sent within a day.

Useful for

  • Following ten summer internship applications at once
  • Choosing between two offers with different stipends
  • Remembering who to follow up with after a career fair

What's included

  • 4 tabs: Dashboard, Applications, Contacts, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Applications: a table
  • Contacts: a table
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Applications tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How do I track internship applications?

Add each internship as a row with its company, role, season and closing date. Change the stage as you hear back, and write the next step so the list always shows what to do next.

How do I compare internship pay?

Enter the monthly stipend for each offer. The average stipend on the Dashboard gives a quick baseline, but also consider the cost of living, travel and whether housing is included, since two similar stipends can leave very different amounts.

When should I follow up after applying?

A courteous nudge a week or two after the application, or after an interview, is usually welcome. Write the nudge date on the Contacts tab so it is not forgotten, and keep each message short and specific about the role.

  • #job-application-tracker
  • #internship-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More job application tracker templates

See all 3

Also in Careers

All careers templates
Get this template

Preparing your template…