Open Agent Connect CSV files

Overcome formatting challenges from regional settings.

In certain regions, files downloaded from Medallia Agent Connect in CSV format may not open correctly (Europe or South America, for example), and the data will be displayed incorrectly. This is due to regional system settings that have different default delimiters. For example, files will be read with a comma or semicolon delimiter.

In this guide, we present two ways to handle the issue of unexpected formatting when opening CSV files.

Change the default delimiter in your OS

Follow the steps below to change the default delimiter in your OS:

Windows

  1. Open the Windows Control Panel.

  2. Open the Regional and Language Options dialog box.

  3. Click the Regional Options tab.

  4. Click Customize/Additional settings (Windows 10).

  5. Type a comma (,) into the List Separator field.

  6. Click Ok twice to confirm the change.

Note: This only works if the Decimal Symbol is not also a comma. If you do not want to change this setting, there is an alternative method for opening comma delimited files below.

OS X

  1. Open System Settings.

  2. Open the Language & Region pane and go to the Advanced option.

  3. Change the Decimal Separator:

    • 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

If you do not want to change the default list separator or decimal symbols, then the following method can serve as an alternative:

  1. Create a new spreadsheet in Excel.

  2. Open the Data tab and select "From Text".

  3. Select your CSV file.

  4. Choose the "Delimited" option and click Next.

  5. Select the delimiter that displays the metadata correctly in the Preview pane below.

  6. Make your changes to the file and save it in TXT (tab delimited) format so that the file is delimited by tabs instead of a variable character.