Skip to content

Welcome to QueryStorm

This document is a 2-minute introduction to help you quickly get started with QueryStorm.

Tables, not sheets

QueryStorm works with Excel tables (not sheets). This is an important distinction, so I mention it several times throughout this documentation.

Tables

Excel tables are quite similar to database tables. They have names, delineate data from surrounding content, allow basic sorting and filtering and enforce consistency in columns (column names are unique, cells in a column share the same formula). As such, they are the ideal structure for QueryStorm to work with.

Note

Press Ctr+T on a cell or a block of cells to convert it to a table.

Querying with SQL

Once you have the data in tables, you can start querying by clicking Connect (SQLite) in the ribbon. This will pop up the QueryStorm IDE and open a SQLite connection that sees Excel tables as database tables.

Querying with SQL

The database engine is SQLite and you can run any valid SQLite query on your data, including UPDATE, INSERT and DELETE statements. You can even change row formatting via SQL.

You can read more about the SQL support here.

Querying with C#

Aside from SQL, you can also query data via C#. Excel tables show up as strongly typed collections that you can query and modify. Click the Connect (C#) button in the ribbon to open the IDE and start an interactive C# session.

Querying with C#

You can read more about QueryStorm's C# support here.

Connecting to external databases

Moving data between Excel and databases is usually quite tedious. QueryStorm makes combining database and spreadsheet data much easier allowing you to run queries that combine data from Excel tables with data from permanent database tables.

To connect to an external database, click Connect custom. A dialog will appear allowing you to choose (or define) a database connection:

Defining a connection

While defining the connection, you can select which Excel tables will be visible to the database engine. These tables are copied to the database as temp tables as soon as the connection is established.

Connected to DB

You can now query the data from Excel tables alongside permanent database tables, using all the resources of the database server. Query results can easily be returned into Excel and used to populate tables or ranges.

Read more about working with external databases here.

Try it!

Congratulations, you now know the basics of QueryStorm. There's a lot more interesting stuff in the rest the documentation and some video tutorials as well, so I encourage you to take a look.

Comments