Excel to SQL Server Add-In

The Benefits

Manage and update centralized data through Excel

For organizations using Microsoft SQL Server, who need to create solutions where end-users can manage and update their SQL Server data through Excel, SQL Spreads is an Excel to SQL Server Add-In that lets you:

• easily create solutions to manage and update SQL Server data using Microsoft Excel,
• improve data quality by utilizing automatic validation and integrity checks, and
• enable data owners to reach their centralized data through Excel.

Well-known Excel interface

Business users who are used to work with data in Microsoft Excel will be up and running in minutes with updating and managing SQL Server data using the same tool they are used to; Microsoft Excel.

No problems with wrong data types

When importing user data to SQL Server, wrong data types may cause problems. SQL Spreads has a built-in data check that validates the data at the same time it is entered by the user.

Simple data integrity checks

Drop-down lists make it easy for users to update data columns with foreign key relations – the user selects a text item in the drop-down list in Excel, and SQL Spreads will insert the corresponding key into the database table.

No coding required

SQL Spreads does not require any coding to create data management solutions. Use existing knowledge in Microsoft Excel and SQL Server to build and update your Excel to SQL Server solution.

Easy to maintain and update

A data management solution in SQL Spreads is built using basic Excel and SQL knowledge. Solutions can be maintained in-house without the need to rely on external consultants for updates and changes further down the line.

No more troublesome SSIS-imports of Excel files

Importing Excel data into SQL Server using SSIS can be hard. Invalid data types and unclosed files are a few issues that may cause the Excel to SQL Server import to fail.

When using SQL Spreads, data is instantly updated in the SQL Server database.

No more complex VBA scripts to import Excel files to SQL Server

VBA projects can be tough to maintain over time. SQL Spreads use VBA-free Excel documents together with standard database technologies to move data from Microsoft Excel to SQL Server.

Our features

End-user data management of Microsoft SQL Server data

SQL Spreads reads and writes data between Excel and Microsoft SQL Server, and is designed to create end-user applications to update and manage centralized SQL Server data using Microsoft Excel.

Insert, update and delete data in tables in SQL Server through Excel

SQL Spreads will write updates in Microsoft Excel back to SQL Server. Existing data can be updated, new rows can be added or existing rows can be deleted.

Automatic validation for data quality

When a new value is entered into a cell in Excel, SQL Spreads instantly validates the value against the data type of the mapped column in SQL Server to prevent unsafe data entries.

Drop-down lists for data consistency

To keep data consistent, SQL Spreads creates data-driven drop-down lists in Excel. Data-driven drop-down lists make it possible for the end-user to select a text in the drop-down lists while the corresponding key value is inserted into the database.

Tree-View data selection filter

SQL Spreads can create database import filters that are presented in a Tree-View in Excel. By selecting filter items in the Tree-View, users can select which database data to load into the spreadsheet.

The Tree-View items are fully customizable and are created using standard SQL queries to fetch filter items from the database.

Change tracking

SQL Spreads tracks which user-created and changed a row in a table in SQL Server, and the time when the change was made.

Conflict detection

SQL Spreads’ built-in conflict detection ensures that collaboration works smoothly and that several users can work against the same SQL Server tables at the same time.

Pivot data between Excel and SQL Server

If you have data stored in SQL Server in a row-wise format, SQL Spreads can easily pivot those SQL Server rows into columns in Excel so that end-users can edit and update the data in a column-wise format in Excel.

When saving the data from Excel back to SQL Server, SQL Spreads will save the columns in Excel as rows in SQL Server.

SQL Spreads can update, insert and delete data in pivoted format.

Designer and Data Editor roles

SQL Spreads makes it possible for a person with database knowledge to create an Excel document for data maintenance, and then share that Excel document with non-database skilled users so they can work with the data through Excel.

When sharing an SQL Spreads Excel document, you can install SQL Spreads in Data Editor mode. In Data Editor mode, all the Design-features in SQL Spreads will be locked down, and the user can only do changes in the data, not in the setup of how data is transferred back and forth between Excel and SQL Server.

Data Post-processing

Data that SQL Spreads updates in SQL Server can be post-processed for purposes such as cleaning, copying, validation, etc. Data Post-processing is done using a custom SQL query that is executed after the data has been saved to the database.

» Download Demo Files

Start updating
SQL Server data from Excel