Trusted by 900+ customers in 50+ countries

Join the 900+ businesses and organizations in over 50 countries that use SQL Spreads to simplify their data management by enabling non-technical users to use Excel to update and manage data in Microsoft SQL Server.

Microsoft logoAdobe logoSamsung logoPirelli logoGE Healthcare logoBASF LogoDupont logoEquinix logoMaersk logoVestas logo

Automotive

1A Auto
Apollo Vredestein
Brakeplus
Express Oil
Pirelli
Power Stop

Communications

Charter Communications
AOTMP
CCMI
Sepura

Construction &
Real Estate

Brookfield Residential
DEW Construction
Fischer Homes
Laing O’Rourke
McHugh Construction
North America Construction
Residential One
The British Land Company
TrueHomes

Education

Baker College
Kirkwood College
Onondaga College
UNC Kenan-Flagler
University of Kentucky

Energy

American Electric Power
BHI Energy
BHP Billiton
Huntley & Huntley
MHI Vestas Offshore Wind
UK Power Solutions
Ørsted

Enviromental & Recycling

BOS Solutions
Brown and Caldwell
Pacific Green Technologies
Tetra Tech
Waste Management

Financial Services & Insurance

BDO USA
Gjensidige Forsikring
Motor Trade Finance
NMG Financial Services
Pine Walk Capital
Suncorp
Wolters Kluwer

Food Industry

Continental Foods
Glanbia

Government

Cerro Gordo County
City of Stamford
City of West Des Moines
Deschutes County
Farm Credit Administration
Island County
Jackson County

Healthcare

GE Healthcare
MedPro Billing
New Horizons Enterprises
Rodericks Dental
Salud FamilyHealth Centers
Samaritan Medical Center
Siemens Medical Solutions
Zest Dental Solutions

Industrial

BASF
Chem-Trend
DuPont
Duracell
Emerson
Henkel
Kaneka
Saab Seaeye
Weidmüller

Nonprofits

PAHO
United Nations UNCTAD

Investment & Funds

AMP Services
Caravel Asset Management
Kalnin Ventures
Vertical Ascent Partners
Vornado Realty Trust

Legal

James & Wells
Cooley
Copenbarger Law Firm
Hoge Fenton
Skadden

Life Sciences

AstraZeneca
Enclara Pharmacia
Infinity Pharmaceuticals
Genomatica

Software & Technology

Adobe
Caselle
Equinix
Gulf Coast Technology
Microsoft
OpSec Security
Precise Intelligence
Stanford Linear Accelerator

Testimonials

quote

Before SQL Spreads, the process of managing data felt heavily involved for a relatively small business that did not want to implement a heavy Data Management solution.

Pretty much from the start, SQL Spreads felt like exactly what we were looking for, we owned our database, so it felt great to be so easily on top of it.

SQL Spreads has saved us countless hours in terms of system development.

It turns your SQL dimension tables into a set of simple look up tables and brings SQL and Excel into the same window!

Tom Lawson

Group Information Manager,

Pine Walk Capital, UK

quote

Our operational forecasting process was highly manual and Excel based, and previous projects to shift to an ERP platform failed.

With SQL Spreads, we were able to cheaply and quickly build a SQL Server based forecasting tool using Excel as the front-end user interface.

We continue to iteratively improve the tool without the high costs that would come along with change management of an ERP platform.

Tristen Hannah

Senior Director, Workforce Planning,

US Infrastructure Corporation (Usic)

quote

We implemented an SQL Server based ERP system a few years ago and SQL Spreads has provided a way for us to do some things that would have otherwise been very labor-intensive.

It has saved us hundreds of hours. We have used it to help us put in place data integrity controls and perform mass master data updates.

Installing it was very easy and customer service has been great.

I highly recommend this tool for any business with an SQL Server database.

David Carlson

Chief Financial Officer,

State Systems, Inc., US

quote

Before I started using SQL Spreads, manually updating, and creating data in SQL Server was a cumbersome task, consisting of slow and tedious processes due to the Management Studio interface. Often, we would use some Master Data functionality, but it was always a lengthy process.

About 25 minutes after I installed SQL Spreads and could copy and paste data into my SQL Server, I knew that SQL Spreads had found a niche in the Microsoft ecosystem.

It is a very nice tool, that helps managing data.

David Blythner

Business Intelligence Consultant,

Codan Forsikring, DK

quote

It was always frustrating, and manual, to get data into SQL Server before we had SQL Spreads. I used SSIS and the Import Wizard, but neither is easy to use, and neither would give my customers the ability to quickly load data themselves.

SQL Spreads has allowed me to make user-friendly applications, in an agile way, that my clients can use. Customers are familiar with Excel so the training was minimal.

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,

Hudl Analytics, AU

quote

We had a lot of people in the business who were hiding data in spreadsheets, that was all inaccessible to others in the company, prone to human error.

After we implemented SQL Spreads, I saw them use the tools they were comfortable with, while at the same time keeping the data where it was most useful.

Support has been fantastic, any questions we had were answered quickly and accurately.

It’s a great tool not just for business people, but for developers too. I use it regularly for quickly modifying configuration tables.

Brendon Mills

Senior Developer,

MTF Finance, NZ

quote

It works perfectly, you can just dive in and do the work. Within 5 minutes I was up and running and making updates to our ERP system based on SQL Server.

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.

During the implementation of our new accounting system, migrating the data has been very painful and we have spent a lot on consultants previously. Now I can use SQL Spreads to do most of that work myself.

I would recommend SQL Spreads to any company that uses Microsoft SQL Server, I would even say that any serious company using SQL Server should have SQL Spreads in their software repertoire.

Kevin P. Barnett

Project Manager,

R.E.A. Group Holdings, UK

quote

Prior to purchasing SQL Spreads, we had no interface for users who worked outside of the SQL Server to access and edit information.

In searching for a cost-effective way to enable non-SQL users to access and edit data stored in a SQL table, we found SQL Spreads was the most efficient and user-friendly option.

End-users still interfaced with a table very similar to the Excel table they had been accustomed to, but it enabled multiple members of our administrative team to update information at the same time and now link directly into our SQL server and geographic information.

The time and cost of implementing SQL Spreads were much more efficient than purchasing or building an elaborate custom interface.

Rebecca Alcorn

Graphical Information System Manager,

Huntley & Huntley, Inc., US

quote

Before we used SQL Spreads we had spreadsheet upon spreadsheet of duplicated data. We centralised this into a SQL database and wanted a simple interface for end-users to manage the data.

I researched solutions to synchronise SQL Databases with Excel and came across SQL Spreads, started the trial and knew immediately this would be revolutionary for our processes,

within minutes I had set up the connection and updated 100s of rows of data.

We have increased efficiencies and data integrity, meanwhile, decreasing costs by removing an outdated legacy application and replacing with this simple but elegant and cost-effective tool.

Ellie Shelley

Application and Data Manager,

Associated Independent Stores, UK

quote

“SQL Spreads is a brilliant tool that I think nearly every organization would benefit from. It is quickly helping us solve two long-standing challenges: data ownership and scaling user-generated reports.

I’ve seen a lack of data ownership consistently stem from the fact that database applications, often with web UIs, make maintaining large data sets difficult and tedious. Excel is a far more preferable front-end for this: it’s easy to use, powerful, and familiar to business users.

SQL Spreads bridges the gap – users can maintain and own their data in Excel, but load it into a database enabling data integrity and scalability.

Setting up new SQL Spreads workbooks is easy and our user’s love it. Highly recommend!”

Jonathan Boone

Business Intelligence Developer,

PMI Worldwide, US

Use cases

SQL Spreads lets your organization use the data tool everyone loves, Microsoft Excel, as a front-end to update and manage data in SQL Server. SQL Spreads is super-fast to get started with, and lets you create Excel documents for your non-technical users to easily update or enter data into SQL Server.

Analytics icon Data Management for BI Projects

Building BI solutions with Power BI and SQL Server requires reliable, up-to-date data. While SQL Server provides robust central storage, end-users need a simple way to access, update, and manage this data.

Large master data management tools can be complex to set up and use, and custom web applications are time-consuming to develop. SQL Spreads offers a lightweight, easy-to-use data management solution where end-users can enter and update data.

SQL Spreads utilizes the well-known Excel interface, offering an intuitive environment, while the integration with SQL Server ensures data quality. SQL Spreads simplifies and enhances data management in BI projects.

ERP Icon Financial Forecasting and Planning

Companies working with BI and data analytics often need to collect and aggregate financial data for budgets, forecasts, or KPI calculations. This type of data collection needs to be done in a short time frame and therefore must be easy to use.

By using Excel as an interface with SQL Server as the back-end database, SQL Spreads offers a simple and intuitive forecasting solution. End-users can continue working with the data in the application they know, Excel, while data storage in SQL Server allows for instant aggregation of data across different parts of the organization.

To streamline the forecasting process, SQL Spreads offers features such as row-to-column pivoting, change tracking, data validation, workflow handling, and much more.

Cog icon Data Cleansing and Translation

Data cleansing is essential for maintaining the accuracy and reliability of data, while data translation tables are crucial for ensuring data consistency across different systems.

With SQL Spreads, you can leverage the familiar Excel interface to streamline these processes in data projects.

The role-based usage of SQL Spreads allows data professionals to set up an environment where end-users can cleanse data and manage translation tables using the familiar Excel environment.

Features like foreign key lookups with dropdown lists, data validation, and change tracking maintain high data quality while simplifying updates for end-users.

MS Excel icon Use Excel to Update data in SQL Server

SQL Spreads offers an intuitive way to build solutions that allow end-users to regularly update data in SQL Server. Use cases for updating SQL Server data include ERP data updates, data cleansing, pricing updates, data migrations, and more.

The role-based design of SQL Spreads allows data professionals to easily set up and maintain solutions where end-users can update data in SQL Server tables themselves using the familiar Excel environment. This offloads tasks from IT and BI departments while ensuring data quality.

The familiar Excel interface, along with features like automatic data validation, change tracking, and foreign key lookups, ensures data quality and ease of use.

Case study

Automated forecasting streamlines
monthly project monitoring.

Real-estate company Wallenstam put a lot of effort into producing monthly forecasts for project monitoring and control of their construction projects. In order to streamline the work Wallenstam introduced SQL Spreads. Wallenstam now has an automated forecasting process with increased safeguards, a higher quality of submitted forecasts and saves about 500 man-hours a year.

Situation

Wallenstam is one of Sweden’s largest real-estate companies, managing, building and developing properties in Gothenburg, Stockholm and Helsingborg. Wallenstam makes monthly forecasts for all ongoing construction projects to ensure that their cost parameters are followed. The project managers felt that the amount of work required to make these predictions was very time consuming. It was largely a manual effort, where project managers input data manually thus increasing the risk of errors.

The work was performed in Microsoft Excel. Håkan Lindhén, project controller at Wallenstam, says: “We dealt with a variety of files that could be difficult to structure. Another problem was that our users have different levels of Excel knowledge and use templates in different ways, resulting in an unsafe and unreliable template.”. Wallenstam’s controllers had to expend much time and energy to help project managers in their efforts to develop forecasts.

Meanwhile Wallenstam employees were used to working with Microsoft Excel and it was perceived as a problem to switch to a completely new solution. “I’ve worked in web-based cost management programs in the past and the problem is that they are so extremely inflexible that you always encounter problems. They become difficult to work with and can result in project managers not using the system.” says Håkan Lindhén.

Solution

Using SQL Spreads, Wallenstam implemented a new solution for project monitoring. “The introduction of SQL Spreads has worked very well. The employees who will work with the forecast have been able to see the progress and influence the design of the final solution along the way. This facilitates implementation because the project managers’ views are incorporated and through their participation they are already motivated to start working with our new forecasting tool.” continues Håkan Lindhén.

“ We have together with project managers christened the program as WaKS, Wallenstam Cost Control. ”

SQL Spreads connects to Wallenstam’s data warehouse so that the comparative data is loaded into the forecasting spreadsheet automatically. – “To automate the input of comparative data into the forecast will save a lot of time and we know that the values in the forecast are identical to those we have in the financial system.”

“ Project managers can spend more of their time running their projects instead of creating forecasts. ”

Wallenstam’s employees can easily access the forecasting tool via Microsoft Excel. “With SQL Spreads we get a very consistent and pleasing interface, with a common entrance to both current and archived forecasts. It gives us a much more unified view.”

When users work with SQL Spreads, they receive a lot of automatic support – “Now it is handled mostly by automation which means that project managers can spend more of their time running their projects instead of creating forecasts.” states Lindhén.

Results

  • Saves about 500 man-hours a year
  • Project managers can spend more time running projects
  • Higher quality of submitted forecasts
  • Better understanding of the forecasting process
Wallenstam logo

Customer
Wallenstam AB is a Swedish real-estate company listed on the Nasdaq OMX Nordic Stock Exchange. Wallenstam develops and manages properties worth 3.7 billion USD.

Requirement
The need to introduce a new forecasting tool to produce monthly cost forecasts for on-going construction projects.

Solution
A user-friendly, secure and automated forecasting tool – built in Excel using SQL Spreads.

Results
Significantly higher quality of submitted forecasts. Greater security in the forecasting process. Saves about 500 man-hours a year.

Links
wallenstam.se

Contact
Håkan Lindhén
Project Controller,
Wallenstam AB

Try SQL Spreads for free

Try SQL Spreads during 14 days for free. The free trial is the fully
functional, time-limited only product.

×