SQL Server Tools is only available for SQL Server, Azure SQL, and Fabric. It's not currently supported for PostgreSQL, Snowflake, or Databricks. See which features are supported for each database →
The SQL Server Tools feature extends some of the capabilities of SQL Server Management Studio into Excel through the SQL Spreads Add-In.
With SQL Server Tools, SQL Spreads Designers can from within Excel:
- Create new SQL Server tables based on data in Excel
- Add, Delete and Modify columns in existing SQL Server tables
- Copy tables from one database to another
You'll find the SQL Server Tools menu button on the SQL Spreads ribbon.
The following sections explain how to use the tools.