Google Sheets add-on

Dependent dropdowns in Google Sheets, without helper sheets.

Point at one flat table—Category, Subcategory, Brand, Product—and get cascading dropdowns in your sheet. Pick Electronics and the next column only offers Laptops and Phones.

Native data-validation rules, 2–5 levels, no hidden tabs, and no spreadsheet content leaving your Google account.

Open in Google Sheets See how it works

Free for your first 3 configurations. Pro from $2.50/month billed annually.

Product catalog — intakeSheet: Orders

Row 5 — each choice narrows the next.

CategoryB

Electronics⌄

2 options

SubcategoryD

Laptops⌄

2 options

BrandE

Lenovo⌄

1 option

ProductH

ThinkPad X1⌄

Selected

All four levels are valid for this row.

How it works

Four steps, about two minutes

Everything happens in the sidebar. No formulas, no named ranges, nothing to maintain by hand.

Select a flat source table

Any normal table, on any sheet. One row per valid combination.

Choose 2–5 hierarchy columns

Order them parent to child. That becomes the cascade order.

Choose destination columns

They can be on another sheet and do not need to be adjacent.

Create the dropdowns

Native validation rules appear in your range and stay in sync.