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 […]