Data Import & Export

Can Microsoft Forms Update Existing Excel Inventory Data?

Adam DavisAdam Davis Nov 2, 2026 871 views

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.

Can Microsoft Forms Update Existing Excel Inventory Data?
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 you start

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.

Solution 1Recommended

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.

1
Prepare your Data Source

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.

2
Create a new Power App

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.

3
Customize the Edit Form

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.

4
Track User Identity

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.

Build an Inventory Management Solution with Power Apps
Dataverse Recommendation: For robust inventory systems, consider using Microsoft Dataverse as your backend data source instead of Excel to avoid file locking issues.
Free Microsoft Office alternative

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. 1. Download and Install: Visit the official WPS Office website and download the free software for your operating system.
  2. 2. Open Your Inventory File: Launch WPS Spreadsheet and open your existing Microsoft Excel inventory files directly without any formatting loss.
  3. 3. Analyze and Manage Data: Utilize powerful built-in formulas and data processing tools to reconcile your inventory updates effortlessly.
Fully compatible with Microsoft Excel (.xlsx, .xls) and CSV formatsFree and lightweight office suite with a familiar, easy-to-use interfaceAdvanced data tools including XLOOKUP, PivotTables, and Data ValidationBuilt-in cloud sync for easy cross-device access to your inventory lists
microsoft office alternative - wps office

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.