Chart & Visualization Issues

How to Export Microsoft Forms Survey Charts and Graphs to Excel

Olivia MillerOlivia Miller Oct 29, 2026 870 views

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.

How to Export Microsoft Forms Survey Charts and Graphs
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.
Before you start

Ensure you have the necessary form owner or co-author permissions to access the Responses tab and download the survey data.

Solution 1Recommended

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.

1
Open the Forms Responses Tab

Log into Microsoft Forms, open your specific survey or quiz, and navigate to the 'Responses' tab at the top of the page.

2
Download the Data

Click the 'Open in Excel' button located in the responses summary area to download your raw data as an .xlsx file.

3
Select the Survey Data

Open the downloaded Excel workbook and highlight the specific columns or rows of data you want to visualize.

4
Insert a Chart

Navigate to the 'Insert' tab on the ribbon and choose your preferred chart type (e.g., Pie Chart, Column Chart) to generate the graph.

Export Form Responses to Excel and Create Charts
Quick Alternative: Snipping Tool: If you do not need to customize the data and simply need the visual as it appears in Forms, use your operating system's built-in screenshot utility (like Snipping Tool on Windows) to capture the web page directly.
Visualize Survey Data

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. 1. Download Forms Data: Click 'Open in Excel' inside Microsoft Forms to save your responses locally.
  2. 2. Open with WPS Office: Right-click the downloaded .xlsx file, select 'Open with', and choose WPS Office.
  3. 3. Select Data Range: Highlight the specific data cells you wish to turn into a chart.
  4. 4. Insert Chart: Go to the 'Insert' tab on the top menu, click 'Chart', and select a template to instantly visualize your survey responses.
Fully compatible with Microsoft Excel (.xlsx) formats exported from Forms.Rich library of built-in chart templates (Pie, Bar, Line, Scatter, etc.) for visual analysis.Lightweight software with a familiar, easy-to-use interface for immediate productivity.
microsoft office alternative - wps office

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.