How to use CSV from the studio in Office Excel or Google Sheets

Learn how you can use the downloaded CSV file of your results from the studio in Office Excel or Google Sheets.

Download CSV export

After you downloaded the CSV export from the studio to your computer, you can open this in a so called spreadsheet editor. The most common used programs are Microsoft Office Excel and Google Sheets.

We will explain for those two programs how to open the CSV export, so your data is readable, understandable and usable for further analysis.

CSV in Office Excel

If your data isn't separated in Excel automatically, you can try the following:

  1. Download the CSV, but don't open it yet;
  2. Open a new file in Excel;
  3. Click DataFrom text/CSV;
  4. Select the CSV file from your disk;
  5. You'll see an example of the data that gets imported. Make sure the separator is set to Semicolon;
  6. Click Load.
Your data should now be separated in columns matching your form's structure, so you can use it for further analysis in Excel.

CSV in Google Sheets

If your data isn't separated in Google Sheets automatically, you can try the following:

  1. Download the CSV, but don't open it yet;
  2. Open a new Sheets file in Google Docs;
  3. Click FileImport;
  4. Select the CSV file from your disk;
  5. You'll see a Settings screen of the import. Make sure the Separator Type is set to Custom and fill out a ; (a semicolon sign) in the field behind Custom;
  6. Click Load.
Your data should now be separated in columns matching your form's structure, so you can use it for further analysis in Google Sheets.

Using another spreadsheet editor?

We cannot discuss all spreadsheet editors, but most of them will have comparable functionality to import and read CSV files.

Use these helplines if you have any questions, problems or requests