Exporting data

If you have a Professional or Corporate account, you can export your poll, survey, quiz, or rating data to Excel, Google Docs, CSV, XML, and/or PDF formats. The process to export data is the same for polls, surveys, quizzes, and ratings. Let’s walk through the options using polls as an example.

Hover over the title of the poll in your dashboard, Then click on View Results:

View Results

Then, click on Export:
Export

When you click on Export, you’ll see a dropdown with five export options:

Export Options

PDF

Export to PDF to get a report which you can view, print, and share as needed. Clicking on the PDF option creates a PDF in your current browser window that you can save to your computer.

Excel

This is the best option to use, if you’d like to export your data into Excel. We support Excel version 97 and up.

Google Docs

This method allows you to securely upload your data straight into a Google Docs account. Click on the “Google Docs” export option:

Google Docs

When your data is ready, you’ll receive an email with a link to your data in Google Docs:

Clicking on the link takes you directly to a spreadsheet in Google Docs with your poll data:

Naturally you can still export data from Polldaddy as Excel or CSV, and import those files into Google Docs if you like.

CSV

The CSV exporting option offers a more generic export format that has greater compatibility other software packages. Note that all data exported from Polldaddy is encoded as UTF-8. If your data contains non-English characters, then you may experience encoding problems if you open the file in Excel by double-clicking it. To get around this you need to import the CSV file through the import tool:

Then ensure that the UTF-8 encoding and delimited file type options are selected.

You then need to pick that a comma is used as a delimiter:

The data preview should show separate columns.

XML

Use this if you wish to import your data using another tool.

Extra Data

Exported poll data will sometimes have rows containing the value “n/a”. This usually happens when votes were cast before a poll was edited and answers removed. Instead of removing the votes the export file contains them giving you some idea of activity before the poll was edited.

Polldaddy Tweets
%d bloggers like this:
wpcom_wp_footer