Draft:SQL Spreads
Draft article not currently submitted for review.
This is a draft Articles for creation (AfC) submission. It is not currently pending review. While there are no deadlines, abandoned drafts may be deleted after six months. To edit or make changes to this draft, simply click on the "Edit" tab at the top of the window. To be accepted, a draft should:
It is strongly discouraged to write about either yourself or your business or employer. If you do so, you must declare it. Where to get help
How to improve a draft
You can also browse Wikipedia:Featured articles and Wikipedia:Good articles to find examples of Wikipedia's best writing on topics similar to your proposed article. Improving your odds of a speedy review To improve your odds of a faster review, tag your draft with relevant WikiProject tags using the button below. This will let reviewers know a new draft has been submitted in their area of interest. For instance, if you wrote about a female astronomer, you would want to add the Biography, Astronomy, and Women scientists tags. Editor resources
Last edited by Vivigot (talk | contribs) 14 days ago. (Update) |
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 | |
|---|---|
| Developer | Obnex Technologies AB[1] |
| Operating system | Microsoft Windows[2] |
| Platform | Microsoft Excel |
| Type | Excel add-in, Data management |
| License | Proprietary |
| Website | sqlspreads |
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 2 3 4 5 "About the SQL Spreads Data Management Solution". SQL Spreads. Obnex Technologies AB. Retrieved 2026-11-03.
- 1 2 3 "SQL Spreads FAQs". SQL Spreads. Obnex Technologies AB. Retrieved 2026-11-03.
- ↑ "Use SQL Spreads Excel add-in to update data in SQL Server". SQL Spreads. Obnex Technologies AB. Retrieved 2026-11-03.
- 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.
- ↑ "Lock Design Mode for End Users". SQL Spreads Documentation. Obnex Technologies AB. Retrieved 2026-11-03.
- ↑ "Tracking changes". SQL Spreads Documentation. Obnex Technologies AB. Retrieved 2026-11-03.
- ↑ "Post-Save Data Processing Scripts". SQL Spreads Documentation. Obnex Technologies AB. Retrieved 2026-11-03.
- ↑ "Supported databases". SQL Spreads Documentation. Obnex Technologies AB. Retrieved 2026-11-03.
- 1 2 "SQL Spreads security". SQL Spreads Documentation. Obnex Technologies AB. Retrieved 2026-11-03.
