How to use your CSV file in Office Excel or Google Sheets
Learn how you can use the downloaded CSV file of your results 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:
- Download the CSV, but don't open it yet;
- Open a new file in Excel;
- Click
Data
From text/CSV
; - Select the CSV file from your disk;
- You'll see an example of the data that gets imported. Make sure the separator is set to
Semicolon (;)
; - 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:
- Download the CSV, but don't open it yet;
- Open a new Sheets file in Google Docs;
- Click
File
Import
; - Select the CSV file from your disk;
- 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 behindCustom
; - 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.