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