All Connectors ⋅ Microsoft Excel Add-in Microsoft Excel Add-in Supports:Microsoft Excel 2003 -2016 3 Minute Video View Live Demo Microsoft Excel Add-in Overview Frequently Asked Questions Overview The Excel Add-in SmartConnect has a free Excel add-in for use by all clients. The Excel add-in provides a number of great features for enhancing Excel integrations through SmartConnect. Push integrations from within Excel: The Excel add-in allows you to execute an integration right from the Excel Menu bar. Simply enter your data into your defined format and hit “send to SmartConnect.” The Excel add-in lets you retrieve data from a data source right into Excel through the ‘Get Data’ function. This means if you need an opportunity to interact with your data before completing an integration, you can. Pull data from your favorite cloud app (for example timelyapp.com) and view those timesheets in Excel, update them if you need to, then push them into Xero or NAV to create invoices based on those timesheets. The 'Get Columns' function will automatically build a data template for you in Excel – based upon a prebuilt map. Add Some VBA For those Excel gurus out there you can build a very complex worksheet that meets your specific formatting needs, and then add a button to that screen that will call a SmartConnect map from behind that button. This ensures SmartConnect is invisible to the end user and fits in tightly with your specific business process. In the same way, any developer can call a SmartConnect map (via our web service) from their custom code on any website or customer software solution. Frequently Asked Questions We're here to help. See SmartConnect In Action by Attending a Weekly Webinar. View Webinar Schedule FREE EBOOK DOWNLOADThe 10 Commandments of Data Integration READ IT NOW CONNECT EXCEL TO ALL OF YOUR BUSINESS APPS See how SmartConnect gets Excel working together with other platforms including: Salesforce CRM Dynamics CRM Xero Cloud ERP Dynamics NAV Web Services Database (ODBC) Microsoft SQL Flat File / Folder Dynamics GP View All Connectors Free 30 Day Trial Get Started Now © 2016 SmartConnect by eOne Solutions. All Rights Reserved.