Help Center

How do I open a CSV file in a spreadsheet?

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:

  1. Select column A of the document.

  2. Click on the Data tab.

  3. Select the option “Text to columns”.

  4. A dialog box will open. Select the option “Delimited” and click “Next”.

  5. In the menu “Delimiter” check the options “Tab” and “Comma”.

  6. 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 👇 

This website stores cookies on your computer. These cookies are used to collect information about how you interact with our website and allow us to remember you. We use this information in order to improve and customize your browsing experience and for analytics and metrics about our visitors both on this website and other media. To find out more about the cookies we use, see our Privacy Policy.

If you decline, your information won’t be tracked when you visit this website. A single cookie will be used in your browser to remember your preference not to be tracked.