From a spreadsheet to an app
The spreadsheet your team has outgrown, as an app.
Give it an Excel or CSV file and get an app around your rows, with search, a page for each row and a form to add and edit.
What the spreadsheet becomes.
An app around your rows
What you get is an app around your rows: search, a page for each row, and a form to add and edit.
Your rows, exactly as they are
Your rows are copied in exactly as they are, after the code is built, so the very first preview shows your own data and no AI retypes it.
Read in your browser
The file is read in your browser.
Columns you can leave out
Untick any column the app should not have, say what the app is for if you like, and press Build the app.
A warning for personal details
If a column looks like a personal detail, such as an email, a phone number or a salary, the window warns you that anyone who opens the published app can read it.
Reading it costs nothing
Reading the spreadsheet costs nothing; the button shows the price of a new app.
See the columns before you build.
Then you see its columns, each with the kind of thing it holds, such as text, number, date, email or picture, and the first five rows.
From a spreadsheet, in the documentationFrom the file to the app.
- 1
Give it the file
In Import an app, choose Spreadsheet and give it an Excel (.xlsx) or CSV file.
- 2
Check what it understood
Untick any column the app should not have, say what the app is for if you like, and press Build the app.
- 3
Add the rest afterwards
Up to 300 rows are copied in. If your file has more, the window says how many the app starts with, and the rest can be added after it is built with Import a catalogue, below.
Good to know before you start.
Google Sheets
Save a Google Sheet first with File, then Download.
One sheet, one list
A workbook with several sheets asks which one to use; one sheet becomes one list.
Formulas
Cell colours and formatting do not come over, and the values of formulas do.