Add new data from MS Excel to an existing sharepoint list by import

Question

Hi,

I have an existing SharePoint list with various categories of data (with multiple columns and rows) and I need to update different categories of data, e.g. I filter category A and paste data from MS Excel sheet under the filtered category; then I do the same with category B, C, etc. I would like to know how to do that automatically so the new or modified data is added automatically at the end of the list in appropriate categories, which I filter in the SharePoint list. (So far the only automated process of importing data I could find is how to do that in a completely new SP list; whereas I need to do that with an already existing list).

Please help.

Kamil

Answer 1

Because O365 is a collection of disparate software that is not properly integrated, this isn't possible out of the box. We are forced to use Access as a bridge, because it does sync up with a SP list. There's an append action in Access that allows you to import data from Excel to an exisitng database, and in turn Access updates the list. Clumsy and awkward but it's the best this service offers.

Answer 2

Hi Kamil_YU,

It is not feasible to add new data from Microsoft Excel to an existing SharePoint list by importing to SharePoint list. To sync a SharePoint list with a Excel, we need to export the list to Excel via the Export to Excel feature. After updating the data in Excel, click Design > Export > Export Tables to SharePoint list. With this way, we can only export it to a new SharePoint list. More information can be found in the article:Synchronize a SharePoint list with a Excel 

If you would like to update the data in an existing SharePoint list, I would suggest you use the Quite Edit feature in SharePoint. Click LIST > Quick Edit. Then, filter the data and update them as below:

  

Thanks for your understanding. 

Shirley

Answer 3

That is what I know but don't love. Thank you for answering and confirming my fears :).

Answer 4

Hi,

Thank you for this interesting approach. I will try it out. If it turns out to be more efficient and effective than what I am doing now then it sure is worth using it and perhaps optimising in the future.