1. Gather every list in one place
Collect the spreadsheets, the exhibition scans, the WhatsApp contacts someone keeps in a notes app, and the export from your previous system. Put them in one folder and note which is authoritative where they disagree.
2. Standardise the columns
Give every file the same headings for the same meaning. Phone numbers in one format, dates in one format, one value per cell. Most of the effort sits here, whichever CRM you choose.
3. Map columns to fields
Match each column to a CRM field and add custom fields only for what your business genuinely uses. Unused fields make the record harder to read for the rep working it.
4. Set the duplicate rule and the owner
Choose the match key, decide whether matches skip, update or wait for review, and set who owns the incoming records. An import that lands unassigned is an import nobody follows up.
5. Run a test batch, then the full file
Import twenty rows. Open three of them and read them as a rep would. Fix what looks wrong, then run the rest. Keep the import log so you can rerun the rejected rows once they are corrected.
Download failed rows, fix, re-upload
Real files are messy: a phone number with a letter in it, a date in the wrong format, a required column left blank. When some rows in an import do not make it in, HelloGrowthCRM does not leave you guessing which ones. The import summary offers Download failed rows, with the number of rows that failed.
The download contains only the rows that did not import. Fix them in your spreadsheet and upload the file again — the columns are already mapped, so there is no need to redo the mapping step. The rows that succeeded the first time are left exactly as they were.