4

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)

4

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 '15 at 12:30
  • then i think you should look 3rd party tools for it. – Waqas Sarwar MVP May 15 '15 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 '17 at 21:27
  • I am sorry, i have no idea about the Adodb. – Waqas Sarwar MVP Feb 6 '17 at 21:29

protected by Community Mar 15 '17 at 22:42

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).

Would you like to answer one of these unanswered questions instead?

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