QueryStorm

Excel Plugin adds powerful development and data processing capabilities into Microsoft Excel.

Published by QueryStorm
Distributed by ComponentSource since 2018

Prices from: $ 371.42 Version: 2.12.x Updated: Apr 12, 2024

Screenshot of QueryStorm

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).

QueryStorm

Process data and build smart workbooks with C#/LINQ in Excel.
Process data and build smart workbooks with C#/LINQ in Excel.
Use SQL on Excel tables.
Use SQL on Excel tables.
Automatically formatting user code
Automatically formatting user code
Tooltips display function/parameter documentation
Tooltips display function/parameter documentation
SQL star expansion
SQL star expansion
Error hints for faulty code
Error hints for faulty code
Full autocomplete for SQL and C#
Full autocomplete for SQL and C#
Querying Excel tables alongside permanent database tables.
Querying Excel tables alongside permanent database tables.
Connecting to external databases
Connecting to external databases
Click for more

Image 1 / 10

Process data and build smart workbooks with C#/LINQ in Excel.
Use SQL on Excel tables.
Automatically formatting user code
Tooltips display function/parameter documentation
SQL star expansion
Error hints for faulty code
Full autocomplete for SQL and C#
Querying Excel tables alongside permanent database tables.
Connecting to external databases

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...
Learn more about QueryStorm

Latest News

QueryStorm 2.10.505.0
QueryStorm 2.10.505.0
August 15, 2023New Version
Adds a status bar service to show the status for sync operations.
QueryStorm 2.10.502.0
QueryStorm 2.10.502.0
July 24, 2023New Version
Adds text wrapping to the 'Summary' field.
QueryStorm 2.10.501.0
QueryStorm 2.10.501.0
July 14, 2023New Version
Adds new runtime VSTO add-in which improves installation.
QueryStorm 2.9.8525.20169
QueryStorm 2.9.8525.20169
May 5, 2023New Version
Adds HTTP request infrastructure for throttling and API key management.
QueryStorm 2.8.8503.17156
QueryStorm 2.8.8503.17156
April 13, 2023New Version
C# scripts can now reference other C# scripts using the #load directive.
QueryStorm 2.7.8487.32462
QueryStorm 2.7.8487.32462
March 30, 2023New Version
New GPT-powered copilot lets you generate SQL code based on SQL comments.
More News

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...
More on Licensing

Got a Question?

Live Chat with our QueryStorm licensing specialists now.

Feature Highlights

Use SQL on Excel tables.Process data and build smart workbooks with C#/LINQ in Excel.Query Excel tables alongside database tables in the same query.Advanced code editor for effective C# and SQL coding.
More Features
QueryStorm
As official and authorized distributors, ComponentSource supplies you with legitimate licenses directly from QueryStorm.
More about QueryStorm
Product Type
  • Add-In
More on Compatibility