synchronizing Excel 2013 sheet with SharePoint Lists

Question

How I can synchronizing Excel 2013 sheet with SharePoint Lists and vice a verse.

Sumit Deshmukh · 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

Mohamed Elqassas Mvp · Answer

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

Manpreet Singh · Answer

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]