"I’m very impressed with this add-in."   -   Daily Dose Of Excel   
    No SQL Server Required. QueryCell is a complete solution. Query with SQL in Excel!    


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

  • Query Excel Data Using SQL
         Save time by selecting and joining data within Excel
         using SQL
  • 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...

Check Out the Screenshots and Video Below

  • Color Rows that match your criteria
          "I want to mark all the rows in worksheet1 where COLUMN_A is greater than COLUMN_B
          in Worksheet2"     It's easy with QueryCell more...
  • Generate Test/Dummy data
          Use the Test Data Table Generator to produce test data you can tweak in Excel and then
          turn into SQL inserts and get into your database more...
  • Easy to Install and easy to Uninstall
  • Supports Excel 2003 and 2007
download trial
Buy Now
Highslide JS
QueryCell pane open in in Excel 2007.
Highslide JS
The Regions Grid on the left and the SQL Template Library on the right can be minimized with a single click of the splitter bar.
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
You can mark rows that match your critera. Use different colors to mark rows matching different criteria.
Highslide JS
QueryCell pane open in in Excel 2003.

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

It demonstrates :

Using SQL in Excel

Marking Rows that match your criteria

Creating Test Data

Generating SQL Insert Statements

 

Click the Download button and try QueryCell for yourself

download trial
Buy Now
logo
  • Copyright Oak Focus Software / QueryCell 2009 (All Rights Reserved).
  • Microsof Excel® is a trademark of Microsoft Corporation.
  • The QueryCell Product and its website are not associated with Microsoft Corporation