Automatically Import XLSX or CSV Data Into a SharePoint List
Question details
Automatically import data from an exported XLSX or CSV file into a SharePoint Online list, updating existing items or adding new ones.

- Product
- SharePoint Online
- Device & OS
- not provided
- Scenario
- Another application exports a spreadsheet or CSV file that needs to populate a SharePoint list on an ongoing basis.
- Observed behavior
- The desired outcome is a list that reflects the imported rows without creating duplicate items.
Identify a stable unique ID in the source data and create matching columns in the SharePoint list. For Power Automate, store the XLSX file in an accessible SharePoint document library or OneDrive for Business and format its data as an Excel table.
Use Power Automate to import rows from an Excel table
Use a scheduled flow to create or update SharePoint list items from an XLSX file.
This approach processes an Excel table, not an arbitrary worksheet range. Choose a schedule that runs after the exporting application has finished writing the file.
In Power Automate, select Create > Scheduled cloud flow and set the recurrence to match the export schedule.
Add the Excel Online (Business) action List rows present in a table. Select the file location, document library if applicable, XLSX file, and table.
Inside Apply to each for the Excel rows, add the SharePoint Get items action. Select the site and list, then use Filter Query to match the source row's unique ID to the corresponding SharePoint column.
Add a Condition to check whether Get items returned a match. If none is found, use SharePoint Create item; if exactly one is found, use Update item with its SharePoint item ID. Map the source fields to the list columns and handle multiple matches as an error.
Select Test, run the flow against a sample export, and check the SharePoint list for both new and updated items. Review the flow's run history for errors.

Use a scheduled script for CSV or custom imports
Use a script or custom integration when the source is CSV or the import requires more control.
Prepare SharePoint Import Files With WPS Spreadsheets
WPS Office is a free, lightweight Office alternative with a familiar interface for reviewing and editing spreadsheet data. Its Microsoft Office format compatibility makes it easy to work with existing files; SharePoint synchronization still requires Power Automate or another integration.

Frequently Asked Questions
Can SharePoint automatically synchronize a list with an XLSX or CSV file by itself?
SharePoint Online does not provide an out-of-the-box continuous synchronization between a list and an exported XLSX or CSV file. Use a Power Automate flow, script, or other integration to read the file and write list items.
How do I prevent duplicate items during an import?
Include a stable unique ID in the export and a corresponding column in the list. Before creating an item, use SharePoint Get items with a Filter Query for that ID; update the existing item if exactly one match is found.
Can the Excel Online action read a CSV file directly?
The List rows present in a table action reads an Excel table in a supported workbook, not a CSV file directly. Convert the CSV data to an XLSX table or use a CSV parser in a script or another suitable integration.
Will the flow remove list items that are no longer in the export?
Not with create-and-update steps alone. Add separate comparison and deletion logic if the list must mirror the latest export, and test that logic carefully before using it on production data.




