I am not able to open xls containing Analytics report.
1. Download the Report from Analytics Page by clicking on Download Report, it will be downloaded in zip format
2. Browse to the directory where you downloaded the zip file and do right click and extract it any compression tool(Winzip or WinRAR)
3. After you extract it then open the xls file with Excel
4. When you open it in Excel you will see below warning, click on Yes to open the xls anyways.
5. Once you click on Yes you will see the contents as shown below