• 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"


 cid:image001.png@01D6B757.C58DCA50

  

  • Select the file and click on "Import"


cid:image022.png@01D6B758.3C15B930

 

  • Chose option "Separated" and "Character Set 65001: Unicode (UTF-8)"


cid:image023.png@01D6B758.3C15B930

 

  • Chose separator "Comma"
  • Click on "Next"

 

cid:image024.png@01D6B758.3C15B930

 

  • Choose "Further" option for number formats

 

cid:image025.png@01D6B758.8CC90E40

 

  • Chose decimal separator ‘.’ and thousand separator ‘,’


cid:image026.png@01D6B759.44746760

 

  • 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