Data Import & Export

How to Update Microsoft Forms Responses Without Losing Excel Data

Huda Qurayshi Oct 8, 2026 870 views

Question details

The user needs to add manual completion details to an Excel workbook containing Microsoft Forms responses without losing the added data when new responses are generated or downloaded.

How to Update Microsoft Forms Responses Without Losing Excel Data

Product: Microsoft Forms and Excel
Device & OS: not provided
Scenario: Managing and updating survey or form responses in a spreadsheet alongside manual data entries.
Observed behavior: When forms are created at Forms.office.com, downloading responses creates an offline Excel file. Subsequent downloads create new files that do not contain previously added manual notes or columns.

Before you start

Ensure you have access to a Microsoft 365 business or education account, as you will need OneDrive for Business or SharePoint to set up live synchronization for your forms.

Solution 1Recommended

Use Forms for Excel in OneDrive or SharePoint

Creating the form directly from OneDrive or SharePoint ensures the Excel workbook remains online and automatically syncs new responses without overwriting your manual notes.

When you create a form directly from the Forms web portal, exporting to Excel downloads a static, offline copy. By creating the form through OneDrive for Business or SharePoint instead, the data is dynamically linked to an online workbook, preserving any extra columns you add.

Access OneDrive or SharePoint

Log in to your Microsoft 365 account and navigate to OneDrive for Business or the designated SharePoint site where you want to store the data.

Create a new Forms for Excel file

Click on the 'New' button in the top menu bar and select 'Forms for Excel' from the dropdown list.

Name and build your form

Enter a name for your new form and click 'Create'. This automatically generates an online Excel workbook and opens the form designer. Add your required questions here.

Add manual tracking columns

Open the linked Excel file from your OneDrive or SharePoint. You can now safely add manual columns next to the response data (such as 'Completion Status' or 'Reviewer Notes') without them being overwritten when new submissions arrive.

Use Forms for Excel in OneDrive or SharePoint

Live Synchronization: Because the workbook is stored securely online, new Microsoft Forms responses are automatically appended as new rows, perfectly preserving any additional data you have manually populated.

Free Microsoft Office alternative

Manage Your Survey Data Effectively with WPS Office

While live syncing Microsoft Forms requires a paid online Microsoft 365 account, you can effortlessly manage, merge, and analyze downloaded survey responses using WPS Spreadsheet. It provides a lightweight, highly compatible, and free alternative to Microsoft Excel.

1. Download WPS Office: Visit the official WPS website, download the free suite, and complete the installation.
2. Open downloaded responses: Launch WPS Spreadsheet and open your offline offline form response workbook.
3. Merge data seamlessly: Use built-in data matching tools like VLOOKUP to easily combine new downloaded responses with your older spreadsheets containing manual notes.

Fully compatible with Microsoft Excel (.xlsx) and CSV formatsAdvanced data processing tools like VLOOKUP and Pivot Tables for merging offline dataLightweight application that runs smoothly on Windows, Mac, Linux, and mobileFree to use with a familiar, user-friendly interface for seamless migration

microsoft office alternative - wps office

Frequently Asked Questions

Why do I lose my manual data when downloading Microsoft Forms responses again?

If you created the form directly at Forms.office.com, clicking 'Open in Excel' downloads a completely new, static copy of the responses. It does not update your previous downloaded file, so any manual data added to the old file won't appear in the new one.

Can I link an existing standard Microsoft Form to a live Excel online workbook?

No, you cannot directly link an existing standard form (created on Forms.office.com) to a live Excel online workbook retroactively. You must start by creating a 'Forms for Excel' from OneDrive or SharePoint to enable the live synchronization feature from the beginning.

Is there a way to merge new offline responses with my manually updated spreadsheet?

Yes. If you must use offline files, you can use Excel's or WPS Spreadsheet's VLOOKUP or INDEX/MATCH functions. Use a unique identifier (like the respondent's email or ID) to pull your manually added data from the older spreadsheet into the newly downloaded spreadsheet.

Excel & Data Problems