DEV Community

Dataford Research
Dataford Research

Posted on

How I track internship applications

Most students I talk to apply to 30, 50, sometimes 100 internships in a season. By week three, it is hard to remember which ones you already applied to, which ones need a referral, or which deadline is next Friday. The system I keep coming back to is simple and it works: one spreadsheet, one row per application.

Here is the setup I use, including the columns and a weekly review habit that keeps the search from turning into a second class.

The columns

Keep it to one row per application. These are the columns I use:

  • Company. Google, a local hospital, a regional bank, whoever.
  • Role. For example, "Data Analyst Intern, Summer 2027."
  • Link. The posting URL, so you can find it again.
  • Source. Career page, Handshake, referral, or another job board.
  • Date opened. When you first saw the posting.
  • Deadline. The posted close date, if there is one.
  • Date applied. Leave this blank until you hit submit.
  • Status. A short dropdown, described below.
  • Next step. "Email recruiter" or "Online assessment due Friday."
  • Follow-up date. When you will check in next.
  • Notes. Visa sponsorship, referral name, pay, location, or anything else you might forget.

Every extra column is one more thing you will stop filling in. If you need a field only for a handful of roles, put it in Notes.

A status dropdown

Use a short list of statuses and stick to it:

  • To apply
  • Applied
  • Online assessment
  • Interviewing
  • Offer
  • Rejected
  • Ghosted

In Google Sheets, select the status column, go to Data > Data validation > Add rule, pick Dropdown, and add those options. Give each one a color. A column of "Interviewing" cells after a rough week is easier to read than a wall of unstructured notes.

Save the job description

Postings disappear. Before you apply, paste a copy of the description into a folder or a second tab, or save a PDF. When an interviewer asks about a requirement from the original posting, you will be glad you kept it.

A weekly review, not a daily scramble

Set a weekly target you can sustain. Around five thoughtful applications can be a workable starting point during a busy semester. Adjust for your field and your available time. That is a planning suggestion, not a promise about how many applications lead to an offer.

Once a week, sort the sheet by follow-up date and deadline. Move anything that is late. If you rarely hear back, ask a career adviser to review your targeting and resume. If interviews stall, practice the stage where you are getting stuck.

Where the roles come from

Start with your school's career platform and the career pages of employers you already care about. Then add one or two wider search tools so you are not checking 50 company sites by hand.

I built I Got An Internship as a free internship search platform for students. It lists internships and co-ops pulled from about 2,200 employer career pages across the US and Canada, about 5,000 roles at a time. Students can filter by role, term, city and visa sponsorship. When a company takes a posting down, the listing comes down too. You still apply on the employer's own site; the tracker is there so the application does not get lost.

Wherever you find a role, open the employer's current posting before you spend time on the application. Confirm the dates, location, pay, and eligibility language yourself.

What to do this week

  1. Create the sheet and add every application you have already started.
  2. Pick two or three role types so you are not rewriting your resume for unrelated jobs.
  3. Add five live postings with real deadlines or a date you will submit a rolling application.
  4. Put a 20-minute review on your calendar for the same day each week.

The tracker will not get you the offer. It keeps the search organized long enough that your best applications actually go out.


Author bio: Amney Mounir is a Product Growth Analyst at Meta, founder of Dataford, and creator of I Got An Internship. He shares career and data content with more than 85,000 followers on LinkedIn. This article reflects his personal views.

Top comments (0)