Spreadsheet mockup showing Functable formula functions
Google Sheets functions Google never shipped

A utility belt of fast, formula-first custom functions.

Functable adds the spreadsheet formulas that teams keep rebuilding: DST-aware time zones, JSON extraction, dynamic summary tables, fuzzy lookup, name splitting, and a growing set of focused Google Workspace add-ons.

Browse functionsRead docs
=TZ_CONVERT(A2, "America/New_York", "Asia/Tokyo")=PARSEJSON(B2, "items[*].price")=GROUPBY(A1:A20, C1:C20, "SUM", TRUE)=FUZZYLOOKUP(A2, Accounts!A:A, Accounts!B:B, 0.82)=SPLIT_NAME(A2:A, TRUE)=TZ_WORKDAY_OVERLAP("America/New_York", "Europe/London")

Function families

Install focused add-ons instead of one bloated bundle.

Functable uses a hub-and-spoke model: individual Marketplace listings for high-intent jobs, with a future Pro bundle for enriched backend-touching functions.

Timezone Toolkit icon29 functions

Timezone Toolkit

Convert, compare, and schedule across time zones with 29 DST-aware TZ_ functions that behave like native spreadsheet formulas.

ParseJSON icon1 function

ParseJSON

Extract nested fields from JSON strings with a formula-first JSONPath function built for spreadsheet workflows.

GROUPBY / PIVOTBY icon4 functions

GROUPBY / PIVOTBY

Build dynamic summary and pivot tables with formula-first GROUPBY, PIVOTBY, and namespaced GB_ aliases.

FUZZYMATCH icon12 functions

FUZZYMATCH

Find close-enough names, labels, and IDs with formula-first similarity, fuzzy match, and fuzzy lookup functions.

NAMESPLIT icon26 functions

NAMESPLIT

Split contact names into first, middle, last, title, suffix, confidence, and formatted outputs with formula-first Google Sheets functions.

Install only the family you need

Each function family is packaged as its own Google Workspace Marketplace add-on, so a timezone sheet does not need a JSON parser or pivot formula pack.

Type formulas, not workflows

Functable functions sit directly in cells, spill across ranges, recalculate with the sheet, and compose with native Sheets formulas.

Local work stays free

Anything computed inside the spreadsheet stays unlimited. Pro is reserved for enriched variants that need backend services.

Built for Sheets

Free local formulas now. Pro services later.

The boundary is simple: if Functable can compute it locally inside the sheet, it stays free and unlimited. If a future function needs an external service, license checks and Stripe-backed Pro access live on the backend.

Formula-first custom functions
Google Workspace Marketplace packaging
No per-seat pricing for local functions
Docs for every exported function

Timezone Toolkit

Convert zones, read offsets, plan meetings, and inspect DST behavior with 29 TZ_ functions.

View landing page

PARSEJSON

Extract nested values from JSON strings using JSONPath-style paths directly inside cells.

View landing page

GROUPBY / PIVOTBY

Build dynamic summary and pivot-style tables with a single spilling formula.

View landing page

FUZZYMATCH

Reconcile close-enough names, labels, and IDs with similarity and fuzzy lookup formulas.

View landing page

NAMESPLIT

Split full names into contact-ready first, middle, last, title, and suffix columns.

View landing page
    xs