In 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.
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 »
SQL 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 »
We’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 …
We’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 …
SQL 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 …
SQL 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 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 »
SQL 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 …
SQL 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 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 …
SQL 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. …
SQL 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 …
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”. …
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 »
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 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 …
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 …
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 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 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 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 …
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 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 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 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 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 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 …
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 …
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 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 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 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 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 »
With this new release, SQL Spreads has support for updating and managing data in cloud-based Azure SQL databases.
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 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 4.1.3 is now available for download. Fixed issue with case sensitive collation. Download the latest version of SQL Spreads »
SQL Spreads 4.1.2 is now available for download. Bug fixes and minor updates. Download the latest version of SQL Spreads »
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 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 »
SQL Spreads 4.0.23 is now available for download. Improved Undo when working with SQL Server data. Fixed issue with length of text and ntext columns. Download the latest version of SQL Spreads »
SQL Spreads 4.0.22 is now available for download. Added subscription license model. Bug fixes and minor updates. Download the latest version of SQL Spreads »
SQL Spreads 4.0.21 is now available for download. Fixed issue with settings when using document created with SQL Spreads 3.0. Fixed issue with pasting into filtered rows. Fixed issue with when updating cells in a hidden sheet via VBA. Fixed issue with loading table in Designer in Excel 2010 64-bit. Download the latest version of …
SQL Spreads 4.0.17 is now available for download. The new release includes support for working with NULL values in the SQL Server tables. Added support for showing and updating NULL values in cells and in Drop Down Lists. Advanced setup is now shown by default. Fixed issue that a document that only contains a database …
Introducing the new SQL Spreads Designer Creating solutions for updating and managing SQL Server data has always been a demanding task. Even creating a simple solution, where one or two persons owns a few rows of data that they need to update, can takes several weeks to create and set up. And, later, when you …
SQL Spreads 3.1.50 is now available for download. The new release includes better handling and display of the database schema and a fix for the issue with the license being lost when upgrading Excel to a new version. Improved display of schema in Wizard and database export. Improved detection of column names in Edit Export …
SQL Spreads 3.1.4 is now available for download. Minor updates. Fixed issue with pasting into a filtered range with hidden rows. Download the latest version of SQL Spreads »
SQL Spreads 3.1.3 is now available for download. Fixed issue with Num Lock beeing turned off. Download the latest version of SQL Spreads »
SQL Spreads 3.1.2 is now available for download. The new release includes an update that will auto-detect available SQL Server instances. When selecting columns, there is a new “Select All”/”Select None” feature for tables with large amount of columns. The column width of the data imported into Excel will now auto-adjust the column size to …
