Save Delimited Data with CSV file extension
Thu, 07/12/2018 - 03:27 pm
I would like to save data with the .CSV file extension for latter loading into Excel (client request - don't understand why).
If I try to save a delimited file I am forced to use .txt file extension. The issue is Excel does not understand that .txt is a csv file and loads it as general text not columns of data. If I change the file extension to .csv then Excel recognizes it properly.
How do I avoid the extra step of having to manually rename the file?