For Dropdown and Selection blocks with long option lists, you can import all the options at once from a CSV file instead of adding them one by one. This article covers the file format and how the import works.
When to use it
Any time you have more than a handful of options, a CSV is faster than typing each one. It's also the way to set up cascading dropdowns, since the CSV can carry the filter key that links child options to a parent.
CSV format
Your CSV needs a header row. The recognized columns are:
- label — the text the visitor sees. Required.
- value — the number sent to the spreadsheet when the option is chosen. Required.
- filterKey — (cascading dropdowns only) the parent value this option belongs to. Optional; include it only when building a dependent dropdown.
A simple example:
label,value
Small,10
Medium,20
Large,30
And for a cascading child dropdown:
label,value,filterKey
Austin,1,USA
Dallas,2,USA
Toronto,3,Canada
Importing
- Open the block's settings and find the Options group.
- Click Table View to open the options table.
- Click Import CSV and choose your file.
The imported options are added to the existing list (they don't replace what's already there). Empty rows are skipped automatically. Once imported, each option appears in the table where you can still edit its label, value, image, or filter key.
Tips
- Keep labels short — long labels can wrap awkwardly on option cards.
- If you're importing for a cascading dropdown, make sure every row has a
filterKeythat matches a parent value exactly. See Cascading (dependent) dropdowns.