The correct process to import the data report generated by analytics into Excel
The decimals are not taken into consideration when importing the data
Excel settings selected while importing the data
- Launch Microsoft Excel and open a blank workbook. •
- On the Data Menu at the top of the screen, click –From Text/CSV.
- Navigate to the correct file, click on it, and choose “Import”.
- Change Data Type Detection to “Do not detect data types”. •
- Click “Load”.