Skip to content


Tech Tuesday: Difference between Excel Add-In and the Excel Template

Yes, there is a difference. Many times, we see users download our Excel Template and try to use the Excel Add-In to send data their destination. Unless some setting changes are made within the Excel Workbook, this will not work successfully.

Both methods are version neutral with SmartConnect so you can use all templates, and add-ins with any version of SmartConnect.
Both methods use web services you need to install on an IIS server. Both require the SmartConnect WCF service.

Excel Templates

eOne has created a set of Excel Templates that are basically Excel files that allow for simple data entry for Dynamics GP transactions. These templates use VBA code in the background and submit to SmartConnect using the SmartConnect WCF service. This is the only web service that can be used for the Excel Templates.
*If you are using the templates for Dynamics NAV/Business Central, refer to our documentation for those templates. They are setup differently than the GP templates compared here.

On the  templates you click the SUBMIT button on the worksheet to run the map, as shown below.

The SmartConnect WCF service will typically have a url of http://myserver:5557/SmartConnect.svc The server would be where the SmartConnect web service has been installed and uses the default port of 5557.

Any version of Excel, which supports Excel Macro-Enabled Workbooks, can be used for the Excel Templates.

Configuration Sheet

There is a hidden worksheet that contains the configuration information. This needs to be filled out initially before being used.


Excel Add-In

eOne has created an Excel Add-In that allows for any pre-defined Excel file, where data is in consistent rows of the same number of columns, to submit data to SmartConnect using the SmartConnect WCF web service. The SmartConnect WCF web service will typically have a URL of http://myserver:5557/smartconnect.svc. The server would be where the SmartConnect web service has been installed and uses the default port of 5557.

On the Excel Add-in you click the Run Map button to run the map, as shown below.

There are different versions of the Excel Add-In that were created for different versions of Excel.

Configuration Sheet

Like the Excel Template, there is a hidden worksheet that contains the configuration information.


The chart below highlights the difference between the two products

Excel Template

Excel Add-in

Pre-defined Excel File

User defined Excel file

Map is already provided

User created map

Cannot be modified

Can be changed as needed (may require map changes)

One version of template for all versions of Excel and SmartConnect

Versions (2010, 2013, 2016) based on your version of Excel.

Why would I choose the Template instead of the Add-in?

The templates are restricted compared to the add-in, but as long as they meet your needs they will be easier to implement. They won’t require the anything be installed on work stations, and the map is already created for you.

Common Errors

The primary issue you will encounter when trying to use the Excel templates with the add-in is the configuration sheet for the template will be overwritten with the details from the add-in which make them invalid. You will see the below errors.

The parameter is incorrect

System error: -2147012890

The only way to correct this is to start over with a new version of the template, and do not use any features in the add-in.

Leave a Comment


Accessing Your Historical Dynamics NAV Data in D365 Business Central - Part 1: Getting Started
2023 Migration from Dynamics GP to D365 Business Central Training
eOne Welcomes Incremental Group as a New eOne iPaaS Integration Partner
Employee Spotlight: Floyd Jones, Front End Developer
NEW WEBINAR: Popdock Onboarding - Fall in Love with Your Data


2016 SmartConnect Integration Bootcamps
Tech Tues: Automatically refreshing Pivot Tables in Excel Refreshable Reports
Happy Thanksgiving from the eOne team!
2017 SmartConnect Integration Bootcamps
New Releases of Extender and SmartList Builder



Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships Partner All Hands Call Popdock promotions release SalesForce SmartConnect SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.