Format Conversion
XLSX Data Validation Dropdown
Batch-create dropdowns, dependent cascading dropdowns, and input prompts in Excel workbooks using data validation rules
file· File resultOpen tool
Quick start
Call this tool from your code in three languages.
cURL
# 1) Request a presigned URL → returns { uploadUrl, storageKey }
curl -X POST 'https://api.elysiatools.com/api/upload/presign/xlsx-data-validation-dropdown' \
-H 'Content-Type: application/json' \
-d '{"filename":"workbookFile.ext","contentType":"application/octet-stream","size":12345}'
# 2) PUT the file bytes directly to the presigned uploadUrl
curl -X PUT '<presigned uploadUrl>' \
--data-binary @/path/to/file.ext
# 3) Call the tool, passing the returned storageKey for each file field
curl -X POST 'https://api.elysiatools.com/en/api/tools/xlsx-data-validation-dropdown' \
-F 'workbookFile=uploads/2026/01/01/your-tool-1700000000000-abc123.ext' \
-F 'rulesJson=[
{
"type": "list",
"sheetName": "Input",
"target": "B2:B50",
"values": [
"Open",
"Pending",
"Closed"
],
"promptTitle": "Status",
"prompt": "Choose a workflow status"
},
{
"type": "cascade",
"sheetName": "Input",
"parentTarget": "C2:C50",
"childTarget": "D2:D50",
"mapping": {
"Hardware": [
"Laptop",
"Monitor",
"Keyboard"
],
"Software": [
"CRM",
"ERP",
"Analytics"
]
},
"parentPromptTitle": "Category",
"parentPrompt": "Choose a category first",
"childPromptTitle": "Item",
"childPrompt": "Then choose an item"
}
]'