Licensing options

  • For Teams & Organizations Teams
  • For individuals Individuals
  • Special Offers Special
Community
Free

For querying data in Excel and developing Excel based solutions using SQL, C# and VB.NET. Suitable for non-commercial use and small businesses.

SQL Pro
379
License + 1yr support
169
Yearly support (2nd year onwards)

For querying Excel data, connecting to external databases and developing Excel based workbooks and functions using SQL. Suitable for commercial use.

Developer
499
License + 1yr support
219
Yearly support (2nd year onwards)

For querying data in Excel and developing Excel based solutions using SQL, C# and VB.NET. Enables all features, including the ability to connect to external databases and publish packages. Suitable for commercial use.

Prices are per-seat. All licenses are perpetual and include 1 year of support and upgrades.
The (optional) support subscription ensures you will have access to new versions after the first year.
Community
Free

For querying data in Excel and developing Excel based solutions using SQL, C# and VB.NET. Suitable for non-commercial use and small businesses.

SQL Pro
149
License + 1yr support
59
Yearly support (2nd year onwards)

For querying Excel data, connecting to external databases and developing Excel based workbooks and functions using SQL. Suitable for commercial use.

Developer
199
License + 1yr support
79
Yearly support (2nd year onwards)

For querying data in Excel and developing Excel based solutions using SQL, C# and VB.NET. Enables all features, including the ability to connect to external databases and publish packages. Suitable for commercial use.

All licenses are perpetual and include 1 year of support and upgrades.
The (optional) support subscription ensures you will have access to new versions after the first year.
For students and teachers
Free

Students and academic staff members are eligible to use QueryStorm for free, upon verification of their university/college domain email or ISIC card.

For user groups
Free

Organizers of active user groups can get free licenses for QueryStorm products to raffle off at regular user group meetings and community events.

For Microsoft MVPs
Free

Microsoft Most Valuable Professionals are eligible to receive a free QueryStorm license upon verification of their profile.

Compare Features

Community
SQL Pro
Developer
SQL in Excel
C# scripting in Excel
Advanced IDE features
Workbook automation (.NET)
Excel functions & extensions (.NET)
NuGet support
External database connectivity
Workbook automation (SQL)
Custom Excel functions (SQL)
Publishing functions & extensions
Commercial use
License
Free
$379
$499
Yearly support (optional)
Free
$169
$219
In non-enterprise organizations, up to five users can use QueryStorm Community. In enterprise organizations (>$1 Million US Dollars in annual revenue), no commercial use is permitted.

Compare Features

SQL Lite
SQL Professional
Developer
SQL in Excel
C# scripting in Excel
Advanced IDE features
Workbook automation (.NET)
Excel functions & extensions (.NET)
NuGet support
External database connectivity
Workbook automation (SQL)
Custom Excel functions (SQL)
Publishing functions & extensions
Commercial use
License
$99
$149
$199
Yearly support
$39
$59
$79
In non-enterprise organizations, up to five users can use QueryStorm Community. In enterprise organizations (>$1 Million US Dollars in annual revenue), no commercial use is permitted.

Compare Features

For Students and Teachers
For User Groups
For Microsoft MVPs
SQL in Excel
C# scripting in Excel
Advanced IDE features
Workbook automation (.NET)
Excel functions & extensions (.NET)
NuGet support
External database connectivity
Workbook automation (SQL)
Custom Excel functions (SQL)
Publishing functions & extensions
Commercial use
License
Free
Free
Free
Yearly support
Free
Free
Free

Frequently Asked Questions

Who can use individual licenses?

An individual license is an option for private individuals who purchase a license with their own funds, and solely for their own use. Individual licenses may be used for commercial work (e.g. by an independent contractor), but they are not to be purchased, refunded or in any way financed by companies.

Who can use Community licenses?

Community licenses can be freely used for any non-commercial use, while limited commercial use is allowed in smaller companies. Specifically, in non-enterprise organizations, up to five users can use QueryStorm Community. In enterprise organizations (>$1 Million US Dollars in annual revenue), no commercial use is permitted.

Users in enterprise organizations can generate a free 30 day trial key for trial purposes. They can also use the community version, provided it is only being used non-commercially.

How can I manage my licenses?

To manage your licenses, please create an account on Keystodian (our license management portal). Make sure to use the same email address that your keys are registered to. The portal allows you to view and manage your keys.

Note that the credentials you define on the licensing portal can also be used in the activation prompt to activate QueryStorm.

Can I move my licenses from machine to machine?

Yes, you can transfer licenses as often as you like. The licensing prompt offers three ways of activating, all of which are applicable for transferring licenses as well:

  • Sending a transfer link via email
  • Using your existing key on another machine
  • Using your license portal credentials in the license prompt

All three methods will deactivate a previously activate machine (if the key has no more available slots).

Do my clients need a license to use my workbooks and functions?

No, your clients only need the QueryStorm runtime which does not require a license.

What happens if I cancel my support subscription?

All licenses are perpetual. Once you buy a license it’s yours forever. During payment, a support subscription is created, but if you’re not interested in support and staying up to date with new versions, you can cancel your subscription immediately without affecting your license or the currently started year of support.

Can I reactivate a cancelled subscription?

Yes, you do not need to pay for an entirely new license to add support to an existing license. However, we charge a one-time 25% fee for reactivating deactivated subscriptions. For example, if the subscription cost is $199, you will be charged $249 initially ($199 for the year + $50 reactivation fee) and then $199 on following years.

Can I activate QueryStorm on multiple machines over the network?

Yes, your domain administrator can install and activate it remotely on multiple machines on your domain. For help with this, please get in touch.

Can I publish and/or sell my own QueryStorm extensions and workbooks?

Yes, you can publish (and optionally sell) your own extensions. You can also license and sell your smart workbooks.

Extensions: If you would like to publish a generally useful extension package to the official QueryStorm feed, contact us to submit it for publication. You can, of course, freely publish any packages to your own Azure servers. If you would like to sell licenses for an extension that you built, our transaction fee will be 20% (in case the extension is distributed via on your Azure Artifacts server) or 30% if it will be hosted on the official QueryStorm feed.

Workbooks: If you would like to license a workbook to your clients, you can do so as well, using the same licensing and payment infrastructure that QueryStorm itself uses. This allows you to sell workbooks without worrying about your intellectual property (simply remove all code and leave the compiled dlls inside the workbook) or worrying about how to charge for them per machine.

In both cases (licensing workbooks or extensions) the process is simple. You install the Keystodian.Client NuGet package to your project and make sure to call the method for checking the license at the appropriate time (at startup or at function call). In addition, you will need to register for vendor status at keystodian.com and define your product there.

For more detailed instructions, please get in touch.

Get Started

Read the documentation to
learn how to use QueryStorm.

Contact sales

Contact us for any licensing
or sales related questions.