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…
Every semester, ambitious students flock to apply for internships, often sending out a daunting number of applications. Keeping track of these applications can quickly become overwhelming. The reporter found a solution that works well: one spreadsheet, with each application assigned a single row. To use this spreadsheet effectively, the writer used specific columns and a weekly review process to stay organized.
The spreadsheet includes key columns such as the company name, the role title, the link to the posting, the source of the posting (career page, Handshake, referral, or another job board), the date the posting was first seen, the deadline, the date the application was submitted, the status of the application, the next step required, follow-up date, and any additional notes.
The status column uses a dropdown list with options like To apply, Applied, Online assessment, Interviewing, Offer, Rejected, Ghosted. To use this feature in Google Sheets, go to Data > Data validation > Add rule, and set the dropdown options.
Before submitting applications, the writer recommends saving the job description in a separate tab or folder to refer to later, especially if the interviewer asks about specific requirements. A weekly review is essential rather than a daily scramble. Set a reasonable weekly target, such as five thoughtful applications, and adjust as needed.
Sort the sheet by the follow-up date and deadline every week, moving any late applications to the top. If responses are scarce, seek advice from a career adviser or practice interview skills.
The reporter suggests starting with your school's career platform and the career pages of employers you are interested in. Expand your search using additional tools to avoid manually checking 50 company sites. I Got An Internship, a free internship search platform built by the writer, aggregates internships and co-ops from about 2,200 employer career pages across the US and Canada.
The platform allows students to filter by role, term, city, and visa sponsorship. Always confirm job details with the employer's current posting before spending time on the application. Stick to a consistent review schedule, and the tracker will help keep your internship search organized and increase the chances of landing an offer.
Written by urgent.news from Dev.to's reporting — not their text. Machine-written — may contain errors; check the original before relying on it.