Back to blog
excel google-sheets how-to

How to convert an Excel spreadsheet to a web app, step by step

Convert Excel to a web app in 5 steps. Upload the workbook free, with no account, and get an app with your formulas rebuilt and checked.

G
GoodTaco Team
|

To convert Excel to a web app, make each tab one clean table, decide who will use the app and what they need to do, then upload the .xlsx or CSV file to an AI app builder such as GoodTaco. It imports your records and rebuilds your formulas. Test it with real records, add sign-in and share the link.

This guide is for the person who keeps the workbook running: the ops lead, office manager or founder whose team keeps asking which copy is the latest. It walks through converting Excel to a web app in five steps and compares the other options, from Excel for the web to Power Apps, so you can pick the one that fits.

Reviewed October 2026. Prices for other tools come from each vendor’s own pages.

What does it mean to turn a spreadsheet into a web app?

A spreadsheet web app is a browser app built on the data in your workbook. Instead of opening a file, people open a link, sign in and get screens made for their job, like a form to add an order or a dashboard with this month’s totals. Each tab becomes a table of records, and your formulas run as app logic, so totals and statuses stay correct as records change.

It’s worth the switch when you see these signs:

  • Copies multiply. The file gets emailed around, and nobody is sure which version is current.
  • Formulas break. Someone types over a calculated cell, and the totals quietly go wrong.
  • Everyone sees everything. You want to share some of the data with a team or a client without handing over the whole file.
  • You do the chasing. Reminders and follow-ups happen by hand because the sheet can’t send them.

An app fixes each of these: one link and one set of records, forms instead of formula cells, sign-in you control, and reminders sent from your Gmail.

Web app or website: which do you need?

Publishing Excel to a website and building a web app are different jobs. If visitors only need to look at a table or a chart, publish or embed the spreadsheet; both options are covered below. If people need to add, update or approve records, or you need to control who sees the data, build a web app.

How to convert Excel to a web app, step by step

Here’s how to create an online app from an Excel spreadsheet with GoodTaco, without writing code.

1. Prepare the workbook

Most app builders read a workbook as a set of tables, so a little cleanup now saves fixing things later.

  • One table per tab. Each tab holds one kind of thing, such as orders or customers. Move notes, summary blocks and charts off the data tabs.
  • Headings on top. Put clear column names at the top of each tab, like “Customer”, “Order date” and “Status”, with no merged cells above or across them.
  • One record each. Below the headings, put one order, customer or job on each line, with no blank gaps or subtotals in between.
  • One kind of data per column. Keep dates in date columns and numbers in number columns. A column of repeated choices, like Open, Shipped and Paid, becomes a dropdown in the app.
  • Note your formula columns. Write down which columns are calculated so you can check them after the import.

Here’s what a clean tab looks like:

Order Status Qty Unit price Line total
1041 Shipped 10 $2.50 $25.00
1042 Open 100 $1.25 $125.00
1043 Paid 20 $10.00 $200.00

Line total is a formula (Qty times Unit price). In the app, it’s calculated for every new order and updates when someone changes a quantity.

2. Decide what the web app must do

A spreadsheet accepts whatever anyone types into it. An app does the jobs you give it, so design it from those jobs, not from the columns. Answer four questions:

  1. Who uses it? The sales team or your clients.
  2. What do they enter? A new order or a status change.
  3. What do they need to see? Their open orders or this month’s revenue.
  4. Who signs in? Only your team, or clients too.

Turn the answers into two or three plain sentences, for example:

Track orders and show revenue by customer. Sales reps add orders and update their status. Managers see a dashboard of this month’s revenue and overdue orders.

That’s how you design a web app from an Excel spreadsheet without drawing a single screen. You’ll paste the description in the next step.

3. Upload the .xlsx or CSV file

First, check the file. GoodTaco takes .xlsx and .xlsm workbooks and CSV or TSV files, up to 10 MB and 2,000 records per upload. Save older .xls files as .xlsx. Macros, charts and pivot tables aren’t imported, so plan to ask for the charts you need on a dashboard.

Then go to GoodTaco’s spreadsheet to app page, drop in the file, paste your description into the optional “What should the app do?” box and enter your email. You don’t need an account. GoodTaco then:

  • Turns each tab into a table and imports your records into a built-in database.
  • Turns columns of repeated choices into dropdowns, and carries over lookups between tabs, like VLOOKUP and XLOOKUP, where it can.
  • Rebuilds your formulas as app logic. It recomputes each one from your data and compares every result with the value your spreadsheet calculated. If a formula can’t be reproduced exactly, it keeps the values instead and tells you which ones.
  • Builds the first version of the app in minutes and emails you the link.

Open the link to see the app working with your own data. Until you keep it, the app sits at an unlisted link we send only to you. To keep it, create a free account, and we then delete the file you uploaded. If you don’t, the app, its data and your file are deleted 24 hours after you upload. If you already have an account, choose “Upload a spreadsheet” when you create an app in GoodTaco.

The upload is a copy

After the import, your records live in the app, not in the Excel file. To keep working in a live spreadsheet, connect a Google Sheet instead (see below).

4. Test it with real records

Use the app the way each person will:

  • Add a record through a form and check that it appears in the list and the totals.
  • Compare a few calculated values with your spreadsheet, starting with any formulas GoodTaco flagged.
  • Search for a record the way a busy colleague would, then update it.

When something’s off, ask for the change in plain language, like “Add a Refunded status” or “Show overdue orders first.” Every change is saved in version history, so you can roll back.

5. Add sign-in and share it

Make the app private so people sign in with Google or an emailed link before they see any data, and limit access to the users or roles you choose. Then share the link. Apps are published at a GoodTaco link, or on your own domain.

Pick a switch-over day: from then on, people add records in the app, and the workbook stays as a read-only backup.

Finally, add what a spreadsheet can’t do on its own. The app can send an email from your Gmail when an order is approved, or tell a customer when their order ships.

How to go from Google Sheets to a web app instead

If your data lives in Google Sheets and people still work in the sheet, don’t upload a copy. Connect the sheet and build a Google Sheets web app on top of it. GoodTaco reads and writes the same sheet, so it stays the source of truth: a record added in the app appears in the sheet, and edits made in the sheet show up in the app.

It takes four steps: sign in with Google, pick the spreadsheet, describe what the app should do, then test and share it as above. The Google Sheets app builder page shows how the connection works, and our guide to turning a Google Sheet into an app walks through a full build.

This is also the route for Excel users who want to keep a live spreadsheet: import the workbook into Google Sheets, then connect it. If your data is in an Airtable base, you can connect that instead.

Upload an Excel or CSV file Connect a Google Sheet
Where your records live A built-in GoodTaco database Your Google Sheet
What happens to the spreadsheet The app replaces it It stays the source of truth
Account needed to try it No Yes, a free account
Best for A workbook you’re ready to retire A sheet your team still works in

What can you build from an Excel spreadsheet?

If several people touch a workbook every week, it’s a good candidate. Common conversions:

Your workbook The web app
Order log Order tracker with statuses and a revenue dashboard
Stock sheet Inventory app with a daily low-stock email
Contact list CRM with a pipeline and follow-up reminders
Timesheet Hours log that managers approve
Expense sheet Expense reports with an approval step
Client list Client portal with sign-in

If you’re starting from scratch, our Google Sheets template guides list the columns to set up for each of these, and GoodTaco builds the app on that sheet.

Other ways to convert Excel to a web application

An app builder isn’t the only way to convert an Excel spreadsheet to a web application. Our roundup of tools that build an app from a spreadsheet compares more app builders.

Method Best for Price to start Where your data lives
GoodTaco (our product) Teams that add and update records Free plan; paid from $9/month Built-in database, Google Sheet or Airtable
Excel for the web One shared file Free with a Microsoft account OneDrive or SharePoint
Microsoft Power Apps Microsoft 365 teams with an app builder $20 per user/month, paid yearly Dataverse, or a workbook in cloud storage
Appizy Website calculators From $9/month An uploaded copy
Molnify Pricing and ROI models From 99 EUR per app/month An uploaded copy

Share the workbook in Excel for the web

Save the workbook to OneDrive or SharePoint and share it, so people can edit or view it in Excel for the web. Several people can edit at once with co-authoring. Excel for the web is free with a Microsoft account; the desktop app needs Microsoft 365 to co-author.

The catch: it’s still a spreadsheet, with no forms or screens built around each person’s job.

Publish or embed the spreadsheet on a website

To put Excel on a website, embed the workbook from OneDrive; visitors can view it without signing in. To publish from Google Sheets to a website, Publish to the web makes a read-only version that updates with the sheet.

Rebuild it in Microsoft Power Apps

Power Apps can build an app from an Excel or CSV file, and Power Apps Premium costs $20 per user a month, paid yearly, with a free trial.

The catch: Copilot drafts a starter app, but you shape screens and Power Fx logic yourself. Some Microsoft 365 plans cover simple apps on a OneDrive for Business workbook; beyond that, Premium bills every user.

Use a calculator converter such as Appizy or Molnify

Appizy turns spreadsheets into web calculators from $9 a month, and Molnify turns Excel models into web apps from 99 EUR per app per month. Both fit pricing and quote calculators better than a shared list of records.

Collect entries with a form

Google Forms can save responses to a Google Sheets spreadsheet, and Microsoft Forms can keep them in an Excel workbook. A form only adds records; to search, update or approve them, people still open the spreadsheet.

Hire a developer

A developer can build exactly what you want, but you pay for the build and every later change. That fits best when the app is a product you’ll sell.

Which method should you choose?

Five questions decide the route:

  • Where should the data live? If people keep editing the spreadsheet, connect a Google Sheet or share the workbook. If you’re ready to retire the file, import it into an app.
  • Who signs in? For public viewing, publish or embed. For a team or clients who change records, use an app with sign-in.
  • What do people do with it? View: publish or embed. Calculate: a calculator converter. Submit entries: a form. Add and update records: an app builder.
  • What does each extra person cost? Per-user pricing grows with the team; GoodTaco charges per workspace, not per app user.
  • What’s in the workbook? GoodTaco doesn’t import macros. If the workbook depends on VBA macros, look at a tool such as EASA, which says it supports VBA and macros.

Turn your workbook into a web app with GoodTaco

If you’re the one who keeps the workbook alive, fixing broken formulas and answering “which version is this?”, GoodTaco turns that workbook into an app your team signs in to, with no developer to hire. Trying it doesn’t need an account, and the Free plan costs nothing. Paid plans start at $9 a month; compare plans and pricing.

Upload your spreadsheet and get the link to your app in minutes.

Frequently asked questions

How do I turn an Excel spreadsheet into a web app?

Clean up the workbook so each tab holds one table, decide who will use the app and what they need to do, then upload the .xlsx or CSV file to an AI app builder such as GoodTaco. It imports your records, rebuilds the formulas it can reproduce exactly and builds an app you can test, add sign-in to and share.

Can I convert Excel to an app for free?

Yes. You can upload an Excel or CSV file to GoodTaco without an account, and keeping the app on the Free plan costs nothing. Paid plans start at $9 a month.

What happens to my Excel formulas?

GoodTaco rebuilds them as app logic, recomputes each one from your data and compares every result with the value your spreadsheet calculated. If a formula can't be reproduced exactly, it keeps the values instead and tells you which ones. Macros, charts and pivot tables aren't imported.

How do I design a web app from an Excel spreadsheet?

Start from the jobs, not the columns: list who will use the app, what each person enters and what they need to see. Describe that in a few plain sentences and GoodTaco builds the screens, forms and dashboards. You change the design later by asking for changes.

Is my spreadsheet data safe when I upload it?

The uploaded file is deleted once you keep the app, and an app you don't keep is deleted after 24 hours. Private apps ask people to sign in before they see any data, and GoodTaco's SOC 2 audit is in progress.

Will the app update when I change my Excel file?

No. An upload is a one-time import, so the app becomes where you add and edit records. To keep a live spreadsheet, connect a Google Sheet instead; the app reads and writes the same sheet.

Do people need Excel to use the web app?

No. They open a link in their browser and sign in with Google or an emailed link. Nobody needs Excel or a copy of the file.

Get started

Ready to build faster?

Start building internal tools in minutes, not months. Free to start.

Start building free