Export Crunch survey results in a BI-ready format


New tabulated data export format for multitables.

Nov 19, 2021

Crunch gives you the best of all worlds — you analyze all your survey data in Crunch, and now you can export those results into your other reporting tools (such as Tableau, Google Data Studio, PowerBI) so that you can see your survey results alongside your other business metrics.

Your tables (tab books) can now be exported in a specialized output format. This format contains a row for each cell of the table you see in the Crunch app. For example, this table from Crunch would generate 40 rows. There will be a row for the “All” category for “I am making more sustainable choices….” response, one for males and more sustainable choices, females and more sustainable choices, etc. all the way down to the 55+ age group and “Don’t know”.

The output format is a delimited text file of results that is ready to put into other analysis and presentation tools. Below is an excerpt of the file generated from the table above:

You have a few options to customize your file (noted below).

To generate your file, navigate to your multitable. In the upper right hand corner, click Export and select Export settings from the dropdown menu.

This screen will appear:

You can customize the format and contents of the export. Column headings (the first row of the exported file) can be compact, single-word labels or space-separated labels. Columns can be separated by commas or semicolons; and decimals by a period or comma. After making your customizations, click Save to persist them.

To export, click Export again in the upper-right and select Export tab book from the dropdown menu. Select the CSV option from the Format menu, choose which variables to export, and then click Export to download your results.

Once you’ve downloaded your tabulated results file, consult the documentation on the tool of your choice for guidance on how to upload. Below we show you how our sustainability results look in Google Data Studio.

Details regarding this new feature can be found in the help center.

Questions or feedback on this feature? Please contact support@crunch.io and use “Tabulated results export” in the subject line.