Using QueryStorm commercially? Upgrade to a QueryStorm Premium license, and unlock external database connectivity and advanced IDE features!
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.
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!
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.
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!
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".
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