What's New

What's New in Excel Add-ins 3.1

BigCommerce

•	Corrected the maximum length metadata for the CartId field in the CartCustomItems, CartGiftCertificateItems, CartLineItems, and CartMetafields objects

Dynamics 365

•	Improved the display of error messages for invalid or unsupported data types when reading data from Dynamics 365

FreshBooks

•	Added the TeamMember, TeamMemberRate, and ProjectTeamMemberRate objects to the FreshBooks connector

HubSpot

•	Added support for OAuth v3 API endpoints

•	Added support for custom unique identifier properties that can be used as unique IDs

•	Added support for labeled associations. The connector represents labeled associations as objects with the _labels suffix

MySQL

•	Added support for PuTTY SSH PPK3 keys

Netsuite

•	Added support for the TransactionAccountingLines object in NetSuite API v2

Oracle

•	Added support for PuTTY SSH PPK3 keys

PostgreSQL

•	Added support for the SCRAM-SHA-256-PLUS authentication mechanism

•	Added support for PuTTY SSH PPK3 keys

QuickBooks Online

•	Added the PrefVendorRefId and PrefVendorRefName fields to the Item object

Zoho CRM

•	Added support for the IMAGEUPLOAD, LAYOUT, LINETAX, MODULE, MULTIUSERLOOKUP, ROLLUP_SUMMARY, and TERRITORIES native types in Zoho CRM API v2

What's New in Excel Add-ins 3.0

•	Added support for Excel 2024

BigCommerce

•	Added the new object ProductImageContents for working with binary content of product images in BigCommerce

•	Added the CustomerMetafields object

Fresh Books

•

Added new report objects: AccountAgingReport, BalanceSheetReport, CashFlowReport, CashFlowSummaryReport, ChartOfAccountsReport, ExpenseDetailsReport, GeneralLedgerReport, GeneralLedgerSummaryReport, InvoicesReport, InvoiceDetailsReport, JournalEntriesByAccountReport, ManualJournalEntryReport, ManualJournalEntrySummaryReport, PaymentsCollectedReport, ProfitAndLossReport, TaxSummaryReport, TrialBalanceReport

•	Added new objects: Account, AdjustmentJournalEntry, AdjustmentJournalEntryLine, ChartOfAccountsReport, CreditNote, CreditNoteLine, Estimate, EstimateLine, JournalEntriesByAccountReport

Freshdesk

•	Added support for INSERT, UPDATE, and DELETE DML operations for the TicketFields object

HubSpot

•	Added support for HubSpot reports

•	Added the Sensitive Data connection string parameter for accessing Sensitive Data fields

•	Added new objects: Appointments, Courses, FormSubmissions, FeedbackSubmissions, Leads, Listings, Services, and Subscriptions

Mailchimp

•	Added new objects: CartLines, Carts, Customers, OrderLines, Orders, ProductVariants, Products, PromoCodes, PromoRules, Stores

Marketo

•	Improved support for the Leads object, which now supports native filtering by the CreatedAt field in Bulk Extract mode

MySQL

•	Added support for modern SSH encryption and key exchange algorithms

•	Added support MariaDB 12

Netsuite

•	Added support for NetSuite API v2

•	Added support the NetSuite 2024.2 release of API v1

•	Added support for OAuth login by NetSuite Connection Manager

Oracle

•	Added support for the Oracle Database 26ai

•	Added support for the JSON data type in Oracle Database 21c, 23ai, and 26ai

•	Added support for the BOOLEAN data type in Oracle Database 23ai and 26ai

•	Added support for modern SSH encryption and key exchange algorithms

PostgreSQL

•	Added the Use Session Timezone connection string parameter to control whether PostgreSQL date/time values are converted using the current session time zone

•	Added support for modern SSH encryption and key exchange algorithms

•	Added support for PostgreSQL 17 and 18

QuickBooks Online

•	Added the TaxExemptionReasonId field to the Customer object

•	Added new 50 QuickBooks Online report objects

Salesforce

•	Added support for version 64.0 of the Salesforce Web Services API

•	Added support the server-to-server authentication

•	Added the Preserve Names connection string parameter to preserve the original names of custom objects and fields, including the __c suffix

SQL Server

•	Added support for Microsoft SQL Server 2025

SugarCRM

•	Added the RowsAndColumns, Summation, and SummationWithDetails reports

Zendesk

•	Added the SectionId and AuthorId fields to the Article object

•	Added the CategoryId field to the Section object

Zoho Books

•	Added support for nested objects within the LineItems field of the Bills object

•	Improved selection for BankTransactions records of all available statuses

•	Added the SalesReceipts object

•	Improved filtering records by the Status field

•	Improved support for the CustomFields and CustomFieldHash fields in the SalesOrders, Bills, CreditNotes, and CustomerPayments objects

•	Added support for the Saudi Arabia domain in the Connection Editor for Zoho Books connections

Zoho CRM

•	Changed the behavior: the API Version connection option now has only two supported elements - Preferred (currently API v8, but subject to change) and Deprecated (currently API v2)

•	Added support for Zoho CRM API v8

•	Added the BulkRead option to the connection string. It enables the Bulk Read API of Zoho CRM for querying large data volumes

•	Added support for Canada, Japan, Saudi Arabia, and the UK domains in the Connection Editor for Zoho CRM connections

What's New in Excel Add-ins 2.0

•	Added support for Shopify API version 2024-04

•	Added support for Salesforce Web Services API version 59.0

•	Introduced a new parameter, "Warn about tables without columns that uniquely identify rows," now available under Options -> Edit -> General

•	Introduced a new parameter, "Show connection string" option (by default: True), now available under Options -> Edit -> Error Handling

•	Introduced a new parameter, "Show sensitive info in connection string" option (by default: False), now available under Options -> Edit -> Error Handling

•	Added the Copy Log button in the Execution window

•	Added the GiftCards table for Shopify

•	Added new read-only tables for HubSpot: Invoices, InvoiceLineItems, LineItemInvoices, Teams, and Users

•	Added new tables for FreshBooks: BillVendor, Bill, BillLine, and BillPayment

What's New in Excel Add-ins 2.9

•	Released Excel Add-in for Zoho Desk

•	Released Excel Add-in for Zoho Books

•	Added support for Oracle 23c

•	Added support for MariaDB 11

•	Added support for PostgreSQL 16

•	Added support for SQL Server 2022

•	Renamed the Excel Add-in for Magento to the Excel Add-in for Adobe Commerce

•	Renamed the Excel Add-in for QuickBooks to the Excel Add-in for QuickBooks Online

•	Added the "Do not validate single update/delete per row on commit" option to Options -> Edit -> Error Handling

•	Added support for NetSuite 2023.2 Release

•	Added support for Zendesk Custom Lookup Fields

•	Optimized filtering and caching for V3 Product-related tables in BigCommerce

•	Added support for two-factor authentication for Adobe Commerce

•	Added the CostRate field to the TimeActivity object in QuickBooks Online

•	Added the Phone field to the Customers object in Shopify

What's New in Excel Add-ins 2.8

•	Added support for PostgreSQL 15

•	Added support for Zoho CRM API v4

•	Added support for MariaDB 10.10

•	Added support for Custom App authorization (Shopify)

•	Added support for Private App authorization (HubSpot)

•	Added support for Salesforce Web Services API version 55.0

What's New in Excel Add-ins 2.7

•	Added the compact installation function

•	Renamed the Excel Add-in for Microsoft Dynamics CRM to the Excel Add-in for Microsoft Dynamics 365

•	Added support for Windows 11

•	Implemented AES-128, AES-192, AES-256, Blowfish, CAST-128, RC4, Triple DES in-built encryption support for SQLite databases

•	Added support for the default browser for the Web Login authentication

•	Added the Buffer size parameter to Option -> Import -> Data -> General

•	Added the TicketMetricEvents object (Zendesk)

•	Added the Wishlists, WishlistItems, PriceListAssignments, and OrderMetaFields objects (BigCommerce)

•	Added support for COQL queries for Zoho CRM is to speed up the query execution process. COQL is available for the following objects: Accounts, Contacts, Deals, Campaigns, Tasks, Cases, Events, Calls, Solutions, Products, Vendors, PriceBooks, Quotes, SalesOrders, PurchaseOrders, Invoices (Zoho CRM)

•	Added the Query API connection parameter (Zoho CRM)

What's New in Excel Add-ins 2.6

•	Added modern encryption algorithms for MySQL and PostgreSQL

•	Renamed the Excel Add-in for G Suite to the Excel Add-in for Google Workspace

•	Added support for People API for Google Workspace

•	Added support for Microsoft Excel 2021

•	Added the DealsStageHistory read-only table (Zoho CRM)

•	Added the ProductCustomsInformation table in BigCommerce

What's New in Excel Add-ins 2.5

•	Added the server-to-server authentication type to the main Salesforce Marketing Cloud connection parameters

•	Added support for Salesforce Web Services API version 52.0

•	Added the NoteAttributes field to the Orders object and the Properties field to the OrderDetails object according to updates in Shopify API (version: 2021-04)

•	Added the ContactDetails object

•	Added the Tags field to the Ticket object (Freshdesk)

•	Added the DynamicContentItem and DynamicContentItemVariant objects (Zendesk)

•	Added support for the FreshBooks token server

•	Added support for the current_total_price_set_presentment_money entity for Shopify Orders

•	Added the Tags field to Freshdesk Ticket

•	Added the Save line breaks in multi-line text cells as option to Options -> Edit

•	Added support for SSH and SSL/TLS in the Direct Mode (Oracle)

•	Added the license number to the Copy Info and About/Register windows

•	Added the ExchangeRate field to the Invoice object (QuickBooks Online)

What's New in Excel Add-ins 2.4

•	Added a relationship with Partitions through leadPartitionId on Lead records for Marketo

•	Added support for Web Login for Dynamics CRM

What's New in Excel Add-ins 2.3

•	Added support for QuickBooks Online OAuth 2.0

•	Added the SQL Server command timeout option to Options -> Advanced

•	Added the Production or Sandbox parameter to the Connection Editor dialog box

What's New in Excel Add-ins 2.2

•	Implemented Search API result limits (Zendesk)

•	Added support for BigCommerce API v3

What's New in Excel Add-ins 2.1

•	Added support for Web Login for HubSpot

•	Added support for PostgreSQL 12

•	Added the Local SQL Engine advanced connection parameter to Excel Add-ins for cloud applications

•	Added the Failover Retries advanced connection parameter to Excel Add-ins for cloud applications

•	Added the object LineItems (HubSpot)

•	Implemented the server-to-server authentication type (Salesforce Marketing Cloud)

What's New in Excel Add-ins 2.0

•	Added support for PostgreSQL 11

•	Added the UseCustomLists parameter to NetSuite (NetSuite)

•	Added the Escape text values that start with $ so Excel does not convert them option to Options -> Import -> Data -> Escaping

•	Added support for for editing data from user-defined SQL queries or views with a ROWID column in Oracle Database

•	Added support for Microsoft Excel 2019

•	Added support for Freshdesk API v2

•	Added TicketDetails object with additional information about tickets for Freshdesk

•	Changed the default value of the API Version connection parameter for FreshBooks from Classic to Alpha

What's New in Excel Add-ins 1.8

•	Added support for Zoho CRM API v2

•	Added support for FreshBooks API (alpha)

•	Added the PaymentPayouts object to Shopify

•	Changed the default value for the API Version connection parameter for MailChimp from v2 to v3

What's New in Excel Add-ins 1.7

•	Added a progress bar for starting Edit Mode

•	Added the Keep hidden columns checkbox to Refresh Options

•	Added Refresh Options

•	Added support for Windows scaling for high-DPI devices

•	Added the RegionId field to CustomerAddresses for Magento 2

•	Added the Use Custom Fields parameter to Zendesk

•	Implemented the ability to connect to Salesforce Sandbox

•	Added support for INSERT and UPDATE operations for AccountUser in Salesforce Marketing Cloud

What's New in Excel Add-ins 1.6

•	Added the Use Display Name For Custom Tables parameter to Zoho CRM connection

•	Added the Sandbox checkbox to the NetSuite connection editor

•	Added the ListMemberInterests view (MailChimp)

•	Added the LineItems JSON field to the Shopify Fulfillments object

•	Added the ability to select a Zoho CRM connection domain in the connection editor

•	Added the UniqueExternalId field to the Freshdesk User object

•	Added support for Freshdesk

•	Added support for shared workbooks

•	Added support for G Suite

•	Added support for Hubspot

•	Added support for Marketo

•	Added support for NetSuite

•	Added support for Shopify

•	Added support for Zendesk

•	Added the "Read-only primary key columns for the existing (committed) record" option to Options > Edit > General

What's New in Excel Add-ins 1.5

•	Implemented field validation for cases where values must be unique or NULL

•	Added support for TLS 1.1

•	Added the "Escape text values that end with % so Excel does not treat them as percentage" option to Options -> Import -> Data -> Escaping

•	Added the "Escape text values that contain special chars so Excel does not treat them as datetime" option to Options -> Import -> Data -> Escaping

•	Added the Item column to the OrderShipments table for BigCommerce

•	Added the "is null" and "is not null" filter operators for mandatory fields in Zoho CRM

•	Added support for Excel 2016

•	Added support for ExactTarget

•	Added support for Magento

•	Added support for Web Login for Salesforce

•	Added the ABTestingCampaigns table for MailChimp

•	Added a progress indicator for query execution during data preview in the Import Data Wizard

What's New in Excel Add-ins 1.2

•	Implemented validation of entered unsigned numeric values

•	Implemented the MergeFieldsDetectionBehavior connection string parameter for MailChimp

•	Implemented validation of entered enum field values for all supported cloud sources

•	Added support for FreshBooks

•	Added support for BigCommerce

•	Added the "Refresh all columns after commit" option with default value true to Options -> Edit -> General

•	Added the "Read-only cells of new row" option for changing color for read-only cells in new rows to Options -> Edit -> Appearance

•	Added the "Show commit error message" option to Options -> Edit -> Error Handling

What's New in Excel Add-ins 1.1

•	Added support for Mailchimp

•	Added support for QuickBooks Online

What's New in Excel Add-ins 1.0

•	First release of Excel Add-ins