Jump to content

Draft:SQL Spreads

From Wikipedia, the free encyclopedia
  • Comment: In accordance with the Wikimedia Foundation's Terms of Use, I disclose that I have been paid by my employer for my contributions to this article. Vivigot (talk) 11:35, 3 November 2026 (UTC)

SQL Spreads
DeveloperObnex Technologies AB[1]
Operating systemMicrosoft Windows[2]
PlatformMicrosoft Excel
TypeExcel add-in, Data management
LicenseProprietary
Websitesqlspreads.com

SQL Spreads is a proprietary add-in for Microsoft Excel that lets users update, insert and delete data in Microsoft SQL Server tables and views from an Excel spreadsheet.[3] It is developed by Obnex Technologies AB, a privately held software company based in Gothenburg, Sweden.[1][4]

History

[edit]

Obnex Technologies AB was founded in 2015 by Johannes Åkesson.[1] According to the company, SQL Spreads was developed so that data entered in Excel could be sent directly to a central SQL Server database, instead of being moved there manually or with tools such as SSIS or VBA.[1]

In 2026, the company stated that the product had more than 1,000 customers in more than 50 countries.[1]

Features

[edit]

SQL Spreads has two user roles. A designer, typically a person with database knowledge, creates Excel documents for data maintenance that are connected to a database. A data editor can change data only through documents created by a designer, and the design features are locked for that role.[5] The document settings are stored in the Excel file, so a document can be shared with other users.[4]

Optional features include change tracking, which writes the user name and the date and time to the table when a row is created or changed,[6] and post-save scripts, which run a SQL query as the last step of the transaction that updates the database. If the script raises an error, the update is rolled back.[7]

Supported databases

[edit]

SQL Spreads supports Microsoft SQL Server versions 2008 to 2025 and Azure SQL.[2] It also supports PostgreSQL. A paid Cloud Data Platforms add-on adds support for Snowflake, Databricks (Lakebase Postgres) and Microsoft Fabric (Fabric Warehouse and SQL database). Some features, such as views and pivoting, are not available on every platform.[8]

Security

[edit]

The add-in runs in the desktop version of Excel on Windows 10 and Windows 11 and connects directly to the database, without a separate server installation.[2] SQL Spreads does not store customer data outside the customer's own infrastructure, and the data is stored and processed in the customer's own databases and cloud accounts.[9] The add-in has no user management or authentication layer of its own for database access. Instead, it relies on Windows authentication, SQL Server authentication or Microsoft Entra ID authentication, including multi-factor authentication.[9]

See also

[edit]

References

[edit]
  1. 1 2 3 4 5 "About the SQL Spreads Data Management Solution". SQL Spreads. Obnex Technologies AB. Retrieved 2026-11-03.
  2. 1 2 3 "SQL Spreads FAQs". SQL Spreads. Obnex Technologies AB. Retrieved 2026-11-03.
  3. ↑ "Use SQL Spreads Excel add-in to update data in SQL Server". SQL Spreads. Obnex Technologies AB. Retrieved 2026-11-03.
  4. 1 2 "Obnex Technologies' Excel Add-In to Update Cloud Data in Azure SQL Database" (Press release). Obnex Technologies. July 7, 2017. Retrieved 2026-11-03 – via Newswire.
  5. ↑ "Lock Design Mode for End Users". SQL Spreads Documentation. Obnex Technologies AB. Retrieved 2026-11-03.
  6. ↑ "Tracking changes". SQL Spreads Documentation. Obnex Technologies AB. Retrieved 2026-11-03.
  7. ↑ "Post-Save Data Processing Scripts". SQL Spreads Documentation. Obnex Technologies AB. Retrieved 2026-11-03.
  8. ↑ "Supported databases". SQL Spreads Documentation. Obnex Technologies AB. Retrieved 2026-11-03.
  9. 1 2 "SQL Spreads security". SQL Spreads Documentation. Obnex Technologies AB. Retrieved 2026-11-03.
[edit]