Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

How to add dropdown in CSV file.

Copper Contributor

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_0-1644989762811.png

 

 

 

4 Replies

@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.
Thank you, I will try that