Data Import & Export

How to Fix Microsoft Forms Export Limited to 5000 Excel Responses

Maira Mehtab Sep 28, 2026 871 views

Question details

The user needs to download a complete set of survey responses, but the system restricts the Excel export to only 5,000 entries at a time.

Product: Microsoft Forms
Device & OS: not provided
Scenario: Exporting a large dataset with more than 5,000 responses from Microsoft Forms to an Excel workbook for data consolidation and analysis.
Observed behavior: When selecting the option to open responses in Excel, only a maximum of 5,000 entries are downloaded, preventing access to the full dataset in a single file.

Before you start

Verify the total number of responses your form has received on the 'Responses' tab to calculate exactly how many export batches you will need to perform.

Solution 1Recommended

Export Form Responses in Batches

Because Microsoft Forms imposes a hard limit of 5,000 responses per Excel download, you must export the data in sequential batches to retrieve the entire dataset.

This workaround requires you to specify data ranges and manually download multiple Excel workbooks. Once all batches are downloaded, you can merge them into a single master spreadsheet.

Identify Total Responses

Open your form in Microsoft Forms, navigate to the 'Responses' tab, and note the total response count to determine how many 5,000-entry batches you will need.

Specify the First Batch Range

Use the Forms download-size workaround menu to specify the range for your first batch by typing 1 to 5,000.

Download the First Batch

Click the 'Open in Excel' button to download the first 5,000 responses to your device.

Repeat for Remaining Batches

Repeat the process for the next batch by specifying the range 5,001 to 10,000, then click 'Open in Excel'. Continue this pattern until all responses are exported.

Consolidate the Data

Open all the downloaded Excel workbooks. Copy the data rows from the subsequent batches (excluding the header rows) and paste them at the bottom of your first workbook to create a complete dataset.

Data Consolidation Tip: Ensure you do not copy the header row from the second and third batches when pasting into your master workbook to avoid corrupting your data formatting.

Free Microsoft Office alternative

Consolidate Large Datasets Seamlessly with WPS Office

While you have to deal with Microsoft Forms' export limits, you don't need expensive software to merge and analyze the resulting files. WPS Office is a free, lightweight, and highly compatible alternative that effortlessly handles massive Excel datasets.

Easily merge and process multiple batch-exported response files.Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Free and incredibly fast, even when managing millions of rows of data.Familiar user interface makes transitioning from MS Office completely seamless.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Microsoft Forms limit Excel exports to 5,000 responses?

This limitation is a built-in performance safeguard set by Microsoft to ensure stable server response times and to prevent browser timeouts when generating large Excel files.

Is there a way to bypass the 5,000 limit without manual batches?

Yes. If you initially create your form directly from OneDrive for Business or Excel Online (using 'Forms for Excel'), the responses will automatically sync to a live Excel workbook in the cloud, bypassing the manual 5,000-entry export limit.

Will I lose my data if the form has over 5,000 responses?

No, your data is completely safe and stored in Microsoft Forms. The 5,000 limit only applies to a single download action. By exporting in batches, you can safely retrieve every response.

Excel & Data Problems