C# and SQL in Excel

Because developers use Excel too.

Get QueryStormWatch tutorials

Free 14-day trial

What does it do?

Adds SQL support in Excel

Why vlookup when you can join? Let QueryStorm spoil you rotten with its snappy SQLite engine and its fancy IDE. Fiddling with stuff in your sheets can be a lot of fun!

C# and LINQ too

How about some LINQ with those Excel tables? With full C# support you can show off your lambdas and work those rows how ever you like.

Adds connectivity

Are you into hooking up on the side? REST APIs, databases, files, websites; nothing is safe from you. With two-way database connectivity, and all the .NET APIs you can think of, getting things in and out of your sheets has never been easier!

Replaces VBA

VBA scripts are so last decade. Make your worksheets smart with QueryStorm's C# support. Insert your scripts and queries right into your client's business, and automate their workbooks without them even caring that you're using C# and SQL for the magic!

Why is it useful?

1. Processing in Excel

Excel largely deals with tabular data, much like databases. The ability to use SQL and LINQ right inside Excel offers the best of both worlds in one package. And if you need a quick & dirty database, Excel will do just fine.

2. Moving data

Getting Excel data into databases, and database data into Excel is usually quite clumsy. QueryStorm supports two-way connectivity with databases and Excel, substantially lowering the barrier between Excel and databases. And with .NET libraries and APIs, it's very easy to get all sorts of data into Excel.

3. Prototyping applications

Workbooks are not just static documents. They are applications in their own right, with data, behavior and visualization, all in one neat shareable package. Improving the way this behavior is implemented can greatly speed up development, as well as improve the overall quality of the solutions.

Who is it for?

Data professionals

Greatly empowers data professionals in Excel by allowing them the use the full repertoire or SQL operations inside Excel, conveniently, with a single click.

DB Admins

Move data between Excel and various relational databases in both directions, seamlessly, with a unique interface that's convenient and built right into Excel.

Developers

Unleash your technical know how when working in Excel. Make use of SQL, Regular expressions and SQL/VBA integration for some serious data processing power, right inside Excel.

Business users

With automated dashboards and pre-built queries, you can run powerful data transformations without writing any SQL at all. Unpivot data, create histograms, find outliers and much more.

Pricing options

Subscription

$15 /seat/month*
1h of expert support/license/year
Continual upgrades and license transfers
Licenses transferable from PC to PC
ALL features enabled
Full SQL support in Excel
Advanced IDE features
Connectivity to external databases
Automation
Buy licenses

Perpetual

$299 /seat
1h of expert support/license
1year of upgrades and license transfers
Licenses transferable from PC to PC
ALL features enabled
Full SQL support in Excel
Advanced IDE features
Connectivity to external databases
Automation
Buy licenses
Buying over 10 licenses? Contact us for volume discount information.
*Per month pricing billed annually.

Free

$0 
Non-commercial use
1 Machine
Use SQL in Excel
Automation
License transferable from PC to PC
Advanced IDE features
Connect to databases
Email Support
Download installer

Independent professional*

$99 (perpetual)
1year Of upgrades and license transfers
1+1 Machines (private + work machine)
Use SQL in Excel
Automation
License transferable from PC to PC
Advanced IDE features
Connect to databases
Email Support
Buy your license
*Independent-professional is a perpetual license suitable for purchase by individuals and should not be paid for or in any way compensated by a business entity.