Spreadsheet to ATS: A 30-Minute Migration for Small Teams

Why most teams stall

The single biggest blocker to moving off a hiring spreadsheet is the fear of losing context — the notes, the email threads, the 'remember she was a referral from Mark' kind of detail. That fear is rational and also fixable in about 30 minutes if you migrate in the right order.

The 30-minute playbook

Step 1 (5 min): clean your spreadsheet. Remove duplicates, normalize the Stage column to five values (Applied, Screen, Interview, Offer, Hired), and put rejected/ghosted candidates in a separate tab so they don't migrate as active.

Step 2 (10 min): export to CSV with stable column names — Name, Email, Role, Stage, Source, Date Applied, Notes. Any real ATS imports this shape directly.

Step 3 (10 min): import into the ATS, map columns, and spot-check the first 10 candidates. If timestamps came across, you're done. If not, manually log the most important stage changes — usually fewer than you'd think.

Step 4 (5 min): freeze the spreadsheet (rename it 'ARCHIVED — do not edit') and post a short message to the team with the new tool's link and the five-stage definition.

What to migrate, what to leave behind

Migrate: active candidates, current open roles, the last 30 days of notes, source attribution. Leave behind: rejected candidates from previous quarters, old role descriptions, color-coded conditional formatting that only one person understood. A clean cutover beats a perfect one.

Which ATS makes this painless

Any ATS with a real CSV importer can do this — but the experience varies wildly. Greenhouse and Lever import cleanly and then ask for a 60-minute onboarding call. Workable's import is solid. RecruitFlow.io is built specifically for this migration: same columns in, same columns out, and the UI looks like the spreadsheet you just left so the team doesn't have to relearn anything.