synchronizing Excel 2013 sheet with SharePoint Lists

Sumit Deshmukh9y ago

Accepted answer

Hi Yogendra,

There are several way to synchronizing Excel 2013 sheet with SharePoint Lists, Please do refer below links.

http://www.sharepointdiary.com/2012/05/synchronize-between-sharepoint-list-and-excel.html

http://www.nothingbutsharepoint.com/2012/10/29/how-to-use-microsoft-excel-to-query-a-sharepoint-list-aspx-2/

It may help to reach the goal.

Thanks,

Sumit

+4

Mohamed Elqassas9y ago

There are several ways to synchronize data between a SharePoint list and Excel. Whichever way you choose, this synchronization is one-way, or unidirectional. Changes made in the SharePoint list can be written to Excel, but any changes that you make in Excel are not automatically written to the SharePoint list.

For more details https://support.office.com/en-gb/article/Synchronize-a-SharePoint-list-with-a-Excel-bfb2ea48-6118-4fa9-abb6-cced9424e5d9?ui=en-US&rs=en-GB&ad=GB&fromAR=1

+3

Manpreet Singh9y ago

Hi Yogendra,

You can use the "Export to excel" option and have a sync option of the list and excel everytime.

Cheers,

Manpreet

[Microsoft MVP]

+4