QueryStorm

SQL superpowers in your Excel tooklit

Get QueryStorm free
Version 1.6.261.1, 2016-09-21
MD5:7e7805370c792fca8f2df964f4fce63a

QueryStorm Premium

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

Premium trial

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.

Preprocessor


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.

VBA API


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.
api

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.

Automation

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 thgough organizations and is more available allowing users to make informed business deciosions.

What users are saying

Bravo on the plugin, I've wanted something like this in Excel for so many years, this is a fantastic tool!

Matthew Crews

Just wanna say I'm crazy psyched about your product, it's something that Excel has been lacking for ages!

Ege Demirel

Very (very, very) happy with QueryStorm. I used to either (1) use MSQuery - very complicated to use, or (2) move data back/forth between Excel and Access - tedious.

Peter Chang

Hi, This is great! I was looking for Excel addin that allows sql queries, and QueryStorm is absolutny number 1!

Anna Natalia Leszczynska