How to Automatically Copy Google Forms Responses to any other Spreadsheet

Learn how to automatically copy Google Form responses to a Microsoft Excel or Zoho Sheet when a new form response is submitted. You can also copy the form responses to multiple Google Sheets.

Google Forms is a perfect tool for collecting data, from event registrations to customer feedback. By default, your Google Form responses are added in a Google Sheet that is linked to the form.

However, there could be scenarios where you may want to store a copy of the form responses in a different location, such as a Microsoft Excel worksheet, a Zoho sheet, or even multiple Google sheets.

Copy Form Responses to Multiple Sheets

The Problem

For this example, we have a Google Form where respondents can fill in their name, email address, city and other basic details. When a respondents submits the form, we would like that form response to be stored in an Excel sheet as well in addition to the original Google Sheet.

Let’s see how we can easily automate this with the help of Document Studio.

The Solution

Launch Document Studio inside Google Forms and create a new workflow. Provide the workflow name and move to the Conditions page.

Google Form Conditions

Let’s add some conditions here to filter out the form responses that we don’t want to be saved in the Excel sheet. For instance, you may want to save only the responses where the respondent’s city is either New York or Boston. Any form response that doesn’t meet this condition will be ignored.

Next, move to the Tasks page and add a new task. Choose Copy Row from the list of available tasks. Here we’ll choose the spreadsheet service the Google Form responses should be stored. You can choose from Google Sheets, Microsoft Excel, or Zoho Sheets.

Copy Form Responses to Excel

Connect Microsoft Excel to Google Forms

Select Excel Sheets from the list of available spreadsheet applications, and click on the Link Microsoft Excel button. You’ll be asked to sign in with your Microsoft account and grant permissions to Document Studio to access your Excel files.

Once your Microsoft account has been linked, open the Excel workbook in your browser and copy-paste the spreadsheet URL as shown in the screenshot below. If you would like to copy the form response to a Zoho Sheet, you can choose Zoho Sheets from the list and link your Zoho account.

Microsoft Excel URL

You also need to specify the name of the worksheet where the form responses should be copied. If the sheet doesn’t exist, Document Studio will create a new sheet in Excel with the specified name.

The next section is Field Mapping where you can specify which form fields should be copied to the Excel sheet. You also need to specify the corresponding column names in the Excel sheet where the form responses should be stored.

For instance, if the field in your Google Form is called “Zip Code”, you can map it to the “Postal Code” column in your Excel sheet. Similarly, if the field in your Google Form is “Email”, you can map it to the “Email Address” column in your Excel sheet.

Google Form Field (Field Name)Excel Column Name (Field Value)
Zip Code{{ Postal Code }}
Email{{ Email Address }}

Save your task and click on Continue to proceed to the triggers screen. Check the Run on form submit option so that every time a new form response is submitted, the workflow will be triggered, and a new row will be added to the specified Microsoft Excel or Zoho Sheet.

Copy to Microsoft Excel

  1. Copy Google Form response to Zoho Sheet
  2. Duplicate Google Form response in another Google Sheet
Amit Agarwal

Amit Agarwal

Google Developer Expert, Google Cloud Champion

Amit Agarwal is a Google Developer Expert in Google Workspace and Google Apps Script. He holds an engineering degree in Computer Science (I.I.T.) and is the first professional blogger in India.

Amit has developed several popular Google add-ons including Mail Merge for Gmail and Document Studio. Read more on Lifehacker and YourStory


Awards & Titles

Digital Inspiration has won several awards since it's launch in 2004.

Google Developer Expert

Google Developer Expert

Google awarded us the Google Developer Expert award recogizing our work in Google Workspace.

ProductHunt Golden Kitty

ProductHunt Golden Kitty

Our Gmail tool won the Lifehack of the Year award at ProductHunt Golden Kitty Awards in 2017.

Microsoft MVP Alumni

Microsoft MVP Alumni

Microsoft awarded us the Most Valuable Professional (MVP) title for 5 years in a row.

Google Cloud Champion

Google Cloud Champion

Google awarded us the Champion Innovator title recognizing our technical skill and expertise.

Email Newsletter

Sign up for our email newsletter to stay up to date.

We will never send any spam emails. Promise.