Skip to main content

XLTools.net SQL Queries

WavePoint Co. Ltd.
Run SQL queries in Excel and directly against Excel tables.

When you work with large Excel spreadsheets, tasks like joining several tables into one, removing duplicates, complex filtering, grouping, sorting, etc. become a challenge. SQL Queries App offers a new approach to accomplish these tasks easily. Now users who are familiar with structured query language can run SQL queries directly against Excel tables. Here is just a short list of what you can do:

• Automatically generate SELECT and JOIN queries and edit them manually

• Work with many tables in any open spreadsheet using SELECT queries

• Join two or more tables by a key column using JOIN statements

• Remove duplicates using DISTINCT or GROUP BY statements

• Apply complex filtering with a certain criteria using WHERE statements

• Apply complex sorting, grouping and aggregation using SUM, COUNT, MIN, MAX statements, and much more!

Add-in capabilities
When this add-in is used, it
  • Can read and make changes to your document
  • Can send data over the Internet
  • https://az158878.vo.msecnd.net/marketing/Partner_21474839848/Product_42949676368/Asset_01bd7614-9afa-45f1-a628-ec5111798a4e/appsqlqueries1.png
    /images/videoOverlay.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474839848/Product_42949676368/Asset_01bd7614-9afa-45f1-a628-ec5111798a4e/appsqlqueries1.png
    /images/videoOverlay.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474839848/Product_42949676368/Asset_01bd7614-9afa-45f1-a628-ec5111798a4e/appsqlqueries1.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474839848/Product_42949676368/Asset_6ff15ad8-43bf-42ad-8d2f-89e571372b82/appsqlqueries2.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474839848/Product_42949676368/Asset_8eab4a5f-19e7-4bf2-b2f9-be9d01e30843/appsqlqueries3.png