Skip to main content
How Can I Fix the Format in My CSV Export?
Updated over 3 months ago

Related Questions:

  • Why all the data is under one column when I download as CSV?

  • How can I get my CSV information into columns?

  • How can I get the CSV download with the right format for dates and currency?

Procedure:

Depending on your regional settings, when you export data from Event Temple as CSV all the information shows under one column separated by commas, in order to apply the right regional settings and load the information into columns you can try:

Windows

  1. Export desired information as CSV

  2. Open a new Excel worksheet

  3. Go to Data

  4. Get Data From Text/CSV

  5. Select the file that you have downloaded

  6. Click Import

  7. Click Load

  8. Information should now be loaded in the right format and into different columns.

Mac

  1. Export desired information as CSV

  2. Open a new Excel worksheet

  3. Click File

  4. Click Import

  5. Choose CSV and click Import

  6. Choose the Delimited data type

  7. Choose Unicode (UTF-8) as the file origin

  8. Leave the default value for where you want to put the data

  9. Click Ok

Did this answer your question?