Job hunting is a daunting process, you apply for several jobs, you have to talk to many recruiters and if you’re tech you even have to go through coding interviews. It’s all a lot to keep track of. Fortunately, we can make this process a bit easier if we organize job leads.
During my job search, I’ve been keeping up with my job search leads via a spreadsheet. With this spreadsheet, not only can you keep track of your leads but you can also track the statuses of those job leads and it’s completely customizable to fit your needs. This spreadsheet is meant to be a template and should be tweaked to fit your own job search, I just wanted to make it easier for you to start.
Go to this link to sign up for your free copy of the spreadsheet. After you’ve received the email with your download, come back here and I’ll show you how to use it.
Job status spreadsheet columns:
Job name – the name of the job
Company name/size – it’s helpful to know how big the company is, you can usually find this by quickly looking on LinkedIn.
Company location – this a good place to add the location of the job and if they intend for you to locate or if it’s a remote position
Link to job – I keep track of my job descriptions in a google doc, however it’s also useful to have a link to the actual job on the company website so you can quickly have a link to refer to during the interview process.
Main languages – this is specially if you’re adding tech job leads. The language refers to the coding languages the company uses based on the job description
Date applied – once you apply, add the date here so you can see how long your response time is.
Where did you hear about the job? – This is a very important one. Hiring managers and recruiters will ask you where you heard about the job from and if a friend sent you the job, let them know. For example, I put that I heard from the job on twitter from John Smith and also keep track of that person’s twitter username so that if I need to I can quickly go back and see what that person said or if I sent them a message I can quickly refer back to it. Use this same process whether the lead came from any social media like linkedin or if you spoke to this person at an online event etc.
Initially qualified? – I added this because I want to know if the positions I’m interviewing for are seemingly within my reach just at a glance. For me, the main thing since I’m looking at tech jobs is that I have some of the coding languages and most of the amount of experience they are looking for. Spoiler alert, I’m not always initially qualified and that’s okay, I still apply if the position looks interesting and I feel that I could learn the skills they ask for. This column can be answered with yes you are or no you are not
Cover letter – Some jobs ask you to, some jobs you have to apply via email with a message stating your interest and qualifications (this is considered a cover letter) and others don’t require it. Either way, this column can be a simple yes you did add a cover letter or no you didn’t. If I want to provide further information, sometimes I’ll add that the cover letter is saved in my google doc.
Heard back after applying? – Did you get an email after submitting your application whether it was a rejection or an invitation to interview. This is a yes or no column and is used in conjunction with the initial contact column.
Initial contact – For this, I add the first and last name of the person I talked to first from the company in terms of a recruiter or hiring manager. I don’t put down phone numbers usually because we’re talking over zoom. It could be a good idea to add their email here in case you need to quickly refer to it. Also in case you need to write a follow up email, you now have it in this sheet as a quick reference
Initial interview – Here, I write down whom I had the initial interview with and what date and time. If there are important details we talked about or things that may be helpful later down the line, I jot them down here. This may be good time to write down the rest of the interview process to expect for this position. Also jot down how you feel the interview went.
Second interview & Third Interview – Same here, jot down whom the interview with was and the date and time of that interview. As well as any additional notes that may be important throughout the interview process.
Side note, you’ll notice there are no additional columns for any subsequent interviews, feel free to add additional columns as you need them. This is meant to be a template that you can tweak as you see fit.
Additional notes – In this column, you can add any information about coding interviews here or you can use it to keep track of important details about the job that you may need later on in the process. You can also use this column to write down how you feel about the job – maybe it’s a good fit but you didn’t like the conversations you had with the people on the team during your interview process. Use this field to write out any helpful details you will need or that may be helpful for the future.
Offer amount – This is the fun part of the spreadsheet! You did the hard work of interviewing and then you get an offer, keep track of your offer amounts for positions. Even if you only have one offer, take note of it here. Write down what all comes with that offer as well including bonuses, equity, vacation days etc. This is important for future reference. Chances are you aren’t staying the same job forever so it’s great to have this to refer back to as where you started at and what you want for future opportunities.
I do hope this was helpful for you. If you have any questions or comments you can find me here.