How to add dropdown in CSV file.

[rahul_oberoi]

Hi Experts, 

Kindly help us to understand if we can add a dropdown in CSV file like we did in excel as mentioned screenshot. 

[#2]

@rahul_oberoi Adding a dropdown to an Excel file (.xlsx) is no problem, but your question relates to a CSV file. Such a file contains text only. Bits and pieces separated by commas. When you open such a file in Excel, all the pieces get placed on the Excel grid. You could then add the dropdown, but if you save the file as a CSV, all that functionality is removed and you end up with a text file again where the content of individual cells are stringed together and separated by commas.

So what is it that you really want to achieve?

[#3]

I have the same problem, I create a dropdown list in a .csv file then it disappears next time I open it, is there a way around this?

[#4]

Save the .csv as an .xlsx.

[#5]

Thank you, I will try that