How to Import Excel Data into Existing SharePoint List

Question

We have a SharePoint(2013) list called Stakeholder Analysis, and we would like to import bulk data from Excel into the existing SharePoint list without using Power Automate flow and manual update(copy/paste). Can anyone help us?

Answer 1

Hi @Manasa,

You could follow the steps to import the excel data to sharepoint

• In Excel spreadsheet, select the data range and Format it as a Table
• While still in Excel, highlight the table, then choose Export from the top ribbon, then Export Table to SharePoint list
• From the pop-up that appears, specify the URL of the site you are importing to, then give the list a name, then hit Next. You can also (optionally) check the box next to Create a read-only connection to the new SharePoint list. What it does is make your Excel physically linked to SharePoint list. Any changes in the SharePoint list will propagate down to Excel when you refresh the data there.
• On the next screen, you will see all the columns with corresponding recognized column types (Currency, Date, etc.). Just click Finish
• You should be getting a success message/pop-up
• You should now see your list created in SharePoint. It will default to Datasheet view, just click Stop to view it as a normal list

For details steps please refer the below article :

https://www.beyondintranet.com/blog/how-to-export-and-import-excel-to-sharepoint-list/

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.