Data Import & Export

How to Export Microsoft Forms Responses to a Macro-Enabled Excel Workbook

Huma Ashraf Ch Oct 1, 2026 869 views

Question details

The user wants to export Microsoft Forms responses directly into a customized, macro-enabled Excel workbook (.xlsm) for automated data processing.

How to Export Microsoft Forms Responses to a Macro-Enabled Excel Workbook

Product: Microsoft Forms / Excel
Device & OS: not provided
Scenario: Automating data collection from a form submission into an advanced Excel file that utilizes macros to process the gathered information.
Observed behavior: Microsoft Forms does not natively support direct exporting into customized macro-enabled workbooks, only standard .xlsx files.

Before you start

Ensure you have access to Microsoft Power Automate and have your target macro-enabled Excel workbook (.xlsm) saved in OneDrive or SharePoint, featuring a pre-formatted table ready to receive incoming data.

Solution 1Recommended

Use Power Automate to Route Responses to an Excel Table

Since direct export to .xlsm isn't natively supported, Power Automate can be used to bridge the gap by automatically sending new form responses to a designated table within your macro-enabled workbook.

By setting up a cloud flow in Microsoft Power Automate, you can extract submission details every time a user completes your form and instantly append that data as a new row in your existing workbook.

Note that macros will not execute automatically in Excel Online when data is injected; you will need to open the workbook in a desktop application to run your VBA scripts.

Prepare the Destination Workbook

Create or upload your macro-enabled Excel file (.xlsm) in OneDrive or SharePoint. Highlight the columns where data will go, press Ctrl+T to convert them into a Table, and name the table.

Create an Automated Cloud Flow

Log into Microsoft Power Automate, click 'Create' in the left menu, and select 'Automated cloud flow'. Name your flow and choose the trigger 'When a new response is submitted' under Microsoft Forms.

Link the Microsoft Form

In the trigger setup, use the 'Form Id' dropdown to select the specific Microsoft Form you want to pull data from.

Get Response Details

Add a new step, search for 'Get response details' (Microsoft Forms), select your Form Id again, and map the 'Response Id' dynamic content to the Response Id field.

Add a Row to Your Excel Table

Add a new step and search for 'Add a row into a table' (Excel Online). Select your OneDrive/SharePoint location, Document Library, File, and Table. Once the table is selected, map the form questions from the dynamic content to the corresponding columns.

Use Power Automate to Route Responses to an Excel Table

Advanced Customization: For highly complex workflows involving branching logic or specific data transformations before insertion, it is recommended to consult the Microsoft Power Automate Community.

Free Microsoft Office alternative

View and Edit Macro-Enabled Workbooks Free with WPS Office

While automated cloud connections require Power Automate, managing, editing, and running macros on your downloaded .xlsm workbooks can be done effortlessly with WPS Office. It provides robust spreadsheet features and excellent compatibility with Microsoft Office formats without the expensive subscription fee.

1. Install WPS Office: Download and install the free WPS Office suite from the official website onto your computer.
2. Open WPS Spreadsheet: Launch WPS Office and click on the 'Spreadsheet' module to access the Excel-compatible interface.
3. Load Your Macro-Enabled File: Click 'Open', navigate to your synced OneDrive folder or local directory, and select your .xlsm file to begin editing.

100% free and lightweight office suite for daily tasksFully compatible with Microsoft Excel formats including .xls, .xlsx, .xlsm, and .csvSupports advanced data processing and complex spreadsheet functionsFamiliar user interface ensuring seamless migration with no learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Can I export Microsoft Forms directly to an .xlsm file without Power Automate?

No, Microsoft Forms natively exports responses to a standard .xlsx workbook. To automatically route incoming data into a macro-enabled workbook (.xlsm), you must use an automation tool like Power Automate and store the target workbook in a supported cloud location.

Why are my macros not running automatically when new data arrives via Power Automate?

Excel macros (VBA) cannot execute in the background via Excel Online when data is injected by Power Automate. The data will be added, but you must open the workbook in a compatible desktop application to manually or automatically trigger the macros.

Can I run Office Scripts instead of VBA macros in this scenario?

Yes, Power Automate supports running Office Scripts on Excel Online files. You can append a 'Run script' action in your flow immediately after the 'Add a row into a table' step to process the data in the cloud without needing to open a desktop app.

Excel & Data Problems