Zones, Lookup, and Scheduling
TZ_LIST
Lists available IANA time zones, optionally filtered.
Syntax
=TZ_LIST([filter], [limit])Parameters
NameTypeDescription
Name
filter?Typetext
DescriptionCase-insensitive substring, such as "Europe" or "Tokyo".
Name
limit?Typenumber
DescriptionMaximum number of rows to return.
Returns
A single-column spill range of matching zone names.
Example
=TZ_LIST("Tokyo", 3)Result: Asia/Tokyo