Choose the migration scope
Identify records the team still needs and decide what historical information stays in an archive. Preserve backups instead of deleting old working copies indiscriminately. Map the operational fields and decide which long notes need a readable summary. A focused first migration is easier to review than an unexplained dump of every old list.
Define the cutover
Agree when new enquiries start going into the workspace. Otherwise one teammate may update the spreadsheet while another uses the application. If you allow an overlap, specify which system is authoritative and who reconciles changes. The rule should be simple enough that everyone can explain where a new record belongs.
Pilot representative records
Include a new enquiry, an active conversation, an international number, and missing optional values. Ask the actual users to inspect the result. Confirm they can find the information and understand the next step before importing the remaining batch. A technically successful upload can still produce records that are difficult to use.
Review the working process
Check new enquiries and handoffs during the first few days. Use Happitap’s Getting started checklist to orient teammates, then review whether notes and dates are maintained. The move succeeds when people can continue conversations confidently, not merely when all the rows have appeared in a new interface.
Continue reading
Guide / Lead data
How to prepare a lead spreadsheet for CSV import
A practical guide to cleaning names, email addresses, and phone numbers before importing a lead spreadsheet.
Read the guide →Guide / Lead data
The minimum useful lead record for a small team
Start with enough information to act, then add detail when it becomes useful.
Read the guide →Guide / Lead data
How to review duplicate leads before an import
Use repeatable matching rules and review uncertain matches before combining records.
Read the guide → Browse all guides →