Use SQL to Analyze Data Stored in Excel

Ever want to quickly summarize or filter data you have in an Excel tab by using SQL commands? This add-in will let you do that. You can write SQL code to analyze your data directly in Excel.

For example, assume you had a list of sales data that you wanted to sum the total sales by month. You could write something like: Select Month(sale_date) sale_mo, Sum(amount) tot_sales From A1:B30 Group By Month(sale_date)

This assumes that your headers are in row 1; it doesn't matter which column is the sale_date column - the code will figure it out.

This add-in is currently in development and is not yet ready for release. Want to be notified when the add-in is released? Sign up below and we'll let you know: