Welcome to SQL Spreads Knowledge Base

Intro

SQL Spreads is a lightweight Data Management solution for SQL Server. With the use of Excel as the front-end for managing the data in SQL Server, users can get up and running in minutes.

Built-in Data validation, Drop-Down lists with key lookups, conflict detection, and change tracking guarantee your corporation's data quality.

The knowledgebase will help you to get started and learn all the details about how to create your data management solution using SQL Spreads.

SQL Spreads Videos

00:00 Intro  00:11 Download the free SQL Spreads trial  00:23 Install the SQL Spreads Excel Add-In  00:40 Connect your SQL Spreads Excel document to SQL Server  00:52 Select your SQL Server table to load into Excel  01:02 Update your data in Excel and save back to SQL Server  01:15 The SQL Spreads Knowledgebase

00:00 Intro  00:15 Create a SQL Spreads documents  00:50 Connect the Excel document to SQL Server  01:16 Select SQL Server Authentication method  02:24 Select your Table or View  03:06 Setup how your SQL Server table is shown in Excel  03:45 Saving and sharing your document

00:00 Intro  00:17 Select which columns to show or hide  00:31 Make columns Read-Only  00:45 Change the name of a column  00:52 Arrange columns order  01:05 Create lookups with drop-down lists for key columns  01:37 See column details like data type, length etc.  01:47 Set a default value for empty cells  02:11 Column Filter to filter the rows loaded from SQL Server into Excel  02:22 Custom SQL Filter  to filter the rows loaded from SQL Server into Excel  02:35 Tree Filters - let the user filter which rows to load from SQL Server into Excel  02:54 Sort the rows loaded from SQL Server into Excel

00:00 Intro  00:15 Lookup a key value in a database table  01:20 Lookup a key value in a simple list of key-value pairs

Contact support

If you need any help, feel free to contact SQL Spreads support at:
support@sqlspreads.com

Contact sales

If you have a sales inquiry please contact sales at:
sales@sqlspreads.com