{"id":520,"date":"2022-07-21T06:02:51","date_gmt":"2022-07-21T06:02:51","guid":{"rendered":"https:\/\/extendedforms.io\/blog\/?p=520"},"modified":"2024-07-11T10:01:01","modified_gmt":"2024-07-11T10:01:01","slug":"connect-google-forms-to-google-sheets","status":"publish","type":"post","link":"https:\/\/extendedforms.io\/blog\/connect-google-forms-to-google-sheets","title":{"rendered":"How to Connect Google Forms to Google Sheets? ( 2 Easy Ways)"},"content":{"rendered":"\n<p>Want to link Google Forms responses to Google Sheets? You may be aware of it if you use forms frequently. However, if you don\u2019t know much about Google Forms&#8217; different functionality then no worries, because in this article I am going to explain how to connect <a href=\"https:\/\/extendedforms.io\/\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Google Forms to Google Sheets<\/a>.\u00a0<\/p>\n\n\n\n<p>Creating a document of your all responses makes it easier to evaluate and analyze. For instance, if your form is used for student <a href=\"https:\/\/extendedforms.io\/blog\/conduct-online-tests-google-forms\" target=\"_blank\" rel=\"noreferrer noopener\">assessments<\/a> or <a href=\"https:\/\/extendedforms.io\/blog\/use-google-forms-for-recruitment\" target=\"_blank\" rel=\"noreferrer noopener\">job interview<\/a> purposes.\u00a0<\/p>\n\n\n\n<p>Though Google Forms provides the summary and even individual responses, it\u2019s easier to save all the responses in one place and view them whenever needed or edit them. Google Forms is surely designed to have so many benefits for free. Though there are many form\/quiz makers online, Google Forms is still one of the best amongst them due to its versatility. <\/p>\n\n\n\n<p>Here, in this blog, we will take you through a detailed guide to how you can easily connect Google Forms to Google Sheets.<\/p>\n\n\n\n<div class=\"wp-block-rank-math-toc-block\" id=\"rank-math-toc\"><h2>In this Article<\/h2><nav><ul><li class=\"\"><a href=\"#why-connect-google-forms-to-google-sheets\">Why Connect Google Forms to Google Sheets?<\/a><\/li><li class=\"\"><a href=\"#steps-to-connect-google-forms-to-google-sheets\">Steps to Connect Google Forms to Google Sheets<\/a><ul><li class=\"\"><a href=\"#method-1-connect-google-forms-to-google-sheets\">Method 1: Connect Google Forms to Google Sheets\u00a0<\/a><ul><li class=\"\"><a href=\"#a-connect-the-form-to-the-spreadsheet\">A. Connect the form to the spreadsheet<\/a><\/li><li class=\"\"><a href=\"#b-create-google-form-from-a-spreadsheet\">B. Create Google Form from a Spreadsheet<\/a><\/li><\/ul><\/li><li class=\"\"><a href=\"#method-2-save-form-responses-to-sheets-through-extended-forms\">Method 2: Save Form Responses to Sheets through ExtendedForms<\/a><ul><li class=\"\"><a href=\"#a-install-the-add-on\">A. Install the add-on\u00a0<\/a><\/li><li class=\"\"><a href=\"#b-save-form-responses\">B. Save Form Responses<\/a><\/li><\/ul><\/li><li class=\"\"><a href=\"#extended-forms-app\">ExtendedForms App<\/a><\/li><\/ul><\/li><li class=\"\"><a href=\"#wrapping-up\">Wrapping Up<\/a><\/li><\/ul><\/nav><\/div>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-4-3 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<div class=\"ast-oembed-container\"><iframe loading=\"lazy\" title=\"Best Way to Connect Google Forms with Google Sheets - Sync Google form Responses\" width=\"500\" height=\"375\" src=\"https:\/\/www.youtube.com\/embed\/Pb3oy3gc5vc?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/div>\n<\/div><\/figure>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><strong><em>Prefer \u201cwatching\u201d over reading?<\/em><\/strong><em>\u00a0<a href=\"https:\/\/www.youtube.com\/watch?v=uTUFYMtCeAQ\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">You can find a video version of this tutorial here<\/a>.<\/em>\u00a0<em>Otherwise, just scroll down and keep reading!<\/em><\/p>\n\n\n\n<h2 id=\"why-connect-google-forms-to-google-sheets\">Why Connect Google Forms to Google Sheets?<\/h2>\n\n\n\n<p>As I mentioned earlier you can always use Google Forms as a standalone app, simply go to the \u2018responses\u2019 section and you can read all the responses. However, it doesn\u2019t contain analytical functionality as you might need, solely for that reason you might need to connect Google Forms to Google Sheets.\u00a0<\/p>\n\n\n\n<p>Manually, transferring data to Google Sheets is too time-consuming. Instead, you can simply connect Google Forms to Google Sheets to transfer the data automatically.&nbsp; It also means the sheet will automatically be updated with a response if\/when a respondent submits a form.&nbsp;<\/p>\n\n\n\n<p>The most important advantage of linking Google Forms to Google Sheets is that your data will remain intact even if you delete the data from your form. Another thing is, that if you change the field within the form, your sheet will automatically update too. Once, your form has been submitted any data within the spreadsheet will not change.\u00a0<\/p>\n\n\n\n<h2 id=\"steps-to-connect-google-forms-to-google-sheets\">Steps to Connect Google Forms to Google Sheets<\/h2>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" width=\"716\" height=\"2560\" src=\"https:\/\/extendedforms.io\/blog\/wp-content\/uploads\/2023\/08\/22.-How-to-Connect-Google-forms-to-Google-Sheets-scaled.webp\" alt=\"\" class=\"wp-image-4089\" srcset=\"https:\/\/extendedforms.io\/blog\/wp-content\/uploads\/2023\/08\/22.-How-to-Connect-Google-forms-to-Google-Sheets-scaled.webp 716w, https:\/\/extendedforms.io\/blog\/wp-content\/uploads\/2023\/08\/22.-How-to-Connect-Google-forms-to-Google-Sheets-84x300.webp 84w, https:\/\/extendedforms.io\/blog\/wp-content\/uploads\/2023\/08\/22.-How-to-Connect-Google-forms-to-Google-Sheets-768x2745.webp 768w, https:\/\/extendedforms.io\/blog\/wp-content\/uploads\/2023\/08\/22.-How-to-Connect-Google-forms-to-Google-Sheets-430x1536.webp 430w, https:\/\/extendedforms.io\/blog\/wp-content\/uploads\/2023\/08\/22.-How-to-Connect-Google-forms-to-Google-Sheets-573x2048.webp 573w\" sizes=\"(max-width: 716px) 100vw, 716px\" \/><\/figure><\/div>\n\n\n\n<div style=\"height:15px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>So, let\u2019s get started with this article, it is going to be a quick guide to read. We are going to just discuss two ways through which you can connect and save Google Forms responses to sheets.\u00a0<\/p>\n\n\n\n<h3 id=\"method-1-connect-google-forms-to-google-sheets\">Method 1: Connect Google Forms to Google Sheets\u00a0<\/h3>\n\n\n\n<p>In this step, you can connect Google Forms to Google Sheets in two ways &#8211; either create sheets from the forms or create Google Forms from existing spreadsheets.\u00a0<\/p>\n\n\n\n<h4 id=\"a-connect-the-form-to-the-spreadsheet\">A. <strong>Connect the form to the spreadsheet<\/strong><\/h4>\n\n\n\n<ul><li>To start with, set up your Google Form. Either go through G-drive > Google Forms > Blank Form\/Quiz, or you can directly head to the <a href=\"https:\/\/docs.google.com\/forms\/u\/0\/\" target=\"_blank\" rel=\"noopener\">Google Forms<\/a> app.<\/li><li>Create your form, enter down Q&amp;A, and configure settings under the \u2018Settings\u2019 option.\u00a0<\/li><li>Navigate to the \u2018Responses\u2019 tab,<\/li><li>Click on the Google Sheet icon or \u2018\u1367\u2019 icon next to it followed by \u2018Select response destination.\u2019\u00a0<\/li><li>You\u2019ll get two options either you want to \u2018create a new spreadsheet\u2019 or \u2018select an existing spreadsheet\u2019. If choosing a new spreadsheet, then type the name of your sheet and you&#8217;re done.\u00a0<\/li><li>But, if you are using the existing spreadsheet option then, click on \u2018Select\u2019 and choose from the remaining sheets.\u00a0<\/li><li>Click on the \u2018Sheet\u2019 icon to open the spreadsheet and test out the form.<\/li><\/ul>\n\n\n\n<p>[Note* Even if you choose an existing spreadsheet, know that the data will be saved in another tab with the fields equivalent to those in your form.]&nbsp;<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" width=\"1024\" height=\"600\" src=\"https:\/\/extendedforms.io\/blog\/wp-content\/uploads\/2022\/07\/Google-forms-google-sheets-create-spreadsheet-1024x600.png.webp\" alt=\"\" class=\"wp-image-533\" srcset=\"https:\/\/extendedforms.io\/blog\/wp-content\/uploads\/2022\/07\/Google-forms-google-sheets-create-spreadsheet-1024x600.png.webp 1024w, https:\/\/extendedforms.io\/blog\/wp-content\/uploads\/2022\/07\/Google-forms-google-sheets-create-spreadsheet-300x176.png.webp 300w, https:\/\/extendedforms.io\/blog\/wp-content\/uploads\/2022\/07\/Google-forms-google-sheets-create-spreadsheet-768x450.png.webp 768w, https:\/\/extendedforms.io\/blog\/wp-content\/uploads\/2022\/07\/Google-forms-google-sheets-create-spreadsheet-1536x901.png.webp 1536w, https:\/\/extendedforms.io\/blog\/wp-content\/uploads\/2022\/07\/Google-forms-google-sheets-create-spreadsheet.png.webp 1620w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<div style=\"height:17px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h4 id=\"b-create-google-form-from-a-spreadsheet\">B. <strong>Create Google Form from a Spreadsheet<\/strong><\/h4>\n\n\n\n<p>You can go the other way around by creating Google forms from columns in Google Sheets.\u00a0<\/p>\n\n\n\n<ul><li>To connect the form, open an existing or new Google sheet<\/li><li>Navigate Tools > Create a new form from the menu<\/li><li>This will create a new blank Google form and open up a new tab. Also, a new responses sheet will be created in the existing Google Sheet.\u00a0<\/li><li>As you start adding questions to your form, the sheet will get automatically updated as well.\u00a0<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" width=\"1024\" height=\"522\" src=\"https:\/\/extendedforms.io\/blog\/wp-content\/uploads\/2022\/07\/Google-Forms-Google-Sheets-Create-form-1024x522.png.webp\" alt=\"\" class=\"wp-image-534\" srcset=\"https:\/\/extendedforms.io\/blog\/wp-content\/uploads\/2022\/07\/Google-Forms-Google-Sheets-Create-form-1024x522.png.webp 1024w, https:\/\/extendedforms.io\/blog\/wp-content\/uploads\/2022\/07\/Google-Forms-Google-Sheets-Create-form-300x153.png.webp 300w, https:\/\/extendedforms.io\/blog\/wp-content\/uploads\/2022\/07\/Google-Forms-Google-Sheets-Create-form-768x392.png.webp 768w, https:\/\/extendedforms.io\/blog\/wp-content\/uploads\/2022\/07\/Google-Forms-Google-Sheets-Create-form-1536x783.png.webp 1536w, https:\/\/extendedforms.io\/blog\/wp-content\/uploads\/2022\/07\/Google-Forms-Google-Sheets-Create-form-2048x1044.png.webp 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 id=\"method-2-save-form-responses-to-sheets-through-extended-forms\">Method 2: Save Form Responses to Sheets through ExtendedForms<\/h3>\n\n\n\n<p>Now, let\u2019s get to another part through which you can save Google form responses to Google Sheets. So, it\u2019s a little bit more extensive steps, however, it doesn\u2019t take much of your time. In this part of the article, we are going to focus on how you can save responses to sheets through the <a href=\"https:\/\/extendedforms.io\/blog\/why-extendedforms-must-have-google-forms-addon\" target=\"_blank\" rel=\"noreferrer noopener\">ExtendedForms<\/a> app.&nbsp;<\/p>\n\n\n\n<h4 id=\"a-install-the-add-on\">A. <strong>Install the add-on&nbsp;<\/strong><\/h4>\n\n\n\n<ul><li>To start with, we have to first install the add-on and it is a very quick process. Click on \u2018\u1367\u2019 icon > Add-ons > search for ExtendedForms.\u00a0<\/li><li>Click on the Install button and your app will be installed within seconds.<\/li><li>Once that\u2019s done, you\u2019ll see a puzzle-shaped icon on the top bar. (If you don\u2019t see one, refresh the page) Click on it > ExtendedForms > Configure.\u00a0<\/li><li>[Note* &#8211; If you don\u2019t see the Configure option then refresh the page and check again]<\/li><li>The settings dialogue box will appear, and you will see all the basic settings configurations (like <a href=\"https:\/\/extendedforms.io\/blog\/share-google-forms\" target=\"_blank\" rel=\"noreferrer noopener\">share<\/a>, timer) to configure. <\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" width=\"1024\" height=\"583\" src=\"https:\/\/extendedforms.io\/blog\/wp-content\/uploads\/2022\/07\/google-forms-google-sheets-extendedforms-1024x583.png.webp\" alt=\"\" class=\"wp-image-531\" srcset=\"https:\/\/extendedforms.io\/blog\/wp-content\/uploads\/2022\/07\/google-forms-google-sheets-extendedforms-1024x583.png.webp 1024w, https:\/\/extendedforms.io\/blog\/wp-content\/uploads\/2022\/07\/google-forms-google-sheets-extendedforms-300x171.png.webp 300w, https:\/\/extendedforms.io\/blog\/wp-content\/uploads\/2022\/07\/google-forms-google-sheets-extendedforms-768x437.png.webp 768w, https:\/\/extendedforms.io\/blog\/wp-content\/uploads\/2022\/07\/google-forms-google-sheets-extendedforms.png.webp 1440w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<h4 id=\"b-save-form-responses\">B. <strong>Save Form Responses<\/strong><\/h4>\n\n\n\n<ul><li>To start with, go to the main settings page of ExtendedForms or the dashboard.&nbsp;<\/li><li>To visit the main page, you can go through the \u2018Responses\u2019 option in the settings box in Google Forms. Click on it and it will take you to the Forms page of ExtendedForms.&nbsp;<\/li><li>Click on this \u2018\u1367\u2019 icon and then \u2018Export CSV.\u2019&nbsp;<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" src=\"https:\/\/extendedforms.io\/blog\/wp-content\/uploads\/2022\/07\/GoogleForms-GoogleSheets-ExportCSV.png.webp\" alt=\"GoogleForms-GoogleSheets-ExportCSV\" class=\"wp-image-526\" width=\"451\" height=\"439\" srcset=\"https:\/\/extendedforms.io\/blog\/wp-content\/uploads\/2022\/07\/GoogleForms-GoogleSheets-ExportCSV.png.webp 902w, https:\/\/extendedforms.io\/blog\/wp-content\/uploads\/2022\/07\/GoogleForms-GoogleSheets-ExportCSV-300x292.png.webp 300w, https:\/\/extendedforms.io\/blog\/wp-content\/uploads\/2022\/07\/GoogleForms-GoogleSheets-ExportCSV-768x748.png.webp 768w\" sizes=\"(max-width: 451px) 100vw, 451px\" \/><\/figure><\/div>\n\n\n\n<ul><li>The Excel sheet will be downloaded to your device of that particular form.\u00a0<\/li><li>You can either open it in your Excel sheet or you can also open it in your Google sheet.\u00a0<\/li><li>Just go to Google Sheets, create a \u2018Blank\u2019 sheet, and go to File > Open > Upload.\u00a0<\/li><li>And you are done! All the responses will be uploaded to your Google Sheets.\u00a0<\/li><\/ul>\n\n\n\n<p><em>Looking for an easy way to allow multiple domains for form sharing? Read,\u00a0<a href=\"https:\/\/extendedforms.io\/blog\/org-only-multiple-domains\" target=\"_blank\" rel=\"noreferrer noopener\">How to Allow Multiple Domains for Form Sharing With an Organization.<\/a><\/em><\/p>\n\n\n\n<h3 id=\"extended-forms-app\">ExtendedForms App<\/h3>\n\n\n\n<p><a href=\"https:\/\/workspace.google.com\/marketplace\/app\/extended_forms_timer_for_google_forms\/763170157069\" target=\"_blank\" rel=\"noopener\">ExtendedForms<\/a> app is one of the top-rated timer apps of Google Forms in Google Marketplace. It lets you add a countdown timer within seconds, as it has no pesky configurations. Other than hassle-free settings, you get other features to set like \u2013 a specific deadline with date\/time, sending invites with a customized invitation message, adding a welcome message (show before users start attempting forms), and so on.&nbsp;<\/p>\n\n\n\n<p>Apart from these basic features, it includes a .CSV export option, classroom integration, team management (add teams and manager team role feature), and brand customization. The app has a dashboard that shows the summary of responses in an intuitive graph and the last 10 respondents&#8217; status.\u00a0<\/p>\n\n\n\n<p>Furthermore, you can transfer ownership of your account to anyone with the account, including image cropping for your profile, and brand images. Plus, it allows you to enable shortened URLs and customize URLs.<\/p>\n\n\n\n<div class=\"wp-container-6a280919d54d8 wp-block-buttons\">\n<div class=\"wp-block-button aligncenter\"><a class=\"wp-block-button__link\" href=\"https:\/\/u.expresstech.io\/ef-connectedforms\" target=\"_blank\" rel=\"noreferrer noopener\">Visit ExtendedForms Now!<\/a><\/div>\n<\/div>\n\n\n\n<h2 id=\"wrapping-up\">Wrapping Up<\/h2>\n\n\n\n<p>Google Forms is a versatile tool and has all the needed features you may need. In this article, we got to know that you can link Google form responses to Google Sheets. However, if you want to know whether you can link multiple forms to one sheet, then let me tell you that whenever you connect Google Forms to Google Sheets a new tab is created. It is not possible to merge multiple forms into a single tab sheet. However, there are various add-ons in the Google market available to do that. <\/p>\n\n\n\n<p>Also, the extended form has a free trial version and other pro versions. However, it has a feature now that allows you to top up your quota anytime, no matter which existing subscription plan you are on or the free plan. Just pay the amount of the particular quota you need and you are good to go.<\/p>\n\n\n\n<div class=\"wp-container-6a280919d57e2 wp-block-buttons\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link\" href=\"https:\/\/workspace.google.com\/marketplace\/app\/extended_forms_timer_for_google_forms\/763170157069\" target=\"_blank\" rel=\"noreferrer noopener\">Install ExtendedForms Now!<\/a><\/div>\n<\/div>\n\n\n\n<p>If you like reading this blog, also read our detailed guide on<a href=\"https:\/\/extendedforms.io\/blog\/connect-google-forms-to-discord\" target=\"_blank\" rel=\"noreferrer noopener\">&nbsp;How to Connect Google Forms to Discord. [3 Ways]<\/a>&nbsp;and&nbsp;<a href=\"https:\/\/extendedforms.io\/blog\/create-a-question-bank-in-google-forms\" target=\"_blank\" rel=\"noreferrer noopener\">How to Create a Question Bank in Google Forms? [In 2 Ways]<\/a>.&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Connect Google Forms to Google Sheets to automatically collect and organize form responses in a structured spreadsheet. Read this blog.<\/p>\n","protected":false},"author":3,"featured_media":6269,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":""},"categories":[16,85],"tags":[89,86,87,88],"_links":{"self":[{"href":"https:\/\/extendedforms.io\/blog\/wp-json\/wp\/v2\/posts\/520"}],"collection":[{"href":"https:\/\/extendedforms.io\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/extendedforms.io\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/extendedforms.io\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/extendedforms.io\/blog\/wp-json\/wp\/v2\/comments?post=520"}],"version-history":[{"count":29,"href":"https:\/\/extendedforms.io\/blog\/wp-json\/wp\/v2\/posts\/520\/revisions"}],"predecessor-version":[{"id":6271,"href":"https:\/\/extendedforms.io\/blog\/wp-json\/wp\/v2\/posts\/520\/revisions\/6271"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/extendedforms.io\/blog\/wp-json\/wp\/v2\/media\/6269"}],"wp:attachment":[{"href":"https:\/\/extendedforms.io\/blog\/wp-json\/wp\/v2\/media?parent=520"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/extendedforms.io\/blog\/wp-json\/wp\/v2\/categories?post=520"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/extendedforms.io\/blog\/wp-json\/wp\/v2\/tags?post=520"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}