Export data may appear strange when using older versions of Microsoft® Excel and look something like this ...
To get the data to display correctly, the CSV file needs to be converted.
There are a few options available:
You can use this free service to upload your CSV file and convert it to excel format. Note: this site might not be secure. Use at your own risk. convertcsv.com
If you have access to google sheets, upload to Google Docs and export in excel version.
Follow the procedure below for the appropriate Excel version.
If you are still running into difficulty, reach out to us via support.
Microsoft® Excel (pre-2003 versions)
Open the file in Microsoft® Excel and select File -> Save As, and save the file as type Web Page.
Select Tools -> Options -> General tab and click the Web Options button.
Select the Encoding tab and then choose the "Unicode (UTF-8)" option.
Click OK to close the dialog boxes.
Select File -> Save to save the file with selected encoding. These steps will need to be repeated for each file.
Microsoft® Excel 2003
Open Microsoft® Excel and click File -> New.
Click Data -> Import External Data -> Import Data.
Select the csv file to open and Microsoft® Excel will launch the text import wizard.
Select "Delimited" and choose the "Unicode (UTF-8)" option for File origin.
Click Next.
Select "Comma" in the Delimiters section and click Finish. You may be prompted to select a range of cells. These steps will need to be repeated for each file.
