XLTools.net SQL Queries

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!