I do not think it is possible to create a dropdown list (Data Validation) direct from your csv File.

However what is possible is to import your application created csv list into a fixed tab and range in an existing excel sheet to which a validation can refer.
I have done this with a pivot table that refers to a range of information the user can import in an existing tab called importdata.