- Go to the session you would like to have downloaded in excel
- Click on "Actions" --> "Download"
CSV format
- Select CSV format
- Click on "Download"
If the PC Regional setting is equal to the chosen language in ARP, the downloaded file will be opened in a proper excel format (with columns). In case the setting differs, please follow the steps below:
Option 1 (CSV format)
- Open Excel
- Chose tab "Data"/option "From text"
- Select the file and click on "Import"
- Chose option "Separated" and "Character Set 65001: Unicode (UTF-8)"
- Chose separator "Comma"
- Click on "Next"
- Choose "Further" option for number formats
- Chose decimal separator ‘.’ and thousand separator ‘,’
- Confirm the other steps
- Save the result as an Excel file
Option 2 (CSV format)
- Open the downloaded file
- Click on "Data"
- Select the first column
- Click on "Tex to Columns"
- Select "Delimited"
- Click on "Next"
- Select "Comma"
- Click on "Finish"
- You will be able to see the downloaded excel file in a proper excel format (with columns)
HTML Format
- Select HTML format
- Click on "Download"
- Do not open the downloaded file
- Open a new and empty Excel file
- Click on "File" --> "Open" to open the downloaded html file
- Save it as an Excel file