Community · Help

SheetApps User Guide

Turn an Excel workbook (or Google Sheet) into a multi-user web app — forms, validation, lookups, import/export and more.

Creating an appStart here

On the My Apps page, workspace admins and builders see a New App tile. You can create from:

  • An Excel workbook (.xlsx) — upload it from your computer.
  • A Google Sheet — if Google integration is enabled, pick a sheet from your Drive (see Google Sheets).

Before the app is created, SheetApps checks your workbook and shows what it found. If something would stop it from building a working app — no Form_ sheet, a blank form, no readable fields, or more than one header / line-items section in a form — it explains the problem (in red) and asks you to fix the spreadsheet and upload again. Smaller issues, like a lookup, rule, or formula it couldn't read — or a date or number that looks like it was typed as text — appear as orange warnings; the app is still created, just without those parts.

On the Configure Your App step, use Preview App to try the forms before anything is created: the preview is the real form — fill in fields, pick from dropdowns, add line rows — rendered with your chosen Form style and layout. Nothing you enter is saved. Close the preview, adjust the style or layout if you like, and preview again before pressing Create App.

To update an existing app later, use the Change (↻) icon on its card — rename it, edit the description, or supply a new workbook to migrate its schema. Existing records are preserved. You first see exactly what will change (fields added, removed and kept) to confirm. If the file looks like the wrong one — its name doesn't match the app, or it would replace most of the fields — the change is blocked: you'll be asked to pick a different workbook or create a new app, so an existing app can't be overwritten by an unrelated spreadsheet. The Change dialog also has a Preview button to rehearse the forms with your chosen look and field layout before you save.