Exporting allows you to send your survey results to an external spreadsheet for further analysis outside of OpinionX. This guide covers:

The main export button is found at the top of your survey to the left of the "Share" button when viewing any tab in your survey dashboard. Clicking it opens a popup window where you can configure your export format and destination.

The first option on this popup offers the ability to link your survey to a spreadsheet on Google Sheets. This creates an Aggregated Results spreadsheet that updates with new data every time a new participant is added to your survey. Connecting to Google Sheets is very easy, just hit the "Connect" button and then pick which Google Account you want the spreadsheet to be created on. Once you've done this, the connect button will be replaced by "Open" and "Delete" buttons. This integration just sends data once a participant is registered — it does not update based on edits or deletions made on OpinionX via your survey dashboard.

Once you connect your survey to Google Sheets, you can create additional spreadsheet tabs for summarizing results (for example, see the screenshot below) or use automation platforms like Zapier and Integrately to trigger things like updating your CRM.

The "Aggregated Results" format puts all your survey data into a single spreadsheet. Each row represents one participant. The Aggregate export mirrors what is already available on the Participants Tab on OpinionX. Below you'll find a link to examples of Aggregated Exports that cover every block type available on OpinionX.

^ Please contact [email protected] for a .csv version of these example exports.

The "Raw Data" export format gives you a .zip folder with separate CSV files for each block in your survey. These spreadsheets show a full list of every vote or answer submitted by participants — for example, the Pair Rank export shows the results of every head-to-head comparison that every participant voted on in your survey. Use the link below to view examples of Raw Data exports for every type of question block on OpinionX.

^ Please contact [email protected] for a .csv version of these Raw Data examples.

The third export method can be found on the analysis bar of any results table. Clicking this "Export" button sends the results, as shown on that table, to a spreadsheet. Here's an example that shows the results table on OpinionX and the equivalent export:

If you have any other questions about data exports, please ask! We can provide other examples of exports from real surveys and are always open to discussing your needs if you have custom requirements for your survey.