Are you feeling overwhelmed by the job search process, whether you’re a recent graduate or looking to advance your career? It’s easy to forget which job applications you’ve submitted or struggle to keep track of potential interviews with employers. That’s where job application tracking comes in handy.
If you’re in need of a ready-to-use template to organize your job applications, our job tracking spreadsheet is incredibly intuitive. In this article, we’ll share tips that you may have never considered before.
What is a Job Application Tracking Spreadsheet?
This tool helps you organize all your job applications (and their statuses) in one place. You’ll typically use a program like Google Sheets to create and access your job application tracking spreadsheet.
Job application tracking enables you to monitor the progress of your applications, take note of companies that have responded, and keep track of whether you’ve been invited to an interview or been rejected. It helps you stay organized and even gain insights into your job search strategy. This can be especially helpful when working with freelancers and service providers, as you would find on a platform like Fiverr.
What Should a Job Application Tracking Spreadsheet Include?
There isn’t a one-size-fits-all template for building a job tracking spreadsheet and its contents. However, it is generally recommended to consider the following details and categories:
-
About the job:
- Company or organization you’re interested in joining
- Contact person and preferred communication channels
- Job title
- Salary
- Link where you found the job posting
- Application deadline
- Job location
- Employment type (e.g., freelance, full-time, part-time)
-
Pre-interview:
- Date of your application
- Status of your application (e.g., if you’ve received a response, if you’re qualified for an interview)
- Files and documents sent to the hiring department
- Checkboxes if you’ve sent follow-up emails
-
For interviews and other steps before being hired:
- Status of your hiring process (e.g., job offer, rejection, scheduling another interview)
- Date of interviews
- Location and mode (e.g., online, in-person)
- Any other notes to consider
Of course, you can always add more fields to your spreadsheet, especially if you’re creating it from scratch. If you’re unsure where to start, there are plenty of helpful guides and tutorials on Crawlan.com to assist you.
For the most comprehensive guides on Google Sheets for job tracking and much more, why not enroll in online courses on Udemy?
Why Use Our Free Job Tracking Template?
A ready-to-fill job tracking spreadsheet only requires the addition of specific details about your applications. It saves you time that you would otherwise spend organizing formatting and formulas on a blank sheet.
There are a few other reasons to consider our job tracking spreadsheet:
Organized tabs
This job tracking spreadsheet consists of three distinct tabs: job details, pre-interview, and interviews. This divides your application process into multiple stages, allowing you to keep specific information in organized categories.
Pre-formatted
Common application status options and checkboxes can be easily selected from a dropdown list. This avoids the tedious task of typing words repeatedly.
Easy accessibility
Since our template works on Google Sheets, you can access it anywhere with an internet connection. If you want to collaborate, you can easily share it with friends or colleagues.
Personal customization
Our spreadsheet also includes a dedicated section for your notes, allowing you to detail the most important aspects of a company, its culture, and employee benefits. You can also prepare questions about the position here.
You’ll discover more personalized advantages by exploring our job tracking spreadsheet. For even more comprehensive access to useful templates, don’t forget to visit Crawlan.com – and save 50% on all premium templates using the promotional code SSP.
3 Tips for Using this Free Job Application Tracking Template
Job Details tab
Browsing and noting multiple job postings on different websites (such as LinkedIn and Indeed) is a necessary step for job seekers. It allows you to cast a wide net and see which companies would be interested in hiring you.
This tab is where you input all the information you know about the position offered by a particular company. Enter the organization’s name in the first column, followed by the job posting link, recruiter’s name, and contact details in the adjacent cells.
You’ll also notice that two columns have dropdown lists: Type and Mode. Under Type, you can quickly select the employment conditions for the position, whether it’s full-time, part-time, or freelance work.
On the other hand, Mode allows you to note if the job is performed remotely or in-person. Updating the cells in this field is important, especially if you’re applying for the position online.
Don’t forget to fill in other categories, such as the base pay for the position and any documents you’ve already submitted.
Pre-Interview tab
After sending out your application emails and documents, start tracking companies that invite you for an interview.
Under the pre-interview tab, the first four leftmost columns are pre-filled with the company’s name and recruitment manager’s contact details. These details should only appear when you’ve sent an application for the position (and noted it under the Sent field in the previous tab).
Next to them, you can enter the date of your application. Immediately after, you’ll find the “Response Received” and “Send Follow-Up” categories. Checking these boxes helps you know if you still need to follow up on your application or move on to the next.
To move your application forward in the hiring process, you may also be asked for additional documents or media. List them under “Other Requested Files,” which you can also refer to when applying for other jobs in the future.
The last two columns are labeled “Research Done” and “Qualified for Interview,” with checkboxes below. Update the former if you’ve already studied the company details (such as its work culture) while waiting for a response. The latter allows you to mark if you can move on to the next step in your job search.
Interviews tab
If you qualify for an interview – and have updated the corresponding category in the previous tab – the Interviews tab will be useful.
Column A (“Status”) lets you mark if you’re currently undergoing a second interview or if you’ve already been hired. In case you didn’t succeed in any of your interviews, you can also select “Rejected” from the included dropdown list. Columns B to E should display the recruitment firm’s name and contact information.
This tab is also divided into Interviews 1, 2, and 3 (which you can increase as per your preferences or needs). Here, you can input the details of your interview, including whether it is online or in-person, as well as the location or platform.
There’s another status column that allows you to mark if you’ve received a callback for another interview, if you were hired on the spot, or simply rejected.
A “Notes” section is provided to jot down interviewer comments and questions you want answered in your next meeting.
Tracking Job Applications Has Never Been Easier
A job tracking spreadsheet is a valuable tool that makes the application process more efficient. You can easily monitor your progress, analyze what employers expect from potential candidates, and personalize your approach for each application. Download our job tracking template today:
Related articles:
