ListFill: Dependent Dropdown & Drop Down List
ListFill is an add-on for Google Sheets™ that makes dependent dropdowns: pick a country, and the next cell offers only its states, then only that state’s cities.
- One table, up to five levels: keep your choices as a plain table, a header row and one column per level (Country, State, City), one row per path. Select it, select the cells for the dropdowns, click Add dropdowns.
- Every row on its own: each row’s dropdowns follow that row’s choices, on up to 2,000 rows at once. No named ranges, no INDIRECT, no formulas to copy down.
- Sheets’ own dropdowns: they work for everyone who edits the spreadsheet, with or without ListFill. Add a row to your table and it shows in the dropdowns (after 20 new choices in one dropdown, click Refresh all).
- Cleared when the one before changes (Pro): change the country, and that row’s state and city are emptied, so no row keeps a city from another country.
ListFill keeps each dropdown cell’s choices as formulas on one hidden tab named “ListFill lists” in your spreadsheet, and nothing anywhere else. Leave that tab as it is: change or remove the dropdowns in ListFill, and when none are left the tab goes too. Removing dropdowns keeps the cells’ values.
Plans
- Free: 2 setups per Google account, each on its first 20 rows and two levels. Removing and refreshing dropdowns are always free.
- ListFill Pro: $9 once per Google account: every row, up to five levels, and clearing. No subscription or renewal. Refunds within 14 days. See the terms.
Open it from Extensions > ListFill in any spreadsheet.
Add-on will not open or uses the wrong Google account?
Google Sheets™ is a trademark of Google LLC. ListFill is not affiliated with Google.
Privacy policy · Terms of service · Support: spyridwn.pd@gmail.com