How to Use Google Sheets Tables with Google Sites
Convert, format and visualize your data from spreadsheets into handy tables.Ā
About Tables
Announced at the 2024 Google Next, tables is an exciting upgrade for spreadsheets which allows users to "simply and accelerate spreadsheet building." The rollout of this Google Sheets feature was announced on the Google Workspace Updates blog on May 8, 2024.
The formatting of tables will streamline managing tasks, projects and teams in Google Sheets. The Google Docs help center also contains a tutorial on how to use tables in Google Sheets. Users can easily sort and filter data and then create table views.
How to Convert to Table
Converting a table transforms your data from a typical spreadsheet to a simply beautiful, yet functional table. Enhance the usability of your data for end users and make it easier to update.Ā
Instructions
Open a Google Sheet
Select a data range
Select Format > Convert to Table
Embed a Table into Google Sites
Users can insert tables into Google Sites. This visualization of data will be a powerful tool for intranets and team sites. The ability to interact with embedded tables for filtering and sorting is not currently supported. We expect this to be an upcoming improvement to tables.
Instructions
Select your table menu
Create a table view or create a filter view
Embed
Copy embed code snippet
Open your Google Site
Insert <embed code>
Paste your code and adjust for dimensions
Features of Tables
There are many options to customize tables. Such settings may have an affect on appearance, while others allow for advanced usage and formulas.
Table Headers
Number
Date
Dropdown
Checkbox
Smart chips
Table Menu
Rename
Adjust table range
Turn off alternating row colors
Change alternating colors
Customize colors
Remove formatting
Delete your table
Readjust the row height
Change the font style
Create group by view
Create filter by view
Select Views