Last summer, I applied to a lot of jobs, but one problem I ran into is that sometimes I would get contacted for an interview for jobs that I did not remember applying for. I would gladly accept the interview and research the company. As it turns out, I had not always applied for them a recruiter had just come across my resume on Indeed, LinkedIn, etc.
Now that I am searching for a full-time job. I knew I needed to find a way to stay organized and keep track of my job applications.
How did I do this?
The answer is easy…a spreadsheet! As it turns out, Excel (at least the Mac version, but I am sure the PC version does this too) has a template for either a Job Application Log or a Job Application Tracker. Personally, I chose the Job Application Log because it was more pleasing to the eye and had more options.
How did I find the template?
It is quite simple. Go file à New from Template à Enter ‘job’ in search bar à Choose the template that works best for you!
What happened once I found the template?
Once I found the template I edited a few of the titles and deleted some of the columns that were not necessary for me. I also added another column to number each row so I could keep track of the amount of job applications.
Now, every time I apply to a job I add the following to my log:
- Job Title
- Company Name/Website
- Date Cover Letter & Resume was sent
- How they were sent (i.e. email, through Indeed, on their website, etc.)
- References sent (if it was requested)
- Application Status
- If I was rejected I turn the text in that row red
- I write in if they said I would hear from them and would not
- Interview Date
- Follow up info (whether they contacted me after the interview, whether or not they said they would contact me)
- How I heard about the job
The template had most of the titles already put in, so it was a breeze getting started. I also input whether or not I was considered or not.
I have yet to find a full-time job, but I only just finished school and I know a lot of people are having trouble finding work, so I know I am not alone. Doing this spreadsheet has not only helped keep me organized, but has made me feel as though I have been working hard to find work and this spreadsheet demonstrates this.
How do YOU keep organized during your job search? Please provide your input in the comments.
Thanks for reading my post!