Can Microsoft Forms Update Existing Excel Inventory Data?
Question details
The user wants to use Microsoft Forms to pull up and display previously collected computer inventory data, allow users to update it, track the identity of the person making changes, and automatically keep an existing Excel workbook current.

- Product
- Microsoft Forms, Excel
- Device & OS
- not provided
- Scenario
- Collaboratively managing and updating computer inventory data using Microsoft 365 tools.
- Observed behavior
- Microsoft Forms only collects new responses and appends them as new rows; it does not have the native capability to read, display, or overwrite existing data rows in an Excel workbook.
Before attempting to automate inventory updates, ensure your master Excel workbook is backed up and saved to a cloud location like OneDrive or SharePoint to allow for potential Power Automate integrations.
Build an Inventory Management Solution with Power Apps
Since Microsoft Forms cannot read or update existing Excel data, building a Canvas App with Power Apps is the recommended Microsoft 365 solution for this workflow.
Power Apps is designed specifically for reading and writing data. It allows you to create custom forms that can display existing inventory records from your Excel file, let users modify them, and automatically save the changes back to the source data.
Format your Excel inventory data as a Table and save it in OneDrive for Business or SharePoint Online. Alternatively, migrate your data to a SharePoint List for better performance.
Go to the Power Apps portal, select 'Create', and choose 'Excel' or 'SharePoint' depending on where your data is stored to automatically generate a standard three-screen app.
Use the EditScreen to allow users to modify existing fields. Power Apps will automatically display the current values when a user selects a specific computer inventory record from the gallery.
Add the Office 365 Users connector to your app and set the default value of your 'Updated By' field to 'User().FullName' to automatically track who made the changes.

Export Responses and Reconcile Manually
If you are restricted to using only Microsoft Forms and Excel, you can collect update requests as new entries and manually merge them into your master inventory workbook.
Manage Your Inventory Spreadsheets with WPS Office
While automated form-to-spreadsheet systems often require complex Microsoft 365 setups like Power Apps, managing and reconciling your exported inventory data is seamless with WPS Office. It provides a highly compatible, free, and lightweight alternative to Microsoft Excel.
- 1. Download and Install: Visit the official WPS Office website and download the free software for your operating system.
- 2. Open Your Inventory File: Launch WPS Spreadsheet and open your existing Microsoft Excel inventory files directly without any formatting loss.
- 3. Analyze and Manage Data: Utilize powerful built-in formulas and data processing tools to reconcile your inventory updates effortlessly.

Frequently Asked Questions
Why doesn't Microsoft Forms update my Excel file automatically?
Microsoft Forms is designed strictly as a one-way data collection tool. It appends new responses as new rows in a connected Excel sheet but lacks the backend database capabilities required to query, display, or overwrite existing records.
Can I use Power Automate to update Excel rows from Microsoft Forms?
Yes, you can create a Power Automate flow that triggers when a new Form response is submitted and uses the 'Update a row' Excel action. However, the Form itself still will not be able to display the existing data to the user before they submit the update.
Does Excel have a built-in data entry form?
Yes. Excel has a built-in Data Form feature that allows you to easily add, edit, search, and navigate through existing rows of data in a table format directly within the spreadsheet environment.
What is the best Microsoft 365 tool for updating existing data collaboratively?
Microsoft Power Apps, particularly when connected to SharePoint Lists or Microsoft Dataverse, is the recommended tool. It allows you to build custom user interfaces capable of reading, editing, and writing back to existing data sources.




