PutThrough Product engineering studio
Book a free call

Building

Spreadsheet to app in 2026: AppSheet vs Glide vs Softr vs a custom build, and how to move your data

How to turn a spreadsheet into an app: AppSheet, Glide, Softr, Apps Script or custom, what each costs in 2026, Google Sheets’ limits, and the SQL to migrate.

In short

Turn a spreadsheet into an app when several people edit it, people need to see only their own rows, the data drifts, or other tools depend on it. There are five routes: Google Sheets with Apps Script; an app on top of the sheet with AppSheet ($5–$20 per user a month, Core included in most paid Workspace plans) or Glide; a portal such as Softr ($19–$329 a month billed yearly); Airtable, Retool or Power Apps; or a custom app on Postgres. Whichever you choose, split the sheet into tables with one fact in one place, import it through validation rules with a reject pile, and enforce permissions in the database, because Google says protected ranges “shouldn’t be used as a security measure” and anyone who can view a sheet can copy it. Keep the spreadsheet afterwards as a read-only report.

Key takeaways

  • Move when the sheet is the system: shared editing, per-person permissions, drifting data or tools that depend on it.
  • Size is rarely the limit; Sheets now holds 20 million cells. Permissions and concurrency are.
  • AppSheet and Glide are fastest on top of a sheet; Softr suits customer logins; a custom app suits per-person rules and audit trails.
  • Split the sheet into tables, import through validation rules, and send rejected rows back to a person.
  • Put permissions in the database: a shared sheet can’t hide one row from someone who can view it.
  • Keep the spreadsheet as a nightly read-only report, not as the source of truth.

When should a spreadsheet become an app?

A spreadsheet is the right first tool for almost every process. It stops being right when the sheet has become the system the business runs on, and the signs are consistent:

  • People overwrite each other. Two people edit the same rows, and the last save wins.
  • Everyone sees everything. You need staff to see only their own jobs, or customers to see only their own orders, and a shared sheet can’t do that.
  • The data drifts. “Done”, “done ”, “Completed” and “DONE” in one status column; three date formats in another.
  • Work happens away from a desk. Field staff need a phone screen with three buttons, not a grid with forty columns.
  • You need a trail. Who changed the price, when, and from what, for every row.
  • Other tools need the data. Invoices, reminders and reports depend on the sheet, and a renamed column breaks them all.

What are Google Sheets’ real limits?

Size is rarely what forces the move. Google raised Sheets to 20 million cells or 100MB per spreadsheet in September 2026, and Excel holds 1,048,576 rows by 16,384 columns per sheet. The limits that bite are the ones around the data.

The limits that matter when a spreadsheet runs a process
LimitFigureSource
Sheets API reads or writes300 a minute per project, 60 a minute per userSheets API limits
Sheets API request timeout180 secondsSheets API limits
Apps Script run time6 minutes per executionApps Script quotas
Apps Script triggers, total run time90 minutes a day on a free account, 6 hours on WorkspaceApps Script quotas
AppSheet on a Google SheetNo more than 100,000 rows or 1,000 columns, and 5–10MB of compressed data per appAppSheet help

Two details explain most failed spreadsheet apps. First, permissions are per file, not per row: Google says protected ranges “shouldn’t be used as a security measure”, anyone who can view a sheet can make a copy of it, and viewers can still read hidden sheets. Second, apps built on a sheet usually load all of it: for spreadsheet sources, AppSheet fetches the entire sheet and only then filters it, and its own documentation says security filters “aren’t a complete security solution.”

Google also warns that Apps Script quotas are “subject to elimination, reduction, or change at any time, without notice,” so don’t design a business process that needs every one of them.

How often do spreadsheets go wrong?

More often than their owners think. In Raymond Panko’s compilation of field audits, errors turned up in 91% of 55 spreadsheets examined in the core studies. When researchers read Enron’s spreadsheets and emails, 24% of spreadsheets with formulas contained an Excel error, and 20.4% of spreadsheet emails were about versions, updates or revisions: version control by email.

The documented failures come from things a spreadsheet allows and a database refuses:

Each of these maps to a database feature: types and check constraints for the typed-over number and the converted value, one table instead of copied sheets, no row ceiling, and permissions enforced on the server instead of hidden columns.

What are your options for turning a spreadsheet into an app?

There are five routes, from least to most change:

  1. Stay in Google Sheets and add Apps Script. Custom menus, form-driven entry, scheduled emails. Cheapest, and still a spreadsheet underneath.
  2. Put an app on top of the sheet with AppSheet or Glide. A mobile-friendly app in hours, with the sheet still holding the data.
  3. Use a no-code portal such as Softr on top of Sheets or Airtable, when outsiders such as customers need to log in.
  4. Move the data to Airtable, or build internal screens in Retool or Power Apps. A real database feel without writing an app.
  5. Build a custom app on a real database. Postgres underneath, your own screens on top, and the spreadsheet kept only as a report.

What do AppSheet, Glide, Softr, Airtable, Retool and Power Apps cost?

Prices from each vendor’s pricing page on October 11, 2026. Most charge per user, so the bill grows with your team, not with your data.

Spreadsheet-to-app platforms, at list price
PlatformPriceHow it countsData limits
AppSheetStarter $5, Core $10, Enterprise Plus $20 per user a monthPer user; Core is included in most paid Google Workspace plans100,000 rows on a Google Sheet
GlideBasic $25, Plus $50, Pro $125 a monthCredits; this is GlideOS, a new productNot published
Glide ClassicBusiness $199 a month billed yearly, 30 usersUsers, plus 5,000 updates then 2¢ each25,000 rows from a spreadsheet
SoftrBasic $19, Pro $99, Business $329 a month billed yearlyTeam and client users per plan, such as 10 team and 50 client on Pro50,000–1,000,000 records in its own database
AirtableTeam $20, Business $45 per collaborator a month billed annuallyPer collaborator50,000 or 125,000 records per base
RetoolTeam: $10 per builder, $5 per internal user a month billed annuallyBuilders and users priced separatelyYour own database
Power AppsPremium $20 per user a month, paid yearlyPer user; the per-app plan is no longer sold to new customersDataverse or your sources

For a team of ten using one internal app, as an illustration at list prices:

Ten staff, one app, a month (an illustration)
OptionMonthly cost
AppSheet Core$100, or nothing extra if your Workspace plan includes Core
Retool Team, 1 builder and 9 users$55
Softr Pro, up to 10 team users$99
Glide Classic Business, up to 30 users$199
Airtable Team, 10 collaborators$200
Power Apps Premium$200
Custom appAbout $65 to run, plus the build, as in Custom CRM vs HubSpot

At ten people, the platforms are cheap and fast. The gap opens when you add users, need customers to log in, or need permissions the platform can’t express.

How do you turn a spreadsheet into a database?

This is the step that decides whether the app works, whichever route you take. Take a typical jobs sheet:

A typical jobs spreadsheet, before
DateCustomerPhoneAddressJobAssignedStatusPricePaid?
10/03/2026Customer A555-01011 Main StRepairTech ADone240Y
2026-10-04Customer A555-01011 Main StServiceTech Bdone120yes
Oct 5Customer B9 Oak AveRepairTech ACompleted

Three problems hide in three rows. The customer is copied on every job, so a new phone number has to be changed in many places. Status and paid are free text, so nothing can count them reliably. And dates arrive in three formats, so sorting by date is wrong.

The fix is to split the sheet into tables with one fact in one place, and let the database refuse bad data:

create table customers (
  id bigint generated always as identity primary key,
  name text not null,
  phone text,
  address text,
  unique nulls not distinct (name, phone) -- a missing phone still counts
);

create table staff (
  id uuid primary key, -- the user's login id
  name text not null
);

create type job_status as enum ('quoted', 'scheduled', 'in_progress', 'done', 'cancelled');

create table jobs (
  id bigint generated always as identity primary key,
  customer_id bigint not null references customers (id),
  scheduled_for date not null,
  job_type text not null,
  assigned_to uuid references staff (id),
  status job_status not null default 'quoted',
  price numeric(10, 2) check (price >= 0),
  paid_at timestamptz,
  created_at timestamptz not null default now()
);

A status outside the list, a negative price or a job with no customer now fails at the database, not three weeks later in a report.

Import with a reject pile, not with hope

Export the sheet as CSV and run every row through the same rules. Rows that pass are imported; rows that don’t go back to a person with the reason, instead of being guessed at:

type Row = Record<string, string>;
const STATUS: Record<string, string> = {
  done: 'done', completed: 'done', complete: 'done',
  scheduled: 'scheduled', booked: 'scheduled',
  quote: 'quoted', quoted: 'quoted',
  'in progress': 'in_progress', cancelled: 'cancelled', canceled: 'cancelled',
};

function isoDate(s: string): string | null {
  const t = s.trim();
  if (/^\d{4}-\d{2}-\d{2}$/.test(t)) return t;
  const us = t.match(/^(\d{1,2})\/(\d{1,2})\/(\d{4})$/); // MM/DD/YYYY
  return us ? `${us[3]}-${us[1].padStart(2, '0')}-${us[2].padStart(2, '0')}` : null;
}

export function clean(row: Row, line: number) {
  const problems: string[] = [];
  const date = isoDate(row['Date'] ?? '');
  const status = STATUS[(row['Status'] ?? '').trim().toLowerCase()];
  const price = row['Price']?.trim() ? Number(row['Price'].replace(/[$,]/g, '')) : null;
  if (!date) problems.push(`date "${row['Date']}" isn't a date`);
  if (!status) problems.push(`status "${row['Status']}" isn't one of the allowed values`);
  if (price !== null && !(price >= 0)) problems.push(`price "${row['Price']}" isn't a number`);
  if (!row['Customer']?.trim()) problems.push('no customer');
  const paid = /^(y|yes|true|paid)$/i.test(row['Paid?']?.trim() ?? '');
  return problems.length
    ? { ok: false as const, line, problems }
    : { ok: true as const, date, status, price, paid, customer: row['Customer'].trim() };
}

“Oct 5” lands in the reject pile on purpose: a date without a year is a question for a person, not for code. Most imports take two or three rounds of fixing rejects, and each round is minutes.

Give each person only their rows

This is the thing a shared spreadsheet can’t do. In Postgres, row-level security lets the database itself decide which rows each signed-in person can read or change. On Supabase, staff seeing only the jobs assigned to them is one policy:

alter table jobs enable row level security;

create policy "staff see their own jobs"
on jobs for select
to authenticated
using (assigned_to = (select auth.uid()));

Because the rule lives in the database, it holds for the app, the API and any report that connects later. If it seems not to work, the usual causes are in Supabase RLS not working?.

Keep the spreadsheet as a report

People who like the spreadsheet can keep one: a scheduled export to a read-only sheet each night. The difference is that the sheet becomes a view of the data, not the place the data lives, so nobody can break the system by sorting a column.

Which should you choose?

Stay in Sheets with Apps Script, if

  • One team edits, everyone can see everything, and you mainly want forms, menus and emails.

AppSheet or Glide, if

  • You want a phone-friendly app this week, the data is modest, and your people already have Google accounts.

Softr or Airtable, if

  • Customers or partners need to log in and see their own records, and the workflows are standard.

Retool or Power Apps, if

  • The screens are internal, your data already sits in a database or Microsoft 365, and you have someone technical to own it.

A custom app, if

  • Per-person permissions, an audit trail, approvals or integrations matter, or per-user pricing would grow with your team.
  • You want the data in your own database and the code in your own repository.

We build the last kind as internal tools, usually with the spreadsheet import, roles and a nightly export to a sheet included, in about a week. See CRMs and internal tools. If AppSheet or Glide would do the job, we’ll say so.

How do you move from a spreadsheet to an app without breaking anything?

  1. Freeze the columns. Agree the final list of fields and what each one means before anything is built.
  2. Write the rules down. Allowed statuses, required fields, who can see and change what.
  3. Build the schema, then import. Run the import, fix the rejects in the sheet, and repeat until the pile is empty.
  4. Run both for a week. The app is the source of truth; the sheet becomes read-only and is compared each day.
  5. Cut over. Lock the old sheet, keep it as an archive, and switch any automations to the app’s data.
  6. Keep the export. The nightly read-only sheet means nobody loses their favorite view.

What next?

Open your most important spreadsheet and count three things: how many people edit it, how many columns hold free text that should be a fixed choice, and how many other tools read from it. If any of those numbers worries you, it’s time to move. When you’re ready, send us the sheet’s column list or see how a one-week internal tool build works.

Sources

  1. Google — Files you can store in Google Drive (Sheets limits)
  2. Microsoft — Excel specifications and limits
  3. Google — Sheets API usage limits
  4. Google — Apps Script quotas
  5. AppSheet — Spreadsheet data source limits
  6. Google — Protect, hide and edit sheets
  7. AppSheet — Security filters
  8. Raymond Panko — Spreadsheet field audits
  9. Hermans and Murphy-Hill — Enron’s spreadsheets and related emails (ICSE 2015)
  10. DASH — Board meeting presentation, September 2026
  11. US Senate hearing record — JPMorgan Chase whale trades (task force report)
  12. Public Health England — Statement on delayed reporting of COVID-19 cases (2020)
  13. BBC — Excel error and lost COVID-19 cases (2020)
  14. Microsoft — When a data set is too large for the Excel grid
  15. Abeysooriya et al. — Gene name errors in supplementary data (PLOS Computational Biology, 2021)
  16. Bruford et al. — Guidelines for human gene nomenclature (Nature Genetics, 2020)
  17. UK Information Commissioner’s Office — PSNI fine (2024)
  18. AppSheet — Pricing
  19. Google Workspace — Editions that include AppSheet Core
  20. Glide — Pricing
  21. Glide Classic — Pricing
  22. Softr — Pricing
  23. Airtable — Pricing
  24. Airtable — Plans and limits
  25. Retool — Pricing
  26. Microsoft Power Apps — Pricing
  27. Microsoft — Power Platform licensing options

Written by

PutThrough

A product engineering studio that builds AI agents, automations, web and mobile apps, and audits apps built with AI coding tools.

Questions

Questions this raises

Something we haven’t covered?

Ask on a call
01 How do you turn a spreadsheet into an app?

Decide the route first: Apps Script inside Google Sheets, an app on top of the sheet with AppSheet or Glide, a portal such as Softr, or a custom app on a real database. Then split the sheet into tables with one fact in one place, write the validation rules, import the data with a pile of rejected rows for a person to fix, set up roles and permissions, and run the app and the old sheet side by side for a week before you lock the sheet.

02 Is AppSheet free?

You can test an AppSheet app with up to 10 users at no cost. In production, Starter is $5, Core $10 and Enterprise Plus $20 per user a month, and AppSheet Core is included in most paid Google Workspace plans, so many businesses already have it.

03 AppSheet vs Glide: which should you use?

Both put an app on top of your spreadsheet quickly. AppSheet suits teams already on Google Workspace, where Core may be included, and Google advises staying under 100,000 rows and 1,000 columns on a Sheets source. Glide is quick to design with; its new GlideOS plans are priced in credits, and Glide Classic allows 25,000 rows from a spreadsheet. If you need strict per-person permissions or an audit trail, consider a database-backed app instead.

04 What are the limits of Google Sheets?

Up to 20 million cells or 100MB per spreadsheet. The Sheets API allows 300 reads or writes a minute per project and 60 per user, Apps Script runs for at most 6 minutes per execution, and triggers can run 90 minutes a day on a free account or 6 hours on Workspace. The bigger limit is permissions: they are per file, not per row.

05 Can Google Sheets restrict access by row?

No. Sharing is per file, and protected ranges only control who can edit; Google says they shouldn’t be used as a security measure, and anyone who can view a sheet can make a copy and read hidden sheets. If people must see only their own rows, the data needs to live in a database with row-level permissions.

06 How much does it cost to turn a spreadsheet into an app?

For ten staff using one internal app, list prices run from about $55 a month on Retool Team to $200 on Airtable Team or Power Apps Premium, and AppSheet Core may cost nothing extra on a paid Workspace plan. A custom app costs about $65 a month to run plus the build, and it doesn’t grow per user.

07 When should you move from Excel to a database?

When more than one person edits the data, when people need different permissions, when values must follow fixed rules, or when other systems depend on it. Field audits have found errors in most spreadsheets examined, and the documented failures, from hard-coded numbers to silently cut-off rows, are the kind a database with types and constraints refuses.

08 What is Google Apps Script good for?

Adding menus, forms, scheduled emails and small automations to Google Sheets and other Workspace apps, without leaving the spreadsheet. It works well for one team that can see everything; it isn’t a permission system, and its quotas, such as 6 minutes per execution, can change without notice.

Have something to build?

A free 30-minute call. We’ll tell you honestly what fits in a week, and send a fixed quote afterward.

Prefer to write? Send your requirements

What do you need?

What it should do, who will use it, the must-haves, and any links. A few sentences is plenty.

Budget, if you have one in mind
When would you like to start?