Step by step
Add CalcForms to ChatGPT
Open the CalcForms app page in ChatGPT and click Install plugin. Sign in with your email when asked; we send a 6-digit code. You only do this once. A free ChatGPT account works.
Drag your spreadsheet into the chat
Start a new chat, attach the .xlsx or paste the Google Sheets link, and say what it is in one line: "This is my roofing pricing sheet."
Say what the customer should see
Tell ChatGPT which cells are questions for the customer and which are yours. One sentence is enough: "The customer enters roof size, material and pitch. Everything else is calculated. Show them the total only."
Check the numbers
ChatGPT shows you the form. Type in a quote you already know the answer to and compare. If anything is off, say so in plain words: "The metal rate should be $9.50, not $9.00."
Publish and share
Say "publish it." You get a link like forms.badabingapp.cc/yourname/roofing-quote. Send it to customers, put it in your email signature, or add a button on your site.
Worked example: one roofing quote, on sample rates
| Line | Worked out | Amount |
|---|---|---|
| Roof area at the sheet's material rate | 2,000 sq ft × $5.50 | $11,000.00 |
| Steep roof factor | $11,000 × 1.15 | $12,650.00 |
The customer sees one number, $12,650.
Sample rates for this example, not a quote: $5.50 a square foot and a 1.15 factor for a steep roof.
Four ways to turn a spreadsheet into a form, side by side
What each way needs, whether the form works out a price while the customer types, what it costs and the work involved, taken from each product's own pages.
| Way | What you need | Works out a price as the customer types | Cost | Effort |
|---|---|---|---|---|
| Microsoft Forms with Excel | Excel for the web, a Microsoft 365 work or school account, and the workbook stored in OneDrive for work or school | Not among the question types Microsoft's help page lists | The Microsoft 365 work or school account it needs | Insert, then Forms, then New Form in Excel for the web, then write each question |
| A Google Apps Script web app | A Google account, and HTML, CSS and JavaScript you write yourself | If the JavaScript you write works it out | A Google account; Google's quotas page sets daily limits for consumer accounts such as gmail.com | Write the page in the Apps Script editor, add a doGet function, then deploy the script as a web app |
| SpreadsheetConverter | Microsoft Excel with the SpreadsheetConverter add-in | Yes, it converts the workbook into a calculating web page | From $15 a month, or $12.75 a month billed yearly; without a paid plan, links are test links deleted after 7 days | Convert the workbook in Excel, then upload it with Publish to Cloud |
| CalcForms | ChatGPT, where a free account works, with the CalcForms app, and your Excel or Google Sheets file | Yes: when every question is on one page, the results you choose to show update as the customer types | Free in ChatGPT; Pro $12.99 a month after a 1-day trial | Paste the sheet into ChatGPT, say what the customer sees, test a past quote and publish, in about 10 minutes |
Competitor prices and details were read from each vendor's own site on 6 November 2026 and can change. Sources: Microsoft Support; Google for Developers (HTML Service, Quotas); SpreadsheetConverter (home page, price list, Publish to Cloud).
The words to say
Copy this into ChatGPT (with CalcForms added) and fill in the brackets.
"Here is my pricing spreadsheet. Build a form from it. The customer fills in [the inputs], everything else is calculated. Show the customer only [the total]. Do not show my costs or margin. Then publish it."
What you will see
A form with one question per input, your formulas running behind it, and a results panel that shows only the numbers you chose. Every reply reaches you with all the calculations done, including the ones you do not show: in ChatGPT, in your email copy, or in the web portal on Pro.
Common mistakes
- Pasting a sheet with the answers typed in as numbers instead of formulas. The form needs the formulas to do the math. If your sheet is "flat", say what the rule is and ChatGPT will write it.
- Forgetting to say what the customer sees. By default the form shows no calculated results, so say explicitly which number the customer should see.
- Not testing with a real past quote. Always try one you know before you send the link.
Last updated 12 November 2026
Questions about how to turn an Excel spreadsheet into a form customers can fill in
Does it work with Google Sheets?
What if my spreadsheet has several tabs?
Will my spreadsheet be stored by CalcForms?
Can I do this with Microsoft Forms and Excel instead?
Can I build it myself with Google Apps Script?
What does it cost?
Rather do it together?
Book a free 30-minute onboarding call. We open your spreadsheet and build the form with you.
Book a free call → Or start in ChatGPT