Profisee offers thorough MDM capabilities for larger companies looking for a potentially more affordable alternative to the industry giants. However, compared to its competitors, it can still prove a tough buy-in, leaving users to look for better options. SQL Spreads emerges as a top alternative for teams looking for an effective – and cost-efficient – …
The Excel and SQL Server experts blog
-
Top 5 Profisee Alternatives: 2025 edition
Johannes Åkesson - Feb 15, 2025 -
SQL Spreads release 7.6.3
Johannes Åkesson - Jan 31, 2025In this release, we have made several improvements to Forecasting and KPI data collection scenarios. We have also added the long-awaited feature that allows using Excel formulas to calculate values saved back to SQL Server.
Additionally, we have introduced an automatic check for new SQL Spreads updates and simplified the process of sending details to SQL Spreads support.
-
Top 5 Vena Solutions Alternatives for FP&A
Johannes Åkesson - Jan 27, 2025Are you looking for a more streamlined FP&A and financial forecasting solution than Vena Solutions? In this article, we’ll show you five top Vena alternatives that can help your finance team budget and plan more effectively – and reveal how SQL Spreads not only makes the switch straightforward, but also offers the flexibility and value your …
-
How to insert data from Excel to SQL Server
Johannes Åkesson - Jan 20, 2025Most people do not know that there is a really simple way to copy and paste data from Excel to SQL Server. In this article, I will show you what you need to know to copy and paste data from Excel to SQL Server.
I will go through and show the technique using simple step-by-step instructions, and I will also cover a few special cases that are great to know. -
Top Devart Excel add-in alternatives in 2025
Johannes Åkesson - Jan 08, 2025Is Devart falling short on essential safeguards in your needs for secure and reliable SQL data management? Many teams have looked for alternatives to Devart’s Excel add-ins because of security limitations and lagging performance. Plenty of these users found SQL Spreads to be an excellent alternative, highlighting its intuitive approach to role-based permissions and faster …
-
Power BI write back to SQL Database: 2 methods
Andy McDonald - Jan 03, 2025Power BI dashboards and reports often pull data from a SQL Server database, but what happens when you need to update that data? For businesses, having Power BI write-back to SQL functionality is critical for staying agile. In this article, we’ll explore two methods for writing back to SQL, including the SQL Spreads Excel Add-In, …
-
Connect Power BI to SQL Server: Step-by-step Guide
Andy McDonald - Dec 24, 2024Power BI makes it easy to visualize your data, but first, you need to connect it to SQL Server. This guide walks you through the process step -by -step. With SQL Spreads Excel Add-In, business users can bring in and update SQL Server data themselves — all from Excel — ensuring that your Power BI …
-
Top CData Excel Add-in Alternatives in 2025
Johannes Åkesson - Dec 23, 2024Is CData proving too complex or not user-friendly enough for your SQL data management needs? You’re not alone. Plenty of our users migrated to SQL Spreads from CData’s Excel add-in, attracted by an exceptionally intuitive interface and the promise of a leaner stack. Here’s everything you need to know about the top CData competitors this …
-
The Best Alternative to Microsoft Access in 2025
Andy McDonald - Dec 07, 2024If you’ve been frustrated with Microsoft Access’s limitations or wondering if it’s still worth using in 2025, you’re not alone. With businesses moving towards more scalable and flexible solutions, SQL Spreads Excel Add-In is a powerful, user-friendly alternative. In this article, we’ll explore why Access is losing popularity and how this lean tech stack alternative …
-
Top Alternatives to Microsoft MDS in 2025
Johannes Åkesson - Nov 22, 2024Are you looking for an effective solution for master data management as Microsoft Master Data Services approaches its end of life? We’ll walk you through these top alternatives as MDS replacements that offer robust features tailored to your organization’s unique data management needs – and show you how SQL Spreads not only makes the transition …
-
Top Alternatives to Microsoft Power Apps for SQL Data Management in 2024
Johannes Åkesson - Nov 15, 2024Looking for a way to simplify SQL data management? Check out these top Power Apps alternatives that make it easier to build SQL data management solutions without requiring excessive technical skills and suited to your organization’s unique needs. Microsoft Power Apps – a major market player Microsoft Power Apps is a development platform that – …
-
How to Export Data from SQL Server to Excel
Andy McDonald - Nov 08, 2024For organizations that use SQL Server and Excel extensively, there is often a need to export data from SQL Server to Excel. In this article, we’re going to look at how to export data from SQL Server to Excel using 3 methods. We’ll also introduce a valuable feature in the SQL Spreads Excel Add-In that allows …
-
Excel GROUPBY Function – Guide and Examples
Andy McDonald - Nov 06, 2024Microsoft recently released two new aggregation functions in Excel – GROUPBY and PIVOTBY. Both these functions are useful when you want to quickly summarize data in your Excel spreadsheet. In this article we’re going to look at how to use the GROUPBY function, and in the next article we’ll cover the more powerful PIVOTBY function. …
-
SQL Spreads release 7.5.6
Johannes Åkesson - Sep 17, 2024SQL Spreads 7.5.6 is now available for download. Resolved an issue with the new setting for lookups, enabling the creation of dependent drop-down lists. Download the latest version of SQL Spreads »
-
SQL Spreads release 7.5.5
Johannes Åkesson - Sep 13, 2024SQL Spreads 7.5.5 is now available for download. Fixed issue with connecting to Azure using Azure AD Authentication Download the latest version of SQL Spreads »
-
SQL Spreads release 7.5.4
Johannes Åkesson - Sep 03, 2024We’re excited to announce the release of SQL Spreads 7.5.4, which focuses on improving the Tree Filters and Intro dialogs, as well as addressing various bug fixes. New Features and Enhancements Redesigned Introductory Dialogues: We have redesigned the introductory dialogues to provide a more intuitive user experience. This includes a new option to restart the …
-
Power BI Dashboards: Examples & Use Cases
Andy McDonald - Aug 30, 2024Power BI is a Business Intelligence (BI) platform. With Power BI, users can get data, analyze it, and create visualizations that help turn data into actionable information for their business. In this article, we’re going to look at creating Power BI dashboards and reports, and give some examples of how and when to use them. …
-
How to Update an SQL Table from Excel: Complete Guide
Johannes Åkesson - Aug 06, 2024There’s an easier way to update SQL tables Many teams turn to Excel for updating SQL tables because it’s familiar for business users. However, team members in charge of data management may fear losing control of the database. This makes it crucial to find the right tool for connecting Excel and SQL Server. In this …
-
How to perform an INSERT in SQL Server
Johannes Åkesson - Aug 01, 2024Inserting data into SQL Server is a fundamental operation for business users who need to add new records to their databases. This guide will walk you through the process of using the INSERT statement in SQL Server, providing comprehensive steps and code snippets you can use directly in SQL Server Management Studio (SSMS). Understanding the …
-
How to perform a DELETE in SQL Server
Johannes Åkesson - Aug 01, 2024Deleting data in SQL Server is a critical operation for business users who need to remove obsolete or incorrect records from their databases. This guide will walk you through the process of using the DELETE statement in SQL Server, providing comprehensive steps and code snippets you can use directly in SQL Server Management Studio (SSMS). …
-
How to create a database in Excel
Johannes Åkesson - Aug 01, 2024Creating a database in Excel is a straightforward process that can help you manage and analyze your data efficiently. Whether you need to keep track of personal information, business records, or project details, Excel offers powerful tools to build and maintain a database. Follow these steps to create a database in Excel: 5 steps on …
-
How to perform a SELECT INTO in SQL Server
Johannes Åkesson - Aug 01, 2024The SELECT INTO statement in SQL Server is a powerful tool for creating new tables and copying data from existing tables or queries. This guide will walk you through the process of using the SELECT INTO statement in SQL Server, providing comprehensive steps and code snippets you can use directly in SQL Server Management Studio …
-
How to perform an UPDATE in SQL Server
Johannes Åkesson - Jun 28, 2024Updating data in SQL Server is a common task for business users who need to ensure their data remains accurate and up-to-date. This guide will walk you through the process of using the ‘UPDATE’ statement in SQL Server, providing easy-to-follow steps and code snippets you can use directly in SQL Server Management Studio (SSMS). Understanding …
-
How to Build a KPI Dashboard with Power BI
Andy McDonald - May 21, 2024In this article, we’re going to show you how to build a KPI dashboard in Power BI for managers. The example we’ll work through uses our KPI data collection template, used by operational level administrators to collect KPI metrics. This template was built with SQL Server, Excel and the SQL Spreads Excel Add which is …
-
SQL Spreads release 7.4.1
Johannes Åkesson - Mar 29, 2024We’re excited to announce the latest enhancements and fixes in SQL Spreads to make your data management experience smoother and more secure. Here’s what’s new in SQL Spreads 7.4.1: Enhanced Tree Filters: Tree Filters have been improved and are now shown only for individual Excel sheets, and changes in a Tree Filter only refresh the …
-
Use Case: How to build a KPI Excel template with SQL Server
Andy McDonald - Mar 06, 2024In this article, we’re going to show you how to build a KPI Excel template using SQL Server and an Excel Add-In. Many organizations collect performance metrics related to aspects of their business and then use KPIs to measure and track performance against targets. However, the process of collecting the data is often a manual …
-
Temporal Tables and how to use them in SQL Server
Andy McDonald - Feb 01, 2024If you want to keep track of when changes were made to your data, or see how data changes over time, you need to start using temporal tables in SQL Server. Microsoft introduced this great feature in the 2016 version of SQL Server, but is still relatively unknown. A common associated challenge with tracking changes …
-
SQL Spreads release 7.3.0
Johannes Åkesson - Jan 31, 2024SQL Spreads 7.3.0 is now available for download. Enhanced SharePoint integration for SQL Spreads documents by implementing document locking for Editors. In the SQL Spreads Designer, the database and table filters are now displayed by default in the Database tab. Optimized connectivity with Azure Data Warehouse/Azure Synapse. Refined the introductory dialogues for a more intuitive …
-
Get started with Azure SQL
Andy McDonald - Jan 26, 2024In this article, we’re going to show you how to get started with Azure SQL. Azure SQL is one of the many services offered on Azure, Microsoft’s comprehensive cloud computing platform. And it enables organizations to run workloads and develop applications in regional data centers around the globe. Introduction to Azure SQL Azure SQL is …
-
Artificial Intelligence Add-Ins for Excel
Andy McDonald - Dec 06, 2023In this third article, in our series about using AI in Excel, we’re going to look at the best third party Artificial Intelligence Add-Ins for Excel that bring the power of AI technology to your spreadsheets. In the past year or so, there has been a great deal of interest in using AI more generally …
-
Excel AI Tools: built-in AI technology in Excel
Andy McDonald - Dec 02, 2023In our second article looking at Excel AI tools, we’re going to look at existing features and functionality in Excel that use AI technology to some extent. Make sure you also check out our earlier article on the new experimental LABS.GENERATIVEAI function. This allows you to send prompts from within Excel to a generative AI …
-
SQL Spreads release 7.2.5
Johannes Åkesson - Nov 10, 2023SQL Spreads 7.2.5 is now available for download. Fixed issue with the new Show intro button being shown in Data Editor mode. Download the latest version of SQL Spreads »
-
SQL Spreads release 7.2.4
Johannes Åkesson - Nov 08, 2023SQL Spreads 7.2.4 is now available for download. Improved the Intro dialogs shown during the first start of the trial. Added a button in the SQL Spreads tab to show the Intro again. Minor bug fixes. Download the latest version of SQL Spreads »
-
Update View in SQL Server using Excel – Step by Step Guide
Johannes Åkesson - Sep 08, 2023In many businesses, it’s common to use Views to present database tables in a user-friendly way. With SQL Spreads, you can update a View in SQL Server from within Excel. SQL Spreads allows you to work with SQL Server Views, making it easy to display data side by side in Excel, similar to any other …
-
AI in Excel: the LABS.GENERATIVEAI function
Andy McDonald - Aug 30, 2023Excel is a powerful tool for data analysis, but did you know that there is a new function that provides the power of generative AI in Excel. The experimental LABS.GENERATIVEAI function allows you to send prompts from within Excel to a generative AI model and then return the results from the model back to your …
-
SQL Spreads release 7.2.0
Johannes Åkesson - Aug 28, 2023SQL Spreads 7.2.0 is now available for download. Added a new intro dialog with info about the trial. Added a check if Excel is running before installation, and auto-restart of Excel after the installation. Added a lock to prevent a user with a Data Editor license to install and use the SQL Spreads trial in …
-
How to copy a table in SQL Server
Andy McDonald - Jul 18, 2023In this article we’re going to show you a quick and easy way to copy a table in SQL Server. The new Copy SQL Server Table feature in SQL Spreads means that you can copy a table from one database to another in just a few clicks from within Excel. Introduction Although it’s not something …
-
SQL Spreads release 7.1.2
Johannes Åkesson - Jul 14, 2023SQL Spreads 7.1.2 is now available for download. In this new release we are introducing the new SQL Server tools which allows you to do more SQL Server operations from within Excel. The SQL Server tools contains these three features: The Table Creator – to create SQL Server tables based on data in Excel. The …
-
SQL Spreads: a front end for SQL Server
Andy McDonald - Jul 05, 2023There are several options available if you are looking for a front end for SQL Server. Like most things, what is best for you will depend on a number of factors. In this article, we’re going to look at the things to consider when choosing a front end for SQL Server and how the SQL …
-
Master Data Services Excel Add-in: What to Know and Alternatives
Andy McDonald - Jun 20, 2023In a previous article, we provided an overview of Master Data Management (MDM). In this article, we’re going to look at Microsoft’s platform for supporting the discipline of MDM: “Master Data Services”. Specifically, we’re going to look at how the Master Data Services Excel Add-in can be used to organize your MDM data models and …
-
SQL Spreads release 7.0.8
Johannes Åkesson - May 29, 2023SQL Spreads 7.0.8 is now available for download. This release fixed a couple of minor issues. Fixed issue with columns with data type Time not updating correctly. Fixed issue with Change tracking not working when only one of the ModifiedBy or ModifiedOn was used. Fixed issue with labels for number of loaded rows not shown …
-
Tree Filters in Excel: an easy way to view and filter SQL data
Andy McDonald - May 11, 2023With 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 …
-
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 …
Product
Key features
Use Cases
Compare SQL Spreads
Resources
Doc
Support
Company
Subscribe for updates
×
×