Welcome to SQL Spreads Knowledge Base
- Print
- DarkLight
- PDF
Welcome to SQL Spreads Knowledge Base
- Print
- DarkLight
- PDF
Article Summary
Share feedback
Thanks for sharing your feedback!
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: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: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: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: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