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).
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:
- Open a blank Excel workbook.
- In the Data tab, click Get Data > From File > From Text/CSV.
- Select the file to open and click Import.
- In the File origin area, select 65001: Unicode (UTF-8) and Semicolon in the Delimiters area.
- Click Load.
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.