SQL Queries in Excel

What is SQL Queries in Excel?

SQL query add-in: the power of SQL to run queries in Excel and directly in Excel tables

Excel tables often grow gradually into large inconvenient workbooks. Finding duplicates, filters, groupings, complex sorting, joining tables into one - becomes a real challenge. Potentially, these tasks can be easily performed with SQL... if only sql queries could be run on excel data.

The XLTools SQL Queries add-in enhances Excel with the power of the structured query language:

•         Run SQL queries in excel interface and directly in 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 table from a tree-list view

Learn your way:

•         How to turn your Excel data into a relational database and prepare for sql query

•         How to create and run SQL SELECT in Excel tables

•         Operators on the left: Join, Order By, Group By, Distinct, and other SQLite commands in Excel

•         How to associate two or more Excel tables with the SQL Queries add-in

System requirements:

CPU: 1.8 GHz dual core processor

RAM: 2 GB

HDD / SSD: 50 GB of free space on the main drive

Operating system: Microsoft Windows 8 32-bit, Microsoft Windows 7 32-bit and Microsoft Windows Vista 32-bit

Resolution: 1024×768