Managing candidates in Excel: a practical guide and free template
Excel is where most recruiters start, and set up properly it can last a long time. Here is how to structure it, which mistakes to avoid and a ready-made template to download.
Download the free template
A ready-to-use Excel file: candidates, interviews, drop-down menus, callbacks that turn red when overdue and a dashboard that updates by itself. No sign-up required.
What a candidate spreadsheet should contain
The main rule: one row per candidate, one column per piece of information. No merged cells, and no colors used as data. These are the columns you actually need:
| Column | Why it matters |
|---|---|
| First name, last name, email, phone, city | The minimum you need to get back in touch |
| Target role | To filter who fits a given opening |
| Source | To see where your best candidates come from (LinkedIn, job boards, referrals) |
| Stage | New, contacted, interview, offer, hired, rejected |
| Last contact and next callback | Where most candidates are lost: if nobody calls them back in time, they disappear |
| Privacy consent | Under GDPR you must be able to show you have permission to store the data |
| Notes | What you discussed, salary expectations, notice period, preferences |
Tricks that make Excel far more useful
1. Drop-down menus instead of free text
If you type "Interview", "interview" and "Intvw" by hand you end up with three different stages and wrong counts. Use Data → Data Validation → List to pick values from a menu.
2. Highlight overdue callbacks
With conditional formatting you can turn the next-callback cell red once the date has passed. The formula is =AND(N2<>"",N2<TODAY()).
3. Count candidates per stage with COUNTIF
=COUNTIF(J:J,"Interview") tells you how many candidates are at that stage. Put the stages in a separate table and you get a small dashboard that updates itself.
4. Use filters
Turn on filters on the header row (Data → Filter) to find "developers in London, not contacted for a month" in two clicks.
5. Keep backups
A single file is a single point of failure. Also save it on a second drive or in the cloud, with the date in the file name.
The most common mistakes
- Several different files (one per client, one per month): after a few weeks you no longer know where to look.
- Colors instead of columns: a yellow "to call back" can't be filtered or counted.
- No callback date: promising candidates go cold without you noticing.
- Resumes in scattered folders: the spreadsheet doesn't know where they are. Use a fixed naming convention such as
LastName_FirstName_Role.pdf. - Unprotected personal data: a sheet with names and phone numbers should live on a password-protected PC and not be emailed around casually.
When Excel stops being enough
Excel works well while you have a few dozen candidates. Problems begin when:
- you have hundreds of records and searching gets slow;
- you forget to call people back because nothing reminds you;
- you need to attach and find each person's resume;
- you type the same interview invitation again and again;
- you want to know how many hires you closed and which source they came from.
At that point a dedicated tool makes sense. A subscription ATS/CRM is one route; a Windows program that works offline, keeps data on your own PC and is paid once, is another.
Try it free for 14 days
Recruiter CRM is the software I built for my own day-to-day recruiting work: candidates, pipeline, resumes with detected skills, callbacks with notifications and message templates. Offline, €79 one-time, no subscription.
Frequently asked questions
Is Excel good enough to manage candidates?
Yes, if you have a few dozen candidates and a well-structured sheet (one row per candidate, drop-downs, callback dates). With higher volumes or several clients it becomes hard to maintain.
Is the template really free?
Yes. You can download, edit and use it without signing up and without leaving your email.
Can I use the template with Google Sheets or LibreOffice?
Yes, it also opens in Google Sheets and LibreOffice. Some formatting may look slightly different.
How do I handle GDPR in an Excel sheet?
The template includes a privacy consent column. Beyond that: store the file somewhere protected, limit access and delete data when it is no longer needed. For specific questions, consult a professional.