Excel as a front-end to write-back data to SQL Server
SQL Spreads is an Excel Add-In to let your end-users Update, Insert and Delete data in SQL Server themselves.
Trusted by 900+ customers in 50+ countries
Why SQL Spreads?
Manage SQL Server
data using Excel
Use the well-known data tool everyone loves to also manage your data in SQL Server.
Get started in
5 minutes
Quickly setup which tables and columns to use with the inuitive SQL Spreads Designer.
No coding
required
Read and write data between Excel and SQL Server without having to write any SQL or VBA code.
How it works
1. Connect to
SQL Server
Easily install the Excel Add-In and connect Excel to your SQL Server. Quickly load your database tables into Excel, start editing your data and write-back changes to SQL Server.
2. Setup Excel as
a Front-end
Exactly control how your data in the database tables are updated from within Excel. Hide or show columns, make columns read-only, or lookup keys values in related tables.
3. Securely Invite
End-Users
With SQL Spreads relying on SQL Server and Windows Security, it is secure to invite your team. SQL Spreads does not store any of your data outside of your network.
Maximize efficiency:Key Benefits of using Excel for SQL Server Data Updates
Update your SQL
Server data using Excel
Easily use Excel to Update, Insert and Delete data in SQL Server directly from within Excel. Create solutions for end-users where they take ownership and update the centralized data in SQL Server by themselves.
Ensure data quality
Automatically validate all entries against the data types in SQL Server. Work with related tables using drop-down lists and show descriptive texts instead of keys. Track changes and avoid conflicts when working together.
Easy to setup, easy to maintain
Get up and running within 5 minutes with no need for coding. Easily maintain your solutions in-house when the requirements change down the line. Easily collaborate and delegate the responsibility to the data owners.
Secure solution
SQL Spreads relies on Windows and SQL Server security to protect access to your data. All your data is stored within your organisation’s own network on the databases that you control yourself.
SQL Spreads Comparisons
Power BI + SQL Spreads
Power BI shines in data visualization and business intelligence, enabling users to create interactive reports and dashboards.
SQL Spreads complements Power BI perfectly and facilitates the maintenance of manually added data, such as financial forecasts, sales forecasts, and product categories. It empowers data owners to update and manage their data, ensuring enhanced accuracy in Power BI reporting.
SQL Spreads vs.
Management Studio
SQL Server Management Studio may be complicated and difficult to navigate for business users not well-versed in SQL Server.
SQL Spreads uses the familiar Excel interface, enabling business users who are proficient in Excel to comfortably access and interact with SQL Server data.
SQL Spreads vs.
Custom Web Applications
Creating a Web Application to modify data in SQL Server provides versatility but may require significant time to develop and can be challenging to maintain.
SQL Spreads offers a quicker and more straightforward setup, enabling the in-house creation and maintenance of solutions without the need for coding.
SQL Spreads vs.
Power Apps
Power Apps is a flexible platform for developing a variety of application interfaces. It offers an easy start but can quickly become complex.
SQL Spreads is a user-friendly data management tool that leverages the familiar Excel interface, making it ideal for quickly and easily creating solutions to update data in SQL Server.
SQL Spreads vs.
Power Query
Power Query is an ETL tool designed for fetching data from various sources, processing it, and loading it into one or more destination systems. It supports exporting data to SQL Server, but requires scripting and coding.
SQL Spreads introduces an intuitive Excel interface to easily update SQL Server data directly from Excel without any coding.
Best Features for easily updating data in SQL Server using Excel
Excel to SQL Server Write-back
Excel users can swiftly update and Write-back data to SQL Server, enhancing productivity and data management.
Industry Standard Security
SQL Spreads leverages SQL Server and Windows Security. All data remains within your networks, servers, and databases.
Key lookups for data integrity
Text lookups for key values enable easy, integrity-focused relational data management for end-users.
Track all changes
Keep track of changes in the database and see who changed a row, and when the change was done.
Collaboration
Distinct Designer and Editor roles enables non-technical end-users to securely update SQL Server data using Excel.
Easy Deployment
Support for packaged deployments and the ability to include the license with the installation enable seamless installation.
Frequently asked questions
How is our data stored?
All data is stored on your machines and in your databases. We don’t handle any of your data. SQL Spreads does not store any data outside of your local network.
How is security handled?
SQL Spreads relies on SQL Server and Windows security and does not have its own mechanism to handle security to connect to the database.
Do I need coding knowledge to use SQL Spreads?
SQL Spreads does not require any coding to create data management solutions. For creating more advanced filters, you can use basic SQL queries.
Do I need a licence for each user?
Yes, all users that will create SQL Spreads documents or work with SQL Server data in documents created by other users need to have the SQL Spreads Excel Add-In installed with a valid license or subscription.
What is the difference between a Designer and Data Editor?
A Document Designer is the user who creates SQL Spreads documents, connects them to SQL Server and decides which columns and rows should be updatable using the document.
A Data Editor is the end user who uses the documents created by a designer to update the data in SQL Server. A Data Editor does not need any technical skills or knowledge about the database, only basic Excel knowledge is required.
Try SQL Spreads for free
Try SQL Spreads during 14 days for free. The free trial is
the fully functional, time-limited only product.
SQL Spreads Release 7.5.6
Latest Release
- Redesigned Introductory Dialogues:
We have redesigned the introductory dialogues to provide a more intuitive user experience. This includes a new option to restart the introduction at any time. - Enhanced Tree Filters Hierarchy:
The Tree Filters hierarchy now supports an unlimited number of levels of depth, allowing for more complex data structures. - Retrieve Code or Text from Hierarchical Tree Filters:
We have added parameters to retrieve the Code or Text of levels above the selected item in hierarchical Tree Filters. - Support for Dependent Dropdowns for Lookups:
A new setting has been introduced to use custom dropdown lists for lookups in SQL Spreads, enabling the use of dependent or cascading dropdowns. - Localized Number Separator in Row Counter:
The row counter within the SQL Spreads Designer now uses localized number separators based on the user’s regional settings.