NEW RELEASESQL Spreads 7.5.6

Excel as a front-end to write-back data to SQL Server

circle-pulsing

SQL Spreads is an Excel Add-In to let your end-users Update, Insert and Delete data in SQL Server themselves.

five-stars

14-days free trial. No credit card required.

circle

Trusted by 900+ customers in 50+ countries

Microsoft logococacolasamsungPirelli logoBASF Logodupontequinix logoMaersk logo

Why SQL Spreads?

MS Excel icon

Manage SQL Server
data using Excel

Use the well-known data tool everyone loves to also manage your data in SQL Server.

clock

Get started in
5 minutes

Quickly setup which tables and columns to use with the inuitive SQL Spreads Designer.

code

No coding
required

Read and write data between Excel and SQL Server without having to write any SQL or VBA code.

stars-image

5.0/5

A simple and robust method for entering data into a SQL Server database, using the familiarity of Excel. Full data integrity checking and ability to execute procedures etc. No more complex SSIS package building.

Simon Hutchings

Financial Data Analyst

stars-image

5.0/5

SQL Spreads has saved us hundreds of hours. We have used it to put in place data integrity controls and perform mass master data updates. I highly recommend this tool for any business with an SQL Server database.

David Carlson

Chief Financial Officer

stars-image

5.0/5

It’s a fantastic product for non-SQL people. For people experienced with SQL, it is a major time-saving tool that combines the best of SQL and Excel. I would recommend SQL Spreads to any company that uses Microsoft SQL Server

Kevin P. Barnett

Data Analyst

stars-image

5.0/5

Lightning solution to get data in and managed effectively without a whole load of development time.

Phil C.

Data Architect

How it works

sql database icon

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.

computer database icon

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.

security icon

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.

image-21-3

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.

image-21-1-1

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.

image-21-2

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

features-icon

Excel to SQL Server Write-back

Excel users can swiftly update and Write-back data to SQL Server, enhancing productivity and data management.

features-icon

Industry Standard Security

SQL Spreads leverages SQL Server and Windows Security. All data remains within your networks, servers, and databases.

features-icon

Key lookups for data integrity

Text lookups for key values enable easy, integrity-focused relational data management for end-users.

features-icon

Track all changes

Keep track of changes in the database and see who changed a row, and when the change was done.

features-icon

Collaboration

Distinct Designer and Editor roles enables non-technical end-users to securely update SQL Server data using Excel.

features-icon

Easy Deployment

Support for packaged deployments and the ability to include the license with the installation enable seamless installation.

See all features

Frequently asked questions

How is our data stored?

plus minus

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?

plus minus

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?

plus minus

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?

plus minus

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?

plus minus

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.

Try Excel Add-In for free image
14-days free trial. No credit card required.

SQL Spreads Release 7.5.6

Latest Release

2024 September 17
  • 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.
Read more
×