Excel SQL Utility


Excel SQL Utility

Excel has built-in, but hidden SQL capabilities. SQL queries are far more powerful than Excel's built in filters, and can make it easy to prepare data extracts for loading into databases.

The Excel SQL Utility is an Excel spreadsheet which allows you to write SQL statements to query data from one worksheet within the spreadsheet, and write the results to another worksheet. It provides capabilities to list a sequence of SQL statements and execute them in a batch in sequential order, or to selectively toggle query execution on and off.