How to remove invalid values in a column

• Click on the invalid column that's highlighted in red
• Select 'more actions' 
• Click 'delete all invalid values'
• All of the invalid values in that specific column will 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

OR:

• Import the clean CSV file

• After, tidy the invalid mobile numbers (in the Exported file) - HERE on how to reformat mobile numbers

• 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

Still need help?

Contact us at [email protected]