Automatically Refresh SQL Data In Excel

Eliminate your VBA/ODBC/SQL maintenance headaches for free


Manage Complex SQL Visually With The Query Builder

Many business professionals are new to SQL. QuerySmith helps you understand joins, data filtering and subqueries, leaving you to focus on the big picture of the problem you’re trying to solve.

Automatically Refresh Workbooks With Charts & Pivot Tables

Export to Excel is the most popular feature in most business intelligence products. QuerySmith is fundamentally built around the concept of getting data into your Excel spreadsheets automatically.

Excel’s Missing SQL Query Builder

QuerySmith adds a powerful SQL query builder with support for Oracle, MySQL, Microsoft SQL Server and Postgres. Whether you are new to SQL or experienced, QuerySmith makes it easy to manage complex joins, filter criteria and subqueries, all while generating the proper SQL for your database.

Instant SQL Refresh With The Push Of A Button

You’re almost certainly going to wind up in Excel making financial/operational models, projections and what-if scenarios.
QuerySmith automates the work of getting data out of your database application and into a usable form for further analysis.

Getting SQL data into Excel has never been so easy

Our reporting system is years out of date and won’t be upgraded anytime soon. Adding QuerySmith has helped us to deliver new reports people need quickly. The fact that it’s in Excel means it’s easy to justify that it’s a safe choice going forward. Susan Temple

Accounting System Administrator

Our application vendor requires a full client license for each user that just want access to reports. Using QuerySmith, we can deliver identical Excel reports to many more people without paying expensive per-seat licensing fees. Geoff Hunt

Application Implementation Consultant

Via acquisitions, we now run 3 separate versions of Maximo across a number of facilities. Using QuerySmith, we have standardized on a single set of reports. Users at our head office now have a consistent view of everything that’s going on. Mike Smith

Systems Integration Manager

Sign Up Today And Get Started

Download QuerySmith today to get started writing the queries and reports you need.