SQL Server for Microsoft Excel

Import, edit and generate data for SQL Server in Excel 2007-2013. Free download

With SQL Server for Excel you can easily view, edit and update records in a Microsoft SQL Server database table without using SQL Scripts or SQL Server Management studio:

  • Edit SQL Server data in Excel
  • Save changes to a file or apply directly in Excel
  • Quickly generate demo/sample data

Complete support for:

See a list of your database tables on the add-in pane

Easily edit and generate SQL Server data in Excel

If you ever wanted to use Excel’s drag-and-drop and copy/paste functionality to update your SQL Server records, this add-in is for you. With SQL Server for Excel, you can easily open data contained inside a Microsoft SQL Server database table and update the existing records.

The changes you make can then either be automatically applied from within Excel by simply clicking a button or saving to a file to be run on the SQL server at a later stage.

SQL Server for Excel also provides the functionality to insert demo or sample information into an existing SQL table. Simply select any CSV file containing data, select which column’s details to use, highlight the cells you wish to update and click the “Insert random data into selection” button. SQL Server for Excel will then automatically select random values from the CSV file and insert it into the Excel selection. The changes can then either be saved to a file or immediately applied to the database.

This is an ideal feature for developers who wish to demo their product but who do not wish to display real client data during the demonstration.

SQL Server for Excel screenshots

Quickly and easily connect to a SQL Server database.

Use this dialog to connect to a SQL Server database

See a list of database tables and simply double-click to open the data in Excel.

See a list of your database tables on the add-in pane

Select any CSV file with sample data, specify which column in the file to use, select the cells in Excel where the data should be written to and random values will be generated.

Quickly generate sample data

Please note, this is a BETA release

Free Download
Freeware, 2.73 MB

SQL Server for Excel system requirements:

Operating System

  • Windows 8 (32- and 64-bit)
  • Windows 7 (32- and 64-bit)
  • Windows Vista (32- and 64-bit)
  • Windows XP (32-bit)
  • Windows Server 2003, 2008, 2012
  • .NET Framework 4.5 must be installed.

Microsoft Excel

  • Microsoft Excel 2013 (32- and 64-bit)
  • Microsoft Excel 2010 (32- and 64-bit)
  • Microsoft Excel 2007

Featured customers

Ablebits.com featured customers
 
Contact us
 
  Publish your message on our forum
 

Please remember that we work from 8am to 4pm GMT, this is 4:00am to 12:00pm EST,
1:00am to 9:00am PST, and our public holidays may differ from yours.

Ultimate Suite for Excel Professionals
 
 
50+ professional tools for Excel 2016-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Awesome!!!
Sheila Blanchard