Spreadsheet to ATS: When a Nigerian Company Actually Outgrows Google Sheets Hiring

A spreadsheet is a legitimate way to run hiring. Plenty of Nigerian companies with twenty or thirty staff hire perfectly well from a shared sheet, an email folder, and a WhatsApp group. If that describes you and it is working, you do not have a problem to solve.

This post is about how to tell when it stops working, because the transition is usually noticed late. The spreadsheet does not fail dramatically. It degrades, and the cost shows up somewhere other than hiring.

Seven signs the spreadsheet has stopped working

1. You cannot answer "where is that candidate?" in under a minute. Someone asks about an applicant from three weeks ago. Finding the answer means opening the sheet, checking a colleague's inbox, and asking in the group chat.

2. Candidates are going silent and you find out late. Good applicants take other offers while your process is between steps. If you cannot see, at a glance, who has been waiting longest, you are losing people to delay rather than to competitors.

3. You are re-advertising roles you have already hired for. A candidate you rejected for a mid-level role six months ago is a strong fit for the one you are opening now. In a spreadsheet, that person is functionally gone. This is the most expensive form of the problem and the least visible.

4. Two people have opened the same CV. Duplicated review time is the clearest sign that the process has no single source of truth.

5. Interview feedback lives in individual heads. The panel meets, discusses, and decides. Nothing is written except a name. Three months later nobody can reconstruct why.

6. You have no idea where candidates come from. Which job board, which referral source, which social post. Without this you cannot decide where to spend recruitment budget, so you spend it evenly, which is the same as spending it badly.

7. A departure takes hiring history with it. When the person who ran recruitment leaves, the institutional memory of your candidate pool leaves too.

Two or three of these is normal friction. Five or more is a system problem.

What an ATS actually changes

It is worth being precise, because the category is oversold.

What it genuinely gives you:

• One record per candidate, visible to everyone who should see it, with the full history attached
• A searchable pool of everyone who has ever applied, so a role you open next year starts with candidates rather than with an advert
• Stage tracking, so nobody sits waiting because a handover was missed
• Structured interview feedback captured at the time rather than reconstructed later
• Source data, so you learn which channels produce hires and which produce volume
• Basic compliance hygiene: retention periods, deletion on request, an audit trail

What it does not give you:

• Better candidates. Your sourcing determines that.
• Better decisions. Your interview design determines that.
• A faster process on its own. It removes the delays caused by coordination, not the delays caused by a hiring manager who takes nine days to give feedback.

An ATS makes a good process faster and a bad process visibly bad. The second effect is usually more valuable in the first six months.

What this costs you if you delay

The concrete cost is re-sourcing. A Nigerian mid-level role typically draws a large applicant pool, of which perhaps ten people are genuinely strong and perhaps two get hired. The other eight are the asset. Losing them means you pay the full sourcing cost again the next time.

The second cost is candidate experience. A candidate who never hears back from you tells their network. In tightly connected professional communities in Lagos, Abuja, and Ibadan, this compounds. Companies acquire reputations for going silent and it shows up later as a weaker applicant pool.

Migrating without losing what you have

Do not import everything. The instinct is to move three years of history across. Most of it is stale. Import the last twelve months and the specific candidates you would genuinely consider again.

Clean before you move, not after. Deduplicate names, standardise role titles, and drop rows where the only data is a name and a phone number. Migration is the one moment when cleaning is cheap.

Get consent and retention right at the point of import. You are moving personal data. Under the Nigeria Data Protection Act 2023, and with the NDPC's General Application and Implementation Directive in force since March 2025, you need a lawful basis for holding candidate data and a defined retention period. Decide the period before you migrate: twelve or twenty-four months from last contact is common. Set it in the system rather than in someone's memory.

Run one live role in parallel. Keep the spreadsheet for one more hire while the first role runs through the new system. This catches configuration problems while you still have a fallback.

Assign one owner. Not a committee. One person responsible for the pipeline being accurate. Without this, the ATS becomes a second place where information is incomplete.

A realistic timeline

For a company of twenty to eighty staff:

• Week 1: decide your stages and your must-have fields. Do not customise beyond that.
• Week 2: clean and import.
• Weeks 3 to 6: run one role in parallel.
• Week 7: retire the spreadsheet.

Companies that spend two months configuring before running a single role usually never finish. Configure lightly, run a real role, adjust from what actually broke.

If you decide not to move yet

That can be the right call. If it is, do three things in the spreadsheet:

1. Add a source column and fill it in.
2. Add a "would reconsider" column and mark the strong rejections.
3. Set a calendar reminder to delete applicant data older than your chosen retention period.

Those three habits are the ones that will still be paying off when you do migrate.

Related reading

• 88% of companies now screen with AI. What it means for Nigerian employers
• Time-to-hire benchmarks for Nigerian roles
• Best HR and payroll software in Nigeria, 2026

CTA: BetternshipHR is an ATS and HR platform built for Nigerian employers, including payroll and statutory compliance in the same system. See a demo.

FAQ

How many employees before a company needs an ATS? Headcount is the wrong measure. Hiring volume is the right one. If you run more than three open roles at a time, or a single role regularly draws over a hundred applications, coordination costs start exceeding software costs.

Can we keep using WhatsApp for candidate communication? Yes, and most Nigerian employers will. The issue is not the channel, it is that the conversation is not attached to the candidate record. Choose a system that lets you log or integrate it.

How long can we keep candidate data in Nigeria? The NDPA does not fix a single number. Retain for as long as you have a lawful basis and a stated purpose, and define the period yourself. Twelve to twenty-four months from last contact is a common and defensible choice, provided you disclose it and honour deletion requests.