Skip to content

How to Track Internship Applications: A Step-by-Step Guide for High School Students

10 min read

A top-down view of printed data sheets with charts and tables, with the edge of a gray laptop across the top

TL;DR: Make one spreadsheet with a row for each opportunity. Give it columns for the organization, the link, the deadline, what the application needs, the date you applied, the next step and the result. Set your own deadline a few days before the real one. Spend 15 minutes each week updating it. A free directory like LEAD Internships is one route if you have no contacts, and it shows the deadline for each listing.

Say you apply to six small programs this term. One wants a short essay. Another wants a transcript. A third accepts applications until it fills, and a fourth closes next Friday. By week three, you can’t remember which is which.

This guide shows you how to track internship applications in a way that takes minutes, not hours. You’ll get the exact columns, a short weekly routine and a plan for replies and rejections. It works on a phone or a laptop, and it costs nothing. If you haven’t started applying yet, read how to get an internship in high school first, then come back.

How do you set up a spreadsheet to track internship applications?

Open a free spreadsheet, such as Google Sheets, and give every opportunity its own row. Add about ten columns: organization, role, link, deadline, your own deadline, what it needs, status, date applied, next step and notes. One row per opportunity keeps everything you need in one place.

Career offices say the same thing. The Tufts career center suggests a spreadsheet with the organization, the position, the important dates and notes on what each employer said. It also says to record where you found each posting and any contacts you have. A CollegeXpress guide adds the application link, whether a cover letter or essay is needed, and a personal deadline set a little before the real one.

Here are the columns we suggest, in this order:

  1. Organization and role. Write both. Two programs can have the same name for a role.
  2. Link. Paste the page where you apply, not the home page. Postings can be hard to find again later.
  3. Real deadline. Copy it exactly as the page states it, and note the time zone if it gives one. “Rolling” is a valid answer; write it as it is.
  4. Your deadline. Set this three to five days earlier. It’s your safety margin for slow internet, a missing form or a parent who needs to sign something.
  5. What it needs. List the parts: résumé, short essay, transcript, a teacher’s name, a video. Tick them off as you finish.
  6. Status. Use a drop-down with the same few words every time: Planning, Applied, Heard back, Interview, Offer, Closed.
  7. Date applied. This one date drives your follow-up timing.
  8. Next step and date. One action and one day, such as “Send check-in message, 20 Nov.”
  9. Contact. The name and email of any real person you wrote to.
  10. Notes. What you learned, in one line.

Here is a hypothetical row so you can see the level of detail. It is an example, not a real listing.

Org/role:      Riverside Library, digital archive helper
Link:          (paste the apply page)
Real deadline: 30 Nov     My deadline: 26 Nov
Needs:         résumé (done), 150-word note (draft), parent email (to do)
Status:        Planning
Date applied:  -
Next step:     Finish note by 22 Nov
Contact:       none yet
Notes:         Student-friendly; in person on Saturdays

A drop-down keeps the status column clean. In Google Sheets, select the cells and add a list under Data validation. Google’s help page for in-cell drop-down lists explains the steps. If you add new rows later, apply the drop-down to them too.

What should you track for each application?

Track anything you would need to look up again later: the link, the deadline, the required parts, the date you applied and every message you sent or received. If it would cost you ten minutes to find it, give it a column or put it in the notes cell.

Two habits save the most time. First, save the posting itself. Tufts advises copying the job description into a document before you apply, because postings can be hard to find again. You can paste the text into a note or save the page as a PDF. When an interview invitation arrives a month later, you’ll know exactly what the role said.

Second, record every contact. Tufts points out that you may be in touch with an organization several times: the application, a reply, a follow-up and a thank-you. Add a dated line to the notes cell each time. If you later write a check-in message, our guide on how to follow up on an internship application shows when to send it and what to say.

A weak note says: “Applied to the museum thing, I think.” A strong one says: “Museum education intern. Applied 3 Nov. Decision date on the page: 20 Nov. Check in 21 Nov.” The second tells you what to do next.

One safety note. Keep private details out of the sheet. Don’t store passwords, ID numbers or your home address. If you share the sheet with a parent or guardian, which is a good idea, they can see your deadlines and help you check each organization.

How do you keep deadlines from slipping?

Use two dates for every deadline: the real one and your own, three to five days earlier. Sort the sheet by your own date each week, so the nearest date is always at the top. Then put that date in a calendar with a reminder.

Sorting does most of the work. Select the whole table and sort by the “your deadline” column, oldest first. Anything marked Closed can drop to the bottom, or you can hide it with a filter.

Rolling deadlines are the trap. “Rolling” means the organization reviews applications as they arrive and may fill the role before any final date. Give a rolling listing your own deadline too, ideally within two weeks of when you first saw it. Otherwise it sits in the sheet for months.

To see what is due soon across many listings, the deadlines page groups free listings by deadline month, so you can add the dates that match your schedule. Always check the date again on the organization’s own page before you rely on it, since the apply link is the final word.

What does a 15-minute weekly routine look like?

Pick one fixed time each week, such as Sunday afternoon. Open the sheet, update statuses, sort by your deadline, choose next steps for the coming week, and add anything new you found. Fifteen minutes is enough when you do it every week.

Here is the order that works:

  1. Update (4 minutes). Check your inbox for replies. Change each status and add a dated line to the notes.
  2. Sort (1 minute). Sort by your deadline.
  3. Act (7 minutes). Do or schedule the top one or two items. That might be finishing a note, asking a teacher, or sending a check-in message.
  4. Add (3 minutes). Put any new opportunity in a new row with the status Planning.

Don’t try to do all the tasks in the session. The routine’s job is to decide what’s next, not to do all of it.

Spreadsheet or document: which tracker is better?

A spreadsheet is better for most students, because you can sort by deadline and filter by status. A document works if you like longer notes for each application. Pick the one you will really open every week. A tool you ignore is worse than a simple one you use.

CollegeXpress describes three methods: a Google Sheet, one Google Doc with a section for each company, and a paper binder with dividers. The binder has one advantage the others lack: you hold a printed checklist in your hand. Its weakness is that you can’t sort it. If you want to combine them, keep the spreadsheet as your master list and save longer drafts in a document, with a link in the notes column.

A phone is fine too. If your sheet opens in a phone app, you can note a reply the moment it arrives, instead of trusting your memory later.

When should you follow up?

Wait about a week for a small team and up to two weeks for a large organization, unless the posting gives a decision date. Then send one short, polite message and add the date to your sheet. Three messages in total is a sensible limit, and then you move on.

Your tracker makes this easy, because it already holds the date you applied. Put the follow-up date in your “next step” column the same day you submit. If you have no contact name, look for a named person on the organization’s site, and tell a parent or guardian before you write. Our guide on writing to a company has a safe way to do it.

What do you do with rejections in the sheet?

Don’t delete them. Change the status to Closed, write the date and the reason if you know it, and add one line on what you’d do differently. Rejections are normal, and the data helps: you’ll see which kinds of programs reply and which don’t.

Most small programs don’t send a rejection at all. If the decision date has passed and you’ve sent your messages, mark the row Closed, with the note “no reply”. That’s a result, and it frees your attention for the next application.

If a whole round of applications goes nowhere, look at the notes before you decide it was about you. Was the deadline too close when you applied? Was the role a poor fit for your age? Our post on what to do after a summer program says no covers the next steps in more detail.

Common mistakes when tracking applications

The first mistake is tracking only the deadline. Add the needed parts too, or you’ll find out on the last night that you need a teacher’s name. The second is too many columns. Ten is enough; a sheet with thirty columns won’t get updated.

Third, students skip the “applied” date, then can’t tell when to follow up. Fill it in the moment you submit. Fourth, they keep rows only for the exciting listings. Add the ordinary ones too, since small local programs can be a good fit. Fifth, they never look at the sheet. A tracker you only open when you’re panicking is just a list of worries. Fix this with the fixed weekly time.

Where to find opportunities to put in the tracker

A tracker is only useful once it has rows. LEAD Internships is a free directory of internships and student programs for high school and college students. A person checks each listing, every one is free to apply to, and you apply on the organization’s own site. Each listing shows a deadline, or “Rolling”, so you can copy it straight into your sheet. LEAD doesn’t run the programs or place anyone, so the listing’s own page is always the final word.

Don’t have contacts at a company? Browse free internships, each verified by people, and apply on the organization’s own site.

Other places to look are your school’s counselor, local libraries, and small businesses near you. The starter kit explains where to search when you have no network. Use the filters on the directory to narrow by field, format or country, and check what is listed before you plan around it.

Frequently asked questions

What columns should an internship tracker have?

Start with the organization, the role, the link, the real deadline, your own deadline, what it needs, status, date applied, next step and notes. Add a contact column once you write to a real person. Keep it under about ten columns so you’ll actually update it.

If you want to see how each one works, the setup section above has a full example row you can copy.

How do I keep my tracker private and safe?

Keep passwords, ID numbers and your home address out of it. Share it with a parent or guardian, who can help you check each organization and spot anything strange. Use a free spreadsheet account that you control, and don’t share the link publicly.

If a listing asks for a fee or a private chat, note it and ask an adult before you reply. The scam signs in the starter kit list what to watch for.

What if I only have two or three applications?

Use the sheet anyway. A short list still has deadlines, parts and follow-up dates, and the habit will help when you apply to more next term. With only a few rows, the weekly routine will take five minutes.

Can I use a tracker if I have no experience?

Yes. A tracker needs no experience, only dates and links. It also helps you prepare, since you can see which listings ask for skills you could build first. Many listings welcome beginners, so check each page for who can apply.

What if I miss a deadline?

Mark the row Closed, note the date and the reason, and move on. Some organizations run the program again next year, so add a reminder to look again. For rolling listings, a short polite message can ask if they are still accepting applications.

The bottom line

A tracker works because it’s small. One row for each opportunity, ten columns, your own earlier deadline and a weekly 15-minute check. Start today by making the sheet and adding the first three opportunities you know about. The free LEAD directory is a good place to find them, since each listing shows its deadline. Then book the same time next week. Browse free internships and fill your first rows.

  • application tracker
  • spreadsheet
  • getting started

Find your next opportunity.

Free internships and student programs, verified by people. No fees, no ads.

All posts