Welcome to deBUG.to Community where you can ask questions and receive answers from Microsoft MVPs and other experts in our community.
0 like 0 dislike
343 views
in SharePoint by 18 22 32
I'm aware that we can create a new list by importing data from a spreadsheet into a SharePoint list. However, I need to bulk add items to an existing list in SharePoint from Excel or CSV instead of adding each item individually. Is this possible?

1 Answer

2 like 0 dislike
by 159 188 375
selected by
 
Best answer

Is it possible to bulk add items to an existing SharePoint list?

Unfortunately, it's not possible to directly import items from an Excel or CSV file into an existing SharePoint list.

Instead, you can utilize the "Quick Edit" feature to edit your list in grid view.

Edit in Grid view in SharePoint online

From there, you can copy your items from Excel and paste them into the grid view.

Add multiple items in SharePoint existing list

However, please note that this method may not work with lookup fields.

Alternatively, you can use Power Automate or PowerShell script to bulk add items to an existing SharePoint list.

If you don’t ask, the answer is always NO!
...