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.
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
Formula calculations run within Google Apps Script™. Pseudonymous usage metadata is sent to Amplitude to help improve the add-on; these analytics never include cell contents or formula arguments.
Read the privacy policyHelp & support
Start with the function reference and examples. In Google Sheets™, open Extensions → Timezone Toolkit → Help & Examples for guidance, or choose Send Feedback to report a problem. You can also email me@aleckriebel.com. Include the function name and a small example using sample data; please avoid sensitive spreadsheet data.
Function map