Google Sheets add-on
Timezone Toolkit for Google Sheets
Convert, compare, and schedule across time zones with 29 DST-aware TZ_ functions that behave like native spreadsheet formulas.
29 custom functions
DST-aware IANA zones
Range input support
No external API calls
Read function docsMarketplace listing URL pending publication
FormulaTypical result
TZ_CONVERT
=TZ_CONVERT("2026-06-01 09:00", "America/New_York", "Asia/Tokyo")2026-06-01 22:00:00TZ_MEETING
=TZ_MEETING("2026-06-01 09:00", "America/New_York", "Europe/London,Asia/Tokyo")Europe/London -> 2026-06-01 14:00:00; Asia/Tokyo -> 22:00:00TZ_OFFSET
=TZ_OFFSET("America/Denver", "2026-07-01")-06:00Global operations sheets
Convert timestamps from vendors, CRMs, logs, and handoff docs without leaving the formula bar.
Meeting planning
Show one meeting across every office and find real workday overlap before inviting the team.
Timezone cleanup
Normalize offsets, abbreviations, ISO strings, Unix timestamps, and date parts into dependable columns.
IANA zone lookup
Search by city, country, or abbreviation, then feed the result into conversion formulas.
DST visibility
Inspect offsets, abbreviations, long names, and the next or previous transition.
Private by design
Time zone calculations run inside the spreadsheet without external API calls.
Function map