ODBC Driver for Microsoft Excel Online
ODBC Driver for Microsoft Excel Online icon

ODBC Driver for Microsoft Excel Online

by Devart
$109.95
ODBC Driver for Microsoft Excel Online boxshot
Version
1.3.0
License
Shareware
Trial Limitations
30-day full-featured trial, started from the installer's Trial option
Operating Systems
Windows (32-bit and 64-bit)
System Requirements
Windows Vista or later, 32-bit or 64-bit, including Terminal Server. .NET Framework 4.5 or later. A Microsoft account with access to the workbook
File Size
34.76 MB
Release Date
10/16/2026
Last Updated
11/22/2026
3 views 0 downloads
Devart ODBC driver that queries and edits Excel Online workbooks with SQL

ODBC Driver for Microsoft Excel Online: Query Cloud Workbooks with SQL from Any ODBC Tool

Devart ODBC Driver for Microsoft Excel Online is a Windows ODBC driver that lets Power BI, Tableau, Excel, SQL Server, DBeaver and other ODBC tools read and change the sheets of an Excel Online workbook with SQL, for $109.95 a year or $219.95 perpetual (Desktop license). Each sheet becomes a table you can join, filter and group, and inserts, updates and deletes go straight back to the workbook in the cloud.

A lot of business data never makes it into a database: price lists, budgets, forecasts and tracking sheets live in Excel workbooks that a team edits online. Getting that data into a report usually means downloading a copy, which is out of date by tomorrow. This driver connects to the live workbook instead, so a dashboard or a nightly ETL job always reads the current numbers.

Quick facts

  • Version: 1.3.0, released October 16, 2026 (first released March 2025)
  • Developer: Devart
  • Platform: Windows Vista or later, 32-bit and 64-bit, including Terminal Server; .NET Framework 4.5
  • Connects to: one Excel Online workbook per connection, over HTTPS or through a proxy, authorized with a refresh token from your Microsoft sign-in
  • SQL: SQL-92 SELECT with joins, subqueries, grouping and aggregates, plus INSERT, UPDATE and DELETE
  • Download: 34.76 MB EXE or 38.54 MB MSI; needs a free Devart account
  • Price: $109.95 a year or $219.95 perpetual for Desktop; $799.95 a year or $1,599.95 perpetual for Server Standard; Server Enterprise, Site and OEM licenses by quote
  • Trial: 30 days, full-featured, chosen in the installer
  • Refund: Devart's ordering FAQ gives a full refund within 30 days only when a technical problem that support can't fix stops the product working
  • What we checked: the order page charged $109.95 for a one-year Desktop license, $219.95 for a perpetual Desktop license, $799.95 a year or $1,599.95 perpetual for Server Standard, and the download page listed version 1.3.0 with a 34.76 MB installer, on November 22, 2026. We didn't connect it to a workbook of our own.

Download Free TrialBuy Desktop LicenseBuy Server Standard License

Overview

Devart ODBC Driver for Microsoft Excel Online installs like any ODBC driver. You create a DSN in the Windows ODBC Data Source Administrator, sign in to Microsoft to give the driver a refresh token, and pick the workbook. From then on, any ODBC-aware program can open the DSN: in Excel you choose Get Data, From ODBC; in Power BI, Tableau or Qlik you pick the ODBC source; in SQL Server you can add it as a linked server. Devart publishes 48 step-by-step integration guides for this driver, from Access and Alteryx to Informatica and FileMaker.

Each sheet shows up as a table. By default the columns are named A, B, C like Excel's own columns; turn on Header As ColumnName and the first row becomes the column names. A Sheet Tables option exposes the formatted Excel tables inside a sheet as separate objects, which helps when one sheet holds several tables.

Features

SQL over workbook sheets

Devart ODBC Driver for Microsoft Excel Online accepts SQL-92 SELECT statements with JOINs, WHERE conditions, subqueries, GROUP BY, aggregate functions and ORDER BY, so you can join two sheets, total a column by region, or filter a list before it reaches your report.

Write back to the workbook

Devart ODBC Driver for Microsoft Excel Online supports INSERT, UPDATE and DELETE, so a tool or script can add rows to a shared tracking sheet, correct values, or remove lines in the cloud workbook the same way it would in a database table.

Control over how sheets become tables

Devart ODBC Driver for Microsoft Excel Online lets you choose whether the first row holds column names, whether Excel tables inside a sheet become their own objects, the minimum number of columns to read, the maximum cell length (4,000 characters by default), and whether dates and numbers follow your regional settings or UTC.

Works with the tools you already use

Devart ODBC Driver for Microsoft Excel Online follows the standard ODBC API, with options for tools that expect ODBC 2.x behavior or only ANSI or only Unicode strings. Devart lists it as compatible with Power BI, Tableau, QlikView, TIBCO Spotfire, Excel, LibreOffice, SQL Server linked servers, Oracle database links, Access, DBeaver, Visual Studio, Python, PHP and FileMaker, and recent releases improved compatibility with Node.js, DBeaver, Visual FoxPro, Qlik Replicate and PHP's PDO_ODBC.

Caching and pooling

Devart ODBC Driver for Microsoft Excel Online caches data locally and pools connections, which cuts the number of calls to Microsoft's servers when a report refreshes several visuals from the same workbook.

Benefits

  • Live numbers, no downloads. Reports read the workbook as it is now, not a copy someone exported last week.
  • One connection for every tool. The same DSN serves Excel, Power BI, Tableau and SQL Server.
  • SQL instead of copy-paste. Joins and totals across sheets happen in the query.
  • Two-way. Tools that can write to ODBC can also update the shared workbook.

Real-World Uses

  • Dashboards on team sheets. A sales team keeps targets in an online workbook, and a Power BI report reads them live next to actual sales from the database.
  • Budget consolidation. A SQL Server linked server pulls each department's budget sheet into one query for finance.
  • Feeding ETL jobs. A nightly job reads a price list that product managers maintain in Excel Online and loads it into the ERP database.
  • Logging results back. A script writes its daily totals into a shared workbook that managers already open every morning.

Who It's For, and Who Should Skip It

Devart ODBC Driver for Microsoft Excel Online suits analysts, BI developers and database people on Windows whose source data partly lives in Excel Online workbooks and who want to reach it from ODBC tools without manual exports.

Skip it if you work on a Mac or Linux, since the driver is Windows-only. If your workbooks are ordinary .xlsx files on a disk or file share, not in the cloud, Devart's separate ODBC Driver for Microsoft Excel is the one you want. If you only need the data in Power BI and nowhere else, Power BI's own connectors for files in OneDrive or SharePoint may be enough at no extra cost. And if you write Python, Devart's Python Connector for Microsoft Excel Online does the same job without ODBC.

Usage Guide

  1. Download the driver from the product's download page (sign in to a free Devart account) and run the EXE or MSI installer.
  2. Choose Trial in the installer to start the 30-day evaluation, or enter your activation key if you bought a license.
  3. Open ODBC Data Sources from the Start menu, go to the User DSN or System DSN tab, click Add and pick the Devart driver for Microsoft Excel Online.
  4. Sign in to Microsoft in the DSN settings to get the refresh token, choose the workbook, and decide whether the first row holds column names.
  5. Test the connection, then open the DSN from your tool: in Excel, Data, Get Data, From Other Sources, From ODBC, choose the DSN, pick a sheet in the Navigator and click Load.

Before you buy

The Desktop license covers one desktop computer used by one person at a time. When several users reach the driver at once, as on a web, application or batch server, or behind a SQL Server linked server that others query, Devart requires the Server Standard license (one server with up to 6 cores) at $799.95 a year, more than seven times the Desktop price. One connection opens one workbook, so a report that reads several workbooks needs several DSNs.

Where it falls short

  • Windows only. There's no macOS or Linux build of this driver.
  • One workbook per connection. Joining data across two workbooks means two DSNs and a tool that can combine them.
  • Spreadsheets aren't tidy tables. Merged cells, blank header rows and notes in a sheet still need cleaning up; the driver reads cells as they are.
  • Young product. The driver first shipped in March 2025, and its release notes so far are mostly compatibility fixes for specific tools.
  • Server pricing jumps. The Server Standard license costs $799.95 a year, against $109.95 for Desktop.

What Users Say

Capterra and G2 (Devart's ODBC driver line)

Review sites rate Devart's ODBC drivers as one product line rather than driver by driver, and this Excel Online driver has no reviews of its own yet. On Capterra, Devart ODBC Drivers average 4.7 out of 5 from 26 reviews, with 4.5 for ease of use. On G2, the Devart ODBC Driver page averages 4.6 out of 5.

Reviewers there describe the drivers as doing what they promise and filling gaps that Microsoft's own drivers leave. Because none of those reviews cover Excel Online, the 30-day trial against your own workbook is the real test.

Comparisons

Excel Online driver vs. Devart's ODBC Driver for Microsoft Excel

Devart sells two Excel drivers. The ODBC Driver for Microsoft Excel reads workbook files on a disk or network share; this one reads workbooks stored online through a Microsoft sign-in. Pick by where the workbook lives.

Excel Online driver vs. Devart's ODBC Driver for Google Sheets

Devart's Google Sheets driver does the same for Google spreadsheets, at the same Desktop price. If your team works in Google Workspace rather than Microsoft 365, that's the one to buy.

Editions and Pricing

License1-year subscriptionPerpetualWhat it coversBuy
Desktop for Windows$109.95$219.95One desktop computer, one user at a timeBuy 1 year Buy perpetual
Server Standard for Windows$799.95$1,599.95One server with up to 6 cores, many concurrent usersBuy 1 year Buy perpetual

Each button opens the order page with that license and term selected; you can change the term to 2 or 3 years or add premium support there. Server Enterprise, Site and OEM licenses are sold by quote from Devart. A perpetual license includes one year of updates and support.

FAQs

Does the Devart Excel Online ODBC driver work on a Mac?

No. Devart ODBC Driver for Microsoft Excel Online runs on 32-bit and 64-bit Windows only, from Windows Vista on, including Terminal Server.

Can I use the Excel Online ODBC driver with Power BI?

Yes. Devart ODBC Driver for Microsoft Excel Online works with Power BI through its ODBC data source, and with Tableau, QlikView, Excel and other ODBC tools. When several users reach the driver at once, for example through a shared server, Devart requires a Server license.

Can the Devart driver write to my Excel Online workbook?

Yes. Devart ODBC Driver for Microsoft Excel Online supports INSERT, UPDATE and DELETE, so changes from your tool are saved to the workbook online.

How does the Excel Online driver name columns?

Devart ODBC Driver for Microsoft Excel Online uses Excel's column letters (A, B, C...) by default. Turn on Header As ColumnName to use the first row of each sheet as column names.

Can one connection read several workbooks?

No. Each connection of Devart ODBC Driver for Microsoft Excel Online opens one workbook, so create a DSN per workbook.

What happens when the subscription ends?

The subscription license of Devart ODBC Driver for Microsoft Excel Online works for the term you paid for and then needs a renewal. A perpetual license keeps working at the version you have.

Can I get a refund?

Only for technical problems. Devart's ordering FAQ gives a full refund within 30 days of purchase when a bug or technical issue stops the driver working and support can't fix it, so use the 30-day trial first.

System Requirements

  • Windows Vista or later, 32-bit or 64-bit, including Windows Terminal Server
  • .NET Framework 4.5 or later
  • A Microsoft account with access to the Excel Online workbook
  • An ODBC-compliant application, such as Excel, Power BI, Tableau or SQL Server

Conclusion

Devart ODBC Driver for Microsoft Excel Online is worth $109.95 a year if your reports or ETL jobs on Windows need data that lives in Excel Online workbooks: you get live SQL access, write-back and one DSN for every ODBC tool. Budget for the Server Standard license if it will run on a server, which changes the math a lot. If your workbooks are local files, you're on a Mac, or Power BI's own connectors already reach the file, skip it.

Download Free TrialBuy Desktop LicenseBuy Server Standard License

We may earn a commission when you buy through links on this page.
Copyright © 2026, Ivertech. All rights reserved.