AppSheet HTML Table Generator
Add your columns, set the header and row styling once, then copy a ready-made CONCATENATE() formula straight into an AppSheet Text column.
Recommended. Values containing < or & can otherwise break the table.
e.g. 100%, 600px
Your formula
Copy this and paste it into a Text-type column's App formula in AppSheet.
| Token | Controls | Accepted values |
|---|---|---|
| CONCATENATE() | Joins every string and column value into one HTML block | wraps the whole formula |
| <th> / <td> | Header and row cells for each column, in the order set above | one pair per column |
| UPPER() | Converts a row value to uppercase before it's placed in the cell | Row value settings |
| LOWER() | Converts a row value to lowercase | Row value settings |
| SUBSTITUTE() | Replaces & and < in values so they can't break the table | HTML-safe ON / OFF |
| border | Adds a 1px border to every cell when turned on | ON / OFF |
| width | Sets the rendered width of the table | e.g. 100%, 600px |
| text-align | Horizontal text alignment for header and row cells | left / center / right |
Common issues
Quick fixes for the problems people run into most. Still stuck? Use the Troubleshoot button at the top.
A value breaks the table layout
Values that contain < or & can be read as HTML and break the table. Turn on Make values HTML-safe and copy the formula again.
I get a formula error after turning on HTML-safe
HTML-safe wraps each value in TEXT() and SUBSTITUTE(). If a column type doesn't accept that in your app, turn HTML-safe off for that table and copy the formula again.
My column has spaces in its name
That's fine. Type the name exactly as it appears in your table, with or without square brackets, and the generator adds the brackets for you.
I need the columns in a different order
Use the up and down arrows next to each column. The table follows the order in the list.
The header text looks wrong
Choose Original to keep the header exactly as typed, or UPPERCASE or lowercase to change it. Header text is escaped, so symbols like quotes and < show as typed.
I've built 100+ AppSheet apps for inventory, POS, inspections, approvals and reporting, for clients in the USA, Europe and Asia.