create dropdown in exported csv file in Javascript

Question

I am exporting CSV file in Reactjs where I need to create dropdown in generated CSV file

I tried excel.js and shell.js as well as csvlink download

<CSVLink data={data}>Download me</CSVLink>;

it showing normal csv with key value pair

Maciej Trojniarz · Accepted Answer · 2019-09-18 08:14:48Z

0

CSV file doesn't allow to use anything like dropdown. If you want a dropdown you need to use spreadsheet format.

Spreadsheets allows to have data validation:

answered Sep 12, 2019 at 7:07

Maciej Trojniarz

7325 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

is it possible in spredsheet to add dropdown

@shweta spreadsheets allows to have data validation. I'm not sure if you can code it that way with any library (possible can) but: support.google.com/docs/answer/… techrepublic.com/blog/microsoft-office/…