Connect Microsoft Excel to (cloud) data sources

The following data sources are available as cloud and database data for real-time access within Microsoft Excel using Invantive Control for Excel. The pre-defined Excel formulas varies per data source from generic Excel formulas for data exchange and securing the data, to hundreds of Microsoft Excel formulas matching the business-logic of a cloud software solution. Custom Excel formulas for data exchange can easily be added using Visual Basic for Applications. Just log on to refresh data from Excel formulas in real-time. Multiple different data sources can jointly be accessed in real-time. Both database data as well as cloud data and file data can be used as source for any data source. Scalability from small to large enterprises is provided through the solid foundation on Invantive UniversalSQL, including the availability of many complex data filters, and advanced models in the model repository integrated into each Microsoft Excel workbook.

• ActiveCampaign Excel Add-in

  ActiveCampaign is cloud software to automate the marketing, sales and support process of prospects, leads and customers. ActiveCampaign includes email campaigns, sales management, website integration, chat and advanced automatic workflows.

  The ActiveCampaign Excel Add-in connector provides access to 66 tables of data.

• AFAS Profit Excel Add-in

  Also known by the name: AFAS Online.

  AFAS Online is online accounting, ERP and payrolling software for Dutch companies. AFAS Online has approximately 15.000 customers, including most of the top 30 accounting firms in the Netherlands. AFAS Online is the cloud version of the AFAS Profit business software. AFAS Online runs on a hosted Windows remote desktop session - similar to AFAS Profit - providing easy access to large volumes of business data. AFAS can manage hundreds of companies per environment.

  Tables accessible with the AFAS Profit Excel Add-in connector.

• Autotask Excel Add-in

  Also known by the name: Datto.

  Autotask is cloud software for IT business management. Autotask covers traditional ITIL processes as well as more recently introduced methods.

  The Autotask Excel Add-in connector provides access to 3,396 tables of data.

• Bouw7 Excel Add-in

  Also known by the name: Exact Online Bouw.

  Bouw7 is a cloud solution for construction companies. Bouw7 is also known as "Exact Online Bouw" and integrates into Exact Online. Bouw7 also provides service and maintenance modules, plus CRM functionality.

  The Bouw7 Excel Add-in connector provides access to 222 tables of data.

• Brevo Excel Add-in

  Also known by the name: Sendinblue.

  Brevo is cloud software to automate the marketing, sales and support process of prospects, leads and customers. Brevo includes email and SMS campaigns, sales management, website integration, chat, chat, tracking and advanced automatic workflows.

  The Brevo Excel Add-in connector provides access to 84 tables of data.

• Calendly Excel Add-in

  Calendly provides online scheduling of appointments using customizable workflows.

• Cbs.nl Excel Add-in

  Also known by the name: Centraal Bureau voor de Statistiek.

  All published data sets from cbs.nl and "informatie voor derden" published by cbs.nl.

• Chargebee Excel Add-in

  Chargebee is subscription billing software in the cloud for SAAS providers. It covers billing, subscription management and auto invoicing. Chargebee is used by over 2000 SaaS companies.

  The Chargebee Excel Add-in connector provides access to 75 tables of data.

• Company.info Excel Add-in

  Also known by the name: Webservices.nl.

  Company.info are Dutch online software services for a large number of data-related tasks such as credit checks and accessing public registers such as Ultimate Beneficiary Owner ("UBO").

  The Company.info Excel Add-in connector provides access to 295 tables of data.

• Crisp Excel Add-in

  Crisp is online software for customer experience, including multi-channel chat, CRM, knowledge base and email campaigns.

• CSV Excel Add-in

  Also known by the name: Comma-separated Values.

  Comma-separated values ("CSV") is a text format for data. A CSV file typically stores data elements separated by a comma. The CSV file format is defined by RFC 4180.

• Data Dictionary Excel Add-in

  Data dictionary provides real-time access to the metadata on the current database and environment.

  The Data Dictionary Excel Add-in connector provides access to 76 tables of data.

• Discourse Excel Add-in

  Discourse is a cloud forum and mailing list management software application. Discourse can be used to increase community co-operation. The source is available as open source. Discourse runs for over 1,500 companies.

  Tables accessible with the Discourse Excel Add-in.

• DocumentCloud.org Excel Add-in

  DocumentCloud is an online archive of documents collected mostly by journalists.

  The DocumentCloud.org Excel Add-in connector provides access to 6 tables of data.

• Dropbox Excel Add-in

  Dropbox is an online file storage service with integrated collaboration features. It integrates into many platforms such as Windows and MacOS.

  Tables accessible with the Dropbox Excel Add-in connector.

• Dummy Excel Add-in

  Dummy is a sample database. The dummy contains data for English project-based companies. The data is relatively small in size and provides fast access due to an in-memory storage.

  The Dummy Excel Add-in connector provides access to 35 tables of data.

• Easyflex Excel Add-in

  Easyflex is Dutch online software for employment agencies. Easyflex provides timesheet registration and approval, payrolling as well as HR functionality.

  The Easyflex Excel Add-in connector provides access to 150 tables of data.

• ECB Exchange Rates Excel Add-in

  The ECB Exchange Rates provides 90 days of history on exchange rates against the European Euro as established daily by the European Central Bank.

  The ECB Exchange Rates Excel Add-in connector provides access to 2 tables of data.

• EDIFACT Excel Add-in

  EDIFACT (Electronic Data Interchange for Administration, Commerce, and Transport) is an international standard for electronic data exchange, using structured text files to transmit business documents like invoices.

  Tables accessible with the EDIFACT Excel Add-in connector.

• Exact Online Excel Add-in

  Exact Online is cloud software for accounting and ERP. In the Netherlands, Exact Online also includes online payrolling software. It is used for approximately 400.000 companies.

  The Exact Online Excel Add-in connector provides access to 1,221 tables of data.

• EZ-Base Excel Add-in

  EZ-Base is a standardized file format used for exchanging product data, commonly in the construction and installation sectors, ensuring uniform structure for specifications, pricing, and descriptions.

  The EZ-Base Excel Add-in connector provides access to 42 tables of data.

• Facebook Excel Add-in

  Facebook is an online social network consisting of social activity by users as well as advertorials by campaigners.

  Tables accessible with the Facebook Excel Add-in connector.

• Fortnox Excel Add-in

  Fortnox ERP system provides cloud-based tools for accounting, invoicing, payroll, and inventory management, enabling small businesses to automate processes efficiently.

• Freshdesk Excel Add-in

  Freshdesk is a cloud solution for customer management. Freshdesk includes CRM as well as tickets. Existing functionality of Freshdesk can be extended by custom fields.

  The Freshdesk Excel Add-in connector provides access to 78 tables of data.

• FTP Excel Add-in

  FTP (File Transfer Protocol) is a standard network protocol used to transfer files between a client and server over the internet or a local network, supporting both uploading and downloading.

  The FTP Excel Add-in connector provides access to 3 tables of data.

• GitHub Excel Add-in

  GitHub is online software management software. GitHub includes GIT for version management, issue tracking and automated builds.

• GitLab Excel Add-in

  GitLab is online software management software. GitLab includes GIT for version management, issue tracking and automated builds.

• Gripp CRM Excel Add-in

  Gripp CRM is a cloud solution for customer management. Gripp includes CRM as well as projects, timesheets and workflows. Gripp can be extended by defining free fields on organizations, contracts, projects and other tables.

  The Gripp CRM Excel Add-in connector provides access to 92 tables of data.

• Horeko Excel Add-in

  Horeko is online software for hospitality, including scheduling and time management, recipe management and HACCP. Horeko is available in the Benelux.

  The Horeko Excel Add-in connector provides access to 163 tables of data.

• HTML Excel Add-in

  HTML is a file format for information intended for human consumption. It includes text elements as well as graphical elements.

• HubSpot Excel Add-in

  HubSpot is cloud-based marketing, sales, CRM and service software. HubSpot is used by over 150.000 companies.

  The HubSpot Excel Add-in connector provides access to 215 tables of data.

• IBM DB2 UDB Excel Add-in

  IBM DB2/UDB is a traditional database platform accessible through an ANSI SQL dialect.

• Invantive Data Replicator Excel Add-in

  Data Replicator caches data retrieved from data container as versioned partitions in a relational database.

  The Invantive Data Replicator Excel Add-in connector provides access to 18 tables of data.

• ionProjects Excel Add-in

  Also known by the name: ionBiz.

  ionProjects is a cloud solution for project management. ionProjects focuses ICT, engineering and consultancy organization providing project management, resource planning, time registration and ticketing.

  The ionProjects Excel Add-in connector provides access to 541 tables of data.

• JIRA Excel Add-in

  Also known by the name: JIRA Cloud.

  Jira is cloud software for managing business processes and sharing knowledge. Jira Cloud offers tickets and customized workflows. Jira Service Desk extends those by integration of external parties in business processes, such as service desk customers. Confluence is online collaboration software for sharing knowledge.

  The JIRA Excel Add-in connector provides access to 133 tables of data.

• JSON Excel Add-in

  JSON is a file format based upon JavaScript. A JSON file consists of a key names and their values. Lists of keys can be combined in groups using arrays.

• Kadaster Excel Add-in

  The Dutch Kadaster is a public register of spatial data of the Netherlands. It bundles land, housing and infrastructure data in structured and graphical formats.

  The Kadaster Excel Add-in connector provides access to 4 tables of data.

• KeePass Excel Add-in

  KeePass is a free, open-source password manager that securely stores usernames, passwords, and other sensitive information in an encrypted database, accessible through a master password or key.

  The KeePass Excel Add-in connector provides access to 7 tables of data.

• Knack Excel Add-in

  Knack is software to create online databases without coding.

  Tables accessible with the Knack Excel Add-in connector.

• Localazy Excel Add-in

  Localazy is online localization software for use by teams. The localization processes is supported by Computer Aided Translation (CAT) and machine translation.

  The Localazy Excel Add-in connector provides access to 43 tables of data.

• Logius COR Excel Add-in

  Logius COR provides all issued Organisation Identification Numbers (OIN). Governmental and general interest organizations that exchange digital information using Digikoppeling Standaard can be assigned an OIN.

  Tables accessible with the Logius COR Excel Add-in connector.

• Loket.nl (REST) Excel Add-in

  This connector is running out

  Loket.nl is online payroll software. Payrolling and HR are offered according to Dutch legislation. Loket.nl is used both by accounting firms as well as entrepreneurs.

  The Loket.nl (REST) Excel Add-in connector provides access to 609 tables of data.

• Mail Excel Add-in

  Mail allows applications enabling sending of email data using SQL queries.

  The Mail Excel Add-in connector provides access to 1 tables of data.

• Mendix Excel Add-in

  Mendix is a software platform for cloud applications. Based upon business logic, Mendix enables cost-effective deployment of business functionality on the web.

• Microsoft Excel Excel Add-in

  Microsoft Excel is an Office application which supports the XLSX file format for spreadsheets.

• Microsoft Graph Excel Add-in

  Microsoft Graph is an API platform that provides access to Microsoft 365 services and data, allowing developers to interact with resources like emails, files, users, and calendars across Microsoft’s cloud ecosystem.

• Minox Excel Add-in

  Minox is an online accounting package used in the Netherlands by entrepreneurs and accounting professionals.

  The Minox Excel Add-in connector provides access to 138 tables of data.

• Mollie Excel Add-in

  Mollie is an online payment service provider. Mollie ensures that the monetary transfer for a service is handled correctly globally.

  The Mollie Excel Add-in connector provides access to 17 tables of data.

• MySQL Excel Add-in

  MySQL is a traditional database platform which supports ANSI SQL. MySQL is often used for small web applications.

  Tables accessible with the MySQL Excel Add-in connector.

• NASA Excel Add-in

  NASA provides NASA data, including imagery, available for reporting. NASA combines asteroid data, earth data, pictures and Mars-rover pictures

  The NASA Excel Add-in connector provides access to 10 tables of data.

• NDJSON Excel Add-in

  NDJSON is a file format based upon JavaScript. A NDJSON file consists of one record in JSON-format per line. No array grouping or record separator is used.

• Nmbrs Excel Add-in

  Nmbrs is payroll software in the cloud. Nmbrs provides both payrolling as well as HR functionality. Payrolling for both the Dutch as well as Swedish legislation are available. Nmbrs is used by entrepreneurs and accounting firms.

  The Nmbrs Excel Add-in connector provides access to 173 tables of data.

• OData Excel Add-in

  OData is both a data format and language to specify actions. OData is used by many cloud platforms to open up their data managed to the customers.

• Odoo ERP Excel Add-in

  Odoo is online ERP and CRM-software. Odoo is used by small and mid-size companies as well as large accounting firms.

  Tables accessible with the Odoo ERP Excel Add-in connector.

• OpenArch Excel Add-in

  OpenArch is cloud software for research. OpenArch combines numerous genealogical sources in the Netherlands. The data is typically cleaned from the original sources.

  The OpenArch Excel Add-in connector provides access to 12 tables of data.

• OpenExchangeRates Excel Add-in

  Open Exchange Rates provides historical and current exchange rates for over 200 commonly traded currencies.

  The OpenExchangeRates Excel Add-in connector provides access to 8 tables of data.

• Openspending.nl Excel Add-in

  OpenSpending is an online web service on the budget and spending of governments in the Netherlands. It includes data from various sources, including IV3 of CBS.

  The Openspending.nl Excel Add-in connector provides access to 8 tables of data.

• Oracle (managed) Excel Add-in

  Also known by the name: Oracle RDBMS.

  Oracle is a traditional database platform. Oracle supports ANSI SQL plus many extensions. Oracle is typically used for large business-critical applications.

  Tables accessible with the Oracle (managed) Excel Add-in connector.

• OS Excel Add-in

  OS access allows applications to interact with operating system data (e.g., files) as if querying a database, enabling structured retrieval via SQL queries.

  The OS Excel Add-in connector provides access to 13 tables of data.

• Outlook Excel Add-in

  Outlook is a desktop email application from Microsoft that manages emails, calendars, tasks, and contacts, supporting both online and offline access with robust integration for Microsoft services.

  The Outlook Excel Add-in connector provides access to 6 tables of data.

• PayPal Excel Add-in

  PayPal is an online payment provider. PayPal ensures that the monetary transfer for a service is handled correctly globally.

• PostgreSQL Excel Add-in

  Also known by the name: Postgres.

  PostgreSQL is a database platform. PostgreSQL is based upon open source and runs ANSI SQL statements.

  Tables accessible with the PostgreSQL Excel Add-in connector.

• Postman Excel Add-in

  Postman is a tool for API development, testing, and collaboration.

• RDW Excel Add-in

  Also known by the name: Rijksdienst voor het Wegverkeer.

  RDW is the Dutch register for vehicles. The RDW data is available online, even up to specific license plates registered in the Netherlands.

  The RDW Excel Add-in connector provides access to 56 tables of data.

• Robaws Excel Add-in

  Robaws is cloud software. Robaws helps construction companies manage their business.

  The Robaws Excel Add-in connector provides access to 209 tables of data.

• Roller Excel Add-in

  Roller is online software for leisure and retail management. Roller is available globally.

  The Roller Excel Add-in connector provides access to 41 tables of data.

• RSS Excel Add-in

  Also known by the name: Really Simple Sindication.

  RSS is a file format to communicate news messages and other streaming data.

  Tables accessible with the RSS Excel Add-in connector.

• Salesforce Excel Add-in

  Salesforce is an online ecosystem. Salesforce originated as a CRM solution, but was extended to cover many more types of online applications by Salesforce partners.

  Tables accessible with the Salesforce Excel Add-in connector.

• Simplicate Excel Add-in

  Simplicate is cloud software for project management, project control and billing. The online Simplicate business software manages sales, CRM, hours, projects and invoices. Simplicate is typically used by entrepreneurs in the Netherlands in their service business processes, involving large numbers of projects.

  The Simplicate Excel Add-in connector provides access to 248 tables of data.

• SnelStart Excel Add-in

  SnelStart is online accounting software. SnelStart is typically used by both entrepreneurs as well as accounting firms in the Netherlands. SnelStart is used by over 125.000 Dutch companies.

  The SnelStart Excel Add-in connector provides access to 129 tables of data.

• SQL Server Excel Add-in

  Also known by the name: Microsoft SQL Server.

  Microsoft SQL Server is a traditional database platform. SQL Server supports ANSI SQL. It is available both as a cloud database on Microsoft Azure as a traditional database running on-premise or hosted.

  Tables accessible with the SQL Server Excel Add-in connector.

• StackOverflow Excel Add-in

  Also known by the name: StackExchange.

  StackExchange is online collaboration software. Most popular variant is StackOverflow which is used by millions of software developers globally.

  Tables accessible with the StackOverflow Excel Add-in connector.

• SWIFT MT 940 Rabobank Excel Add-in

  MT940 is a standardized SWIFT message format used by banks to provide detailed electronic account statements, including transaction data, balances, and other financial details, for reconciliation and reporting.

  The SWIFT MT 940 Rabobank Excel Add-in connector provides access to 2 tables of data.

• Teamleader Focus Excel Add-in

  Also known by the name: Teamleader.

  Teamleader is a cloud solution for customer management. Teamleader includes CRM as well as project and tickets. Teamleader can be extended by defining custom fields on several core concepts.

  The Teamleader Focus Excel Add-in connector provides access to 314 tables of data.

• Teamleader Orbit regular API Excel Add-in

  Teamleader Orbit is a cloud solution for project management. Teamleader Orbit includes CRM as well as project and time registration.

  Tables accessible with the Teamleader Orbit regular API Excel Add-in connector.

• Teamleader Orbit Reporting API Excel Add-in

  Teamleader Orbit is a cloud solution for project management. Teamleader Orbit includes CRM as well as project and time registration.

• Teradata Excel Add-in

  Also known by the name: NCR Teradata.

  Teradata is a traditional database platform. Teradata targets large volumes of data, using a massive parallel architecture.

• Tixly Excel Add-in

  Also known by the name: Tix.

  Tixly is online software for leisure and entertainment management. Tixly is available globally.

  The Tixly Excel Add-in connector provides access to 79 tables of data.

• Tweede Kamer (NL) Excel Add-in

  Tweede Kamer (the Netherlands) provides Public Data from the Tweede Kamer of the Netherlands, such as members and bills that might evolve to law. The Tweede Kamer is the House of Representatives of the bicameral parliament of the Netherlands. It has 150 members.

  The Tweede Kamer (NL) Excel Add-in connector provides access to 36 tables of data.

• Twinfield Excel Add-in

  Twinfield is an online accounting package used in the Netherlands and Belgium. Accounting professionals form a large part of the Twinfield user community.

  The Twinfield Excel Add-in connector provides access to 164 tables of data.

• VirusTotal Excel Add-in

  VirusTotal is a web site of Google for analysis and queries on malware infections on files.

  Tables accessible with the VirusTotal Excel Add-in.

• Visma AccountView Excel Add-in

  Visma AccountView is on-premises accounting software used in the Netherlands. Despite it's age, still very large volumes of companies are managed using AccountView by accountants and entrepreneurs. AccountView is based on data stored in FoxPro-tables and managed by the AccountView metadata.

  Tables accessible with the Visma AccountView Excel Add-in connector.

• Visma Severa Excel Add-in

  Also known by the name: Visma Project Management.

  Visma Severa is cloud-based project management software. Visma Severa is available in the Nordics and the Netherlands.

  The Visma Severa Excel Add-in connector provides access to 263 tables of data.

• Visma.net Financials Excel Add-in

  Also known by the name: Visma.net.

  Visma.net is online software for accounting. Visma.net is used both by large accounting firms as well as large entrepreneurs.

  The Visma.net Financials Excel Add-in connector provides access to 635 tables of data.

• Wikipedia Excel Add-in

  Wikipedia is online software for encyclopedical knowledge. Wikipedia handles both the collection, sharing and maintenance of large volumes of encyclopedical knowledge across a wide range of languages.

  The Wikipedia Excel Add-in connector provides access to 2 tables of data.

• WMI Excel Add-in

  WMI (Windows Management Instrumentation) is a Microsoft framework that allows scripting languages and applications to manage and query system settings, hardware, and software on Windows OS.

  The WMI Excel Add-in connector provides access to 32 tables of data.

• XML Excel Add-in

  XML is a file format for structured storage of data. XML resembles HTML, but the contents are more strictly matched against the metadata.

• XML Audit File Cash Registers (Dutch) Excel Add-in

  Also known by the name: XAA.

  XAA ("XML Auditfile Afrekensystemen") is a file format for Dutch cash registers. It is generated by some cash registers for communication with accounting software and/or the tax office.

  The XML Audit File Cash Registers (Dutch) Excel Add-in connector provides access to 32 tables of data.

• XML Audit File Financial (Dutch) Excel Add-in

  Also known by the name: XAF.

  XAF ("XML Auditfile Financieel") is a file format for Dutch accounting information. It is typically generated by accounting software for communication with other parties and/or the tax office.

  The XML Audit File Financial (Dutch) Excel Add-in connector provides access to 48 tables of data.

• XML Audit File Salary (Dutch) Excel Add-in

  Also known by the name: XAS.

  XAS ("XML Auditfile Salaris") is a file format for Dutch payrolling information. It is typically generated by payrolling software for communication with other software and/or the tax office.

  The XML Audit File Salary (Dutch) Excel Add-in connector provides access to 36 tables of data.

• YouTrack Excel Add-in

  Also known by the name: JetBrains YouTrack.

  YouTrack by JetBrains provides bug tracking, issue tracking system and project management.

  The YouTrack Excel Add-in connector provides access to 379 tables of data.

• Yuki Excel Add-in

  This connector is running out

  Yuki is online accounting software from Visma. Yuki specializes in automated processing of documents in the Netherlands.

  The Yuki Excel Add-in connector provides access to 46 tables of data.

• Zoom Excel Add-in

  Zoom is video, phone and web conferencing software.

  The Zoom Excel Add-in connector provides access to 194 tables of data.