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 2016 (and later)

If you're using Excel 2016 (or a later version) and your data isn't formatted automatically, you can do the following:

1. Download the CSV export of your form, 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 Delimiter is set to Semicolon (;);
6. Click Load.

Your data will now be formatted in columns matching your form's structure, so you can use it for further analysis in Excel.

With Office Excel 2003

If you're using Excel 2003 and your data isn't formatted automatically, you can do the following:

1. Download the CSV export of your form, but don't open it yet;
2. Open a new file in Excel;
3. Click DataFrom Text;
4. Select the CSV file from your disk;
5. In the newly-opened window, choose Delimited. Then click Next;
6. Make sure the Delimiter is set to Semicolon (;);
7. Click Finish.

Your data will now be formatted in columns matching your form's structure, so you can use it for further analysis in Excel.

With Google Sheets

If you're using Google Sheets and your data isn't formatted automatically, you can do the following:

1. Download the CSV export of your form, 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 will now be formatted 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.