How to Auto-Sync Forms to Excel with Power Automate (Step-by-Step)

Most companies collect data the hard way. They build a survey, download a static CSV, and manually copy and paste the results into a master tracker. It is slow. It breaks. It wastes hours of your week.

Stop doing manual data entry. Let the machines do the heavy lifting.

We are going to build an automated pipeline. A respondent fills out a Microsoft Form. That data instantly appears in a shared Microsoft Teams Excel file. No manual exports. Just a clean flow of information.

Let's get to work.

Build the data intake form

Head over to Microsoft Forms. Log in with your standard Microsoft 365 credentials.

Create a new form and call it "The Excel Summit Sports Quiz". Forms uses a visual editor. What you build on the screen is exactly what your target audience will see.

You will notice several question types available.

We are going to keep it simple and use "Choice" questions. Add three questions asking for their favorite athlete across different sports.

Now you need to collect responses. Click the "Share" button on the top menu.

You will see a few permission settings. You want to select Anyone with the link can respond. This opens your survey to the outside world without requiring a login.

Click "Copy" to grab your unique URL.

Test it yourself. Open an incognito browser window and paste the link. The form will load immediately.

Fill out the form and hit submit. Your first piece of data is now captured.

Analyze the form responses

Go back to your editor tab and click on "Responses".

You can view the raw data right there. You also have the option to click "Open in Excel".

This works for a quick glance. But relying on a static spreadsheet is a mistake. You have to keep downloading a new copy every time someone submits an answer.

We want live data flowing directly into a shared workspace.

Set up the Teams database

Before we automate the data transfer, we need a destination. Open Microsoft Teams.

Navigate to your chosen channel and click the "Files" tab.

Click Add new Excel Spreadsheet.

Give your file a clear and memorable name.

Open the new spreadsheet. Type your three column headers into adjacent cells: Best Footballer, Best Rugby Player, Best Tennis Player.

Highlight those three cells. Click "Insert" and then select "Table".

Check the box that says "My table has headers" and click OK.

Your spreadsheet is now formatted to accept automated data.

Power Automate needs this table to have a specific name so it knows exactly where to route the incoming answers. Here is the catch. You cannot rename it in the browser. Renaming tables in Excel Online requires the desktop app.

Open the file in your desktop Excel client and rename the table to something distinct.

Build the automation engine

Now we connect the dots. Open https://flow.microsoft.com.

Log in, click "My Flows" on the left menu, select "Create", and choose "Automated Flow".

Name your flow. Search for the trigger When a new response is submitted. This tells the system to wake up the exact moment someone clicks submit.

Select your specific form from the dropdown menu and click "New step".

Search for "Forms" and select Get response details. This action grabs the actual text the user typed.

Select your form again. Map the "Response Id" field by clicking the dynamic content box that appears.

Right now, the flow wakes up and reads the data. We need it to write the data. Click "New step" and choose "Excel Online (Business)".

Select the action Add a row into a table.

Point it to your Teams location, document library, and the specific file. Select the table you renamed earlier. Your column headers will appear automatically.

Click into the "Best Footballer" field. A dynamic content box will pop up on the right.

Match the form question to the Excel column. Repeat this simple mapping for Rugby and Tennis.

Save the flow. Go back to your form and submit a fresh response. Open your Teams Excel file. The data will be sitting right there waiting for you.

You just built a fully automated data pipeline. No manual work required.