Use the power of SQL to run queries in Excel and directly on Excel tables
- Run SQL queries in Excel interface and directly on Excel tables
- Generate SELECT and JOIN statements automatically
- Use JOIN, ORDER BY, DISTINCT, GROUP BY, SUM and other SQLite operators
- Write queries in the intuitive editor with syntax highlighting
- Address any Excel tables from a tree list view
Before you begin, add SQL Queries to Excel
– free trial gives you 14 days of full access to all features.
How to turn your Excel data into a relational database and prepare for SQL querying
How to create and run SQL SELECT on Excel tables
- As you tick the fields, SELECT statement is generated automatically in the right-hand side area of the editor.Tip: watch the SQL editor automatically highlight syntax.
Operators Left Join, Order By, Group By, Distinct, and other SQLite commands in Excel
- LEFT JOIN – join two or more tables by shared key columns
- ORDER BY – sort data in query results
- DISTINCT – remove duplicates from the query output
- GROUP BY – group data in query results
- SUM, COUNT, MIN, MAX, AVG and other operators
Tip: watch the SQL editor automatically highlight syntax.