Excel Add-Ins 3.0 Updates: Excel 2024 Compatibility, Expanded Database and Cloud Coverage, and Modern Security Enhancements

We are pleased to announce the release of Excel Add-ins 3.0, a major update to our Excel Add-ins for databases and cloud applications.

The new version adds support for Microsoft Excel 2024 across all products. It also includes new database versions, expanded object and report support, improved data type handling, and enhanced connection security.

In this release

• All Excel Add-ins: Excel 2024 support
• Database add-ins: Oracle, MySQL / MariaDB, PostgreSQL, SQL Server
• Cloud add-ins: BigCommerce, FreshBooks, Freshdesk, HubSpot, Mailchimp, Marketo, NetSuite, QuickBooks Online, Salesforce, SugarCRM, Zendesk, Zoho CRM, Zoho Books

All Excel Add-ins: Excel 2024 support

All Devart Excel Add-ins now support Microsoft Excel 2024. Users running the latest version of Microsoft Office can connect to their databases and cloud applications without any compatibility issues.

Database add-ins

Oracle

Excel Add-in for Oracle 3.0 adds support for Oracle Database 26ai, the latest major release in the Oracle Database family. In addition, the add-in now handles the JSON data type available in Oracle Database 21c, 23ai, and 26ai, and the BOOLEAN data type introduced in Oracle Database 23ai and 26ai, enabling richer data access and editing for schemas that use these types. Also, Excel Add-in for Oracle gains support for modern SSH encryption and key exchange algorithms.

MySQL / MariaDB

Excel Add-in for MySQL 3.0 adds compatibility with MariaDB 12, allowing users to connect to and work with data from the latest MariaDB release. Modern SSH encryption and key exchange algorithms are now supported as well.

PostgreSQL

Excel Add-in for PostgreSQL 3.0 adds support for PostgreSQL 17 and 18. Date and time handling has been improved with a new Use Session Timezone connection string parameter, which controls whether PostgreSQL date/time values are converted using the current session time zone, giving users precise control over how temporal data is interpreted across different environments. Modern SSH encryption and key exchange algorithms are also now supported.

SQL Server

Excel Add-in for SQL Server 3.0 adds support for Microsoft SQL Server 2025, enabling users to connect to and work with data from the latest SQL Server release.

Cloud add-ins

BigCommerce

Excel Add-in for BigCommerce 3.0 adds two new objects. The CustomerMetafields object enables reading and working with customer-level metadata. The ProductImageContents object provides access to the binary content of product images, supporting workflows that require image asset management directly from Excel.

FreshBooks

Excel Add-in for FreshBooks 3.0 receives a substantial expansion of its object coverage. Seven new data objects are added:

• Account
• AdjustmentJournalEntry
• AdjustmentJournalEntryLine
• CreditNote
• CreditNoteLine
• Estimate
• EstimateLine

In addition, seventeen financial report objects are now available:

• AccountAgingReport
• BalanceSheetReport
• CashFlowReport
• CashFlowSummaryReport
• ChartOfAccountsReport
• ExpenseDetailsReport
• GeneralLedgerReport
• GeneralLedgerSummaryReport
• InvoicesReport
• InvoiceDetailsReport
• JournalEntriesByAccountReport
• ManualJournalEntryReport
• ManualJournalEntrySummaryReport
• PaymentsCollectedReport
• ProfitAndLossReport
• TaxSummaryReport
• TrialBalanceReport

These additions enable financial analysis and reporting in Excel using live FreshBooks data.

Freshdesk

Excel Add-in for Freshdesk 3.0 now supports INSERT, UPDATE, and DELETE operations for the TicketFields object. Previously read-only, this object now supports full data manipulation, allowing support administrators to manage ticket field configurations directly from Excel.

HubSpot

Excel Add-in for HubSpot 3.0 broadens the range of HubSpot data available in Excel by adding eight new objects:

• Appointments
• Courses
• FormSubmissions
• FeedbackSubmissions
• Leads
• Listings
• Services
• Subscriptions

Also, HubSpot Reports are now supported, enabling users to pull pre-built HubSpot report data into spreadsheets. And a new Sensitive Data connection string parameter has been added, allowing access to sensitive data fields.

Mailchimp

Excel Add-in for Mailchimp 3.0 adds ten new e-commerce objects:

• Carts
• CartLines
• Customers
• Orders
• OrderLines
• Products
• ProductVariants
• PromoCodes
• PromoRules
• Stores

These objects cover the core of the Mailchimp e-commerce data model and allow users to work with store, order, and promotional data directly in Excel.

Marketo

Excel Add-in for Marketo 3.0 now supports native filtering by the CreatedAt field in Bulk Extract mode for the Leads object. This enables more targeted data retrieval when working with large Marketo datasets, reducing data volume for date-scoped extractions.

NetSuite

Excel Add-in for NetSuite 3.0 adds support for NetSuite API v2, expanding functionality for users on the latest NetSuite platform. Support for the 2024.2 release of API v1 has also been added for organizations that remain on v1. Additionally, OAuth login is now supported via the NetSuite Connection Manager, providing a more secure and modern authentication option.

QuickBooks Online

Excel Add-in for QuickBooks Online 3.0 adds fifty new report objects, making it possible to access the full range of QuickBooks Online reports directly in Excel. A new TaxExemptionReasonId field has also been added to the Customer object.

Salesforce

Excel Add-in for Salesforce 3.0 adds support for Salesforce Web Services API version 64.0, keeping the add-in current with the latest Salesforce platform release. Server-to-server authentication is now supported, enabling integration scenarios where user-interactive login isn’t practical. Additionally, a new Preserve Names connection string parameter has been added to retain the original names of custom objects and fields, including the __c suffix.

SugarCRM

Excel Add-in for SugarCRM 3.0 now supports three report types:

• RowsAndColumns
• Summation
• SummationWithDetails

These cover the primary report formats in SugarCRM and allow users to pull summarized and detailed report data into Excel for further analysis.

Zendesk

Excel Add-in for Zendesk 3.0 gains two new fields in the Article object: SectionId and AuthorId. These fields enable filtering and identification by section and author. The Section object now includes a CategoryId field, improving navigation and filtering of the Zendesk knowledge base structure.

Zoho CRM

Excel Add-in for Zoho CRM 3.0 now supports Zoho CRM API v8, the latest version of the Zoho CRM API. A new BulkRead connection string option enables the Zoho CRM Bulk Read API, designed for more efficient querying of large data volumes than the standard API. Additionally, support has been added for the Canada, Japan, Saudi Arabia, and UK domains in the Connection Editor for Zoho CRM connections.

Zoho Books

Excel Add-in for Zoho Books 3.0 receives several improvements:

• A new SalesReceipts object is added.
• Nested objects within the LineItems field of the Bills object are now supported.
• Support for the CustomFields and CustomFieldHash fields in the SalesOrders, Bills, CreditNotes, and CustomerPayments objects has been improved.
• BankTransactions record retrieval now supports all statuses, and filtering records by the Status field has been made more reliable.
• Support has been added for the Saudi Arabia domain in the Connection Editor for Zoho Books connections.

Get started with Excel Add-ins 3.0

Try the new version of Excel Add-ins: upgrade through your Devart account or download a free 30-day trial to explore the new features.