Exporting Data
Exporting data in SurveyGizmo is short and sweet. Data exports are available in .csv files (comma separated values), which are easily imported into Excel or your database.
While editing a survey, click the Reports > Your Reports tab. Then, under Export Data on the right side of the page, click the export link to start the export wizard:
Select the questions you want to include, and click the “Export Now” button. Because different browsers handle the download differently, you may see a window with options for opening or saving the data:
Or, you may see the data itself in your browser window. If this is the case, do not panic! Go to your browser’s File > Save As menu, name the file, and save it.
And that’s it.
12 Comments
When using “Data Export” will the data be copied or actually moved?
Hi Carol,
The “Data Export” feature will copy the data not move it from its original location.
Dane
I take it from this discussion that exporting to a CSV file is a feature available to all levels of account (i.e. you can export results to CSV with a free account?)
Yes, that’s correct. You can export to a csv file even with a free account.
Is it possible to have values delimited by something other than commas? What if there are commas in the answer?
Hi Mike,
No, but you can export to .xls format if you wish. Commas in the question title or answers don’t matter because they’re quoted out.
ie. “this has, a comma”,”but the , doesn’t matter”,”because it is quoted out”
Hope this helps,
Chad
hey!
I have a problem with the export. when I export the data into excel, every solved survey has the questions from the table in it’s own row. so when there are 3 solved surveys there is each participant in his own line, but then the questions duplicate or triplicate in this case. so there are instead of 4 rows with questions, 12 of them.
like that:
Q1 Q1 Q1 Q2 Q2 Q2 Q3 Q3 Q3….
P1 1 3 3
P2 5 4 5
P3 4 3 1
thanks
maja
ok…forgot that there are no spaces shown—
____Q1__Q1__Q1__Q2__Q2__Q2__Q3__Q3__Q3….
P1__1___________3__________ 3
P2______5___________4___________5
P3__________4____________3__________1
well..still not perfect, but I hope you get the problem…
bye
Hi Maja,
Correct, this is done for multi select questions like checkbox questions, where more than one option can be selected. Representing multiple selections in a single cell is very difficult to read an understand which is why we break out each option into it’s own column.
Hope this helps,
Chad
oooh, now I see that I took the wrong table option…well, thanks :)
Test