All Collections
Google Sheets Table
FAQ
How to display a single cell value instead of a table
How to display a single cell value instead of a table

How to show a single spreadsheet cell value instead of a table.

Updated over a week ago

By default, the app is most commonly used to display a table. However, there may be cases in which you would want to display a single spreadsheet cell value on your website.

To achieve the above, we will reduce our table to be a single 1x1 table.

1. Move your value into the A1 cell. Any formula or calculation will now be placed in this cell.

2. Select to display A column only

3. Select to display a single Row

4. Hide the Headers of the table

5. Hide the pagination buttons

Your result look similar to the following:

Your spreadsheet cell values will always be up to date with anything that you have in the A1 cell in your spreadsheet! Feel free to repeat the above procedure for any other cell values (by using different Sheets), and to add other editor elements, for example texts, images etc.

Did this answer your question?