How to fix errors & bulk delete during import

Modified on Wed, 13 Mar 2024 at 01:50 PM

Sometimes you may encounter errors during the import process. In this article, we will show you how to fix errors and bulk delete.

Before you get started

  • Make sure you have a CSV file already uploaded to start the import process.

How to bulk delete errors

  1. Click the error icon at the top so only the error rows are showing
  2. Select the top one so there is a blue ring around it
  3. Scroll to the number row and whilst pressing shift-click again
  4. This is now bulk-selected so when you press delete or backspace they will all be deleted

Possible errors you may encounter

Invalid mobile numbers

When importing Mobile numbers, you must ensure all include a country code and are valid phone numbers, otherwise, the contacts with invalid mobile numbers won't be included in the import.

  • Export the errors as CSV



  • Import the clean CSV file

  • Then, import the tidied CSV file 

Missing State and/or country

  • When importing 'State', the correct 'Country' data must be included in the CSV file too otherwise the data won't be recognized - refer to import data formatting requirements HERE

Date format

Date format is not your preferred format, it is the format of your file's data (International or US format)

Blank rows in the Email address column

  • Ensure you have deleted all blank rows in the Email address column before importing, otherwise, the import will not work

Using the Find & Replace tool

If you need to make changes to a large number of cells, you can use the Find & Replace tool. This tool allows you to search for specific text (or a blank row) and replace it with something else.

"Error" when Importing

  • Ensure your Custom Fields do not include fields that already exist in the import fields, such as State, Country, City, and Mobile number, as this will cause an error when importing


Error caused by this Custom Field, "state"

Related articles

Importing contacts to a List

Importing ticket sales & events

Importing contacts to Audience Manager

Still need help?

Contact us at 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article