is there any way to save a file in a csv format, but rename the extension when saving it to another 3 letters

[soundengineer]

Simply put
I have a device that saves tables in a standard csv format.....but it names them as a .etf

Wondering if there is a way to allow add a custom extension name to excel.... and tell it to to treat it as a csv......
and when I save it, to retain the .etf name(and not name it .csv)

so I could just open it in excel without having to rename it first and without having to rename it again when I save it



is this possible?

 

[shg]

Data > Import from text

 

[btorrean]

Hey @soundengineer,

@shg is correct. However, you may have to select the file type of "All Files (*.*)" from the dropdown above the Open button in the Open dialog box for your .etf file(s) to appear as openable. On my Excel 2013, the default open file types are ".prn, .txt, .csv". If I don't select "All Files", .etf files do not appear as openable.

After you select the file in the Open dialog box, you will be prompted to define how you want the file to be imported in several dialog boxes. If you would like a more streamlined approach, using VBA will probably be your best option.

Brian