Skip to main content
Loading...
  • Customer Experience
    Customer Experience
  • Employee Experience
    Employee Experience
  • Brand Experience
    Brand Experience
  • Product Experience
    Product Experience
  • Core XM
    Core XM
  • Design XM
    Design XM

Exporting Response Data to Google Drive

What's on This Page:


Was this helpful?


This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

The feedback you submit here is used only to help improve this page.

That’s great! Thank you for your feedback!

Thank you for your feedback!


About Exporting Response Data to Google Drive

You can export your Qualtrics data to your Google Drive as a Google Sheet. This page will go over where to find this function, how to link it to your Google account, and how to generate a Google sheet of your response data in just a few simple steps.

Exporting Data to Google Sheets

  1. Go to your Data & Analysis tab.
    Export Import button on far-right of Data & Analysis tab
  2. Click Export & Import.
  3. Select Export Data.
  4. Select Google Drive.
    New window. Google drive option at top. Check boxes further towards bottom. Export button green far-right bottom corner
  5. To only export what appears in your Data & Analysis tab (excluding any columns of data not present in this preview), deselect Download all data.
    Qtip: Unless you have very carefully chosen columns, you should keep Download all data selected.
  6. Select whether to export numeric data (numeric values) or the text of the options (choice text).
    Qtip: Interested in More Options? See Additional Export Options.
  7. Click Export.
  8. You will be asked to log into one of your Google accounts. Select or enter the account you would like to connect Qualtrics to.
    Choose an account screen for logging into Google
  9. Click Allow.
    Allow button in blue on the bottom-right
  10. To see your new Google Sheet, click Open in Browser.
    Blue open in browser text on left
  11. You are now free to view, edit, and share your new Google Sheet.
    A google sheet filled with example Qualtrics data. The columns are organized the same as a CSV export
Qtip: Want to better understand some of the column headers included in your data set? See the Understanding Your Data Set support page.

Additional Export Options

Download data table window with the blue more options link in the bottom-left

When you select More Options on the lower-left of the export window, there will be several options to choose from that can reformat how your data is exported to Google Sheets.

Options expanded towards bottom of window in center

  • Recode seen but unanswered questions as -99: By default, questions that participants chose not to answer are left blank in the survey data. When this option is enabled, any questions that participants saw and chose not to answer are coded as a value of -99 (or any other number you specify by clicking on the number and editing it) in order to distinguish them from questions participants didn’t see.
  • Recode seen but unanswered multi-value fields as 0: This option is similar to “Recode seen but unanswered questions as -99” and can only be enabled if that option is also selected. Additionally, your exported data will only show this option if “Split multi-value fields into columns” is also selected because multi-value fields must be in their own column in order to display the value as 0 (or any other number you specify by clicking on the number and editing it), this identifies answer choices which were shown to a respondent but were unanswered.
  • Export viewing order data for randomized surveys: When this option is enabled, columns are added to your dataset for each randomized element in your survey. These columns contain information on the order in which your randomized blocks, questions, or answer choices were displayed to the individual respondent.
  • Split multi-value fields into columns: Certain question types allow for multiple answer choices to be selected for a single question. This option splits each possible answer to the question into a unique column, rather than combining every chosen answer into a single column.
  • Use internal IDs in header: With this option unchecked, question column headers display the names of questions as you have named them with the Recode Values function of the Survey tab. With this option checked, the question column headers display the internal IDs (which cannot be edited) as assigned by Qualtrics.