Import excel table into an existing SharePoint list

Terry Chan 206 Reputation points
2022-04-22T01:13:29.347+00:00

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.

SharePoint
SharePoint
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
    2022-04-22T08:54:42.437+00:00

    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

    195542-1.jpg

    2.Type your site address > Type list name

    195495-2.jpg


    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.