CRM
Prepare a contact CSV before importing
A few checks on a copy can prevent an import from turning into a lengthy cleanup.
Work on a copy
Keep the original file and prepare a version for importing. Check headers, empty columns, and phone formats. Keep identifiers and numbers as text when they contain leading zeros. Exclude personal comments unrelated to professional follow-up.
Test a varied set of rows
Choose a complete contact, an accented name, and a row with a missing field. In Papaye, review this small import before sending the full file. Compare processed rows with actual created items. A success message does not remove the need to review the resulting records.
Anticipate duplicates
Before trying again, check what has already been imported. Re-running the full file without reviewing earlier results can create more cleanup work. Record the imported batch and the review date.
Checklist
- Keep the original file
- Test a small batch
- Review created records