QueryStorm

Supercharge your Excel with full SQL support

Get QueryStorm
Size: 6MB, Version: 1.7.268.1, Created: 2016-12-05
MD5:8a36fbb7b4026dc3b024d74bc4588a1d

More power over data

With the ability to use SQL in Excel, you have way more power over data in your workbooks. Using the powerful IDE, it's easy to write SQL to clean, query and manipulate data in your workbook, conveniently and without ever leaving Excel!

Database connectivity

Connect QueryStorm to an external database to easily move data in either direction between your workbook and an external database. Query your workbook data alongside existing database data, using all the resources and processing power of the external database, without ever leaving Excel.

Automation

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

How to 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 running SQL queries against your excel tables. And that means all kinds of SQL, even update/insert/delete statements. Read more

Features at a glance


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