ExcelInsider Team
Forms are often required to conduct surveys online. For analyzing the data collected from the survey, we need to import the data into excel. Fortunately, it is possible to connect a web form to an excel spreadsheet. This article will show you the steps to create a web form to populate excel spreadsheet.
➤ Go to https://forms.office.com/
➤ Create a new form
➤ Go to “Collect responses” and share your form with others
➤ After receiving some responses, go to “View responses”.
➤ Click “Open results in Excel” to populate an excel spreadsheet.
To make the steps clearer, we have provided a whole tutorial with a breakdown. Therefore, don’t leave yet, stick to the end of the article to understand the process.
Creating a Web Form to Populate an Excel Spreadsheet
In this example, we are creating a customer feedback sheet. We will collect feedback from customers and connect the form to an excel sheet, which will automatically update whenever a customer fills up the form.
Step 1: Create a Form
➤ Go to this site:
https://forms.office.com/
➤ Click on “New Form” to create a new form.
➤ From the new tab, create the form according to your needs.
Step 2: Share your form
➤ Click “Collect responses” and share your form with others.
➤ Wait for some responses to fill up.
Step 3: Connect to Excel
➤ Hit View responses
➤ From the new dialog, click “Open results in Excel”.
➤ In the new window, you will find an excel spreadsheet which will automatically populate from the web form that you created.
Creating a Form in Excel to Populate a Spreadsheet
Now you know how to create a web form to populate an excel spreadsheet. However, if you are logged in and have autosave on, you can create a form in excel to populate a spreadsheet as well. Here is how to do it:
➤ Sign in to Microsoft 365 if you have not already, and turn on autosave.
➤ From the Insert tab, go to Forms > New Form.
➤ A new browser window will open, and you can manage the form from there. The data will be updated in the excel window automatically. If the window isn’t open yet, you can do it from the right panel.
Frequently Asked Questions
Can Microsoft Forms feed into Excel automatically?
Yes. In your browser, set up your excel workbook with your Microsoft Forms. Then, create a new flow in Power Automate and select “Automated cloud Flow”. Then choose “Microsoft Forms” as your flow trigger. Finally, add an action to get responses directly to microsoft excel.
How to automatically update data in Excel from a website?
From the Data tab, go to Get & Transform Data > From Web. You can enter the website link there to grab data.
How to make an Excel spreadsheet into a fillable form?
Using the Developer tab, add a content control and protect the sheet. Now you can open the file again, and you can save the file again and again after filling it out as a form.
Which is better, Microsoft Forms or Google Forms?
It cannot be objectively said which service is better. However, google forms is more popular, and can be integrated with google sheets.
Is Microsoft Forms free?
Yes, it is free to use.
Wrapping Up
In this article, we have shown how to create and use a web form to populate excel spreadsheet. If you like the tutorial and want to see more, bookmark this site and share it with your friends. If you face any issues, don’t hesitate to comment down.
