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.5.7923.20438
QueryStorm 2.5.7923.20438
Adds support for configuring SSL in Postgres connection strings.
QueryStorm 2.5
QueryStorm 2.5
Updates C# from 7.1 to 9 and upgrades SQLite to latest version with window functions.
QueryStorm 2.4
QueryStorm 2.4
Adds support for trusted documents and improves context menu support.
QueryStorm 2.3.7822.26514
QueryStorm 2.3.7822.26514
SQL Preprocessor adds async functions and event handlers.
QueryStorm 2.2.7730.34357
QueryStorm 2.2.7730.34357
QueryStorm extensions can now define shortcuts and allow users to configure them.
QueryStorm 2.0
QueryStorm 2.0
Adds new project system, automation changes, and NuGet and VB.NET support.

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