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.