Can we publish and synchronize excel 2013 table as SharePoint list. I understand that using export to excel functionality and using data connection changes in the list gets reflected in the excel. But wanted to check is it possible the other way (changes made in excel to list)

1 Answer 1


Yes, You can do it.But for a two-way synchronization you have to download a free Add-In from Microsoft. With this tool you have to create a list in Excel, publish it to a SharePoint list and synchronize with it.

Once you install it, then you should now see under the Design tab a SharePoint section with a button called Publish and allow sync. Please follow the below blogs for complete step by step process. Connecting an Excel Sheet to SharePoint

Note: even this is 2007 add in but works in 2013. You may need to restart you PC after add-in installation.

  • Thanks for the response, I tried the add-in and found few limitations.1. File has to be saved as 97-2003 file 2. Columns cannot be created in excel once the excel is published as list (new columns cannot be published to list) 3. formulas columns in excel become single line of text in the list 4. Doesn't work for excel with macros. So I wanted to check if there is any other alternative to this.
    – Mee
    May 15, 2015 at 12:30
  • then i think you should look 3rd party tools for it.
    – Waqas Sarwar MVP
    May 15, 2015 at 13:10
  • I know this is an old thread, but is there a way to accomplish this perhaps by using adodb?
    – William
    Feb 6, 2017 at 21:27
  • I am sorry, i have no idea about the Adodb.
    – Waqas Sarwar MVP
    Feb 6, 2017 at 21:29

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