Share via

SharePoint - Import Excel table having rows more than 4000 into an Existing list .

Anonymous
2024-04-08T05:50:19+00:00

SharePoint - Import Excel table having rows more than 4000 into an Existing list .

Microsoft 365 and Office | SharePoint | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-04-08T08:41:10+00:00

    Dear Pawar Vishwas.

    Good day!!

    I understand your concern and to my knowledge, I am sorry to convey that there is no existing feature in the SharePoint Online to import the large data into the Excel into the existing SharePoint Online list, where we can use the Edit in Grid View feature to copy and paste the multiple row (such as 50 or 100 rows at once) and paste it into the Edit Grid View as new items.

    I agree with you having the ability to import the large data in the Excel table into the existing SharePoint Online list will benefit the users and I suggest you to add your valuable idea as feedback in the SharePoint · Community (microsoft.com) which is the best place to share our ideas and improve the Microsoft products.

    In addition, I believe you can achieve your requirement with help of custom Power Automate flow. So, I would like to suggest you give a shot by posting your concern in the Microsoft Power Automate Community - Power Platform Community to get the detailed help from the experts.

    Apologies for redirecting you to different community as the members in the category posted focus on the users with the Microsoft 365 concern and have limited knowledge on the Power Automate, so to get the fast and better assistance, we have redirected you in the correct path.

    Appreciate your patience and understanding. Have a great day!!

    Best Regards,
    Sophia

    Was this answer helpful?

    0 comments