How to Export SQL Server Data to Excel

(ScreenShots are available below)

There are many different way to get data out of SQL Server and into Excel. Here we demonstrate how to do this very easily using QueryCell

1. Make sure you are connected to your SQL Server database.

2. Run your Select Query.

3. Rename the QueryResults Worksheet.

The screenshots demonstrate Excel 2003 but the same process can be used in Excel 2007 and Excel 2010.

  Screenshots (Click to enlarge)

Highslide JS
Select your SQL Server Data Source
Highslide JS
Run your Stored Procedure Exec Command
Highslide JS
Run your Stored Procedure Exec Command

After You've Got Your Data from SQL Server into Excel

Now that the data you need from SQL Server is in Excel you can use QueryCell to query it using SQL. You can join it to other data in excel for example.

Because the data is in Excel you have access to Excel formulas and functionality.

You can also use QueryCell to run SQL delete statements to remove the data from SQL Server and create Insert statements to insert new or modified data into SQL Server.

  "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
  • 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...
  • 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...
  • Supports Excel 2003, 2007 and 2010
  • QueryCell is Only $45!

    30 day money back guarantee!

  "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
  "This is a tool any Power Excel User should check out...",
  "I can see this tool saving hours of time"  - BI/BPM - The SeeQueL   


logo