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

Free download 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 support forum
 

Our working hours: 0am to 10am PST; 3am to 1pm EST; 8am to 6pm CET.

Excel add-ins and Outlook tools - Ablebits.com