# Convert an Excel Calculator to a Web Page > An HTML export gives you the answers, not the maths. Here is what it takes to turn an Excel calculator into a working web page, which formulas survive, and how to publish it without giving away your pricing logic. Source: https://llamapress.ai/convert-an-excel-calculator-to-a-web-page | Updated: 2026-09-04 --- [LlamaPress Blog](https://llamapress.ai/blog) An HTML export gives you the answers, not the maths. Here is what it takes to turn an Excel calculator into a working web page, which formulas survive, and how to publish it without giving away your pricing logic. [Back to all articles](https://llamapress.ai/blog) ![Kody Kendall](https://llamapress-ai-image-uploads.s3.us-west-2.amazonaws.com/jujc1ep8nuqrdiftdfer1ngp833u) Written by ### Kody Kendall AI & Software Engineer | Creator of the Leonardo Coding Agent Updated September 2026 You cannot convert an Excel calculator to a web page with a file converter. HTML has no calculation engine, so any converter gives you the last answer your spreadsheet worked out, frozen. To get a page where a visitor types their own numbers and gets their own answer, the formulas have to be re-expressed as code. That takes minutes with AI reading the workbook, or a day or two by hand. The decision that matters more than the method is where the maths runs, because a calculator built the obvious way publishes your pricing formula to anyone who opens their browser's dev tools. In short - A converter exports values. A calculator needs the formulas rebuilt as code, which is a different job. - Arithmetic, IF, lookups, date maths and SUMIF all translate cleanly. Goal Seek, Solver, VBA and circular references do not. - If the maths runs in the browser, your formula is readable by anyone. If your margin is in it, run it on the server. - Rebuilding is also the only honest audit your workbook has ever had. Expect to find at least one wrong formula. I have rebuilt a lot of these. A quoting calculator, a freight rate sheet, a loan affordability model, a materials estimator. They all start the same way. Somebody sends me a workbook, points at cell D42 and says "that number is the whole business". They are usually right, and that is exactly why the conversion needs more care than a table export. ## Why a converter cannot do this A spreadsheet is two things stacked on top of each other. There are the values you see, and underneath them there are the formulas that produced the values. When you save a workbook as a web page, or run it through any [Excel to HTML converter](https://llamapress.ai/excel-to-html), only the top layer travels. The formula is evaluated once and thrown away. So the page you get shows 14,820 in the total cell forever. Change an input and nothing happens, because there is nothing there to recalculate. That is the right result for a price list and the wrong result for a calculator. Our own converter says so on the page, because the alternative is a visitor discovering it after they publish. ## What a calculator actually needs Take your workbook apart into four things before anyone writes code. This is twenty minutes of work and it removes most of the risk. **The inputs.** Which cells does a human actually type in? In most workbooks it is a surprisingly small number, often five to fifteen, scattered across a sheet built for the person who made it. Each one becomes a form field, and each one needs a type, a unit and a sensible range. **The constants.** The markup, the labour rate, the tax percentage, the minimum order. These live in cells too, often in a corner of the sheet or on a tab called Settings. In an app they belong in one place that an admin can edit without touching the maths. **The lookup tables.** A VLOOKUP against a price band or a postcode zone is data, not logic. Those tables become database tables, and updating a price becomes editing a row rather than editing a formula. **The one output that matters.** Most calculators have one headline number and several supporting ones. Name it, and name the intermediate steps you want shown. A calculator that only prints a total is much less persuasive than one that shows its working. ## Which formulas survive the move | In Excel | On a web page | Notes | | --- | --- | --- | | Arithmetic, percentages | Direct | Watch rounding. Excel rounds for display, code does not. | | IF and nested IF | Direct | Deep nesting becomes readable rules, which is an improvement. | | VLOOKUP, XLOOKUP, INDEX/MATCH | Becomes a table | The lookup range becomes a database table you can edit. | | SUMIF, COUNTIF, SUMPRODUCT | Direct | Becomes a filtered sum over the same rows. | | Date maths, NETWORKDAYS | Direct, with care | Holidays become a list. Time zones become a real decision. | | Goal Seek | Rewritten | Becomes a solve loop in code, or algebra if the formula inverts. | | Solver, what-if tables | Rewritten | Doable, and the most expensive part of any such build. | | VBA macros | Rewritten | Microsoft: "macros do not run in a browser window", so there is nothing to port. | | Circular references | Must be resolved | Usually an iterative calculation. Someone has to state the intent. | | RAND, NOW, volatile functions | Change meaning | A value that changes every recalculation needs a fixed rule instead. | Formula by formula mapping in more depth, including the macro question, is in [whether you can keep your Excel formulas and VBA macros](https://llamapress.ai/can-you-keep-your-excel-formulas-and-vba-macros-when-you-convert-to-a-web-app). ## The part nobody warns you about: where the maths runs This is the section I would read twice. A web calculator can do its arithmetic in one of two places, and the choice decides whether your formula stays yours. **In the browser.** The formula is written into the page as JavaScript. It is fast, it works offline, and it is completely readable. Anyone can press F12, open the sources panel, and read your markup percentage, your labour rate and every band in your pricing table. There is no way to prevent this. Minifying the code makes it slightly annoying rather than secret. **On the server.** The page sends the inputs away, the maths happens somewhere the visitor cannot see, and the answer comes back. The formula never leaves your machine. It needs a connection, and it is what you want the moment the formula is a competitive advantage. Pick by asking one question. If a competitor read this formula, would it cost you anything? A mortgage repayment calculator uses public maths, so put it in the browser and enjoy the speed. A quoting engine that encodes fifteen years of knowing what a job really costs belongs on the server. Worth saying plainly, because people assume the spreadsheet already protects them: it does not. Microsoft states that "worksheet level protection isn't intended as a security feature". A password on a sheet stops accidental edits. It is not a lock on your logic, and it never was. ## Three ways to build it ### 1. Have AI read the workbook This is what we do. The agent opens the file, finds the input cells, follows the formula chain to the output, pulls the lookup ranges out into tables, and writes the calculator. A single calculator is usually working the same day. Upload the file to the [Excel to website builder](https://llamapress.ai/excel-to-website) if the calculator is for customers, or the [Excel to app converter](https://llamapress.ai/excel-to-app) if it is a tool your team uses to quote. Both are free to try. ### 2. Rebuild it by hand A developer reads the formulas and writes them out. For a calculator with ten inputs and no Solver, that is a day or two. It is the right choice when the calculator is going into an existing site with its own framework and conventions. ### 3. Host the workbook and let people use it You can embed a live workbook so visitors interact with the real thing. It keeps the maths working with no rebuild, and it comes with real limits: Microsoft caps an embedded workbook at 10 MB and 1,000 concurrent viewers, the page cannot be styled as your own, and search engines cannot read any of it. The five ways to put a sheet on a page are compared in [how to display an Excel spreadsheet on a web page](https://llamapress.ai/how-to-display-an-excel-spreadsheet-on-a-web-page). ## Rebuilding is an audit, so budget for surprises Every time we do this, something in the workbook turns out to be wrong. A range that stops one row short of the data. A hard coded number sitting inside a formula where a reference should be. A rate that was updated on one tab and not the other. This is not unusual and it is not a reflection on whoever built it. Ray Panko's field audits at the University of Hawaii found errors in at least 86% of the operational spreadsheets examined since 1997, summarised in [his review of spreadsheet error studies](https://arxiv.org/abs/0802.3457). Plan for the conversation where you decide whether the web version copies the existing behaviour or fixes it. Copying is sometimes right, because the existing numbers are what your customers have been quoted. ## A public calculator or an internal one? The same workbook makes two very different products, and the difference is who types in the numbers. A **public calculator** sits on your website. Visitors price their own job, see a number, and send you an enquiry attached to it. It is a lead generator and it should be indexed by Google, which is a good reason not to use an embedded workbook. That is the [convert Excel to a website](https://llamapress.ai/excel-to-website) job. An **internal calculator** is used by your own team to quote. It needs sign-ins, saved quotes, version history and probably an approval step above a certain value. That is the [Excel to app converter](https://llamapress.ai/excel-to-app) job, and there is a worked example in [the steel contractor whose estimating workbook we rebuilt](https://llamapress.ai/we-rebuilt-a-contractors-excel-logic-as-an-app), where estimates ended up 62% faster. ## Frequently asked questions ### Can I convert an Excel calculator to a web page for free? You can build one free and see it working before paying anything. Upload the workbook to the [Excel to website builder](https://llamapress.ai/excel-to-website) and describe the calculator in a sentence. What you cannot do free is convert it with a file converter, because that produces a static page with no maths in it. ### Will my formulas keep working on the web page? The logic keeps working, expressed as code rather than as cell references. The formulas themselves do not travel, because a browser has no calculation engine. In practice the rule gets written once instead of being copied down 4,000 rows, which is usually the biggest single improvement. ### How do I stop people seeing my pricing formula? Run the calculation on the server rather than in the browser. Any calculator whose maths happens in JavaScript can be read by opening dev tools. If your margin is in the formula, say so before anyone starts building, because it changes the design. ### What about Goal Seek and Solver? Both are rewritten rather than converted. Goal Seek becomes a small solve loop, or plain algebra when the formula can be inverted. Solver is real work and it is the part of these projects most likely to be underestimated. ### Can the calculator save what people enter? Yes, and this is usually the reason it pays for itself. Each calculation can be stored with the inputs and the answer, so you get a record of what people are pricing. That is an application rather than a page, which is a small step up from a calculator once the calculator exists. ### How long does it take? A calculator with a handful of inputs and no Solver is often working the same day with AI reading the workbook, and a day or two by hand. Add time for the audit conversation, because you will find something wrong in the original. ### Turn the model into a working calculator Upload the workbook and AI reads the inputs, the constants and the formula chain, then builds the calculator. Free to try, no credit card. [A calculator for my customers](https://llamapress.ai/excel-to-website) [One for my own team](https://llamapress.ai/excel-to-app) Formula heavy or full of Solver? [Contact us](https://llamapress.ai/contact). Build sprints start at $2,000. Sources: Microsoft, [Protect a worksheet](https://support.microsoft.com/en-us/office/protect-a-worksheet-3179efdb-1285-4d49-a9c3-f4ca36276de6); Microsoft, [Differences between using a workbook in the browser and in Excel](https://support.microsoft.com/en-us/office/differences-between-using-a-workbook-in-the-browser-and-in-excel-f0dc28ed-b85d-4e1d-be6d-5878005db3b6); Microsoft, [Embed your Excel workbook on your web page or blog](https://support.microsoft.com/en-us/excel/embed-your-excel-workbook-on-your-web-page-or-blog-from-sharepoint-or-onedrive-for-business); R. Panko, [Spreadsheet Errors: What We Know. What We Think We Can Do](https://arxiv.org/abs/0802.3457), arXiv 0802.3457. All checked September 2026.