Welcome to SQL Spreads Knowledge Base
    • Dark
    • PDF

    Welcome to SQL Spreads Knowledge Base

    • Dark
    • PDF

    Article Summary


    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

    Get up and running

    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

    How to evaluate and purchase SQL Spreads

    00:00 Intro 
    00:20 The free SQL Spreads trial 
    00:35 How to evaluate the Basic, Pro and Premium plan in SQL Spreads
    01:07 The Document Designer and Data Editor roles 
    01:50  Licensing and purchasing

    Create your first SQL Spreads document

    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 

    Fine-tune your SQL Spreads 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
    02:22 Custom SQL Filter  to filter the rows loaded from SQL Server 
    02:35 Tree Filters to filter which rows to load from SQL Server
    02:54 Sort the rows loaded from SQL Server into Excel 

    Create Drop-down with texts for Key values

    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:

    Contact sales

    If you have a sales inquiry please contact sales at:

    Was this article helpful?