Skip to content

Google Forms to Google Docs

There is no native export from Forms to Docs. Three things people mean by the question, and what actually works for each.

The short answer is the one most pages avoid giving: Google Forms has no export to Google Docs. There is no menu item, no button, and no setting hidden three levels down. Two Google products that sit next to each other in the same app grid do not talk to one another this way.

So the question becomes what you were actually going to do with the document, because the three plausible answers have three different solutions and only one of them is any real work.

If you want the answers inside a document

Copy them out of the linked spreadsheet and paste them into Docs. The paste keeps the table structure, which is usually what people wanted in the first place.

If you just need something shareable

You probably want a PDF rather than a Doc. It looks the same to whoever receives it, nobody can accidentally edit it, and it is one menu away in Sheets.

If you want one document per response

Certificates, contracts, offer letters, invoices: that is a mail merge, and it is genuinely the thing Docs is good at. Google does not provide it, but add-ons such as Document Studio and Form Publisher do, and they do it well. We have nothing to sell you here, which is exactly why it is worth saying.

Where the FormsGen app fits, and where it does not

It builds forms and exports responses to CSV and Excel. It does not generate documents, and nothing on this page changes if you have it installed.

Why it helps

Knowing it does not exist saves an hour

Most of the time spent on this question goes into looking for a menu item that was never there. There is no export from Forms to Docs, and no add-on changes that; they generate new documents instead.

A pasted table keeps its structure

Copying a range out of the linked spreadsheet and pasting it into Docs preserves the rows and columns as a real table. It is unglamorous and it takes about fifteen seconds.

One document per response is a different problem

If you are producing a certificate or a contract for each person who answered, no amount of copying will get you there. That is a mail merge, and it needs a tool built for it.

How to do it

  1. 1

    Send the responses to a spreadsheet

    Open the form, click Responses, then Link to Sheets at the top right and choose Create a new spreadsheet. Everything else on this page starts from that sheet.

  2. 2

    Select the range you want and copy it

    Include the header row. Without it, the table lands in Docs with no column names and has to be labelled by hand.

  3. 3

    Paste it into a Google Doc

    It arrives as a table you can restyle, resize and write around. If you would rather it did not update or reformat unexpectedly, this plain paste is the safer choice over linking the two files.

  4. 4

    If you needed a document per response, stop here and use a mail merge

    Add-ons such as Document Studio and Form Publisher take a Docs template and fill it in once per submission. That is the real answer for certificates, contracts and letters, and it is not something copying and pasting will ever cover.

Questions people ask

Is there really no export from Google Forms to Google Docs?
No, there is not. Forms exports to Sheets and to CSV. Any route to Docs goes through one of those, or through an add-on that generates a new document.
Should I paste the table or link it?
Paste it, unless you specifically want the document to change when the spreadsheet does. A linked table updates on request, which is useful for a living report and a nuisance for a document you have already sent to someone.
What is the difference between this and a mail merge?
Copying gives you one document containing every response. A mail merge gives you one document per response, each filled in from a template. They solve opposite problems.
Which add-on should I use for a mail merge?
Document Studio and Form Publisher are the two most established. We have no relationship with either and nothing to gain from recommending them; they are simply what this job needs.
Does the FormsGen app create Google Docs?
No. It builds Google Forms. Everything on this page happens after the responses are in, and it happens in Google's own tools.

Documents are somebody else's job. Building the form is ours.