Devart ODBC Driver for Microsoft Excel: Query Workbook Files with SQL, No Excel Installed
Devart ODBC Driver for Microsoft Excel is an ODBC driver for Windows, macOS and Linux, from $139.95 a year, that opens .xlsx, .xlsm and .xls workbook files directly and lets Power BI, Tableau, Access, SQL Server, DBeaver, PHP or Python read and change their sheets with SQL. Microsoft Excel doesn't have to be installed on the machine.
A lot of business data never makes it into a database: price lists, budget sheets, stock counts dropped into a shared folder every Monday. This driver treats those files as a small database, so a report or an ETL job can pick them up the same way it reads SQL Server.
Quick facts
- Version: 2.2.0, released October 16, 2026; first released March 13, 2025
- Developer: Devart
- Platforms: Windows Vista or newer (32-bit and 64-bit, Terminal Server too) with .NET Framework 4.5, macOS x64 and Apple silicon, Linux x86 and x64
- File formats: Excel 2007-2021 workbooks (.xlsx, .xlsm) read and write, Excel 97-2003 (.xls) read-only, OpenOffice Calc and LibreOffice Calc
- Connection: the full path to one workbook; no user name, server or cloud account
- Price: $139.95 a year or $279.95 perpetual for one desktop user
- Trial: 30 days, for evaluation only, downloaded with a free Devart account
- Refund: Devart refunds in full within 30 days of purchase only when a technical problem or bug stops the driver working and its support team can't fix it
- What we checked: the order page charged $139.95 for Desktop for Windows with one year of updates on a yearly subscription (renewing at the same price), and the download page listed version 2.2.0 with a 34.05 MB Windows installer, on November 15, 2026. We didn't run the driver against a workbook
Download Free Trial Buy Now
Overview
You point a DSN (or a connection string such as DRIVER=Devart ODBC Driver for Microsoft Excel;Database=C:\Reports\prices.xlsx) at a workbook, and every worksheet and named range in it shows up as a table. From there, any ODBC tool can run SQL-92 SELECT statements with JOINs, WHERE filters, subqueries, GROUP BY, aggregates and ORDER BY, and send INSERT, UPDATE and DELETE back to the file.
Because the driver reads the file format itself, it runs on servers and Linux boxes where Office would never be installed. Devart documents it with Power BI, Tableau, QlikView, Microsoft Access, SQL Server Management Studio, SSIS, DBeaver, Informatica, Oracle database links, OpenOffice, Visual Studio, PHP and Python, and version 2.2.0 improved compatibility with Node.js, Visual FoxPro and DBeaver.
Features
Sheets and named ranges as SQL tables
Devart ODBC Driver for Microsoft Excel lists each worksheet and each named range in a workbook as a table you can join, filter and group. A Header Row option decides whether the first row holds the column names, and a hidden ROWID pseudo-column can be shown when a tool needs a row key.
CREATE RANGE for data in the middle of a sheet
Devart ODBC Driver for Microsoft Excel 2.1 added CREATE RANGE test_range AS SELECT 'A2:D4' FROM Sheet1, which turns a block of cells into a temporary table. It's meant for sheets with titles, notes or several small tables on one tab: you query only the block you need and drop it again with DROP RANGE. These ranges are read-only and aren't saved in the workbook.
Writing back to the workbook
Devart ODBC Driver for Microsoft Excel can insert, update and delete rows in .xlsx and .xlsm files, so a database job can append the day's figures to a sheet that someone else then opens in Excel. Old .xls files from Excel 97-2003 open read-only.
Control over column types
Devart ODBC Driver for Microsoft Excel guesses each column's type from sample rows (25 by default, set by Describe Amount) and maps Excel booleans, integers, floats, dates, times, datetimes and strings to ODBC types. Default Cell Type returns text as VARCHAR or memo, ExactFieldLength sizes text fields to the longest value instead of 255, 4096 or 32767, and regional settings can govern number and date conversion.
Shared and locked access
Devart ODBC Driver for Microsoft Excel opens a workbook for one user by default. Setting Read Only lets several users read the same file at once, while Exclusive Lock blocks everyone else while a job runs.
The same driver on three systems
Devart ODBC Driver for Microsoft Excel ships as EXE and MSI installers for Windows, a PKG for macOS (with iODBC) and RPM and DEB packages for Linux (with unixODBC). Version 2.0 added a graphical setup tool on macOS and Linux, and 2.2 worked around a unixODBC 2.3.13-2.3.14 DSN issue and improved support for Ubuntu 24 and 26 and CentOS 10.
Benefits
- No Office licence on the server. An ETL server or a Linux container can read workbooks without Excel being installed.
- Spreadsheets join real data. A linked server in SQL Server lets you join a budget sheet to the sales tables in one query.
- Fewer copy-and-paste steps. Reports read the latest version of the file each time they refresh.
- One driver for mixed teams. Windows, Mac and Linux users connect the same way.
Real-World Uses
- Supplier price lists. A buyer drops each supplier's .xlsx into a folder; a nightly job reads the list sheet, ignoring the logo and notes above it with CREATE RANGE, and updates the product database.
- Budget versus actual. Finance keeps the budget in Excel; a Power BI report joins it to actual figures from the accounting database.
- Legacy .xls archives. An analyst pulls ten years of old Excel 97-2003 exports into DBeaver to search them with SQL, read-only.
- Feeding a sheet from an app. A PHP or Python script appends orders to a workbook that the warehouse team opens every morning.
Who It's For, and Who Should Skip It
The Excel driver is for developers, BI and ETL people and database administrators who have to treat spreadsheet files as a data source in tools that speak ODBC, especially on servers, on Linux or on Macs, and anyone who needs to write back to .xlsx files from SQL.
Skip it if you only ever open workbooks in Excel itself, or if Power BI's and Tableau's own Excel connectors already cover your reports. If your workbooks live in Microsoft 365 (OneDrive or SharePoint) rather than on disk, Devart's separate ODBC Driver for Microsoft Excel Online is the right product.
Usage Guide
- Sign in to a free Devart account and download the installer for your system (EXE or MSI on Windows, PKG on macOS, RPM or DEB on Linux).
- Run it and enter your activation key, or carry on with the 30-day trial. On Linux, you run the activator afterwards.
- On Windows, open ODBC Data Sources (32-bit or 64-bit, matching your application), click Add, choose Devart ODBC Driver for Microsoft Excel and browse to the workbook in the Database field.
- On the Advanced Settings tab, turn on Header Row if the first row holds column names, and Read Only if others will open the file too.
- Click Test Connection, then select the DSN in Power BI (Get Data, Other, ODBC), Access (External Data, ODBC Database) or your own code.
Before you buy
A DSN points at one workbook file. If your reports read a new file every week, plan on connection strings with the file path rather than a fixed DSN. Also pick the 32-bit or 64-bit ODBC administrator that matches the program you'll use, or the DSN won't appear in it.
Where it falls short
- Messy sheets need work. Merged headings, totals rows and blank rows inside a table come through as data; you'll need CREATE RANGE, Header Row and Include Empty Rows settings to get a clean table.
- Type guessing can miss. Column types come from the first 25 rows unless you raise Describe Amount, so a column of numbers with text further down can cause surprises.
- Single user by default. Excel files aren't a multi-user database; concurrent access is read-only.
- .xls is read-only. Old Excel 97-2003 files can't be updated.
- Still a young driver. Releases since March 2025 fixed table names with a dollar sign, lost Unicode characters and .xls files that wouldn't open, so test on your own workbooks during the trial.
What Users Say
The Excel driver has no user reviews of its own yet; review sites rate Devart's ODBC drivers as one product line.
Devart ODBC Drivers, the whole line
Capterra users rate Devart ODBC Drivers 4.7 out of 5 from 26 reviews, and G2 shows 4.6 out of 5 from 18 reviews. The reviews mostly concern database and Salesforce drivers. Reviewers like the easy installation, reliable connections and the price; the drawbacks they mention are the cost of buying several drivers and a learning curve for people new to SQL.
Comparisons
Excel driver vs. Devart ODBC Driver for Microsoft Excel Online
Devart sells two Excel drivers. ODBC Driver for Microsoft Excel ($139.95 a year) reads workbook files on a disk or network share and runs on Windows, macOS and Linux. ODBC Driver for Microsoft Excel Online ($109.95 a year, Windows) connects to workbooks stored in Microsoft 365. Choose by where the files live.
One driver vs. the ODBC Universal Bundle
Devart's order page offers the ODBC Universal Bundle beside this driver: drivers for 92 databases and cloud apps, Excel included, from $499.95 a year for a desktop. Four single drivers at this driver's $139.95 already cost more than the bundle, so it pays off once you need four or more.
Editions and Pricing
| Edition | 1-year subscription | Perpetual | Who can use it |
|---|
| Desktop for Windows, macOS or Linux | $139.95 | $279.95 | One user at a time on one computer |
| Server Standard for Windows, macOS or Linux | $899.95 | $1,799.95 | Many users on one server with up to 6 cores, one legal entity |
| Server Enterprise, Site, OEM | Quote | Quote | Any core count, a whole company, or shipping the driver inside your own application |
The Buy Now button opens the order with Desktop for Windows on a 1-year subscription. The edition, the operating system, a 2- or 3-year term or a perpetual license are all chosen on the order page, where priority support can be added and 5, 10 or 20 copies get 5, 10 or 15 percent off. A subscription renews automatically; a perpetual license keeps working after its update period ends.
FAQs
Do I need Microsoft Excel installed to use the Devart Excel ODBC driver?
No. Devart ODBC Driver for Microsoft Excel reads and writes the workbook files itself and needs no Excel or other client software, which is why it also runs on Linux and macOS.
Can the Devart Excel ODBC driver open .xlsb or .csv files?
Devart ODBC Driver for Microsoft Excel lists .xlsx and .xlsm (Excel 2007-2021), .xls read-only, and OpenOffice and LibreOffice Calc files. Binary .xlsb and CSV files aren't on its list, so test them in the trial before relying on them.
Can two people query the same workbook at once?
Yes, read-only. Devart ODBC Driver for Microsoft Excel opens a file for a single user unless Read Only is set to True, which lets several users read it at the same time but not write to it.
Does the Excel ODBC driver keep working when a subscription ends?
No. The subscription license of Devart ODBC Driver for Microsoft Excel works only during its term and checks its status over the internet. The perpetual license ($279.95 for Desktop) keeps working offline after its update year; Devart's ordering FAQ says the renewal price rises by 20% three months after the update period ends and by 60% after twelve months.
Can I get a refund on the Devart Excel ODBC driver if it isn't right for me?
Not just for a change of mind. Devart's ordering FAQ offers a full refund within 30 days of purchase only when a technical problem or bug stops Devart ODBC Driver for Microsoft Excel working and Devart's support can't fix it, so use the 30-day trial to check your workbooks first.
Does one Desktop license cover Windows and Mac?
No. Devart ODBC Driver for Microsoft Excel's Desktop edition is bought for one operating system and one computer; Windows, macOS and Linux are separate choices at the same price on the order page.
Does the Devart Excel driver send any data back to Devart?
Only technical details, if you agree. Devart ODBC Driver for Microsoft Excel has an Improvement Program (a checkbox in the Windows and macOS installers, accepted with the license on Linux) that sends technical details such as the product version, the calling application, the OS and connection-string parameter names, never their values or your data. You can opt out later.
System Requirements
- Windows Vista or newer, desktop or server, 32-bit or 64-bit, including Terminal Server, with .NET Framework 4.5 or later
- macOS on Intel or Apple silicon with the iODBC driver manager
- Linux x86 or x64 with unixODBC
- 34.05 MB Windows installer; only one version of the driver installed
- Read access to the workbook file (write access to change it)
Conclusion
Devart ODBC Driver for Microsoft Excel is worth $139.95 a year if spreadsheets are a regular input to your reports, databases or scripts, and especially if those jobs run on a server, a Mac or Linux, where Excel isn't around. The reason to buy it is SQL read and write access to real workbook files, with CREATE RANGE for the untidy ones. The reason to hesitate is that a one-off import is cheaper done by hand, and if the workbooks live in Microsoft 365 you want the Excel Online driver instead. Try your messiest workbook in the 30-day trial before you pay.
Download Free Trial Buy Now