With the rise of data democratization in the workplace, more people across the organization are working with datasets on a day-to-day basis. SQL Spreads makes this easier for people by letting them use Excel to update and manage data in SQL Server. One of the reasons people enjoy working in Excel is the familiarity of the UI …
- Product
-
-
- KEY FEATURES
- Excel to SQL Server Write-backExcel users can swiftly update and write-back data to SQL Server.
- Filter huge data setsImport large-scale data sets into Excel, even from tables with millions of rows.
- Foreign Key LookupsKey value lookups enable easy and integrity-focused relational data management for users.
- Explore all features
-
-
- Resources
- Pricing
- Company
- Try for free
The Excel and SQL Server experts blog
-
Tree Filters in Excel: an easy way to view and filter SQL data
Andy McDonald - May 11, 2023 -
SQL Spreads release 7.0.5
Johannes Åkesson - Mar 30, 2023SQL Spreads 7.0.5 is now available for download. The new SQL Spreads 7.0 has two major improvements: The first improvement is the batch processing of updates, inserts and deletes from Excel to the SQL Server. We have measured speed improvements of up to 18 times with this new release, compared to the older 6.2 release. …
-
Cleansing data in SQL Server
Andy McDonald - Jan 30, 2023We come across ‘dirty’ data all the time. It’s one of the realities of working with data on a regular basis. With the rise of data democratization in the workplace, more people across the organization are exposed to the problem of dirty data and are also more likely to be involved in the cleansing process. …
-
SQL Spreads release 6.2.15
Johannes Åkesson - Dec 22, 2022SQL Spreads 6.2.15 is now available for download. Improved Intro screens shown during first time start-up. Fixed issue when moving columns if Excels table header filters are turned off. Fixed issue with items with quotes not working in Fixed List Lookups. Fixed issue when switching server when the document has key Lookups. Fixed issue with …
-
How a Business Analyst can help with data conversion projects
Andy McDonald - Nov 25, 2022Businesses today are required to manage more data than ever before. Change is also occurring at a faster rate. Organizations therefore need to be agile with regard to data management and this means being able to move data around from one system to another or between parties with relative ease. In this article we’ll discuss …
-
Master Data Management Tools for Azure
Andy McDonald - Nov 07, 2022Maintaining a “single source of truth” is critical for all organizations. The discipline of Master Data Management (MDM) is one of the means to achieve this. In this article, we’re going to look at some Master Data Management tools for Azure. Introduction Master Data Management (MDM) is an information management discipline focusing on data quality and …
-
Master Data Management Tools for SQL Server
Andy McDonald - Oct 21, 2022Maintaining a “single source of truth” is critical for all organizations. There are many Master Data Management (MDM) tools out there to help achieve this. In this article, we’re going to look at some Master Data Management tools for SQL Server. Introduction Master Data Management (MDM) is an information management discipline focusing on data quality …
-
SQL Union: How to Combine Result Sets
Andy McDonald - Sep 02, 2022This is the sixth in a series of articles aimed at introducing the basics of SQL to Excel users. This article shows how to combine data from one or more data sets using the SQL UNION operator. UNION is one of a number of ‘set operators’ in SQL that are used to join the results …
-
What is the equivalent of the IF THEN function in SQL?
Andy McDonald - Aug 24, 2022This is the fifth in a series of articles aimed at introducing the basics of SQL to Excel users. This article shows how to use the IF THEN function in SQL. If you’re interested in the other articles, check them out here: Introduction to SQL for Excel Users What is the equivalent to VLOOKUP in …
-
How to Use XMATCH: Guide and Examples
Andy McDonald - Aug 18, 2022In 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 – …
Hi,
I am the founder of SQL Spreads, the lightweight data management
solution to update SQL Server data using Excel
In this blog we share the Excel and SQL Server knowledge that we have learnt during our work
with hundreds of customers worldwide.
Hope you find it useful!
Best regards,
Johannes Åkesson
Love Excel? Need to update SQL Server data?
Stena Center
412 92 Gothenburg
SWEDEN