Data Import & Export

How to Combine Microsoft Forms Reports into One Annual Report

Nimra Malik Sep 29, 2026 869 views

Question details

The user needs to merge or consolidate multiple Microsoft Forms reports into a single comprehensive annual report.

How to Combine Microsoft Forms Reports into One Annual Report

Product: Microsoft Forms / Excel
Device & OS: not provided
Scenario: Compiling periodic survey or feedback responses from multiple Microsoft Forms into an aggregated annual report format for review.
Observed behavior: Microsoft Forms lacks a native feature to automatically merge PDF reports or consolidate underlying response data from multiple forms into one document.

Before you start

Determine whether you need a single visual document of the existing reports (combining PDFs) or if you need to analyze the underlying data (consolidating Excel files). Gathering all source files into a single local folder will streamline the combining process.

Solution 1Recommended

Consolidate Response Data using Excel Power Query

Best for users who need to analyze, aggregate, or recalculate the actual response data from multiple Microsoft Forms.

By exporting the raw data to Excel, you can use Power Query to automatically combine multiple response spreadsheets. This method allows you to update the master annual report easily when new data is added.

Export Forms data to Excel

Open each Microsoft Form, navigate to the 'Responses' tab, and click 'Open in Excel'. Save all the exported workbooks into one dedicated folder on your computer.

Import data with Power Query

Open a blank Excel workbook. Go to the 'Data' tab, select 'Get Data', choose 'From File', and then click 'From Folder'. Browse to the folder where you saved your Forms data and click 'Open'.

Combine and Transform

In the preview window, click 'Combine' and select 'Combine & Transform Data'. Select the sheet containing your data to open the Power Query Editor, where you can clean or filter out unnecessary columns.

Load to Master Workbook

Click 'Close & Load' to import the consolidated data into your master workbook. When source files change, simply go to the Data tab and click 'Refresh All' to update the annual report.

Consolidate Response Data using Excel Power Query

Automated Updates: Once the Power Query connection is established, adding a new exported Excel file to the source folder and clicking 'Refresh All' will automatically include the new data in your report.

Solution 2

Merge Existing PDF Reports into a Single Document

Ideal if you only have the exported visual PDF summaries of the Forms and do not need to analyze or manipulate the raw data.

Powerful Data and PDF Tools

Easily Consolidate Data and Merge PDFs with WPS Office

WPS Office provides seamless solutions for combining your Microsoft Forms reports. Whether you need to merge exported PDF reports or consolidate Excel response data, WPS Office handles it efficiently in one application.

1. Install WPS Office: Download and open WPS Office on your computer.
2. Merge PDF Reports: To combine visual reports, open the PDF tab, select 'Merge PDF', and add your exported Microsoft Forms PDFs.
3. Consolidate Excel Data: To analyze raw responses, open your exported Excel files in WPS Spreadsheet to seamlessly copy, filter, and consolidate the data.
4. Save the Final Report: Format your combined data and save your finalized annual report securely to your local drive or cloud storage.

Combine multiple PDF reports into one document in secondsHighly compatible with Microsoft Excel (.xlsx) formats for data analysisLightweight, user-friendly interface for handling large datasetsAll-in-one suite to manage PDFs, Spreadsheets, and Documents without switching apps

microsoft office alternative - wps office

Frequently Asked Questions

Can Microsoft Forms automatically generate an annual report?

No, Microsoft Forms does not offer a native feature to automatically merge multiple forms into a single annual report. You must export the data to Excel or PDF to compile it manually.

What if my Forms reports are only available as PDFs and I need the data?

If you only have PDF files but need to analyze the data, you can use a PDF-to-Excel conversion tool to extract the tables into spreadsheets before consolidating them. Note that converted data may require some formatting cleanup.

How do I update my consolidated Excel report when new Forms data comes in?

If you used Excel Power Query to combine your files from a specific folder, simply save the newly exported Excel file into that same folder. Open your master workbook, go to the Data tab, and click 'Refresh All' to update the report instantly.

Excel & Data Problems