CSV upload issues

Some common errors with CSV's

Matt Barnett 🏄🏽 avatar
Written by Matt Barnett 🏄🏽
Updated over a week ago

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. If you are using Numbers to create your CSV

After you edit your CSV file in Numbers, export your file to CSV format. Make sure that "Include table names" are unchecked.

Which should make your CSV look like this:

8. 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?