Forum Discussion
How to add dropdown in CSV file.
Hi Experts,
Kindly help us to understand if we can add a dropdown in CSV file like we did in excel as mentioned screenshot.
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?
- 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?
- Save the .csv as an .xlsx.
