Skip to content

Testing an import with a small batch first

Last checked November 14, 2026

Load a few records before you load all of them. A bad mapping or a wrong date format is easier to fix on a handful of rows than on thousands.

Build the test file

Copy the header line and a small set of rows into a new file. Keep the original safe. A few dozen rows is plenty for most files; choose them to cover the awkward cases, not just the easy ones.

Include rows that have:

  • A comma, quote or line break inside a value.
  • Accents or other non-English letters.
  • A blank in an optional field.
  • A date, a phone number and an amount.
  • The longest name or address in the file.
  • A value from each fixed-choice field, such as status or category.

If the old file has different record types or categories, include at least one of each. See cleaning a CSV for what to look for.

Use a safe place to test

Ask whether the new system has a sandbox, a trial account or a test mode. If it does, import there. If it doesn't, you're testing in your real account, so plan to remove the test records. Check how deleting works before you start, and whether it can be undone.

Some imports do more than add records. They can send emails, assign owners or change existing data. One CRM's guide notes that users assigned as owners via import will not receive a notification.1 Another tool has a box to update existing contacts, and it's something you choose on purpose.2 Its help says this option replaces existing audience field information with new information from your import file.2 Read each option on the import screen. Leave anything you don't understand switched off.

Run the import

  1. Upload only the test file.
  2. Map the columns, using the table you built in field mapping.
  3. Review the settings screen. One tool's steps include clicking Finalize import to review your import settings.2
  4. Read the summary before you confirm. The same steps say to review the import summary, then complete the import.2
  5. Run it.

Write down the settings you used. You'll want to repeat them exactly for the full file.

Check the result

Open several of the new records and compare them with the old system, field by field.

  • Is every field filled where you expected it?
  • Are dates the right way round?
  • Do phone numbers and amounts match?
  • Do accents and symbols look right?
  • Did the record count match the rows you sent?

Also look at any error report the tool gives. Some systems skip a row when it breaks a rule. One guide says that if validation rules are set, imported values must follow the rules or they will not be imported.1 So a missing record can point to a rule, not a lost file.

Blank cells deserve a look too. One tool ignores blank cells in a spreadsheet.1 If you were trying to clear old values on existing records, they may still be there. Another tool's help says blank fields overwrite and erase existing email contact data when you update.2 Check how your own tool treats blanks before you update existing records.

A small-batch testCopy a few rows into a test fileImport only that fileCompare records with the old systemFix the file or the mappingLoad the full file
Load a few records, inspect them, then decide.

Fix and repeat

When something is wrong, find the cause before you change anything. Use this order:

  1. Wrong column? Fix the mapping.
  2. Wrong format? Fix the values. See the page on fixing formats.
  3. Strange symbols? Check the encoding.
  4. Rows missing? Check required fields and rules.

Delete the test records, correct the file, and run the same test again. Repeat until it comes through clean. Don't fix the problem in the full file only. Apply the same change to your master copy.

Then load the rest

Once the test looks right, import the full file with the same settings. Afterward, compare the record count and spot-check a spread of records, early, middle and late.

Don't close the old system until that check is done. The export checklist explains what to save before access ends.

Notes and sources

  1. Format import files, HubSpot Knowledge Base
  2. Import Contacts to Mailchimp, Mailchimp Help Center