SQL 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 »
- 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
-
SQL Spreads release 7.5.5
Johannes Åkesson - Sep 17, 2024 -
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
Johannes Åkesson - Aug 06, 2024SQL Spreads solves some common data management problems for Microsoft SQL Server. It makes it fast and simple to update an SQL table from an Excel spreadsheet. And it gives you the control you need to manage data entered by various users on a collaborative team. End users love working in Excel End users love …
-
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 …
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