SQL Queries App for Excel in the Office Store

Run SQL Queries against Excel tables

Working with large Excel files, joining several tables into one, removing duplicates, complex filtering, grouping, sorting, etc. are 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.

XLTools.net SQL Queries app helps query Excel data:

  • Automatically generate SELECT and JOIN queries
  • Join two or more tables by a key column using JOIN statements
  • Remove duplicates using DISTINCT or GROUP BY statements
  • Apply WHERE, SUM, COUNT, MIN, MAX statements, and much more.

XLTools.net SQL Queries App is built on Microsoft platform. MS Office Add-ins (or Office Apps) work across Excel Online, Excel 2016 and Excel 2013 desktop, Excel for iPad, Excel for Mac.

Video is kindly provided by Webucator as part of their Excel Training.

Learn your way around:

How to add the SQL Queries App for Excel from the Office Store

Download the add-in from the Office Store website, or directly from Excel interface:

  1. Open Excel > Insert tab > In the Add-ins group click ‘Store’ or ‘Office Add-ins’.
  2. Search for XLTools SQL Queries Add-in in the Store > Buy > Free Trial
  3. The add-in’s task pane will appear on the sheet. Drag and place it as you wish.

Note: you should be singed in to your Microsoft account to manage products and subscriptions:
File > Account > User Information > Sign in.

Add XLTools.net SQL Queries App from the Office Store to Excel 2016 Excel 2013

Add XLTools.net SQL Queries App from the Office Store to Excel Online

How to join two Excel tables by a key column with SQL Query

Suppose you need full client information with all orders, yet your data is stored in two different tables – Clients and Orders. With the SQL Queries app you can run SELECT query and JOIN these tables by their common ‘Client ID’ field.

1. Make sure your data are properly formatted as named tables:
Select the range > ‘Home’ tab > Click ‘Format as Table’ > Select a table style.

2. Follow the steps on the SQL Queries panel:

  • Step 1. Add data tables for your query by selecting the range of tables one by one.
    Note that SELECT and LEFT JOIN queries are generated automatically as you check the added tables.

How to select Excel table for SQL query

  • Step 2. Adjust the query manually if necessary.
    E.g. request to sort data by Client ID – simply type ORDER BY tbl1.[Client ID].
  • Step 3. Select any empty cell in the spreadsheet as the starting cell of the query output.
    Click ‘Run Query’ > The resulting table appears in seconds.

SQL Queries in Excel JOIN tables result

Does the SQL Queries Office Add-in work offline

Online Office Add-ins require Internet connection.

But check out our desktop SQL Queries (requires installation). You can run DISTINCT, WHERE, SUM, COUNT, MIN, MAX, etc. queries as well, and it also works offline.

Read more on the difference between online Office Add-ins and desktop version.

Any questions or suggestions? Please leave your comment below.

2 Responses to SQL Queries App for Excel in the Office Store

  1. Vinod says:

    Hi, I had installed the XL add in pop up calendar. But in my excel2007, i see that the xlTools tabs are all disabled. I cannot do anything there.



    • Maria Balobanova says:

      Vinod, if you cannot find the XLTools tab on Excel toolbar, please activate the add-in:
      Open MS Excel > Click File > Options > Select ‘Add-Ins’ on the left > on the bottom of the page ‘Manage’ select ‘Com Add-Ins’ > Click Go > Check the box ‘XLTools Add-in for Microsoft Excel’ > Ok.
      Hope this helps!

Leave a Reply

Your email address will not be published. Required fields are marked *