Opening Agent Connect CSV files
Files downloaded from Medallia Agent Connect in the format .CSV are comma delimited.
In certain regions, the files may not open correctly (Europe or South America, for example), and the data within will be displayed incorrectly.
This is due to regional System settings that have a different default delimiter setting. For example, files will be read with a comma delimiter or semicolon delimiter.
Below are ways for both Windows and OS X to change the default delimiter:
Open the Windows Start Menu and click Control Panel
Open the Regional and Language Options dialog box
Click the Regional Options tab
Click Customize/Additional settings (Windows 10)
Type a comma into the 'List separator' box (,)
Click 'OK' twice to confirm the change
OS X
Go to System Preferences
Open the Language & Region pane and go to the Advanced option
Change the 'Decimal Separator' to one of the below scenarios
For MacOS, if the Decimal Separator is a period (.) then the CSV separator will be a comma. If the Decimal Separator is a comma (,) then the CSV separator will be a semicolon.
Alternative method to open CSV files
If you do not want to change the default list separator or decimal symbols, then the below method will be an alternative for the meantime:
Open a new empty spreadsheet in Excel
Go to the Data tab and select 'From Text'
Select the file you want to open
Choose the 'Delimited' option and click Next
Select the correct delimiter which will display the metadata correctly in the Preview pane below
Make your changes to the file and save as .TXT (tab delimited) so that the file is delimited by tabs instead of a variable character.