Data Import & Export

How to Sync Microsoft Forms Responses with an Excel File in Teams

Guest Writer Oct 10, 2026 869 views

Question details

The user needs to establish a live connection between Microsoft Forms and an Excel workbook in Teams so that new form responses are automatically recorded.

How to Sync Microsoft Forms Responses with an Excel File in Teams

Product: Microsoft Excel, Microsoft Forms, Microsoft Teams
Device & OS: not provided
Scenario: Automating data collection from a Microsoft Form directly into a shared Excel workbook located within a Teams channel.
Observed behavior: Manually downloading a Forms response workbook and uploading it to a Teams channel creates a static file that does not update when new responses are submitted.

Before you start

Ensure you have access to Microsoft Power Automate, and verify that your destination Excel workbook is stored in SharePoint or OneDrive and contains a formatted Table with column headers.

Solution 1Recommended

Automate Data Sync Using Power Automate

Create a Power Automate flow to capture new Form responses and write them directly into an Excel Online table shared in your Teams channel.

To establish a live connection, you cannot simply upload a downloaded workbook. Instead, you must use Power Automate to detect new form submissions and append them to an Excel file hosted in the cloud (SharePoint or OneDrive).

Set up the Forms Trigger

Log into Power Automate, create a new Automated Cloud Flow, and select the Microsoft Forms trigger 'When a new response is submitted'. Select your specific Form from the dropdown menu.

Retrieve Response Details

Add a new action and search for 'Get response details' under Microsoft Forms. Select your Form ID again and insert the 'Response Id' dynamic content into the corresponding field.

Connect to the Excel Workbook

Add another action, search for 'Excel Online (Business)', and select 'Add a row into a table'. Choose the SharePoint site or OneDrive location where your Teams Excel file is stored, select the Document Library, the specific File, and the Table name.

Map Form Data to Excel Columns

Once the table is selected, the columns will appear in Power Automate. Click into each field and use the dynamic content menu to map the corresponding answers from your Form to the correct Excel columns.

Add a Teams Notification (Optional)

To alert your team, add a Microsoft Teams action such as 'Post message in a chat or channel'. Configure it to post a message in your designated Teams channel containing a link to the updated workbook, then Save and test your flow.

Table Formatting Required: For the Power Automate Excel connector to work, the data range in your destination Excel file must be formatted as a Table (Insert > Table). Make sure your table headers match the questions on your form.

Free Microsoft Office alternative

Edit and Analyze Survey Data with WPS Office

While automating Microsoft Forms relies on Power Automate, you can use WPS Office as a free, lightweight alternative to open, edit, and analyze your exported Excel survey data seamlessly. Enjoy a familiar interface and robust spreadsheet tools without the subscription fees.

1. Download and Install: Download WPS Office for free and install it on your device.
2. Open Your Exported Data: Locate the Excel (.xlsx) file exported from your forms and open it directly in WPS Spreadsheet.
3. Analyze the Results: Use WPS Spreadsheet's built-in filtering, formatting, and pivot table tools to analyze your survey data efficiently.

Highly compatible with Microsoft Excel (.xlsx, .csv) formats.Free and lightweight alternative to Microsoft Office.Advanced data analysis, pivot tables, and charting tools built-in.Familiar spreadsheet interface with zero learning curve for Excel users.

microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't my Excel file update automatically when I upload it to Teams?

Uploading a static, downloaded Excel file from Microsoft Forms only creates an offline copy in Teams. To get live updates, you must use Power Automate to link the active Form to an Excel file stored in SharePoint or OneDrive.

Do I need to format my Excel data as a table?

Yes. For Power Automate to append new responses successfully, the destination Excel file must contain a formatted Table with named columns corresponding to your Form questions.

Can I use OneDrive instead of SharePoint for the Excel file?

Yes, you can store the destination Excel workbook in your OneDrive for Business. However, if multiple team members need access via Teams, storing the file in the Team's SharePoint document library is recommended for better collaborative access.

Is Power Automate strictly required for this sync?

If you created the Form independently via the Forms web app, Power Automate is required. However, if you originally created the Form directly from within an Excel Online workbook by clicking 'Insert > Forms', it will sync to that specific workbook automatically.

Excel & Data Problems