Free applicant tracking spreadsheet template




















Candidates are linked with jobs and hiring managers can easily collaborate with recruiters and HR on candidate status, feedback, etc. Kanban views make it easy to manage moving candidates and job openings through the interview and job opening lifecycle.

Training is vital for employee development, safety and productivity. Featured Templates. Use this template to create and manage a project plan. A project plan is essential for defining a project and keeping its sechedule on track.

Your project plan should typically include the scope, goals, deliverables and deadlines of your project. Within this workbook there are separate worksheets for tracking employee information, courses and certifications, scheduled class dates, and course feedback.

Training is vital for employee development, safety and productivity. Featured Templates. Use this template to create and manage a project plan. A project plan is essential for defining a project and keeping its sechedule on track. Your project plan should typically include the scope, goals, deliverables and deadlines of your project.

Excel Google Sheets. You can find additional hiring-related HR spreadsheets here. As a small business owner, you need every tool at your disposal to do some significant heavy lifting. Excel Google Docs. Fill in the columns with details regarding the position applied for, minimum experience required, department, application received date, candidate name, contact information, and more.

Next to the sustainability and profitability of your business, nothing is more important than hiring the best available candidates. Your company excels with top-notch performers, and you need a way to keep tabs on open positions and track the progress of applicants.

Without a detailed way to keep all hiring-related information in one place, top candidates slip through your fingers, interview histories are lost, and positions remain unfilled. But, what is the best way to track the best candidates? Using a template can help you get started tracking applicant details for your open positions. Empower your people to go above and beyond with a flexible platform designed to match the needs of your team — and adapt as those needs change.

The Smartsheet platform makes it easy to plan, capture, manage, and report on work from anywhere, helping your team be more effective and get more done. Download the HR Applicant Tracker. We set this up for candidates. That will let you keep the menu choices. Column A: This column is where you can put your own unique applicant ID code, whether an identifier from another system, a Social Security number, or an in-house identification method.

Column B: Put the position title of the job for that specific candidate in this column. Column E: This column uses a drop-down to indicate the status of the applicant—whether it be a rejected candidate or one that is currently in the interview process see options above.

You can easily sort your spreadsheet by this column to view all candidates in each stage of the hiring process. Demographics are important for HR considerations for equal opportunity employment, which not only impact the diversity of the company but can also result in tax credits. Nonetheless, this should be considered sensitive information that does not impact hiring itself. Drop-down options are available for Gender, Applicant Race, and Veteran status.

From their resume or application, you can easily fill in Columns N and O with their current employer and position. Column P: By noting where the applicant heard about the job, you can get insight into what venues get the most results and which generate the most qualified candidates.

This can help you with future recruiting planning and knowing where to post job ads. One modification would be to create a menu of items. Columns Q and R: These columns indicate the date the applicant applied and the date of their last interview with your company if applicable.

Column S—U: These columns are used to track the background check, reference check, and drug tests of each applicant. Columns V and W: Use these columns to record the date you made an offer to the candidate. Should the candidate not accept your offer, you can include the reason in Column W. Column X: Interviewers can record notes in Column X. This is for high-level notes or additional comments. Our templates may be modified to suit your business or industry needs.

Below are simple instructions for modifying our templates in Excel:. Separate items with a comma, then click OK. You can use the same process to create a menu of choices, such as for referral sources. There are numerous applications that use Excel templates for applicant tracking. We have highlighted several that may be of interest.

If you are looking for a robust free applicant tracking system that will do all the work for you, consider Freshteam. It is a free cloud-based HR system that offers a customizable career site with job postings to multiple channels. The platform will also allow you to create an in-depth candidate pool, manage with your hiring team, and track candidates through its mobile app.



0コメント

  • 1000 / 1000