Migrate data from Excel to SharePoint
Step 1: Prepare Your Data
- First thing you need is Excel file ready
- Ensure your data is formatted as a table in Excel.
- Remove unnecessary columns and ensure headers are correctly labeled.
Note:
For the Demo purpose, I will be using tbl_Product_5000 Excel, you can download and practice along side.
Step 2: Go to SharePoint Online
- Navigate to your SharePoint site where you want to create the list.
- Navigate to Site Content
- Click on New → List and select Import From: Excel.
Note:
For the Demo purpose, I will be using tbl_Product_5000 Excel, you can download and practice along side.
Step 3: Upload the Excel File
Select the Excel file you prepared earlier.
Note: The data in Excel table should not Exceed 5000 records.
SharePoint will analyze the file and display available columns.
Step 4: Map Columns & Create the List
- If Excel has one more than 1 Table, select the appropriate table (In my case it is Table2)
- Ensure each column is correctly mapped to the appropriate data type (Single Line Text, Multi Line Text, Number, Choice, etc.).
- Click on Next
- Give the List name to the List and click Create to finalize the list.
Process Completed, your data will get migrate in some time.
Are there any other methods to Migrate Data from Excel to SharePoint List?
Yes, there are 2 more ways
Copy-Paste Data into a SharePoint List
Create a New SharePoint List
Go to your SharePoint site and create a blank list with matching column names.
Open the List in Grid View
Click Edit in Grid View to enable bulk editing.
Copy & Paste Data from Excel
Select your Excel data, copy it (
Ctrl + C), and paste it into the SharePoint list (Ctrl + V).Ensure the data aligns correctly with the columns.
Save & Exit Grid View
Click Exit Grid View to finalize the import.
Using Power Automate for Automated Import
Create a Power Automate Flow
Open Power Automate and create a new flow.
Use the “When a file is created in OneDrive” trigger (or manually select an Excel file).
Extract Data from Excel
Use the “List rows present in a table” action to read Excel data.
Insert Data into SharePoint List
Use the “Create item” action to add each row to the SharePoint list.
Map Excel columns to SharePoint fields.
Test & Run the Flow
Save and test the flow to ensure data imports correctly.
[…] Confused how to import data from Excel to SharePoint? – Click here […]