ODBC Driver for Smartsheet
ODBC Driver for Smartsheet boxshot
Version
1.3.0
License
Shareware
Trial Limitations
30-day full-featured trial
Operating Systems
Windows (32-bit and 64-bit)
System Requirements
Windows Vista or later, 32-bit or 64-bit, .NET Framework 4.5. A Smartsheet account (US or EU region). An ODBC application
File Size
35.74 MB
Release Date
10/16/2026
Last Updated
11/19/2026
5 views 0 downloads
ODBC driver that puts Smartsheet data into Excel, Power BI and SQL tools

Devart ODBC Driver for Smartsheet: Query and Update Smartsheet from Excel, BI and SQL Tools

Devart ODBC Driver for Smartsheet is a Windows ODBC driver, $109.95 a year for one desktop or $219.95 perpetual, that lets Excel, Power BI, Tableau, Qlik, Access, SQL Server linked servers, DBeaver, Python and other ODBC tools read Smartsheet data with SQL and write changes back. It signs in with an OAuth refresh token, works with both the US and the EU Smartsheet data centres, and needs no other client software.

Smartsheet is where many operations teams keep project plans, trackers and intake forms, but the numbers often have to end up in a finance model, a Tableau dashboard or a SQL database. The driver lets those tools pull from Smartsheet directly instead of through exports and copy-paste.

Quick facts

  • Version: 1.3.0, released October 16, 2026; first released March 13, 2025
  • Developer: Devart
  • Platforms: Windows 32-bit and 64-bit, including Windows Terminal Server; Windows Vista or later with .NET Framework 4.5
  • Sign-in: OAuth refresh token; Region setting for the US (smartsheet.com) or Europe (smartsheet.eu) data centre; optional proxy
  • Download: 35.74 MB EXE or 39.83 MB MSI installer
  • Price: $109.95 a year or $219.95 perpetual for Desktop; $799.95 a year or $1,599.95 perpetual for Server Standard
  • Trial: 30 days, full-featured (download needs a free Devart account)
  • Refund: Devart's ordering FAQ gives a 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 ODBC Driver for Smartsheet, Desktop for Windows with one year of support and upgrades, Devart's ordering data listed $219.95 perpetual and $1,599.95 perpetual for Server Standard, and the download page listed version 1.3.0 (EXE 35.74 MB, MSI 39.83 MB), on November 19, 2026. We didn't connect it to a Smartsheet account

Download Free Trial Buy Now

Overview

After installing, you create a DSN in the ODBC Data Source Administrator, authorize the driver against your Smartsheet account so it stores a refresh token, and pick the Region: US for www.smartsheet.com accounts (the default) or Europe for www.smartsheet.eu. A connection string needs little more than Refresh Token=.... Proxy fields are there for networks that block direct HTTPS.

Smartsheet objects then appear as SQL tables in any ODBC application. You can run SQL-92 SELECT statements with joins, subqueries, WHERE filters, GROUP BY, aggregates and ORDER BY, and use INSERT, UPDATE and DELETE to change Smartsheet data the way you would a database.

Features

Real column types from sheets

Devart ODBC Driver for Smartsheet assigns actual data types to sheet fields through its Typed Sheet Cells setting, on by default, so dates arrive as dates and numbers as numbers in Excel or Power BI. Turn it off when a sheet mixes values in a column and you'd rather receive everything as text. The driver handles numeric, date and time, array and error values, in any language.

EU and US data centres

Devart ODBC Driver for Smartsheet has a Region setting that points it at North America (www.smartsheet.com) or Europe (www.smartsheet.eu), so companies whose Smartsheet account lives in the EU region connect without workarounds.

Write-back and bulk updates

Devart ODBC Driver for Smartsheet supports INSERT, UPDATE and DELETE and can combine statements into batches. Appending rows from another system, or updating a status column across hundreds of rows, becomes one SQL job.

Fewer API calls when you need speed

Devart ODBC Driver for Smartsheet can suppress the extended API requests it otherwise makes to fill in fields missing from the first response. That means fewer calls and faster loads on big sheets, at the cost of those extra fields.

Connection guides for 45+ tools

Devart ODBC Driver for Smartsheet comes with Devart walkthroughs for Excel, Power BI, Tableau, Qlik Sense, QlikView, DBeaver, SQL Server Management Studio, Access, Alteryx, Informatica, Python, PHP, Node.js and more. Version 1.3 (October 2026) improved compatibility with Node.js, Visual FoxPro and DBeaver.

Benefits

  • One copy of the truth. Reports read Smartsheet live rather than from stale exported copies.
  • Joins Smartsheet with everything else. Combine tracker rows with ERP, CRM or database tables in one query.
  • Push data in, not just out. Load rows into Smartsheet from a script or another database.
  • Familiar tools. Analysts keep working in Excel, Tableau or SQL instead of learning the Smartsheet API.

Real-World Uses

  • PMO portfolio dashboard. A project office reads every project's status sheet into Power BI for a single portfolio view.
  • Budget tracker meets finance. A controller joins a Smartsheet budget tracker with actuals from the accounting database in Excel.
  • Intake form to SQL. A developer copies new rows from a Smartsheet request form into SQL Server each night through a linked server.
  • Bulk status update. An operations lead marks a batch of completed jobs with one UPDATE instead of editing row by row.

Who It's For, and Who Should Skip It

The driver suits analysts, PMOs and developers on Windows who need Smartsheet data in their own reporting or ETL tools, and especially those who also want to write data back or use the EU data centre.

Skip it if Smartsheet's own dashboards and reports already cover you, or if your Business or Enterprise plan includes Smartsheet's Live Data Connector and you only need to read data into a BI tool. Mac users can't run it, and shared servers need the Server license.

Usage Guide

  1. Sign in to devart.com with a free account, download the EXE or MSI, install it, and choose Trial or enter your activation key.
  2. Open ODBC Data Sources (32-bit or 64-bit, matching your application), click Add on the User DSN or System DSN tab, and pick Devart ODBC Driver for Smartsheet.
  3. Sign in to Smartsheet to get the refresh token, choose the US or Europe region, and add proxy details if needed.
  4. Click Test Connection, then OK.
  5. In Excel, choose Data > Get Data > From Other Sources > From ODBC, pick the DSN, select the table in the Navigator and click Load.

Before you buy

Pick the right Region: an EU-hosted account won't connect with the default US setting. The Desktop license covers one desktop computer used by one person at a time; a report server, Power BI gateway or SQL Server linked server used by several people needs Server Standard ($799.95 a year) or higher. Everything goes through Smartsheet's web API, so large sheets load more slowly than a database would.

Where it falls short

  • Windows only. There's no macOS or Linux build of the Smartsheet driver.
  • No table reference. The online manual documents connection options, not the schema, so you browse tables in your tool.
  • Mixed-type columns. With typed cells on, a column holding mixed values can need the setting switched off.
  • Young product. First released in March 2025, with no reviews of its own yet.

What Users Say

How Devart's ODBC line rates

The Smartsheet driver has no reviews of its own on the major review sites. Capterra rates Devart's ODBC drivers as one line, at 4.7 out of 5 from 26 reviews, and G2 at 4.6 out of 5 from 18. Those reviewers mostly use the database and Salesforce drivers. They praise the quick install and stable connections. The usual complaints are the cost once you need several drivers, documentation that is thin on how to supply credentials, and DSN setup that trips up first-time users. Try it on your largest sheets in the 30-day trial before relying on these general marks.

Comparisons

Devart driver vs Smartsheet Live Data Connector

Smartsheet's own Live Data Connector also links Smartsheet to BI tools through ODBC, and Smartsheet lists it for Business and Enterprise plans; Smartsheet describes it for charts, pivot tables and reports. Devart's driver is bought separately, documents INSERT, UPDATE and DELETE for writing back, and lets you pick the US or EU data centre. Check whether your plan already includes the Live Data Connector before buying.

Smartsheet driver vs Devart's ODBC Universal Bundle

Devart's ODBC Universal Bundle includes this driver and drivers for more than 90 other sources, including Airtable, Google Sheets and Excel Online. If you need two or three of them, compare the bundle's price first.

Editions and Pricing

Edition1-year subscriptionPerpetualTypical use
Desktop for Windows$109.95$219.95One person's PC
Server Standard for Windows$799.95$1,599.95A report server or SQL Server machine shared by many users
Server Enterprise, Site, OEMQuoteQuoteLarger servers, company-wide installs, or shipping the driver in your own product

Buy Now opens the order page on Desktop for Windows with a 1-year subscription. The edition, subscription or perpetual license, and a 1-, 2- or 3-year support term are chosen there; all editions are sold under the same order page.

FAQs

Does ODBC Driver for Smartsheet work with Smartsheet accounts in the EU region?

Yes. Devart ODBC Driver for Smartsheet has a Region setting: US connects to www.smartsheet.com (the default) and Europe to www.smartsheet.eu.

How does ODBC Driver for Smartsheet authenticate?

Devart ODBC Driver for Smartsheet uses an OAuth refresh token, stored in the DSN or passed as the Refresh Token connection string parameter, so you don't type a Smartsheet password into the driver.

Can ODBC Driver for Smartsheet add rows to a sheet?

Yes. Devart ODBC Driver for Smartsheet supports INSERT, UPDATE and DELETE and batched statements, within what your Smartsheet user is allowed to change.

Is there a Mac or Linux version?

No. Devart ODBC Driver for Smartsheet is offered for 32-bit and 64-bit Windows only.

What happens when the subscription year ends?

The yearly price of Devart ODBC Driver for Smartsheet includes a year of support and upgrades. The perpetual license ($219.95 for Desktop) keeps working after the first year; renewing support for new versions is optional.

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 ODBC Driver for Smartsheet working and support can't fix it. Use the 30-day trial on your own sheets first.

System Requirements

  • Windows Vista or later, 32-bit or 64-bit, including Windows Terminal Server
  • .NET Framework 4.5
  • A Smartsheet account (US or EU region)
  • An ODBC-compatible application
  • HTTPS access to Smartsheet, directly or through a proxy

Conclusion

Devart ODBC Driver for Smartsheet is worth $109.95 a year if you need Smartsheet data in Excel, Power BI, Tableau or SQL Server and want to write back too, or if your account sits in the EU data centre. If your plan already includes Smartsheet's Live Data Connector and read-only reporting is all you need, start there. Try the 30-day trial against your largest sheets before you buy.

Download Free Trial Buy Now

Submit Your Review
Your Name:
Rating:
(Please click on one of the stars to indicate your rating.)
One Line Summary:
Review:
No html tags are allowed.
Submit Review
We may earn a commission when you buy through links on this page.
Copyright © 2026, Ivertech. All rights reserved.