Buy Now

Try For Free

  • The Excel and SQL Server experts blog

  • How to Use XMATCH: Guide and Examples

    Andy McDonald - Aug 18, 2022

    In a previous post, we looked at XLOOKUP, which is the new and improved replacement for one of Excel’s most popular functions, VLOOKUP. In this article, we’re going to look at XMATCH, which (you’ve guessed it) is a replacement for the MATCH function. As you’ll see, XMATCH doesn’t enhance the old MATCH function particularly – …

  • Excel Linked Data Types: An Introduction

    Andy McDonald - Aug 18, 2022

    There’s a cool feature in Excel for Microsoft 365 that not many people know about. Linked Data Types allow you to access data from a range of subject areas such as finance, geography, nutrition, and media directly in Excel. Do you need to include the latest exchange rates, company stock prices, or city population figures …

  • SQL Spreads release 6.2.8

    Johannes Åkesson - Aug 09, 2022

    SQL Spreads 6.2.8 is now available for download. Fixed issue with bigint numbers with more than 17 digits that were truncated. Fixed issue with commas in text key columns. Fixed issue with uninstalling when both the per-machine and the per-user versions was installed. Fixed issue with the database connection setting “Remember password on local machine”. …

  • What is the equivalent to VLOOKUP in SQL?

    Andy McDonald - Jul 14, 2022

    In this article, we’re going to show you how to perform the equivalent of Excel’s VLOOKUP in SQL.  This is the second of our articles aimed at teaching Excel users the basics of SQL. In our previous article “Introduction to SQL for Excel Users”, we introduced the JOIN statement, and here we’re going to expand …

  • Introduction to SQL for Excel Users

    Andy McDonald - Jul 04, 2022

    This is the first of several articles on SQL for Excel users.  The aim is to show you why it’s so useful for Excel users to be familiar with SQL and to introduce some basic concepts and queries. Why is it important to learn SQL? In a previous article, SQL and Excel: Why you need …

  • Excel Power Query: What is it? Why use it?

    Andy McDonald - Jul 01, 2022

    With Excel Power Query you can connect to data sources, import data, clean and shape it and then load it into Excel or a data model so that you can create charts and reports. In this article, we’re going to look at some examples of where you’d use Power Query and give a quick overview …

  • How to Use SQL with Excel for Data Analysis

    Andy McDonald - Jun 08, 2022

    In a previous article, we talked about why most organizations should use both SQL Server and Excel for their data management needs. In this article, we’re going to look at an example of how to perform data analysis using SQL and Excel with an Excel Add-In, called SQL Spreads. You can use the Add-In to …

  • SQL Spreads release 6.2.1

    Johannes Åkesson - May 23, 2022

    SQL Spreads 6.2.1 is now available for download. Support for connecting to Azure SQL using Azure AD Authentication. Support for using Multi-Factor Authentication when authenticating to Azure AD. Download the latest version of SQL Spreads »

  • How to Connect Power Apps to SQL Server

    Andy McDonald - May 13, 2022

    In this article, we’re going to look at how to connect Power Apps to SQL Server.  This provides a slightly deeper dive than was covered in our previous Quick Start Guide to Power Apps. Power Apps is the low-code/no-code platform from Microsoft. It aims to make it quick and easy for people in organizations to …

  • SQL Server Import and Export Wizard Guide

    Andy McDonald - May 06, 2022

    This guide explains how to use the SQL Server Import and Export Wizard to get data into a SQL Server database. What is the SQL Server Import and Export Wizard? SQL Server Import and Export Wizard is a simple way to copy data from a source to a destination.  It is most commonly used to …

  • Connect Excel to SQL Server: 3 Easy Steps

    Andy McDonald - May 06, 2022

    In a previous article, we spoke about why you need both Excel and SQL in your data management solutions, but how do you connect Excel to SQL Server?  In this article, we’re going to show you the steps and highlight a key benefit of using an Excel add-in like SQL Spreads. But, first, we’re going …

  • Export Power BI to Excel: Solved

    Andy McDonald - May 03, 2022

    Power BI is a Business Intelligence (BI) platform. With Power BI, users can get data, analyze it, and create visualizations that help turn raw data into actionable information for their business.  It’s normally the case that you want to import data from Excel to Power BI to create a dashboard or report, but there are …

  • Power BI Fact and Dimension Tables

    Andy McDonald - Apr 01, 2022

    In an earlier article, we looked at how to create a dashboard based on some sales data.  The data source for that example was several tables in a SQL database.  In this article, we’re going to look in more detail at the data model we built in that Power BI example, and specifically the use …

  • SQL Spreads release 6.1.32

    Johannes Åkesson - Mar 29, 2022

    SQL Spreads 6.1.32 is now available for download. Improved deleting of rows in the database to align with Excel’s Delete rows. Added check if per-machine or per-user installer exists. Added a possibility to call Excel’s Refresh All command after data is saved to the database. Fixed bug so that commas can be used in Pivot …

  • SQL and Excel: Why you need both

    Andy McDonald - Mar 12, 2022

    SQL vs. Excel: which is better?  As you can see from the title of this article, it’s not the case that you should choose one over the other; you actually need SQL and Excel. Introduction Excel is a really great application.  There are not many applications that are used by such a wide variety of …

  • How to use XLOOKUP: Guide and Examples

    Andy McDonald - Mar 02, 2022

    If you’ve been using Excel for a while, you’ll undoubtedly have used one of its most useful functions – VLOOKUP.  This lookup function is invaluable when manipulating data or preparing reports in Excel.  If you’re already familiar with VLOOKUP, then you’ll love the new XLOOKUP function that Microsoft released in late 2019.  It overcomes some …

  • What is Power Apps? Quick Start Guide

    Andy McDonald - Feb 18, 2022

    More and more people are using no-code technologies to create mobile apps, and there are a growing number of vendors in this area.  In this article, we’ll be focusing on Microsoft’s no-code platform, Power Apps. Because it’s a no-code platform it should be easy to create apps, right?! Well, yes, it is easy to use …

  • Creating Reports with Power BI, SQL and Excel

    Andy McDonald - Feb 09, 2022

    In an earlier post, we introduced Power BI and looked at what makes a good dashboard.  In this article, we’re going to go through the steps for creating reports with Power BI, SQL, and Excel.   How Does Power BI Work? A Brief Overview Power BI is a Business Intelligence (BI) platform. With Power BI, …

  • CSV to SQL: How to Convert, Open & Import

    Andy McDonald - Jan 31, 2022

    In this article, we’re going to look at 3 ways to convert a CSV file to SQL. This is a common use case, so hopefully, you’ll find the following information useful in your day-to-day work. Introduction Comma Separated Values (CSV) files are commonly used to exchange data from one system or application to another.  The …

  • SQL Spreads release 6.1.15

    Johannes Åkesson - Dec 09, 2021

    SQL Spreads 6.1.15 is now available for download. Added support for the new pricing model with Basic, Pro and Premium plans and separate Editor licenses. Added a checkbox to the Table Creator to decide if columns in a new table should be nullable. Added a field to set the name of the Identity column in …

  • Master Data Management: What is it and Why is it Important?

    Andy McDonald - Dec 02, 2021

    Master Data Management (MDM) is an information management discipline focusing on data quality and data governance. Its goal is to mitigate problems caused when Master Data is inconsistent, fragmented, or out of date. In this article, we’re going to explain what MDM is and provide some tips on how to start an MDM journey. What …

  • SQL Spreads release 6.0.44

    Johannes Åkesson - Oct 29, 2021

    SQL Spreads 6.0.44 is now available for download. This new release focus on stability improvements – we have made a number of stability improvements and fixes in the areas around Excel table formatting, detection of changes in SQL Server etc. Added the possibility to set a Default value for a column to use when a …

  • Simple Data Validation in SQL

    Andy McDonald - Oct 24, 2021

    What is data validation in SQL and why is it important?  Data validation is a method for checking the accuracy and quality of data.  Information in databases is constantly being updated, deleted, queried, or moved by multiple people or processes, so ensuring that data is valid at all times is essential. In this article, we’re …

  • How to create Pivot Tables in SQL Server

    Andy McDonald - Oct 10, 2021

    In this article, we’re going to show you how to create pivot tables in SQL Server.  This is the third article aimed at teaching Excel users some basic SQL server queries, and how to mimic some of the main functions used in Excel. In a previous article we looked at the equivalent of Excel’s VLOOKUP …

  • SQL Spreads release 6.0.30

    Johannes Åkesson - Jun 17, 2021

    SQL Spreads 6.0.30 is now available for download. This new release introduce a new feature to use the Tree filter selection as the key column when inserting new rows into a table. Added a new Parameter selection dialog to easily insert Tree Filter and Cell parameters. Added the possibility to remove key columns that are …

  • SQL Spreads release 6.0.17

    Johannes Åkesson - Mar 30, 2021

    SQL Spreads 6.0.17 is now available for download. SQL Spreads 6.0 introduces the new Lookup feature to easily lookup key values from a related table or a list of fixed key-text pairs. A drop-down list in Excel allows the user to select a text item, while the corresponding key will be written to the database. …

  • SQL Spreads release 5.1.12

    Johannes Åkesson - Sep 30, 2020

    SQL Spreads 5.1.12 is now available for download. Added support for using key columns with the UNIQUE IDENTIFIER data type while also generating new IDs as a default value in SQL Server. Fixed issue with Designer being locked for new worksheets in certain cases. Minor bug fixes Download the latest version of SQL Spreads »

  • SQL Spreads release 5.1.07

    Johannes Åkesson - Jul 01, 2020

    SQL Spreads 5.1.07 is now available for download. The Excel table is now always resized to the number rows that are imported from the database. Added support for using SQL Server columns with the data type DateTimeOffset. Conflict detection will now work over different time zones when setting the ModifiedOn Change Tracking column to a …

  • What’s new in SQL Spreads 5.0?

    Johannes Åkesson - May 07, 2020

    SQL Spreads 5.0 is the largest update in over two years, with several new and exciting improvements. We have implemented a couple of long-anticipated features, such as: We have also implemented several changes to improve how you can develop and deploy SQL Spreads documents: To try SQL Spreads 5.0, you can download the 14-day free …

  • SQL Spreads release 5.0.55

    Johannes Åkesson - Apr 29, 2020

    SQL Spreads 5.0.55 is now available for download. SQL Spreads 5.0 is the largest SQL Spreads update in over two years with several long-wished features and improvements such as data pivoting, the table creator and database, and table search. Introducing the new Pivoting feature to update pivoted data in columns in Excel into rows in …

  • SQL Spreads release 4.50.148

    Johannes Åkesson - Dec 02, 2019

    SQL Spreads 4.50.148 is now available for download. Fixed issue with changing the SQL Server server name (the text field was disabled) when opening a document when the SQL Server instance is not accessible. Fixed issue with conflict detection not saving non-conflicting rows correctly. Fixed issue with checking the license on the server if a …

  • SQL Spreads release 4.50.139

    Johannes Åkesson - Oct 31, 2019

    SQL Spreads 4.50.139 is now available for download. With this release, we are introducing a new license system that supports online activations and a lot of new features on the deployment and installation side. With the new online activations, there is no need to manually activate the licenses through emails. If you are an existing …

  • SQL Spreads release 4.4.7

    Johannes Åkesson - Jun 05, 2019

    SQL Spreads 4.4.7 is now available for download. Fixed issue when working with protected Excel worksheets. Fixed issue with conflict detection giving an error under certain circumstances. Download the latest version of SQL Spreads »

  • SQL Spreads release 4.4.5

    Johannes Åkesson - Apr 16, 2019

    SQL Spreads 4.4.5 is now available for download. Fixed issue with “Remember password on this machine” for Data User installations. Fixed issue with license key being lost when upgrading SQL Spreads – the fix resolves the issue for upgrades from 4.4.5 and forward on. Fixed issue with loading data when using Excel tables with table …

  • SQL Spreads release 4.4.3

    Johannes Åkesson - Mar 06, 2019

    SQL Spreads 4.4.3 is now available for download. Added a new MSI-installer property to make it possible to force an overwrite of the license key during installation. Resolved issue with mapping columns to CreatedOn and CreatedBy in the Advanced Setup. Resolved issue with the progress panel not hiding after saving data to the database for …

  • What’s new in SQL Spreads 4.4?

    Johannes Åkesson - Feb 01, 2019

    We are proud to announce the release 4.4 of SQL Spreads – the solution for easily letting your non-technical people manage and update data in SQL Server using Excel. In this article, we will shortly describe what’s new in this release. A complete list of the changes in SQL Spreads release 4.4 can be found …

  • SQL Spreads release 4.4.0

    Johannes Åkesson - Jan 31, 2019

    SQL Spreads 4.4.0 is now available for download. Added new buttons to the SQL Spreads tab in Excel for saving and refreshing the data between Excel and SQL Server. Added new change tracking setting to separately track database row creation with date, time and Windows user name. Added a release license feature for transferring a …

  • Happy Holidays from the SQL Spreads team

    Johannes Åkesson - Dec 18, 2018

    This year has been a successful year for SQL Spreads thanks to our fantastic customer and partners. There are now more than 200 customers in over 30 countries that use SQL Spreads to simplify for their non-technical users to update and manage their important data stored in Microsoft SQL Server. We would like to thank …

  • SQL Spreads release 4.3.1

    Johannes Åkesson - Nov 01, 2018

    SQL Spreads 4.3.1 is now available for download. Fixed issue connecting to Azure SQL databases when opening an older SQL Spreads document. Fixed issue when creating a new Database Import. Download the latest version of SQL Spreads »

  • SQL Spreads release 4.3.0

    Johannes Åkesson - Oct 25, 2018

    SQL Spreads 4.3.0 is now available for download. This release adds a few new features and also improves working with data in Azure SQL. Added support for working with contained databases, where the default database must be specified. Added the Formula Row feature to be able to add summary rows within an Excel range that …

  • SQL Spreads release 4.2.5

    Johannes Åkesson - May 08, 2018

    SQL Spreads 4.2.5 is now available for download. Fixed issue with working with SQL Spreads when the Excel document is in Read-Only mode. Fix issue with cursor not returning from wait state after loading document. Minor other fixes and stability improvements. Download the latest version of SQL Spreads »

  • SQL Spreads release 4.2.4

    Johannes Åkesson - Jan 26, 2018

    SQL Spreads 4.2.4 is now available for download. Added possibility to auto-save the Excel file after data has been saved to the database. Added support for XML data type columns. Added warning of FIPS encryption is enabled. Fixed issue with loading SQL Spreads document when opening a document without having Excel running. Fixed issue with …

  • SQL Spreads release 4.2.2

    Johannes Åkesson - Sep 12, 2017

    SQL Spreads 4.2.2 is now available for download. Fixed issue with columns not shown for table names with Cyrillic characters. Fixed issue with ordering of the databases in the Designer. Minor bug fixes and improvements. Download the latest version of SQL Spreads »

  • SQL Spreads release 4.2.0

    Johannes Åkesson - Jul 07, 2017

    With this new release, SQL Spreads has support for updating and managing data in cloud-based Azure SQL databases.

  • SQL Spreads release 4.1.7

    Johannes Åkesson - Apr 06, 2017

    SQL Spreads 4.1.7 is now available for download. Added new setting to scroll to the first row after data has been refreshed. Added new info panel when the Designer’s preview mode is turned on. The info panel will be shown below the last loaded data row and inform the user that preview mode is turned …

  • SQL Spreads release 4.1.4

    Johannes Åkesson - Feb 17, 2017

    SQL Spreads 4.1.4 is now available for download. Improved license key handling. Added the possibility to force an update of columns that saves the result of an Excel formula to the database. Bug fixes and minor updates. Download the latest version of SQL Spreads »

  • SQL Spreads release 4.1.3

    Johannes Åkesson - Dec 05, 2016

    SQL Spreads 4.1.3 is now available for download. Fixed issue with case sensitive collation. Download the latest version of SQL Spreads »

  • SQL Spreads release 4.1.2

    Johannes Åkesson - Dec 02, 2016

    SQL Spreads 4.1.2 is now available for download. Bug fixes and minor updates. Download the latest version of SQL Spreads »

  • SQL Spreads release 4.1.1

    Johannes Åkesson - Nov 17, 2016

    SQL Spreads 4.1.1 is now available for download. The major improvement in this release is support for updating data in SQL Server Views from Excel. The new View support also includes updating data in Views that joins data from multiple base tables. Added support for updating data in SQL Server Views. Added automatic detection of …

  • SQL Spreads release 4.0.27

    Johannes Åkesson - Nov 14, 2016

    SQL Spreads 4.0.27 is now available for download. Improved support for installing on Terminal Server. Fixed issue when saving documents with +250k database rows. Download the latest version of SQL Spreads »

  • Page 2 of 3«123»
Product
Key features
Use Cases
Compare SQL Spreads
Blog
Popular Articles
Support
Company
Contact
Obnex Technologies AB
Stena Center
412 92 Gothenburg
SWEDEN
support@sqlspreads.com sales@sqlspreads.com +46 31 751 26 20
×