How to use your CSV file in Office Excel or Google Sheets

Download results to CSV

First, download the results of your form to CSV using the download button(s) in the Results pane in Tripetto.

Open CSV file

Now that you've got the CSV file, 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 gets readable, understandable and usable for further analysis.

With 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.

With 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.

With other spreadsheet editors

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