2025 was a big year for SpreadsheetWeb.
We shipped a new runtime, crossed the 500‑formula mark, deepened our support for advanced Excel features, and made it much easier to build polished web applications without ever leaving your spreadsheet comfort zone.
Across monthly releases, our focus stayed consistent:
-
Bring more of Excel’s power online
-
Make app building faster and friendlier
-
Give teams better control over data, security, and UX
Here’s a look back at the most important features we introduced in 2025.
Supercharging the Calculation and Simulation Engine
We kicked off the year with our first major release of 2025, where we celebrated our 500th supported Excel formula by adding PIVOTBY. This brought modern, dynamic aggregation capabilities into SpreadsheetWeb, making it easier to build real‑time analytics and reporting experiences directly on top of Excel logic.
That same release also introduced a dynamic Output Grid control inspired by Excel Pivot Tables. Using PIVOTBY and GROUPBY under the hood, grids can now automatically expand and reshape themselves on every recalculation, no manual layout work required. This makes it much easier to build fully interactive dashboards where the layout adapts to the data.
In April, we followed up with a major architectural change: a new runtime for SpreadsheetWeb applications. The new runtime delivers better performance and stability while running side by side with the existing runtime during the transition period. You can preview existing applications in the new runtime, validate behavior, and then migrate when you’re ready. That same release also introduced a basic Print to PDF feature that uses Excel print areas to generate PDFs directly from your apps.
Later in the year, simulations and heavy calculations became a key focus. In the September 2025 release, we added full support for Excel Data Tables, including recursive workbook calculation. That means what‑if analyses, sensitivity tests, and Monte Carlo‑style simulations built with Data Tables in Excel can now run natively in your web apps without restructuring your models.
In the October 2025 release, we rolled out performance optimizations for batch calculations and simulation events, reducing the time it takes to run large‑scale simulations and multi‑scenario analyses. We also introduced Simulation Events, which detect Data Tables in your workbook and expose a “Simulation” event you can attach directly to a button, no scripting or custom wiring required.
Taken together, 2025 gave SpreadsheetWeb a much stronger calculation engine: more formulas, more Excel compatibility, and faster, cleaner simulation workflows.
Making Apps Look and Feel Better: UX & Layout Improvements
A second big theme this year was user experience, both for app builders and end users.
In our first major release of 2025, we completely redesigned the Designer interface, modernizing the look and making navigation more intuitive for configuring data sources, custom formulas, and workflows.
The March 2025 release improved how users work with data inside apps by adding filter support for grid controls. Every column can now have a dedicated filter, text search, dropdown, date range, or numeric slider, so users can quickly navigate large datasets.
In the May 2025 release, we continued enhancing grid and UI controls:
-
Six new grid styles so you can quickly match your application’s visual language
-
The ability to color all editable cells in a grid, making input areas much more obvious
-
A new Compact UI Mode that tightens spacing between controls for dense, dashboard‑like layouts
-
Application‑wide background color settings to keep branding consistent across pages
In June 2025, we added a font configuration module under Application Settings for V2 applications. With roughly 30 fonts to choose from and separate header/body font settings, designers can now standardize typography across the entire app instead of adjusting each control.
The August 2025 release introduced Global Input Color Selection, letting you choose a background color for all input controls, including editable cells inside input grids, so users instantly know where they can type.
Layout capabilities also took a big step forward:
-
In September, containers gained the ability to be rendered as tabs, making it easy to organize complex pages into clean, multi‑section tabbed interfaces.
-
In October, we introduced subdivided containers, letting you split a container into table‑like regions for precise, pixel‑perfect control over your layout.
Finally, the November 2025 release brought a floating navigation menu. Navigation can now remain visible while users scroll through long pages or dashboards, keeping important links and actions always within reach and giving apps a more polished, native‑web feel.
From first load to deep interaction, building a professional UI in SpreadsheetWeb is now significantly easier than it was at the start of the year.
Data, Databases, and Cross‑App Connectivity
Another major area of progress in 2025 was how apps store, move, and reuse data.
The July 2025 release introduced simplified database usage. New applications can now save user input without requiring full schema design. Add a Save button, and SpreadsheetWeb automatically captures UI data in a JSON structure in the background. For more complex scenarios, traditional database configuration remains available in paid accounts, but simplified databases make it much easier to get started.
In the same July release, we enhanced Power Query integration with support for CurrentWorkbook expressions, allowing user interactions to drive what data Power Query pulls in. This leads to leaner, more responsive apps that fetch only the data users request.
Power Query itself first arrived in the June 2025 release, where we added the ability to deploy Excel workbooks that use Power Query as full web applications (for private cloud and server licenses). This is especially powerful for real‑time reporting over external data sources like databases and web services.
In August 2025, we introduced SpreadsheetWebLookup, a new custom, spillable formula. Rather than pulling data from other workbooks, SpreadsheetWebLookup retrieves values directly from the database of any application in your workspace. Combined with dynamic arrays, it enables cross‑application reporting and unified dashboards driven entirely from Excel.
The September release added several more data‑centric features:
-
CSV File Upload to Named Range, so uploaded CSV data can flow directly into a named range and output grid
-
Save as New Record, a new save mode that creates a new record with a unique ID on each save, ideal for versioning, audit trails, and multi‑scenario modeling
If 2024 was about getting models online, 2025 was about making those models data‑aware, easier to persist, and much better connected across applications.
Security, Governance, and Integration at Scale
As more teams use SpreadsheetWeb for mission‑critical and multi‑tenant workloads, we continued investing in security and integration.
The March 2025 release introduced named range restrictions for API calls. Designers can now explicitly select which named ranges are exposed for external read/write operations. This allows you to protect sensitive cells, implement least‑privilege access patterns, and support more complex tenant‑specific scenarios where each client can only see or modify the ranges tied to their data.
Toward the end of the year, the November 2025 release added OAuth‑based email support for paid workspaces. Instead of configuring SMTP hosts, ports, and credentials, you can now connect Google or Microsoft accounts and send emails using OAuth. This makes it much easier to enable secure outbound email in your apps and helps avoid common configuration issues around SMTP and firewalls.
Together with existing hosting and security options, these features make SpreadsheetWeb even more suitable for regulated and enterprise environments.
Building Faster: Automated App Creation and Smarter Tooling
Finally, 2025 made it much easier to go from “Excel file” to “first working app” in just a few minutes.
In the October 2025 release, we completely redesigned the automated application creation flow. The new system shows your Excel workbook in its native layout and automatically detects regions that look like candidate UI sections. You can extend, enable, and label these regions to decide exactly which parts of the file become pages and controls, as if you never left Excel, but with the full power of SpreadsheetWeb’s UI builder.
The November 2025 release took this even further, adding:
-
Smarter detection for charts, images, and labels
-
Toggle controls for whether specific inputs, outputs, grids, and labels should be generated
-
The ability to generate multiple standalone labels at once, ideal for headings and explanatory text
For complex workbooks that mix data tables, graphs, images, and narrative text, this means the automatically created web app lands much closer to your final design, with less manual cleanup.
October also introduced the ability to bind multiple input controls to the same named range, even across different pages, making it easier to build flexible, multi‑entry UIs. And throughout the year, especially in the May, June, and August releases, we added project‑wide settings for fonts, colors, and spacing so you can shape your application’s look and feel at a global level instead of tweaking each screen individually.
All of this adds up to a much smoother builder experience, from first import all the way to a production‑ready UI.
Looking Ahead
2025 was about deepening SpreadsheetWeb’s core promise: turning serious Excel models into professional, interactive web applications, without rewriting them in code.
Over the year, we:
-
Strengthened the calculation engine and runtime
-
Brought more of Excel’s advanced tooling (PIVOTBY, Power Query, Data Tables) into the web experience
-
Modernized UI and layout capabilities
-
Made data handling, security, and app creation more powerful and approachable
Thank you for building with SpreadsheetWeb this year. We’re already hard at work on the next wave of improvements, and we can’t wait to share what’s coming in 2026.
