Import excel table into an existing SharePoint list

Terry Chan 206 Reputation points

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.

A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,267 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. CaseyYang-MSFT 10,341 Reputation points

    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.