• SQL Spreads Features

    End user data management of Microsoft SQL Server data

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

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

    SQL Spreads will push updates in 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.

    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.

    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.

    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 pivot format.

    Mixed database and formula columns

    When importing data from SQL Server into Excel, SQL Spreads can mix columns containing data from SQL Server with columns containing Excel formulas.

    By mixing data and formula columns, comparison columns can show percentage calculations and other direct feedback to the user.

    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.

    User authentication

    SQL Spreads detects the user’s Windows Login, which can be used to filter data from the database.

    Data maintenance for non-database skilled users

    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 User mode. In Data User 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.

    Start updating
    SQL Server data from Excel