Excel Add-in to publish and sync Excel tables to SharePoint Online or On Premise Lists

How to Publish an Excel table in SharePoint 2010/2013/O365?
InfoPath alternatives for form designing SharePoint

In this post we will discuss how we can use Excel Add-in which can publish and sync Excel tables to SharePoint Online or to on premise (MOSS 2007/SharePoint 2010/2013) lists.

WSSandExcel (SynchorinizeWSSandExcel.xlam) Add-in : This is used to synchrone Excel tables with SharePoint Lists on SharePoint 2010/2013 and Office 365.

This was originally built for Excel 2007 for WSS/Moss 2007, but the good news is, it works well for SharePoint 2010, SharePoint 2013 and O365

Also you can read:
– SharePoint 2016 Create web application and Site collection using PowerShell

– SharePoint 2013 Online Create site columns using JavaScript Client Object Model and Create Site Column using REST API in SharePoint 2013

– The specified file is not a valid spreadsheet or contains no data to import

You can download the plug-in from Microsoft Site and follow instruction to install the plugin.

How to use this Add-in with Excel 2013?

Spin up the Excel 2013(The usage will be similar for Excel 2007/2010.). Choose this Add-in under options -> Add-ins. You have to enable the Macros for the Add-ins to work.

How to Publish an Excel table in SharePoint 2010/2013/O365?
How to Publish an Excel table in SharePoint 2010/2013/O365?

how to deploy excel add sharepoint add-in

How to Publish an Excel table in SharePoint 2010/2013/O365?

Step-1: Create a table of data in a worksheet and click on Design tab. You can see “Publish and Sync” in the menu bar appearing after installing the Add-in. This is only to create a SharePoint List.

 

how to deploy excel add in sharepoint 2013 powershell
how to deploy excel add in sharepoint 2013 powershell

Step-2: Click on that will bring a dialog box “Export Table to R/W SharePoint List”. For O365 SharePoint do not forget to enter “Description” , other wise the Add-In will fail.

how to deploy excel add in sharepoint add-in
how to deploy excel add in sharepoint add-in

Fill out the details and click on publish. For O365 based SharePoint lists you will be prompted for credentials.

How to published an Office Add-In to SharePoint for use with Excel Web App
How to published an Office Add-In to SharePoint for use with Excel Web App

How to use this Add-in to Sync data from SharePoint to Excel and Vice Versa?

After adding a List Item, go the excel worksheet -> right click on the Table data -> Table >Click on Synchronize with SharePoint. You can see the newly added/edited list item in your excel table.

 

Excel Add-in to publish sharepoint online
Excel Add-in to publish sharepoint online

You can also add/edit items in the excel table and synchronize with SharePoint by following the same procedure given above. This Add-in greatly helps in quickly creating a SharePoint List , but there are some limitations as well.

Saving the Excel:
The Excel sheet has to be saved as in Excel 97 – 2003 Workbook(*.xls) format. If you save it other formats, you will not be able to sync the list items as “Synchronize with SharePoint” option will not appear.

Deploy and publish your Office Add-in
Deploy and publish your Office Add-in

Deploy and publish your Office Add-in

Hope this will be helpful.

Similar SharePoint 2013 Tutorials


Leave a Reply