[Analytics] How do I convert an exported CSV file into an Excel file?

1. Export data as a CSV file: Click on the header of the data you want to export to bring up the a menu, as shown below;. For example, to export the Survey Completion Summary data, click on this header, which will bring up the menu indicated in red.

1.png

 

2. Click

2.jpg

Click on [Export CSV] to export the data as a CSV file.
 
3. Open the CSV file with Excel.
 
4.Select the first column, then in the Data tab, click the [Text to Columns] button.
 
5. Click [Next], then select Semicolon as the delimiter. Click [Next] again.
 
6. Once this is complete, your data will appear as a normal Excel format, and you can save as an Excel file.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Please sign in to leave a comment.