Get Your Forms Data In Excel
Step 1: Configuring Your Google Form
Make sure you have the Data Everywhere Forms Add-On installed from the Add-On Store. Enable Data Everywhere for this Form, and Google will automatically publish to Data Everywhere after every form of submission.
Read more: Automatic Publishing in Google Forms
Step 2: Linking Google Forms to Excel
Inside of the Data Everywhere Google Forms Add-on is a link to download your data. Once you’ve downloaded this file, the first tab of the spreadsheet has instructions for installing the Excel Add-in. Once the Add-in is installed, the forms data in this spreadsheet will be automatically synchronized with Google Forms.
You can choose to have Excel prompt you when new data is available, or automatically update the data. Now, whenever you open this workbook, you’ll have the latest results from your Google Form!
Read more: Functionality Overview of the Excel Add-In