Troubleshoot exporting form data to Excel

Troubleshoot exporting form data to Excel

Tip: Create a survey, quiz, or poll with Microsoft Forms. Want to create an advanced survey? Try Microsoft Forms Pro.

If your form or survey was created in Forms on the Web (https://forms.office.com) and has received a large number of long answers, you may experience a download error when trying to check your form results and export your data to Excel. Here is a workaround to ensure you can successfully retrieve all your data in one or more Excel workbooks.

  1. In the address bar of your browser, replace the existing URL with the following:

    https://forms.office.com/Pages/DesignPage.aspx?DownloadFileSize=[enter number]#Analysis=true&FormId=[enter Form ID number]

    • DownloadFileSize = Number of responses between 1 and 5,000.

      Note: 5,000 is the maximum number of responses you can download to a single Excel workbook.

    • FormId = The string of 80 numbers and characters at the end of your URL.

    For example, your workaround URL might look like this:

    https://forms.office.com/Pages/DesignPage.aspx?DownloadFileSize=2000#analysis=true&FormId=v4j5c....

  2. Go back to the Responses tab and click Open in Excel.

  3. One Excel workbook will open for up to 2,000 responses (the number you have specified in DownloadFileSize). For example, if your form has 20,000 responses and you've specified DownloadFileSize = 2000, then 10 Excel workbooks, each with 2,000 responses, will open.

    Notes: 

    • If you've created your form in Forms on the Web (https://forms.office.com) and click Open in Excel, an offline Excel workbook will open that has no relationship or connection to your form.

    • If you've created your form in OneDrive for Business and click Open in Excel, your Excel workbook is automatically stored in OneDrive for Business and contains a live data connection to your form. Any new response data in your form will be reflected in your workbook.

    • If you've created your form in Excel Online and click Open in Excel, your Excel workbook is automatically stored in OneDrive for Business and contains a live data connection to your form. Any new response data in your form will be reflected in your workbook.

Got feedback on Microsoft Forms?

We'd love to hear from you! Please visit the Microsoft Forms UserVoice site to provide suggestions and vote on ideas others have already submitted.

See Also

Check your form results

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×