Structured tables for Google Sheets

Google Sheets' Tables make data far more structured and more like database type data. You can assign data types to each column, use structured references on entire column, they automatically expand with formulas, data validation and more. Change your data inputs into Tables and Google Sheets will work much better.
Create better tables in Google Sheets: kzbin.info/www/bejne/i4KqZmeuibmDkJo
Auto colour in Google Sheets: kzbin.info/www/bejne/hp6VepaEhbNsq7M
Download example files here: www.xlconsulting-asia.com/youtube-files.html
00:00 Introduction
01:22 Make a table
02:00 Auto expand
02:54 Group by
03:53 Set data types
04:59 Smart chips data type
07:15 Table templates
07:47 Rename, resize, restyle & revert
09:08 Column options
10:01 Formulas and tables
14:29 Shortcuts
14:52 Multi cell formulas and tables
16:31 Excel Table features not in Sheets
16:56 Data type vs validation

[@NetMediaCCTV]

Structured tables are awesome, thanks for sharing!

[@Hermiel]

About time. One of my top requests, after better named range management.

[@learnspreadsheets]

Absolutely, such a game changer!

[@francoischarette2139]

Hello. Thanks for the video. Now is there a way to retrieve the data using the table name with App Script?

[@rubenmunozverdu7528]

About time!!! Does this have structured references like Excel tables have?

[@rubenmunozverdu7528]

Okay, asked without finishing the video 😂

[@learnspreadsheets]

Partially, they apply to whole columns, not to cells in the same row or headers though

[@johnathanmudrovcic6405]

Great content! What about separate filtered views? Example: Original source Table on Sheet 1. Sheet 2 requires a synced filtered view, and when this filtered view on sheet 2 is edited, it updates the data in the original table on sheet 1 (and visa versa). Is this possible and if not, do you know if it’s coming?

[@learnspreadsheets]

Hi that is absolutely possible but with another method, using the FILTER function or QUERY function. Check my videos on QUERY & dynamic arrays in Sheets for more info!

[@esperanzapadilla6314]

is this already rolled out or is it still under BETA environment?

[@learnspreadsheets]

It’s not in Beta but it’s being gradually released, & Google has said everyone should have it by late June. More info here: workspaceupdates.googleblog.com/2024/05/tables-in-google-sheets.html?m=1