Buy Now

Try For Free

The Excel and SQL Server experts blog

  • Pivot rows into columns

    milan nikolic - Feb 27, 2024

    For scenarios like forecasting, SQL Spreads pivots rows from SQL Server into columns in Excel. Changes made to these columns will  be saved back as rows in SQL Server.

  • Data Processing

    milan nikolic - Feb 26, 2024

    After data is updated in SQL Server, SQL Spreads can carry out post-processing tasks such as cleaning, copying, and validation by using custom SQL queries that process the data.

×