QueryStorm is a tool that makes use of the user's existing knowledge of SQL to enhance their interaction with data in Excel. SQL is a very expressive language for dealing with tabular data, and having it easily available in Excel can considerably empower the SQL savvy Excel user.

Conceptually, QueryStorm consists of five components:

  • The IDE
  • The built in database engine
  • Connectors to external database engines
  • The preprocessor
  • The automation runtime (including the VBA API)

Emphasis has been placed on keeping the user interface simple and the learning curve small while still adding a huge amount of power to the user.

SQL is at the heart of what QueryStorm does, so to use it effectively, being comfortable with SQL is pretty much required. If you aren't though, you still might find it useful, QueryStorm's Live mode is an awesome playground for practicing SQL queries, so it can and is being used to teach and learn SQL.

QueryStorm works with tables

The most important thing to know right off the bat is that QueryStorm works with Excel tables as opposed to sheets and ranges. The reason is that, with tables, the data and headers are clearly marked, and you can have whatever you like around them. You can also have multiple tables in the same sheet and QueryStorm will happily work with them without any issues.

Just a range Ctrl+T Now it's a proper table
Data in a sheet the Insert table button data marked as a table

To mark a range as a table, select the range (or just one or more cells in it) and click Insert->Table in the ribbon (or press Ctrl+T). You can change the table's name in the “Design” tab in the ribbon.

That's all the preparation we need, now we can get querying.

Last updated: 4/18/2016
Back to top