Devart ODBC Driver for Mailchimp: Audiences, Members, Merge Fields and Campaigns as SQL Tables
Devart ODBC Driver for Mailchimp is a Windows ODBC driver, $139.95 a year for one desktop, that connects Excel, Power BI, Access, Crystal Reports, SQL Server and other ODBC tools to Mailchimp through its API 3.0. Lists, list members with their custom merge fields, list surveys, campaigns and folders become tables you can query with SQL and update.
Mailchimp's own reports tell you how one campaign performed. The harder questions, like how subscribers from a sign-up form tag behave across all your audiences, or which customers in your CRM aren't subscribed, need the data somewhere you can join it. That's what this driver does.
Quick facts
- Version: 3.6.0, released October 16, 2026 (first release July 2016)
- Developer: Devart
- System: Windows Vista and later, 32-bit and 64-bit, Terminal Server too; .NET Framework 4.5
- Mailchimp access: API key, or OAuth (added in version 3.0.0); Mailchimp API 3.0
- Tables include: Lists, ListMembers, ListSurveys, Campaigns, Folders
- Custom fields: merge tags joined to ListMembers columns (MergeCustomFields option)
- Price: $139.95 per year for Desktop for Windows; $279.95 perpetual
- Trial: 30 days, fully working
- Refunds: full refund within 30 days of purchase if a technical issue blocks use and Devart support can't fix it
- What we checked: ODBC Driver for Mailchimp cost $139.95 on the order page in its default setup (Desktop for Windows, 1-year subscription renewing every 12 months, no premium support), and the download page carried version 3.6.0 as a 33.11 MB EXE and a 37.20 MB MSI, both on November 14, 2026. We didn't connect it to a Mailchimp account
Before you buy
Leave the API Version setting on 3.0: Mailchimp's API 2.0 is deprecated and no longer works. Decide how you want custom merge fields handled before building reports, because the MergeCustomFields setting changes the columns of the ListMembers table. Edits made through the driver go straight into your Mailchimp audience, so test write-back on a test audience. The driver is Windows only.
Download Free TrialBuy Now
Overview
This is one of Devart's longest-running cloud drivers. It shipped in July 2016, gained the MergeCustomFields option for custom fields in 2017, moved to Mailchimp API 3.x in October 2019, added OAuth in November 2022, and added the ListSurveys table and new ListMembers fields in October 2023. Releases since then have been about stability and tool compatibility: a metadata cache, encrypted keys in the DSN, and fixes for Excel imports, Tableau date columns, DBeaver, Node.js and Visual FoxPro.
Devart's own sample query gives a feel for what you can do: it counts items by type across Campaigns left-joined to Lists (filtered to lists whose default language is English), unions in the Folders table, and groups and sorts the result. That's a level of reporting Mailchimp's interface doesn't offer.
Features
Merge fields as real columns
Devart ODBC Driver for Mailchimp can add your audiences' merge tags (custom fields such as FNAME, company or plan) to the ListMembers table. JoinCommon, the default, adds the tags shared by all lists; JoinAll adds every tag and returns NULL where a member's list doesn't have it; None leaves them out. A Merge Tag As FieldName option uses the tag as the column name.
API key or OAuth
Devart ODBC Driver for Mailchimp connects with the API key from Mailchimp's Account Settings, Extras, API Keys page, or with OAuth since version 3.0.0. The key can be saved encrypted in the DSN. A minimal connection string is DRIVER={Devart ODBC Driver for Mailchimp};API Key=....
Full SQL, including unions and nested queries
Devart ODBC Driver for Mailchimp handles SQL-92 SELECT statements with joins, nested subqueries, UNION, GROUP BY, aggregates and ORDER BY, plus ODBC escape macros for outer joins, dates and scalar functions that tools like Crystal Reports and Microsoft Query generate.
Write-back for audience maintenance
Devart ODBC Driver for Mailchimp supports INSERT, UPDATE and DELETE, with batching for large changes, so you can add or correct list members from Access, a SQL script or a linked server.
Benefits
- Custom fields you can actually report on. Merge tags become ordinary columns, ready for pivot tables and BI filters.
- Mailchimp beside your sales data. Join list members with orders or CRM contacts by email address in Power BI or SQL Server.
- A decade of fixes. Ten years of tool-specific releases mean fewer odd errors in Access, Excel and Crystal Reports.
Real-World Uses
- Subscriber-to-customer match. A retailer joins ListMembers with its order database to find buyers who never subscribed.
- Survey results in Excel. A marketer pulls ListSurveys data into a workbook for the monthly report.
- Campaign inventory. An agency lists every client campaign by type and folder with one grouped query.
- Clean-up of merge fields. An admin fixes thousands of misspelled company names in one UPDATE.
Who It's For, and Who Should Skip It
Buy it if Mailchimp audiences are a core business asset and you analyze them in Excel, Power BI, Access or SQL Server, or if you need custom merge fields in reports. Agencies, ecommerce teams and data analysts are the natural users.
Skip it if Mailchimp's own reporting is enough, if you're on macOS or Linux, or if you only need a quarterly CSV. If you only work in Excel, Devart's Excel Add-in for Mailchimp is the narrower tool; .NET developers have dotConnect for Mailchimp, and SQL Server ETL teams the SSIS components for Mailchimp.
Usage Guide
- In Mailchimp, open your account name, Account Settings, Extras, API Keys, and copy a key.
- Download Devart ODBC Driver for Mailchimp (Devart login needed), install it as an administrator, and pick the trial or enter your activation key.
- Open the 32-bit or 64-bit ODBC Data Sources tool to match your program and add a DSN with the Mailchimp driver.
- Paste the API key, keep API Version at 3.0, choose a MergeCustomFields mode, and test the connection.
- Connect from Excel, Power BI or Access and open ListMembers, Lists or Campaigns.
Where it falls short
- Big audiences are slow to load. Members come through Mailchimp's API in pages; filter in SQL rather than loading everyone.
- Column layout shifts with settings. Switching MergeCustomFields between JoinCommon and JoinAll changes ListMembers' columns and can break saved reports.
- Pricier than newer siblings. At $139.95 a year it costs more than Devart's newer marketing drivers such as Klaviyo or EmailOctopus ($109.95).
- Windows only; subscription licenses activate and re-check online.
What Users Say
There's no review profile for the Mailchimp driver alone; Capterra and G2 rate Devart's ODBC drivers as a family.
Family ratings
Capterra: 4.7/5 from 26 reviews. G2: 4.6/5 from 18 reviews. Users mention simple installs and reliable, quick connections most. The negatives that recur are the cost, setup steps that confuse first-timers, and documentation that's light on how to supply credentials.
From Devart's case studies (other cloud drivers)
Viterbo University, on ODBC Driver for Dynamics 365: "It helps with our admission process and allows us to communicate better/faster with students..."
Comparisons
ODBC driver vs. Excel Add-in for Mailchimp
The Excel Add-in brings Mailchimp data into Excel and lets you edit it there. The ODBC driver works in Excel too, but also in Power BI, Access, Crystal Reports, SQL Server and your own code. Pick the driver if more than one tool needs Mailchimp data.
Mailchimp driver vs. Mailchimp's CSV exports
Exports are free but static, and custom fields arrive as whatever columns that audience has. The driver gives you a live, consistent table structure across audiences and write-back.
Editions and Pricing
You choose the edition and license on the order page.
| Edition | Use rights | Yearly | Perpetual |
|---|
| Desktop for Windows | One computer, one user at a time | $139.95 | $279.95 |
| Server Standard for Windows | One server, up to 6 cores, concurrent users | $899.95 | $1,799.95 |
| Server Enterprise / Site / OEM | Any core count, company-wide, or redistribution | On quote | On quote |
The Buy Now button orders Desktop for Windows on a one-year subscription at $139.95 by default; change edition, term (2 or 3 years cost less per year) or license type on the order page.
FAQs
Can Devart ODBC Driver for Mailchimp read custom merge fields?
Yes. Devart ODBC Driver for Mailchimp adds merge tags to the ListMembers table: tags common to all lists by default (JoinCommon), every tag with JoinAll, or none.
Which Mailchimp API does Devart's Mailchimp driver use?
Devart's Mailchimp driver uses Mailchimp API 3.0 by default. An API Version setting still lists 2.0, but Mailchimp has deprecated it and it's no longer supported.
Does the Mailchimp ODBC driver support OAuth?
Yes. The Mailchimp ODBC driver added OAuth authorization in version 3.0.0 (November 2022), as an alternative to pasting an API key.
Does Devart ODBC Driver for Mailchimp work on macOS?
No. Devart ODBC Driver for Mailchimp is Windows only, in 32-bit and 64-bit versions.
Can I get a refund if the Mailchimp driver doesn't work for me?
Yes, if the problem is technical and unfixable. Devart refunds the Mailchimp driver in full within 30 days of purchase when support can't solve a bug that stops it working; it doesn't refund for a change of mind.
What does it cost to renew the Mailchimp driver late?
Renewing the Mailchimp driver's subscription on time costs the normal price. Devart charges 20% more if 3 or more months have passed since it ended, and 60% more after 12 months.
System Requirements
- Windows Vista or later, 32-bit or 64-bit, including Terminal Server
- .NET Framework 4.5 or later
- A Mailchimp API key or OAuth sign-in; HTTPS access, direct or by proxy
- Administrator rights to install
Conclusion
Devart ODBC Driver for Mailchimp is the most mature of Devart's email-marketing drivers, and its merge-field handling makes it worth $139.95 a year to anyone who reports on Mailchimp audiences in Excel, Power BI, Access or SQL Server. The reasons to hold back are Windows-only support, slow full loads of very large audiences, and a price above the newer sibling drivers. Try it free for 30 days, and settle on a MergeCustomFields mode before you build reports.
Download Free TrialBuy Now