Start Free

Speed up your data preparation with Trifacta

Free Sign Up
Wrangle Summit 2021 On Demand

You can still experience the best people, ideas and technology in data engineering, all in one place

Get All-Access Pass
All Templates

Prepare and Analyze Responses from a Survey Using Survey Data Analysis

Analyzing Survey Forms Flow The flow view of this template

Get insights from survey responses in CSV, Excel, or Google Sheets

array parsing (flatten, unnest), extractlist, unpivot, replacepatterns

This template flow shows you how to prepare and analyze survey data collected from a survey form. The survey form contains many different types of questions – such as single response, multiple choice checkbox and other combinations.

This template comes with an example survey (that’s built using Google Forms) where responses are collected in a CSV, but you can replace it with your own survey and response results collected in either CSV, Excel or Google spreadsheet (if using Google Cloud Dataprep).

The flow starts by doing some basic cleaning and renaming of survey question attributes in the Clean Headers recipe. It then forks into 4 separate recipes where each recipe processes one specific type of survey question. The recipes make extensive use of extractlist transform to collect responses into an array, and then various array parsing functions such as flatten to convert them into individual response rows. You can use this technique to work with many types of survey question responses.

Each of the recipes is annotated with detailed instructions, so feel free to step through them one at a time and customize it to your specific survey.

Fore more information, please check out this blog and detailed technical guide.

On Google Cloud Dataprep, this flow template is also available as part of a broader Smart analytics reference pattern.

New to Trifacta?

Sign up below to our free 30-day trial to use this template.


Already have an account?

Download template (Trifacta version) and import it on the Flows page.

Is your data on Google Cloud?

  1. Download template (Dataprep version)
  2. Launch Dataprep on Google Cloud
  3. Import it on Flows page

Learn more about Dataprep

How to Import