Opening CAIC CSV Exports in Excel

CSV files exported from the Conversational AI Cloud CMS use UTF-8 encoding and a pipe (|) delimiter. Excel, by default but depending on regional settings, will usually assume a comma or a semicolon as a delimiter and a Windows-specific encoding. When opening a CSV file by double-clicking it immediately after download, these are the likely parameters that Excel will use to open a CSV file exported from Conversational AI Cloud, too.

The easiest way to ensure your CSV file is properly opened in Excel is to import the data into Excel via the 'Data’ tab instead of opening the file directly:

Excel will then let you select the file to import data from, and afterward show you a file import screen where you can select an encoding and a delimiter – but it is likely to have guessed correctly already.

From here you can choose to further Transform the data or just Load the data. It will then be in a table in the Excel sheet

Please note that if a file opened this way is saved as a CSV again, the delimiter may have changed. For imports of Entities the Conversational AI Cloud still expects a pipe-delimited file.

Related Article: Interaction Logs from the Analytics API