How to Export Google Forms to Docs

Last Updated: Wed Nov 20 2024

There might be some situations when you want to reference Google Forms response data in Google Docs. Follow the steps below to export Google Forms to Docs.

Easiest Way to Export Google Forms to Google Docs

As of now, there is no way to directly export or synchronize responses from Google Forms to Google Docs. Google Forms is designed to work in conjunction with Google Sheets, where all responses are automatically collected and can be viewed in real time.

However, there is a way to transfer your Google Forms responses from Google Sheets to Google Docs. Here is a step-by-step guide on how to do it.

Step 1 - Connect Your Google Form To A Google Spreadsheet

The first step is to connect your Google Form to a spreadsheet. Go to the responses tab. Click the green link at the right, ‘Link to Sheets.’

A GIF image showing how to access the responses section

A red arrow pointing at the link to the sheets icon.

In the dialog box that appears as soon as you click ‘Link to Sheets,’ select ‘Create a New Spreadsheet’ or ‘Select existing spreadsheet.’ If you want to add the collected responses data to an existing spreadsheet, click the second option.

Click Create to add the data to a spreadsheet.

The first step arrow points to the spreadsheet creation selection, and the second points to the create button.

Next step

Step 2 – Access the Linked Spreadsheet

A new sheet will open in another browser tab after clicking ‘Create’ in the previous step. This spreadsheet shows all the responses that were stored through Google Forms.

Back Next step

Step 3 – Select The Data To Copy And Transfer It To Google Docs

To copy responses in Google Sheets, select the cells and press Ctrl+C (or Cmd+C on Mac), or right-click and choose "Copy". Do not select everything with Ctrl+A (or Cmd+A on Mac). It will copy all the empty cells in the spreadsheet. Select only the columns and rows populated with data.

A GIF image showing how to select the data in a Google spreadsheet

Back Next step

Step 4 – Create A New Google Doc Or Select An Existing One

Go to Google Docs. Create a new document or select an existing one to insert the data from the spreadsheet.

Back Next step

Step 5 – Paste The Selected Data

Click on the document where you want to insert the data. Right-click the context menu, select ‘Paste,’ or use Ctrl +V (Cmd + V in Mac) to paste the data. Choose the ‘Link to Spreadsheet’ or ‘Paste Unlinked’ option and click Paste. It is preferable to link the data to the spreadsheet from which you are copying the data. The data can be updated in real time.

A red arrow pointing at the paste button.

Back Next step

Step 6 – Format the document to make it look professional

You may need to modify the layout and style of the pasted table and text to meet the specific requirements of your document. This can involve adjusting column sizes, modifying font styles, or changing colors.

An image showing how the data copied from the Google spreadsheet looks in Google Docs.

To avoid the hassle of manually copying and pasting data from Google Forms to Google Docs, you can use third-party services such as Zapier or Dokin to automate the process.

Back

Finished!