Export Results

You can export a form's results to a spreadsheet or data file, which may make it easier to analyze and draw conclusions from.

Send Responses to a New Spreadsheet

  1. Click the Responses tab.
  2. Click the Create Spreadsheet button.
    Send Responses to a New Spreadsheet

    You can create a new spreadsheet for this form's responses, or add them to an existing sheet on your Google Drive.

  3. Leave the Create a new spreadsheet option selected.
  4. Click Create.
    Send Responses to a New Spreadsheet

A new spreadsheet is created, and opens in a new browser tab. Every response appears in that question's column, along with some extra data like the time that the response was submitted.

Now you can even use the tools available in Google Sheets to do some extra analysis of the responses, or even download the spreadsheet to use in Microsoft Excel.

Unlink a Spreadsheet

Future responses will be added to the spreadsheet as they come in. To stop, you need to unlink the form from the sheet.

  1. From the Responses tab, click the More button.
  2. Select Unlink form.
    Unlink a Spreadsheet

    A confirmation dialog box comes up, informing you that future responses won't be added to the spreadsheet anymore but existing responses won't be removed.

  3. Click the Unlink button.
    Unlink a Spreadsheet

The form is unlinked from the spreadsheet, and the Sheets icon on this page will no longer link to it.

Send Responses to an Existing Spreadsheet

  1. From the Responses tab, click the Create Spreadsheet button.
    Send Responses to an Existing Spreadsheet
  2. Click the Select existing spreadsheet option button.
  3. Click Select.
    Send Responses to an Existing Spreadsheet

    The spreadsheet you chose opens, with a new tab added with the responses from the form.

  4. Select a sheet on your Google Drive.
  5. Click the Select button.
    Send Responses to an Existing Spreadsheet

Download Responses

Finally, you can download the results of a form as a C-S-V file that you can import into other programs.

  1. From the Responses tab, click the More button.
  2. Select Download responses (.csv).
    Download Responses

The results are packed into a file and saved to your Downloads folder.

Delete a Single Response

  1. Click the Responses tab.
  2. Click the Individual tab.
  3. Select a response using the dropdown menu or the arrows.
  4. Click the Delete response button.
    Delete a Single Response
  5. Click Yes to confirm.
    Delete a Single Response

The selected response is deleted.

Clear a Form's Responses

  1. Click the Responses tab.
  2. Click the More button.
  3. Select Delete all responses.
    Clear a Form's Responses
  4. Click OK to confirm.
    Clear a Form's Responses

All the responses are deleted.

FREE Quick Reference

Click to Download

Free to distribute with our compliments; we hope you will consider our paid training.