Commas can cause problems

Created by Eva Smith, Modified on Tue, 29 Nov, 2022 at 5:31 PM by Ivy Thompson

You may have noticed the site works with CSV files for uploading and downloading data. CSV files are 'Comma delimited files', which means they take commas and separate data wherever they find one. This can be a great way to create really comprehensive data files without a huge file size. 


It's noted If you add commas yourself when that data is ready the site will identify comma's as an instruction to start a new column. 

You may find that you've added a comma to a campaign title, the columns in your CSV have moved along one row from the titles they were meant to sit under.


Without commas


With Commas


When looking at things in the database, you may find this has moved data into the wrong columns.


To be on the safe side, we suggest you use a "-" instead of a "," just to make sure your data all stays where it should! 


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 at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article