I'm trying to synchronize data between a SharePoint list and Excel, and keep both sets of data up-to-date.

Data in excel get updated I want to update list and vice versa. I have SharePoint 2013 and Office 2013 installed on my local system. I want to active this OOTB task .

please help me with this.

1 Answer 1


You specify you want this OOTB, but this is not possible out of the box since 2007, as Microsoft deprecated this feature (ability to sync bi-directionnaly a SharePoint list with an Excel file). OOTB Options include creating a new SP list from an Excel file and exporting a list to an Excel file.

To keep both data sets up to date, you need a third party tool such as SharePoint List Synchronizer. Disclaimer: this product is edited by SoftFluent, my employer.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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