All information in tables in each Analytics module can be downloaded as a CSV file. Sometimes when opening these files information can be difficult to read, since columns are separated by commas or semicolons, and rows are separated by line breaks.
To organize your data easily, follow these steps:
Select column A of the document.
Click on the Data tab.
Select the option “Text to columns”.
A dialog box will open. Select the option “Delimited” and click “Next”.
In the menu “Delimiter” check the options “Tab” and “Comma”.
Click “Finish” and you’ll be all set! Your data is now organized.
Here are two videos so you can follow the step by step