APPSHEET UTILITY

HTML Table Formula Generator

Add your columns, set the header and row styling once, then copy a ready-made CONCATENATE() formula straight into an AppSheet Text column.

Columns order here = order in the table
Header text AppSheet column Preview sample
Header settings applies to every <th>
Row value settings applies to every <td>
Table settings
ON
Live preview Updates automatically

Copy this and paste it into a Text-type column's App formula in AppSheet.

CONCATENATE()
this formula runs on caffeine, not magic Watch on YouTube
TokenControlsAccepted values
CONCATENATE()Joins every string and column value into one HTML blockwraps the whole formula
<th> / <td>Header and row cells for each column, in the order set aboveone pair per column
UPPER()Converts a row value to uppercase before it's placed in the cellRow value settings
LOWER()Converts a row value to lowercaseRow value settings
borderAdds a 1px border to every cell when turned onON / OFF
widthSets the rendered width of the tablee.g. 100%, 600px
alignHorizontal text alignment for header and row cellsleft / center / right