Skip to main content
All CollectionsAnalysisSurvey Data
Exporting: How to send your OpinionX data to an external spreadsheet
Exporting: How to send your OpinionX data to an external spreadsheet
Daniel Kyne avatar
Written by Daniel Kyne
Updated this week

πŸ‘‰ Exporting is available to customers on the Ask tier or higher

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

-- -- --

Where to find the export buttons on OpinionX

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.

-- -- --

Exporting to Google Sheets

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.

➑️ Note: Integrations are only available on the Analyze tier or higher.

-- -- --

Aggregated Results Export

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.

-- -- --

Raw Data Export

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.

-- -- --

Individual Block Exports

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.

Did this answer your question?