Choosing hiring software · 5 min read
Moving hiring off spreadsheets
Spreadsheets are a reasonable way to start tracking applicants, but they break down as more roles and more people get involved. This guide covers when to switch, what to move and how to get everyone on board.
Signs your spreadsheet has stopped working
A spreadsheet is free, flexible and familiar. For a handful of roles managed by one person, it can work well. Problems start when more roles, more applicants and more people are involved at the same time.
- Several versions of the tracker exist, and nobody is sure which one is current.
- CVs live in email inboxes and shared folders, separate from the tracker.
- Hiring managers keep asking for updates because they cannot see where applicants are.
- Interview feedback arrives by chat or email and never makes it into the sheet.
- Applicants wait weeks for a reply, or never hear back at all.
- You cannot answer simple questions, such as how long the last few hires took or which job boards worked.
- Applicant data is copied into personal files, and you cannot say who has seen it or when it should be deleted.
If two or three of these sound familiar, the spreadsheet is costing you time and applicants. The last point also creates risk, because the employment and data protection rules where you hire may limit how long you keep applicant data and who can access it.
Prepare before you switch
Moving to an applicant tracking system is a good moment to fix the process, not just the tool. Spend an hour on these steps before you choose or set up anything.
- Write down your hiring stages as they really are, for example: applied, screened, first interview, second interview, offer, hired, rejected. Our guide to designing a hiring pipeline can help.
- List the columns in your current spreadsheet and mark the ones you actually use. Many trackers collect fields nobody reads.
- Note who needs access and what each person should see. Recruiters, hiring managers and interviewers usually need different views.
- Collect the emails you send most often, such as interview invites and rejections, so they can become templates.
- Agree on one owner for the move, so decisions do not stall.
If you have not picked a system yet, use these notes as your requirements. Our guide on how to choose an applicant tracking system explains how to compare options and test them with a real role.
Decide what to bring across
You do not need to move everything. Old, messy data clutters a new system from the first day. Split your records into three groups:
- Open roles and active applicants: move these. They are your work in progress.
- Recent strong applicants you may contact again: move these, with their consent status, if your privacy notice allows it. They can become the start of a talent pool.
- Old and closed roles: archive the spreadsheet in a secure place with limited access, and delete the records once your retention period ends.
Before importing, clean the data you are keeping. Remove duplicates, fix email addresses, use one format for dates and make stage names match the stages in your new pipeline. A clean import of a few hundred records is worth more than a messy import of thousands.
Pay special attention to notes and feedback stored in comment cells or side columns. Decide whether each note still matters. Useful notes on active applicants should move with them. Personal opinions or remarks that would not stand up to an applicant asking to see their data should be left behind.
Make the move, step by step
- Set up the system first: stages, user roles, email templates and any interview scorecards.
- Create your open roles, with clear requirements for each one.
- Import active applicants and their CVs, then check a sample of records by hand.
- Switch your apply links and careers page to the new system, so new applicants land there directly.
- Run one or two pilot roles fully in the new system before moving everything else.
- Set a cut-off date after which the old spreadsheet becomes read-only.
- A few weeks later, archive the spreadsheet and remove shared access to it.
The cut-off date matters most. If the old sheet stays editable, people will keep using it, and you will end up with two sources of truth instead of one.
Tell applicants who are already in your process as little as they need to know. Most will not notice the change. If your messages will now come from a different email address, or your privacy notice changes, let active applicants know in a short, plain message so nobody misses an interview invite. Spark Careers Enterprise supports bulk CV upload and an apply link you can share or embed on your careers page. Each applicant then moves across a pipeline board, with notes and team feedback kept in one place.
Get the team to use it
A new system only helps if people use it. The biggest risk is hiring managers drifting back to email because it feels quicker.
- Show each person only the tasks they need. A hiring manager may only need to review a shortlist and leave feedback.
- Train with real roles, not a demo account, in sessions of half an hour or less.
- Stop accepting feedback by chat or email. Ask for it in the system, every time.
- Send applicant updates from the system, so replies are consistent and on time.
- Check in after two weeks and fix whatever people are working around.
Clear expectations help. Agree with each hiring manager how quickly they will review applicants and give feedback after interviews. Our guide to working with hiring managers covers how to set this up and keep it going.
Checklist
Use this list to track the move from start to finish. Tick each item only when it is fully done, not when it is in progress.
- Hiring stages written down and agreed.
- Spreadsheet columns reviewed and trimmed.
- Access needs listed by role.
- Data cleaned, with duplicates removed.
- Only active and recent records imported.
- Apply links and careers page switched over.
- Pilot roles completed in the new system.
- Old spreadsheet made read-only, then archived with access removed.
- Retention period set for applicant data.
Your next hire, start to finish, in one place.
Free workspace. No card. Full scoring free for 7 days.