How to Import Excel Data into Existing SharePoint List

Manasa 0 Reputation points
2024-11-04T12:01:21.5+00:00

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?

SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
3,112 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. RaytheonXie_MSFT 36,576 Reputation points Microsoft Vendor
    2024-11-05T02:25:42.89+00:00

    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.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.