How to Download and Open CSV Stats in Excel

  • Updated
Follow

Export CSV Stats in

Whenever an end-user runs through a published module, a session is created and will be logged in the Module stats. These stats can be exported as CSV (Plain) or CSV (Excel) for each environment (Test | Live).

Overview_data.png

BRYTER automatically creates CSV files in UTF-8. Microsoft Excel often incorrectly interprets this format and defaults to a different encoding. This happens when you open a CSV file the same way you would open an Excel file. To correctly open CSV files in Excel, perform the following steps:

  1.     Open a blank Excel workbook.
  2.     In the Data tab, click Get Data > From File > From Text/CSV.
  3.     Select the file to open and click Import.
  4.     In the File origin area, select 65001: Unicode (UTF-8) and Semicolon in the Delimiters area.
  5.     Click Load.

02_Text_Import_Wizard_-_Step_1.png

Evaluating Stats data with Microsoft Excel

The Excel format allows rich formatting, calculations, and output in pivot tables and in a chart.

To use your own Excel template, export the CSV file and add it to a worksheet in Excel. Use this worksheet to reference data you want to display in other tables or charts (for example, pivot tables) in another worksheet of the Excel template.

Related articles