SQL Spreads v4.50.148.0 - Easy Data Management for SQL Server

SQL Spreads v4.50.148.0

SQL Spreads v4.50.148.0
SQL Spreads v4.50.148.0


Easily let your end-users update their data in SQL Server. We believe in simplicity and ease of use. We believe that data should be easy to manage and easy to keep up to date. That is why we are making SQL Spreads the number one choice for updating and managing data in SQL Server.

SQL Spreads 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 Add-In that lets you:

easily create solutions to manage and update data in SQL Server through 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 working in Excel will be up and running with a SQL Spreads solution in minutes.

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 relation – 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 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.

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 project can be tough to maintain over time. SQL Spreads use VBA-free Excel documents together with standard database technologies to move data from Excel to SQL Server.

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.

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.

Technical Information
Supported Excel editions
SQL Spreads is an Excel Add-In that can be installed on Excel 2019, 2016, 2013 or 2010 either 32-bit or 64-bit.

SQL Spreads can be used with the desktop version of Excel for Office 365 either 32-bit or 64-bit.

Supported databases
SQL Spreads supports Microsoft SQL Server, any version from SQL Server 2005 to SQL Server 2017 and any edition from Express or higher.

SQL Spreads also supports Azure SQL.

SQL Spreads can connect to SQL Server using either Windows Authentication or SQL Server Authentication.

Supported Windows editions
SQL Spreads can be used on Windows 10, Windows 8 or Windows 7, either 32-bit or 64-bit.

Prerequisites
Prerequisites for installing SQL Spreads are:

.NET Framework 4.0 Client Profile
VSTO 2010 Runtime
The SQL Spreads installer will check for prerequisites before installation and install them if necessary.