Submit Article Requests

Do you have a suggestion for an article you would like to see created?
Feel free to submit this form and add your suggestions to our document board.

Please fill out the contact form below and we will reply as soon as possible.

  • Appcues Certifications & Training
  • Contact Us
  • Home
  • Analytics
  • Data

Viewing Form & Survey Results

Updated at November 26th, 2022

Submit Article Requests

Do you have a suggestion for an article you would like to see created?
Feel free to submit this form and add your suggestions to our document board.

Please fill out the contact form with the details about the help content you'd like to see.

  • Installation & Developers
    Installing Appcues Installing Appcues Mobile API & Data Troubleshooting Extras
  • User Experiences
    Web Experiences Building Web Experiences Building Mobile Experiences Customization & Styling Targeting Studio Troubleshooting Use Cases FAQ
  • Mobile
    Installation & Overview Building Mobile Experiences Mobile Analytics Troubleshooting Mobile Use Cases
  • Account Management
    Subscription Users & Data
  • Analytics
    Experience and Event Analytics Data
  • Best Practices
    Use Cases Pro Tips PLG FAQ
  • Integrations
    Integration Documents Use Cases Resources
  • Post-mortem
    System Incidents
+ More

Table of Contents

Exporting form & survey responses Manually parsing form responses from a full CSV export

Once you've created a form or survey and published it live, you can review user responses by exporting a CSV. You can export the CSV from the analytics page of the particular flow:

Exporting form & survey responses

The easiest way to see all form & survey responses for a user is to choose " Survey". The export will be emailed to you in a few minutes and will include one line per user, with their latest response per field and the date and time it was last submitted, in a condensed format that's easy to read.

Note: if the same user answers a survey more than once, only the most recent response is returned in the survey export. If you're looking to see all the responses, you'll need to select the full export.

If you need more detail or granularity, continue on to the next section.

Manually parsing form responses from a full CSV export

Individual form response events are included one by one in the Full and Basic CSV exports as well, but they require a lot of manual work to determine which responses came from which users.

You would only need to parse form events manually if:

  • You need to correlate specific user properties with each response at the time it was submitted.
  • You need to see all responses, not just the latest.
  • You want to calculate the timing of when each form element was filled out, not just see the most recent time.
  • You have other advanced needs that require viewing each form event separately.

If you don't need to do these kinds of advanced analyses, you should export "Survey" as shown above.

Once you received and downloaded your CSV via email, the easiest way to view the form response data is to import the CSV into Google Sheets or Excel. The example below uses Google Sheets.

The file will come in the email in a .zip format, so you may need to convert this to .csv before uploading it to your product of choice. On a Mac, you'll simply click the file, which will open it and automatically convert it to a .csv format. On Windows, you may need to use a conversion software like WinZip or 7-Zip.

Step 1. Open your new sheet and in the 'File' tab, select 'Import'.

Step 2. You will then see a few options. You can choose whichever options make the most sense for you but, for a new Google Sheet, the default options will work just fine.

Step 3. Once the CSV is imported, in the 'Data' tab, select the 'Create a Filter' option.

Step 4. Go to the 'name column' (it should be column D) to apply the filter. First, you'll need to 'Clear' all filters and then search by "appcues:form_submitted" to retrieve the results.

Step 5. For each of the fields in the form, there will be a column titled "attributes.interaction.response" followed by the question or label associated with that form field. In that column, you'll find the user's answer to the question. One of the columns in the spreadsheet will be titled attributes._identity.userId, which will indicate which user submitted this response.

Was this article helpful?

Yes
No
Give feedback about this article

Related Articles

  • Understanding Flow Event Data
  • Goals Overview
  • Export Flow Analytics Data (CSV)
  • Flow Analytics Overview
Appcues logo

Product

Why Appcues
How it works
Integrations
Security
Pricing
What's new

Use cases

User Onboarding Software
Feature Adoption Software
NPS & Surveys
Announcements
Insights
Mobile Adoption

Company

About
Careers
we're Hiring

Support

Developer Docs
Contact

Resources

The Appcues Blog
Product Adoption Academy
GoodUX
Case studies
Webinar Series
Made with Appcues
Appcues University

Follow us

Facebook iconTwitter icon greyLinkedin iconInstagram icon
© 2022 Appcues. All rights reserved.
SecurityTerms of ServicePrivacy Policy
Expand