• The Excel and SQL Server experts blog
  • 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 Server.
    • Introducing the new Table Creator to easily create new SQL Server tables from within Excel in just a few clicks.
    • New database and table search in the SQL Spreads Designer to quickly find your SQL Server databases and tables.
    • Improved support to deploy SQL Spreads Excel documents from test databases to production databases. You can now easily switch the connection in a SQL Spreads Excel document to a new server, database, or table while keeping all the settings in the document.
    • Improved the new subscription engine to support monthly and annual subscriptions. We will soon start to offer monthly subscriptions.
    • Improved document compatibility – SQL Spreads documents are from release 5.0 backward compatible so no need to upgrade all users to the same SQL Spreads version.
    • Improved Enterprise Deployment Package which supports large scale installations with one common license key for all users and a web application to manage licenses.
    • Improved the database key selection dialog.
    • Fixed issue with loading and saving data during document opening and closing to be done for all worksheets in a document.
    • Fix issue with drop-down lists to make drop-down lists case insensitive.

    Download the latest version of SQL Spreads »


    Comments are closed.

Use Excel to update your data in SQL Server?

Try the SQL Spreads data management solution to update and manage your SQL Server data from within Excel.