SharePoint Document Issues

How to Import CSV Data into an Existing SharePoint List

Olivia Miller Oct 15, 2026 869 views

Question details

The user needs to import data from a CSV file into a SharePoint list that already exists.

How to Import CSV Data into an Existing SharePoint List

Product: SharePoint / Power Automate
Device & OS: not provided
Scenario: Appending new records or updating existing entries in a SharePoint list using data sourced from an external CSV file.
Observed behavior: SharePoint lacks a direct, native import option for adding CSV data to existing lists, requiring custom solutions like Power Automate to parse the file and map the fields.

Before you start

Ensure your CSV file is properly formatted with headers that exactly match your existing SharePoint list columns, and save it to a cloud location accessible by Power Automate (such as OneDrive or a SharePoint document library).

Solution 1Recommended

Use Power Automate to Parse and Import the CSV

Create an automated workflow in Power Automate to read the CSV file, parse the rows, and create new items in your existing SharePoint list.

Since SharePoint does not natively support direct CSV imports to existing lists, Microsoft Power Automate is the standard tool to bridge this gap. This method requires some familiarity with flow creation and data parsing.

Upload the CSV File

Place your source CSV file into a SharePoint Document Library or your OneDrive for Business.

Create a New Flow

Log into Power Automate, click 'Create' on the left sidebar, and select 'Instant cloud flow' to trigger the import manually.

Retrieve File Content

Add the 'Get file content' action (using the OneDrive or SharePoint connector depending on where you saved it) and select your CSV file.

Parse the CSV Data

Use a CSV parsing action or advanced expression combinations (like split functions) to convert the raw CSV text into a JSON array that Power Automate can read.

Map to SharePoint Fields

Add an 'Apply to each' control to loop through the parsed array. Inside the loop, add the 'SharePoint - Create item' action, select your target list, and map the parsed CSV fields to the corresponding SharePoint columns.

Use Power Automate to Parse and Import the CSV

Simplifying the Process with Excel: Parsing raw CSV files in Power Automate can be complex. If you convert your CSV into an Excel file and format the data as a Table, you can use the 'List rows present in a table' action, which automatically parses columns and is much easier to map.

Solution 2

Consult the Power Automate Community for Advanced Scenarios

If you need to update existing records (rather than just append new ones) or have complex data structures, leverage pre-built templates from the community.

Free Microsoft Office alternative

Prepare and Clean Your CSV Data with WPS Office

Before importing data into SharePoint via Power Automate, it is highly recommended to clean and format your CSV files. WPS Office is a lightweight, fully compatible, and free alternative to Microsoft Office. It offers a powerful Spreadsheet tool to easily edit, filter, and convert your raw CSV data into an Excel Table, making the SharePoint import process significantly easier and preventing flow errors.

Fully compatible with Microsoft Excel formats, including .xlsx, .csv, and .xls.Lightweight architecture ensures fast opening and editing of large CSV datasets.Advanced data cleaning tools like duplicate removal and text-to-columns.Free to use across Windows, Mac, Linux, iOS, and Android.

microsoft office alternative - wps office

Frequently Asked Questions

Can I import a CSV directly into SharePoint without using Power Automate?

SharePoint allows you to create a brand-new list by importing an Excel file or CSV from the modern UI. However, it does not offer a native 'Import' button to append CSV data directly into an list that already exists. For existing lists, you must use Power Automate, PowerShell scripts, or Microsoft Access as a bridge.

Why is it recommended to convert my CSV to an Excel Table before importing?

Power Automate features a dedicated 'List rows present in a table' action for Excel files. This action automatically reads the table headers and provides them as dynamic content for easy mapping. CSV files, on the other hand, require complex manual string parsing (using split functions) or premium third-party connectors to achieve the same result.

How do I prevent duplicate entries when importing my CSV into SharePoint?

To handle duplicates, your Power Automate flow must first use a 'Get items' action with an OData filter query to check if a record with the same unique ID already exists in the SharePoint list. Then, use a Condition control: if the item exists, use the 'Update item' action; if it does not, use the 'Create item' action.

Document & File Issues