Help Center

How do I open a CSV file in a spreadsheet?

The information contained in the tables of each module in Analytics can be downloaded in CSV format. Sometimes, when opening these files, they can be difficult to read as the columns are separated by commas or semicolons, and the rows are separated by line breaks.

To easily sort your data, follow these steps:

  1. Select column A of the document.
  2. Click on the "Data" tab.
  3. Choose the option "Text to Columns."
  4. A dialog box will open where you should select the option "Delimited" and click "Next."
  5. In the "Separators" menu, check the options for "Tab" and "Comma."
  6. Click "Finish," and you're done! Your data will now be sorted.

Here are two videos to guide you through the instructions 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.