Import excel table into an existing SharePoint list

Question

Is there way to import excel table into an existing SharePoint list instead of copy and paste in grid view? It can only copy a limited number of records at one time. When the number of record is large, it is cumbersome and not reliable.

Answer 1

Hi @Terry Chan ,

You could use "Export Table to SharePoint list" option to import excel table into an existing SharePoint list.

1.Select table > Design > Export > Export Table to SharePoint list

2.Type your site address > Type list name

---

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.