"I'm very impressed with this add-in"  -  Dick, Daily Dose Of Excel   


QueryCell  is a Plugin for Excel that  allows you to query using SQL within the Excel application itself.

  • Query Excel Data Using SQL
         Save time by selecting and joining data within Excel
         using SQL, no database required.
  • Query Access, SQL Server, Oracle, MySQL etc
         From Excel
         Run SQL Selects, Updates, Deletes and Inserts on
         your database without leaving Excel

Spend less time, effort and frustration moving data between your databases and Excel

  • Visual Query Builder
          Create queries visually without writing SQL code more...
  • Generate SQL Insert Statements for Excel Data
          Need to move data from Excel into a database ?
          QueryCell can generate SQL Insert Statements for Excel data in seconds more...
  • Supports Excel 2003, 2007 and 2010
  • $45 USD, 30 day money back guarantee
download trial
Buy Now
  "You've come up with something that genuinely enhances
  Excel's functionality, and I am more than happy to recommend
  it as such"  -  Geoff, Number Cruncher
Highslide JS
QueryCell open in Excel 2007
Highslide JS
Select the data source you wish to query, either the regions of data in Excel or an ODBC database such as Access, SQL Server, Oracle, Mysql etc
Highslide JS
Creating SQL Insert Statements for data is as simple as selecting the region of data you are interested and then selecting 'QC - SQL Inserts' from the right Click menu
Highslide JS
Create 1000s of rows of test / dummy data. Prototype more quickly. Test data columns of the 'Excel Source' type will source their data from excel data regions allowing the population of foreign keys!
Highslide JS
QueryCell pane open in in Excel 2003
Highslide JS
The QueryCell Comic
  "This is a tool any Power Excel User should check out...",
  "I can see this tool saving hours of time"  - BI/BPM - The SeeQueL   

To get a feel for how QueryCell works take a look at this short video

It demonstrates :

Using SQL on Excel Data

Running SQL on a Database from Excel

Creating Test Data

 
(note: row coloring demonstrated in the video is no longer available)

Click the Download button and try QueryCell for yourself

download trial
Buy Now
"I am mighty impressed with your software. This lets me do stuff that takes hours - days in transferring excel data to other applications to allow me to further manipulate it."
- Dr Craig L.F.Noonan - Staff Anaesthetist, MB BS, FANZCA, M.Ed.
logo
  • Copyright Oak Focus Software / QueryCell 2010 (All Rights Reserved).
  • Microsof Excel® is a trademark of Microsoft Corporation.
  • The QueryCell Product and its website are not associated with Microsoft Corporation