What’s new in SpreadsheetConverter v12

More of your workbook.
Less preparation.

Turn more of the Excel workbooks you already use into working web calculators and forms. Version 12 handles a wider range of .xlsx workbooks, with fewer formulas to rewrite and fewer workarounds before you publish.

From everyday counts and averages to named ranges and modern array formulas, v12 brings more of your spreadsheet’s logic to the web. Spend less time adapting your workbook and more time putting it to use.

Try your workbook in v12 Compare plans

Keep more of the Excel work you have already done

A workbook should not need a collection of special formulas just to become a web page. V12 improves support for complex references, named cells and ranges, array calculations and workbook formats, so more existing spreadsheets can be converted with less preparation.

Better handling of counts, averages and empty cells

Small differences can change an important result. V12 improves how calculations distinguish numbers, text, empty cells and zero, including everyday functions such as COUNT and AVERAGE.

An empty cell is different from zero. V12 preserves that distinction instead of treating every empty numeric cell as an entered 0, so counts and averages can handle mixed ranges more faithfully. Formulas that directly reference a blank still follow Excel’s rules.

Use the names that make your workbook readable

Named cells and ranges let you write formulas around meaningful terms instead of cell addresses. V12 improves defined-name handling, including names used in dynamic references, so more of those formulas carry over to your web calculator.

Bring modern Excel formulas to the web

Filter a list, sort results, build a sequence or return several answers from one formula. V12 adds dynamic arrays and expands multi-cell results, alongside LET and LAMBDA for reusable formula logic. More of the calculations you use in Excel can stay in their original form.

Keep numbers and dates familiar

Improved number, date and time formatting, plus better handling of language and regional settings, help your published calculator present values the way your audience expects.

A new add-in for the way you use Excel today

Work in supported desktop Excel or Excel Online with the modern Office add-in. Convert your workbook, review the resulting web page and publish a calculator or form people can use in their browser. The installation guide walks you through the first conversion.

Need help with a formula or a setting? The AI Coach can explain Excel and SpreadsheetConverter features and help you work through changes to your workbook.

Much easier to embed in WordPress and other websites

Bring your calculator or form into a page on your own website. After publishing, choose Copy embed code and paste the code into your page’s HTML or a code block that allows scripts. The calculator appears inline, alongside your own content.

V12 provides a single line of embed code that creates the calculator’s place on the page for you, without an iframe. This makes embedding in WordPress and similar website platforms much simpler. Your website must allow scripts in the page; the available options depend on your platform and account.

See the difference with your own workbook

Already own an earlier version? Enter your old licence key and its licence email address in the add-in’s Account tab for a 30-day trial of all v12 features. An old key alone does not provide continued use of the new add-in after the trial. For continued access to v12 features, choose a v12 subscription.

If you do not have an old licence key, request a trial key. You can also email us an .xlsx for a free conversion.

Already pay for Advanced Submit? Connect your existing subscription to update and republish with v11 functionality.

Existing customer and upgrade information

The detailed changes in v12

The release notes below compare v12 with v11.6. For your particular workbook, check the function reference and test the calculations and controls before publishing.

1. Excel functions

The largest expansion is in functions that return multiple results.

Filtering, sorting and sequences. FILTER, SORT, SORTBY, UNIQUE, SEQUENCE and RANDARRAY.
Reshaping and combining arrays. TAKE, DROP, CHOOSEROWS, CHOOSECOLS, VSTACK, HSTACK, TOROW, TOCOL, WRAPROWS, WRAPCOLS and EXPAND.
Text and array mathematics. TEXTSPLIT, together with array-result support for TRANSPOSE, MMULT, MINVERSE, MUNIT, FREQUENCY, TREND, LINEST, LOGEST and GROWTH. The regression functions also gained support for multiple predictor columns.
Expanded lookups. XLOOKUP and XMATCH already existed in v11.6; v12 extends them with array forms and multi-cell results.

Reusable formula logic is another major addition. LET introduces local names within formulas, and LAMBDA enables reusable worksheet-defined calculations. MAP, BYROW, BYCOL, REDUCE, SCAN, MAKEARRAY and ISOMITTED support applying that logic across arrays, accumulating results and handling optional parameters.

Regular expressions. REGEXTEST, REGEXEXTRACT and REGEXREPLACE, Microsoft 365’s functions for validating, extracting and cleaning text, use the same pattern syntax as Excel. That includes capture groups, case-insensitive matching, a chosen occurrence and multi-cell results. They work on any web page, with no special server or browser settings.

More functions, by category:

Text. TEXTBEFORE, TEXTAFTER, ARRAYTOTEXT, VALUETOTEXT and NUMBERVALUE.
Math and logic. XOR, IFNA, PERCENTOF, CEILING.MATH, FLOOR.MATH, and CONVERT for unit conversion.
Lookup, reference and information. INDIRECT and OFFSET (now complete; see below), ADDRESS, AREAS, TYPE, and TRIMRANGE together with trim references such as A1:.A100.
Date and financial. DAYS, VDB, and the coupon-date functions COUPDAYBS, COUPDAYS, COUPDAYSNC, COUPNCD, COUPNUM and COUPPCD.
Engineering. IMLOG10 and IMSQRT.
Statistics. MEDIAN, MODE, MODE.SNGL, MODE.MULT, HARMEAN, MINA, MAXA, COUNTBLANK, RANK.EQ, RANK.AVG, PERCENTILE.INC, PERCENTILE.EXC, PERCENTRANK.INC, PERCENTRANK.EXC, QUARTILE.INC, QUARTILE.EXC, VAR.S, VAR.P, STDEV.S, STDEV.P, SKEW.P, COVARIANCE.S, COVARIANCE.P, PEARSON, STEYX, GAUSS, PHI, GAMMA, GAMMALN.PRECISE and PERMUTATIONA.
Probability distributions and tests. NORM.DIST, NORM.INV, NORM.S.DIST, NORM.S.INV, LOGNORM.DIST, LOGNORM.INV, BINOM.DIST, BINOM.DIST.RANGE, BINOM.INV, NEGBINOM.DIST, HYPGEOM.DIST, POISSON.DIST, EXPON.DIST, GAMMA.DIST, GAMMA.INV, BETA.DIST, BETA.INV, WEIBULL.DIST, T.DIST, T.DIST.RT, T.DIST.2T, T.INV, T.INV.2T, T.TEST, F.DIST, F.DIST.RT, F.INV, F.INV.RT, F.TEST, CHISQ.DIST, CHISQ.DIST.RT, CHISQ.INV, CHISQ.INV.RT, CHISQ.TEST, Z.TEST, CONFIDENCE.NORM and CONFIDENCE.T. The older names POISSON, EXPONDIST, GAMMADIST, GAMMAINV, BETAINV, CRITBINOM, TDIST, TINV, TTEST, FTEST, CHITEST and ZTEST now calculate too.
Forecasting. FORECAST.LINEAR, FORECAST.ETS, FORECAST.ETS.CONFINT, FORECAST.ETS.SEASONALITY and FORECAST.ETS.STAT.

2. Formula types and calculation behaviour

Dynamic arrays and legacy array formulas. V12 adds an array calculation model, including spilled results, spill references such as B1#, and implicit intersection with @. Legacy Ctrl+Shift+Enter formulas use the same machinery. Expressions such as A1:A10*B1:B10, range comparisons and functions applied across ranges can calculate element by element. Spill output remains constrained by the converted page’s allocated space.
Dynamic references. INDIRECT and OFFSET gain runtime address resolution, so references can respond to changing inputs. This includes structured table references inside INDIRECT and improved defined-name handling. Excel dependent dropdowns based on these functions can become cascading dropdowns on the web.
More complete reference expressions. V12 expands INDEX reference-form support, including multiple areas and whole-row / whole-column results. A reference-returning function can also form either endpoint of a range expression.
Improved calculation speed, fidelity and capacity.
Iterative calculation. Iterative calculation settings are honoured in the runtime reference recalculation loop.
Full Excel format strings. TEXT accepts Excel’s complete format-code language: several sections, conditions such as [>=1000], leading zeros, thousands separators, fractions, percentages, currency and language tags, elapsed time such as [h]:mm, and date and time codes down to fractions of a second. Richer date and time formats also display in cells as they do in Excel.
Better international support. Calculations follow the workbook’s language and region. Numbers written as text are read with the correct decimal and thousands separators. Dates and times written as text are read in the local order. DOLLAR returns the local currency. COUNTIF/SUMIF-style criteria compare and sort text by local rules. TEXT format codes written in your Excel’s language are understood.

These are compatibility improvements as well as additions: they allow more existing workbooks to behave correctly without formula rewrites.

3. Features and workflow

Easy install from the Microsoft Marketplace, from within Excel. Search for SpreadsheetConverter in Excel’s Add-ins store and click Add — no downloads, no manifest files. See the install page.
Excel on the web is supported.
In-place refresh when a newer version is available — no need to download updates.
Modern page renderer. A new renderer is now the default, with Classic retained as an option. It brings updated controls and wizard presentation, accessibility labels, and integration with SpreadsheetConverter Server.
Publishing and embedding. The add-in supports authenticated publishing to SpreadsheetConverter Server and choosing which page opens afterwards. Server-hosted forms can be embedded inline on external websites, including WordPress.
Data-table workflows. Mark ranges as data tables, name them, and choose embedded data or supported server-backed modes. This is a new way to package and connect the tabular data your calculations use.

Install for Excel Report a problem

More of your workbook.Less preparation.