Description
The correct process to import the data report generated by analytics into Excel
Problem
The decimals are not taken into consideration when importing the data
Cause
Excel settings selected while importing the data
Solution
- 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”.