Use SQL in Excel easily and often

Get QueryStorm FREE
Version, 2016-10-27

QueryStorm Premium License

Using QueryStorm commercially? Upgrade to a QueryStorm Premium license, and unlock external database connectivity and advanced IDE features!

Premium trial license

You can try out QueryStorm Premium for 30 days for free (no credit card required). Enter your email address, and we'll send you your trial key right away.

Technical features

Mighty IDE

  1. Syntax highlighting
  2. Intelligent autocomplete
  3. Error highlighting
  4. Auto formatting
  5. Star expansion
  6. Symbol tooltips & function insights
  7. Bracket matching
IDE animation

Built in database engine

A built-in SQLite engine that works with Excel tables as if they were database tables. Furthermore, it can call VBA and .NET functions from SQL, has built-in indexing and a wealth of extra functions (regular expressions, math, excel specific...)

Connectivity to external databases

Connect to an external database while copying workbook tables to the destination database (as temp tables). This makes it easy to import/export data, and query workbook and DB data together. Supports: SQL Server, Postgres, MySql, Access, SQLite and ODBC engines.


Processes your queries before passing them on to the underlying database engine. Allows for using cell values as query parameters, and redirecting query results back into Excel tables and ranges.

Automation runtime

Build refreshable dashboard-style workbooks by embedding queries inside your workbooks and setting up triggers for executing them (button click, table/range change, timer...). Query results can immediately update workbook tables and ranges. Does not require VBA.


Exposes a VBA API for extra flexibility with regards to automation. The API can be called to execute embedded and ad-hoc queries. Query results can be processed by VBA subroutines provided as callbacks.

Why choose QueryStorm?

SQL in Excel

The full power of a relational database right inside Excel. Use SQL to clean, query and manipulate data in Excel tables without leaving Excel. Processing data inside Excel has never been more powerful!

Database connectivity

Use the resources and processing power of an external database to process your data. Combine Excel data and existing database data in the same query, move data easily between Excel and an external database.


Embed queries into workbooks and create interactive query-powered workbooks that automate tasks, read data from databases and expose valuable data to your business users and clients.

How do I start?

step 1

Step 1: Mark your data as a table

QueryStorm works with excel tables. To turn a block of cells into a table, select any cell in the block and click Insert->Table. Adjust the borders and headers if needed, and click OK. Voila!

step 2

Step 2: Connect with QueryStorm

Once the data you care about is in tables, you can connect to it by going to the QueryStorm tab in the ribbon and clicking "Connect to workbook".

step 3

Step 3: Get querying!

Now that you are connected you can start writing SQL queries against your excel tables. And I mean all kinds of SQL, including update/insert/delete statements. Read more

So who is it for?
QueryStorm is a tool for businesses and individuals who deal with data in Excel. It is primarily used by IT professionals but can immensely benefit their colleagues and clients as well.

What does it do?
It empowers IT and other tech savvy users by enabling them to use database operations inside Excel and to more easily flow data between Excel and existing databases. Additionally, it allows setting up interactive query-powered workbooks that all users can use and benefit from.

Why is this useful?
QueryStorm can save users a lot of time and effort when processing Excel data and moving it to/from various databases. Additionally, since queries and commands can be automated, the user can automate repetitive tasks and prepare interactive workbooks that other users and clients can consume. The result is that data flows more easily though organizations and is more available allowing users to make informed business decisions.