Import multiple items from Excel file to existing Sharepoint list

Question

You can only use excel files to create a new Sharepoint list, but we cannot find the option to let you add items from Excel file to a existing list. We add some new items in Excel file every days, we want import new added items from Excel file to list at one time every day. I searched online, I saw engineers suggest use power automate, but I am not familiar with power automate, it’s difficult to study and mange flow, so I want to avoid such way, could you provide any suggestions without power automate?

Answer 1

Hi Joseph,

Thank you for querying in this forum.

From your description, it seems that you want to bulk import items from Excel file into SharePoint existing list. And you also don’t want to use Microsoft Power Automate.

If my understanding is right, we’re afraid that there is no out of box way to achieve your requirement directly.

We’re sorry that it doesn’t meet your requirement, we do understand the inconvenience caused and apologize for it.

To address your concern, we’d suggest you go to SharePoint Feedback community to provide your feedback or vote this feedback: Two-Way-Sync between SharePoint and Excel · Community (microsoft.com). This is the best platform to let us hear from you and make our products and services better for you and others.

At the same time, for a workaround, we’d suggest you use the steps below and hope that will help you:

1. You can copy the SharePoint list URL and paste into Internet Explorer and sign in account.
2. Then you can open the Excel worksheet, select the data and press Ctrl + C. As shown below:
3. Then you can go to SharePoint list > click Return to Classic experience > click List > Quick Edit > you need to navigate to the bottom of the list to add items to the end. However, DO NOT click into the last box at the bottom of the list; pasting at that point will not work properly. Instead, use the keyboard navigation keys to go to the bottom (empty) item. As shown below:
4. Then you can press Ctrl + V to paste values, click Allow when you encounter the window below:

Note: you need to keep the same column in Excel file and SharePoint list.

If the scenario above is not consistent with yours, you can also post back and point that.

Your understanding and patience will be highly appreciated. I hope that you are keeping safe and well!

Best Regards,

Sukie