I have to update sharepoint 2013 list with data from excel sheets. Here, 2 excel sheets are being used. I need to update 2 columns of SharePoint list taking column A from one excel book and the other column from another excel book. My client doesn't allow visual studio coding. Is this possible? or atleast updating SharePoint list by taking only selective data (only 2 columns from entire data) from 1 excel book.

  • You can use CSOM/JSOM in a script Editor web part & to read excel & update SPList in your site. Dec 27 '15 at 11:51
  • Another approach is to use powershell for loading the excel spreadsheet contents into a variable ,then access site,spweb, SPList objects & insert the above spreadsheet contents-variable into the SPList items. Ref. podlisk.wordpress.com/2011/11/20/… Dec 27 '15 at 12:34

The ability to synchronize the data between a table and a list in Microsoft Windows SharePoint Services is deprecated.

for more info checkout msdn article MSDN link here!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.