Depending on your Excel's regional setting, your default delimiter/separator may either be using semicolons (;) or commas (,) to separate items in a CSV file. This can either cause file upload issues or cluster all the field values into column A because exported files from Affinity use commas (,) as the default delimiter/separator.

Here are some ways to open files without changing the system settings:

• Using Data To Text to open files
• Other tips and tricks

Using "Data - From Text" to open files

Mac/Windows

1. Open a new Excel sheet.
   
   
   
2. Click the Data tab, then From Text.
   
   
   
3. Select the CSV file that has the data clustered into one column.
4. Select Delimited, then make sure the File Origin is Unicode UTF-8.
   
   
   
5. Select Comma (this is Affinity's default list separator). The preview will show the columns being separated.
6. Finally, click Finish.
   
   
   
7. Remember to Save your document!

Other tips and tricks

Adding "sep=;" or "sep=," to the CSV

When you have a CSV that is separated by semicolons (;) and your system/Excel default is commas (,), you can add a single line to tell Excel what delimiter to use when opening the file. To do this:

1. Open your CSV using a text editor.
   1. Windows: NotePad (notepad.exe)
   2. Mac: TextEdit (textedit.app)
2. Skip a line at the top, and add sep=; if the separator used in the CSV is a semicolon (;), or sep=, if the separator is a comma (,). 
3. Save, and re-open the file.

Note: This newly added line will not show up when opening the file in Excel. Once you've opened up the Excel file (and the formatting looks good), you can re-save the file (if your default separator is a comma) so the "sep=" line is no longer present, which will allow for imports.