Others

How to Compare Pre- and Post-Intervention Feedback Forms in Excel

Maira Mehtab Sep 27, 2026 869 views

Question details

The user needs a method to evaluate intervention effectiveness by comparing participant responses gathered from surveys before and after an event.

Product: Microsoft Forms
Device & OS: not provided
Scenario: Analyzing and comparing survey data collected before and after a specific intervention or training session.
Observed behavior: To successfully match and compare two distinct sets of form responses using spreadsheet tools or automated workflows.

Before you start

Ensure that both your pre- and post-intervention forms contain exactly identical questions and require a unique identifier (such as an email address or student ID) to accurately match the participants' responses.

Solution 1Recommended

Export and Compare Forms Data in Excel

The most reliable method for personal and standard accounts is to export both sets of Microsoft Forms responses into Excel for side-by-side comparison.

Personal Microsoft Forms accounts do not have built-in automated comparison features. You must export the data to a spreadsheet tool like Excel to analyze the results using formulas and charts.

Create matching forms

Set up two separate Microsoft Forms: one for the pre-intervention assessment and one for the post-intervention assessment. Ensure the questions are identical.

Export responses to Excel

Open each form, navigate to the 'Responses' tab, and click 'Open in Excel' to download the collected data.

Merge the datasets

Copy the data from the post-intervention Excel file and paste it into a new worksheet within the pre-intervention Excel workbook.

Analyze the differences

Use spreadsheet formulas like VLOOKUP, pivot tables, or charts to match participant IDs across the two sheets and calculate the score differences.

Account Limitations: Automatic comparison is not supported on personal accounts. All analysis must be done manually after exporting to Excel.

Solution 2

Automate Data Collection with Power Automate

Users with a work, school, or premium Microsoft account can utilize Power Automate to streamline the data collection process into a single master sheet.

Powerful Data Analysis with WPS Office

Analyze Pre- and Post-Intervention Data with WPS Spreadsheet

WPS Office offers a comprehensive productivity suite equipped with WPS Spreadsheet, the perfect tool for matching and analyzing exported survey data. Import your form results and use advanced formulas to evaluate intervention feedback effortlessly.

1. Open a new workbook: Launch WPS Spreadsheet and create a new blank workbook for your analysis.
2. Import survey data: Go to the 'Data' tab and import the CSV or XLSX files exported from your pre- and post-intervention surveys.
3. Organize into sheets: Place the pre-intervention data on 'Sheet 1' and the post-intervention data on 'Sheet 2'.
4. Apply matching formulas: Use the VLOOKUP function in a new summary sheet to match unique participant identifiers and pull scores side-by-side.
5. Calculate and visualize: Subtract the pre-scores from the post-scores to find the difference, then insert a chart from the 'Insert' tab to present your findings.

Fully compatible with Microsoft Excel (.xlsx and .csv) file formats.Built-in advanced formulas like VLOOKUP to easily match participant IDs across sheets.Intuitive Pivot Tables and charts for visualizing pre- and post-intervention trends.Lightweight, fast, and completely free to use for daily data processing tasks.

microsoft office alternative - wps office

Frequently Asked Questions

Do I need a premium account to compare Microsoft Forms responses?

No, you can export the responses to Excel and manually compare them for free using a standard personal account. Automated synchronization via Power Automate, however, requires a premium, work, or school account.

How do I ensure I can match a participant's pre- and post-intervention form?

Include a mandatory question in both forms asking for a unique identifier, such as a student ID, employee number, or email address. This allows you to match the corresponding rows accurately when analyzing the data in a spreadsheet.

Can I combine both surveys into one single form?

While it is possible to use branching logic in a single form, it is highly recommended to use two distinct forms. This keeps the timestamps and response sets clearly separated for accurate time-based comparison.

What is the best spreadsheet formula to compare the two sets of responses?

VLOOKUP or XLOOKUP are the best formulas for this task. You can use them to search for a participant's unique ID in the pre-intervention sheet and accurately pull their score into the post-intervention sheet for direct subtraction.

Office Quick Solutions