• Why SQL Spreads?

    Easily use Excel as a front-end to update data in SQL Server

    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-database users to easily update or enter data into SQL Server.

    Data warehousing

    Having data in a Data Warehouse that is relying on IT-personnel or SQL Server’s Database Import Wizard to be managed and updated is a slow and inefficient way that will prevent you from keeping your data up to date.

    By using Excel as a front-end to manage and update data in your Data Warehouse, you can allow the people who are responsible for the data to keep it up to date. This will improve your Data Warehouse and analytics performance and give you one easily accessible common source of data.

    Master Data Management

    Master Data Management tools can be expensive to purchase and complex to setup and use.

    SQL Spreads is a light-weight data management product that can manage data in a simple and easy way. End users can enter and edit data in an environment that they are comfortable with while still allowing you to control data quality by using back-end business logic.

    SQL Spreads give your end-users a secure and easy way to enter and load data into SQL Server directly from the familiar interface in Excel.

    ERP Data management

    Loading or updating larger amounts of ERP data like price changes or batch imports can be a struggle.

    Clicking through application windows will be very time consuming and writing complex scripts will be limited to only a few advanced users.

    SQL Spreads will let your non-technical user use Excel as a front-end to update SQL Server data. They can quickly and easily import or update hundreds or thousands of rows of data in SQL Server. SQL Spreads takes care of security, data validation, and changes can easily be tracked.

    For batch imports, our users save hundreds of hours by automatically matching the updated rows with the database and avoiding to manually search through hundreds of rows for every update.

    Data Analytics

    Collecting or storing analytics data in Excel files is not an efficient way in today’s connected world with great new analytics tools like Power BI, Tableau, etc.

    SQL Spreads will allow you to move all your analytics data into SQL Server.

    Your end-users can continue using Excel to enter and update the data and SQL Spreads will take care of security, data validation, change tracking, and more.

    Join our 350+ customers in over 40 countries

    Join the 350+ businesses and organizations in over 40 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.

    What our customers are saying

    “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

    CFO, State Systems, Inc., US

    “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. It should be used by professionals.”

    David Blythner

    BI Consultant, Codan Forsikring, DK

    “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

    “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

    “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

    R.E.A. Group Holdings plc, UK

    “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

    GIS Manager, Huntley & Huntley, Inc., US

    “For anyone whom is planning to perform data manipulations into their SQL Server and has a good knowledge of Microsoft Excel, SQL Spreads ties in all the power of Excel for you to use and update your SQL tables.

    Makes things go so much faster and as we all know time is money. Download the trial and test it for yourself, you won’t regret it.”

    Alex Pommier

    QuickSocial LLC, US

    “I would recommend SQL Spreads to anyone who needs to manage SQL Server data without having to write code.

    With SQL Spreads you just link Excel directly to SQL Server.

    It is user-friendly, saves time and makes life much easier.”

    Julie Irwin

    Diamond Packaging, US

    Customer case: 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 project

    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:

    www.wallenstam.se

    Contact:

    Håkan Lindhén
    Project Controller,
    Wallenstam AB