QueryStorm

QueryStorm is an add-in for Microsoft Excel for tech savvy professionals who work with spreadsheets. It’s an IDE and runtime that allows using SQL and C# inside Excel making spreadsheets much more useful and accessible to tech users. For tech users who spend any considerable time in Excel, lack of proper support for tech skills tends to be a source of frustration. The purpose of QueryStorm is to greatly reduce this problem by adding easy and convenient support for SQL and C# into Excel, as well as better database connectivity. QueryStorm makes moving data between Excel and databases much easier. As soon as you connect, Excel tables are visible to the database (as temp tables).

I had a large migration from HR to clean and turn into one Excel report. The data was a real mess, it was all in different layouts and some of it was in PDF files. Months of work ended up taking me a week, using QueryStorm to write SQL queries to transform the data.

Pedrag Petrovic, Head of IT, Construction

QueryStorm Features

  • Speaks your language - Use SQL, C#, and VB.NET right inside Excel to process data, build custom functions and automate workbooks.
  • Intelligent IDE - Code completion, syntax highlighting, code fixes, and much more. With QueryStorm's IDE, writing code is a breeze.
  • Distributable runtime - Share your functions and automated workbooks with clients and colleagues. All they need to use them is the QueryStorm Runtime.
  • Query data in Excel - QueryStorm lets you use SQL and C# in Excel...

Latest News

QueryStorm 2.10.505.0
QueryStorm 2.10.505.0
Adds a status bar service to show the status for sync operations.
QueryStorm 2.10.502.0
QueryStorm 2.10.502.0
Adds text wrapping to the 'Summary' field.
QueryStorm 2.10.501.0
QueryStorm 2.10.501.0
Adds new runtime VSTO add-in which improves installation.
QueryStorm 2.9.8525.20169
QueryStorm 2.9.8525.20169
Adds HTTP request infrastructure for throttling and API key management.
QueryStorm 2.8.8503.17156
QueryStorm 2.8.8503.17156
C# scripts can now reference other C# scripts using the #load directive.
QueryStorm 2.7.8487.32462
QueryStorm 2.7.8487.32462
New GPT-powered copilot lets you generate SQL code based on SQL comments.

Prices from: $ 371.42

Prices are per seat. All licenses are perpetual and include 1 year of support and upgrades. SQL Professional: SQL in Excel, Advanced IDE features, External database connectivity, Workbook automation...

Got a Question?

Live Chat with our QueryStorm licensing specialists now.

Feature Highlights

QueryStorm
As official and authorized distributors, ComponentSource supplies you with legitimate licenses directly from QueryStorm.
Product Type
  • Add-In