Introducing Forms data sync to Excel
Published Jan 23 2024 04:03 PM 101K Views
Microsoft

The highly anticipated feature Forms data sync to Excel is now available in Microsoft Forms. With just one click, you can now easily access all your form responses in Excel for the web and take advantage of Excel’s rich functions to analyze and visualize your data. With automatic syncing of new responses in real-time, you can keep working on your existing spreadsheet without missing a beat. No more juggling multiple copies of the same file, making it easier than ever to stay on top of important data. Ready to check out this feature? Let’s get started! You can also try out this feature from this template. 

 

Open responses in Excel

Open any active form or quiz, go to the "Responses" page and click "Open results in Excel". This will automatically create an Excel worksheet in your OneDrive and take you to Excel for the web, where you'll see all your data in just a few seconds.  

 

Open response in ExcelOpen response in Excel

 

 

Deeper analysis in Excel

In Excel, you can manipulate the data the way you want and leverage various tools to do further analysis, like sorting, filtering, and inserting charts.

 

Manipulate data in ExcelManipulate data in Excel

 

New responses sync to Excel

New responses will automatically sync when you open your Excel file for the web, allowing you to seamlessly continue your existing work.

 

New response sync to ExcelNew response sync to Excel

 

Let’s review two real user cases to see how Excel data sync solved their problems to give you some inspiration on how to leverage this feature.

 

Business scenario

A company uses Excel to manually log every office facility request in a workbook that is shared among different departments for manual status updates and reporting. By using Forms data sync to Excel, they can instead distribute one office facility form through Microsoft Forms and share the Excel workbook of responses. Each department can then review newly synced requests and update the request status they are responsible for accordingly.

 

Education scenario 

Middle school teachers utilize online quizzes for in-class testing. After class, they consolidate various classes' quiz results into an Excel file for deeper analysis, aiming to identify students' weaknesses and provide targeted support. 

 

With Forms, multiple classes can use one quiz, and the results will be synced to a single worksheet, eliminating the need for teachers to manually combine quiz results from different classes. The teacher can add a question for class identification and use the filter in Excel to easily distinguish one class from another. 

 

Please note that Forms data sync to Excel is currently only available in Excel for the Web. While you can still view your data with the desktop and mobile apps, new responses will not be automatically synced unless you are using Excel for the Web.

54 Comments
Co-Authors
Version history
Last update:
‎Jan 23 2024 11:07 PM
Updated by: