CSV's are actually imported as a string or list of data, and there are a few things that can cause the data to mess up. If you are experiencing problems uploading a CSV try these checks:

1. Spaces after text

This solves 90% of CSV issues. Sometimes when you copy and paste in an email / name, you copy in a "Space" before or after the text.  You can tell as when you click on a cell it shows a space between the last character and the cursor:

CSV's read this as an error especially if exporting from Excel (thanks Microsoft).

 

2. Spaces in text

As above, look for any emails that may have a space in the text such as:
test @bonjoro.com instead of [email protected]

3. Odd characters

Some of these get through, some don't - worth removing if steps 1 & 2 don't seem to work.  Characters that can cause isses are:

  • ' as in Mc'Farlene
  • Punctuation as in , " > $ }

4. Make sure is CSV

Some programs have different exports - make sure you select:

Not any of these other formats

5. Make sure your email addresses are email addresses

Sometimes typos can be carried through into your csv. So for example an email address might end in: @gmail.con instead of @gmail.com. This will be registered by the system and prevent successful upload

6. Make sure you haven't changed the column titles 

The titles need to read exactly as they appear in the csv template you downloaded from the site for our system to correctly upload and interpret the data.

7. Send us your CSV

If you've done these and still an issue, send us through the CSV and we'll check it out for you:)

Did this answer your question?