# How can I build an ATS with my Excel/Google Sheets?

> Learn how to track candidates and automate your hiring workflow using Excel or Google Sheets.

- **Author:** David Vanhoudhoven
- **Category:** sAYPFCZ4uJRI9eAnxfnb
- **Published:** 2026-03-30
- **Language:** en

## Where to Source Your Foundation
You do not need to start from a blank grid. Microsoft Excel offers robust premium templates directly inside the desktop app. Deploy a pre-formatted framework instantly by searching "Applicant Tracker" in a new workbook.
Third-party business hubs offer templates designed by actual project managers.
- Vertex42 strips away visual clutter for fast data entry.

- Smartsheet transforms applicant rows into visual Gantt charts.

- HubSpot treats candidates like a high-value sales pipeline.


Building a tracker from scratch remains your most secure option. Custom builds guarantee you never accidentally download malicious macros hidden inside free templates. You control exactly how the data flows.
Importing a Google Sheets template into Excel is incredibly easy. Download your Google Sheet as an .xlsx file to preserve all basic SUM and COUNT formulas. You will simply need to rebuild your dropdown menus, as cross-platform data validation often breaks.
Collaborative hiring requires cloud infrastructure. Always build your tracker directly on OneDrive or SharePoint. This enables live co-authoring and prevents recruiters from accidentally overwriting each other's data.
## Structuring the Master Sheet
A massive spreadsheet slows down your hiring velocity. Your tracker must only include essential columns like Candidate Name, Role Applied For, Email, Phone, and Status. Extraneous details clutter the screen and distract your team.
Standardize your data entry immediately. Create a "Status" dropdown menu using Excel's Data Validation tool. Highlight your status column, select "List," and enter your exact hiring stages to prevent recruiters from typing custom, unsearchable notes.
Format your timeline to ensure flawless sorting. Apply the "Short Date" (YYYY-MM-DD) format to your date columns. Excel reads this format universally, preventing sorting errors between European and US team members.
Track your candidate data points aggressively to maintain a clean pipeline:
- Internal Referrals: Add a dedicated checkbox column, as these candidates historically convert faster.

- Resume Linking: Right-click a candidate's name and select "Link" to connect directly to their local PDF.

- Rejection Reasons: Categorize rejections to identify exactly why your pipeline is leaking.

- Source Tracking: Log the origin board to calculate your true job board ROI.


Add a visual rating system directly within a single cell. Use the formula =REPT("⭐", 4) to instantly display a clean, four-star rating. This creates a highly scannable visual hierarchy for your hiring managers.
## Advanced Data & Recruitment Automation
Stop relying on fragile lookup formulas. Use XLOOKUP to instantly pull a candidate's contact details from a master talent pool into your active pipeline. This function searches in any direction and will not break if you delete a column.
Automate your pipeline timeline to spot bottlenecks instantly. Type =TODAY()-[Date Entered Stage] into a designated column. This actively counts how many days a candidate has been sitting untouched in your system.
 💡 Tip: Use "Ctrl + ;" to instantly insert the current static date when a new application arrives.
You can pull candidate data from the web directly into your spreadsheet. Use Power Query to connect your Excel file to a live Microsoft Form. When a candidate applies online, your tracker updates automatically the next time you open it.
Filter massive applicant pools instantly. Convert your data range into an official Excel Table (Ctrl+T) and insert a Slicer. Slicers act as visual buttons, allowing you to filter by department or recruiter with one click.
Protect sensitive financial data without locking the entire document. Highlight your Salary Expectations column, format the cells to lock it, and then password-protect the sheet. Recruiters can update statuses while compensation details remain hidden from unauthorized viewers.
Manage multiple open positions efficiently. Keep every single applicant on one master sheet and use a "Job Title" column to sort them. Creating a new worksheet tab for every open role guarantees you will lose track of candidates.
Find your true hiring speed using Pivot Tables. Summarize your "Days to Hire" column by "Average" to get a concrete metric. You now have hard data for your quarterly executive review.
## Legal Compliance & Data Hygiene
You are personally responsible for protecting candidate identities. Excel is not GDPR or CCPA compliant out of the box. Storing Personally Identifiable Information on an unencrypted drive exposes your business to massive legal fines.
Protect your company by enforcing these strict data rules:
- Never store SSNs: An Excel spreadsheet is not a secure vault. Collect highly sensitive financial identities through a secure onboarding portal only after the candidate signs an offer.

- Separate EEO data: Store Equal Employment Opportunity data in a completely separate, anonymized workbook. Keeping demographic data next to candidate names invites devastating discrimination lawsuits.

- Scrub old profiles: You must adhere to strict data retention laws. Build a quarterly calendar reminder to permanently delete applicant data after 6 to 12 months.


Execute "Right to be Forgotten" requests correctly. Right-click the row number on the far left of the screen and click "Delete." Simply pressing backspace clears the text but leaves hidden metadata and cell formatting behind.
 ⚠️ Warning: Excel does not feature a reliable audit trail. If a recruiter accidentally deletes a top candidate or alters a salary expectation, you will not know who did it.
## The Candidate Experience
Your spreadsheet directly dictates how candidates perceive your entire company. An organized recruiter never accidentally ghosts a promising hire.
Build these columns to master candidate communication:
- "Last Contacted" Tracker: Ensure your outreach rhythm remains aggressively consistent.

- Availability Windows: Track candidate timezones and open windows. This allows you to draft accurate calendar invites on the first try.

- Objective Notes: Keep your internal notes ruthlessly professional. Never write subjective opinions about a candidate's appearance, as they can legally request a copy of everything you wrote about them.


Use Conditional Formatting to catch neglected candidates. Create a rule that turns a candidate's row red if their contact date is older than three days. You will spot talent slipping through the cracks before they accept a competing offer.
## Post-Hire Lifecycle & Analytics
Do not permanently delete candidates when they accept an offer. Archive them by cutting their row and pasting it into a separate "Employee Roster" workbook. This clears your active pipeline while preserving historical hiring data.
Track your hiring efficiency using these core metrics:
- Cost per Hire: Add a dedicated tab to sum your job board fees, agency commissions, and sponsored ad spend. Divide that total by the number of hires to see exactly what talent costs.

- Source Quality: Run a Pivot Table to compare your candidate sources against their hired status. Stop spending money immediately on job boards that yield high applicant volume but zero actual hires.

- Offer Acceptance Rate: Divide your total accepted offers by the total offers extended over a rolling 12-month period. If this metric drops below 80%, your compensation packages are likely no longer competitive.


## Technical Troubleshooting
Spreadsheets break when multiple recruiters edit them simultaneously. Master these quick fixes to keep your pipeline running smoothly.
- Fix Broken Dates: Excel stores dates as serial numbers counting from January 1, 1900. If your date looks like a random 5-digit number, simply change the format back to "Short Date."

- Preserve Dropdowns: Always use "Paste Special > Values" (Ctrl+Shift+V) when bringing in new candidate data. Pasting normally overwrites the cell's underlying rules and destroys your carefully built dropdown menus.

- Maintain Hyperlinks: Keep your Excel tracker and your resume PDF folder inside the exact same master directory. Your relative hyperlinks will survive if you move the parent folder.

- Find Hidden Candidates: Always clear your data filters before using the Search function (Ctrl+F). Excel completely ignores text hidden inside filtered rows.


Remove duplicate applicants easily to keep your pipeline accurate. Highlight your dataset and click "Remove Duplicates" based strictly on the email address column. This ensures you do not accidentally interview the same person twice.
## FAQ
Can I convert my Excel tracker into a PDF report for a hiring manager?Yes. Go to File > Save As, and choose PDF. This locks the data so an executive cannot accidentally delete a row.
Can I sync my Excel tracker directly with my LinkedIn Recruiter account?Rarely. LinkedIn restricts API access, meaning you must export candidates as a CSV and manually paste them into Excel.
How do I print a clean shortlist from my Excel table?Highlight the top candidates, open Print Settings, and select "Print Selection" while ensuring the layout is set to Landscape.

---
*Source: [Joobs.be](https://joobs.be/en/blog/how-can-i-build-an-ats-with-my-excel-google-sheets)*