Between searching for jobs, sending in applications, doing phone screens, and going on interviews, there’s a lot to keep track of when you’re looking for job. A spreadsheet puts all of the information you need in one place for quick and easy access. It allows you to keep track of everything you’re doing to ensure that you don’t miss anything important.
Having your information organized will make it easier to prepare when you’re called in for an interview or get an email from the hiring manager. It serves as a reference document that you can refer to any time you need it. As an added bonus, being organized can help lower stress levels. The spreadsheet should include the following:
- Name of the company and applied position: The two most crucial pieces of information to track. Write the job title exactly as it it’s written on the job description so that you use the right terminology when you’re speaking with the hiring manager.
- A link to the job application/job description: You’ll want to refer back to the job description before you have your interview. Saving the link to the application will ensure you don’t waste any time going back and searching for the information you need.
- Date applied: Keep track of the dates you send applications in so that you know when to follow up, and also when to consider it a no if you haven’t heard back.
- How you applied: Write down how you sent in your application. Was it through an online system, referral, by email, LinkedIn, or in person?
- Name of the person who referred you: You might be asked how you heard about the job, and this ensures that you won’t forget who referred you. Also, you can write them a thank you note if you get the job.
- Resume version: It’s very helpful to keep track of which version of your resume you sent out. If the interviewer asks you to bring a copy, you want to make sure it’s the correct version. It’s also helpful to know so you can reference it correctly during your interview.
- Interview details: Include the time, location, name of the interviewer, and any other details you need to remember for the interview.
- Current status: This helps you keep track of where you are in the hiring process. The basic steps are applied, phone screen, and interview, HR round, waiting for an offer. Companies can have very different hiring processes, so this column should be customized to each job.
There’s no right or wrong way to use the spreadsheet. Customize it in the ways that work best for you. You can use colors to help you quickly visualize things or choose to have jobs sorted by application date or status.