Why does data in a UnicodeCSV or UnicodeCSVLabelled export open in Excel in one column?

Export data viewed in UnicodeCSV, UnicodeCSVLabelled, or UnicodeCSVEnhanced file format will appear in Excel within a single column. You are able to delimit, or distinguish data separation, for each data point by selecting the Delimiter from the drop-down menu on the Exports page. You can further delimit your data in Excel by separating the data in the single cell into multiple rows or columns using the Text to Columns feature.

Detailed Steps

In Excel separate the data into multiple columns

1. Select the first column in the file containing all the data.
2. Select the Data tab.
3. Click Text to Columns.
4. In Step 1 of the Convert Text to Columns Wizard, select the Delimited option, and click Next.
5. In Step 2 of the Convert Text to Columns Wizard, select the Delimiter you selected when you exported your data, and click Next. 

Note: All of the check boxes under Delimiters should be cleared except for the Delimiter used for this file.

6. In Step 3 of the Convert Text to Columns Wizard, select General in the Column data format, and click Finish.
7. Save this file on your computer as an Excel workbook to keep the changes and formatting you applied.

More Information

Please click on the following links for more information about exporting data and converting text to columns:

• Exporting data
• Split names by using the Convert Text to Columns Wizard