How to Export Microsoft Forms Survey Charts and Graphs to Excel
Question details
The user wants to export summary charts and graphs directly from Microsoft Forms, but this action is not currently natively supported by the platform.

- Product
- Microsoft Forms
- Device & OS
- not provided
- Scenario
- Viewing and analyzing survey responses and attempting to extract the automatically generated charts.
- Observed behavior
- Users cannot find a direct option or button to download or export the response charts from the summary page in Microsoft Forms.
Ensure you have the necessary form owner or co-author permissions to access the Responses tab and download the survey data.
Export Form Responses to Excel and Create Charts
Since Microsoft Forms does not support exporting visual charts directly, exporting the raw response data to a spreadsheet tool is the official method to generate customizable graphs.
By downloading your survey data to Excel, you bypass the limitation of Microsoft Forms. Once the data is in a spreadsheet format, you can utilize built-in charting tools to recreate and customize the graphs for presentations or reports.
Log into Microsoft Forms, open your specific survey or quiz, and navigate to the 'Responses' tab at the top of the page.
Click the 'Open in Excel' button located in the responses summary area to download your raw data as an .xlsx file.
Open the downloaded Excel workbook and highlight the specific columns or rows of data you want to visualize.
Navigate to the 'Insert' tab on the ribbon and choose your preferred chart type (e.g., Pie Chart, Column Chart) to generate the graph.

Create Professional Charts with WPS Spreadsheet
Easily open your downloaded Microsoft Forms response data in WPS Spreadsheet to generate professional, fully customizable charts and graphs for free.
- 1. Download Forms Data: Click 'Open in Excel' inside Microsoft Forms to save your responses locally.
- 2. Open with WPS Office: Right-click the downloaded .xlsx file, select 'Open with', and choose WPS Office.
- 3. Select Data Range: Highlight the specific data cells you wish to turn into a chart.
- 4. Insert Chart: Go to the 'Insert' tab on the top menu, click 'Chart', and select a template to instantly visualize your survey responses.

Frequently Asked Questions
Can I save a Microsoft Forms chart as an image directly?
No, Microsoft Forms does not feature a native 'Save as image' option for its summary charts. To obtain image files of the charts, you must either take a screenshot of your screen or export the data to a spreadsheet software to create and save the charts.
Why is the 'Open in Excel' button missing on my responses page?
The export button may be missing if you do not have the proper permissions. Typically, only the original creator of the form or designated co-authors can view and download response data. Check your sharing settings if you are working collaboratively.
Will my spreadsheet charts update automatically when new responses are submitted?
It depends on how the form was created. If you built the form via OneDrive for Business or SharePoint Online, the connected Excel file updates automatically. If created as a standard form, clicking 'Open in Excel' generates a static offline copy that will not update with future responses.




