SharePoint Document Issues

Automatically Import XLSX or CSV Data Into a SharePoint List

Aamir Naveed AkramAamir Naveed Akram Nov 22, 2026 868 views

Question details

Automatically import data from an exported XLSX or CSV file into a SharePoint Online list, updating existing items or adding new ones.

Automatically Import XLSX or CSV Data Into a SharePoint List
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.
Before you start

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.

Solution 1Recommended

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.

1
Create a scheduled flow

In Power Automate, select Create > Scheduled cloud flow and set the recurrence to match the export schedule.

2
Read the Excel rows

Add the Excel Online (Business) action List rows present in a table. Select the file location, document library if applicable, XLSX file, and table.

3
Find matching list items

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.

4
Create or update each item

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.

5
Test the flow

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 Power Automate to import rows from an Excel table
Rows absent from the export: Creating and updating items does not delete list items missing from the latest file. Full replacement or deletion requires separate, carefully tested logic. For large imports, check pagination settings and connector limits.
Free Microsoft Office alternative

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.

Review and edit source rows before importing them into a SharePoint listOpen and save Microsoft Excel XLSX files for a smoother migrationWork with CSV files used by many data-export toolsUse a familiar spreadsheet interface in a lightweight office suite
microsoft office alternative - wps office

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.