I am using Microsoft Excel to work with tab delimited files. Although I can import tsv files without an issue, I can't save them with the TSV extension. Instead, I have to
1. Import the TSV file into Excel 2. Make my changes 3. Save the changed file as .txt 4. Delete the original .tsv file 5. Rename the .txt file as .tsv
Is there a way to force Excel to save as .tsv file directly?
I am using Excel 16.16 running on Mac OS El Capitan 10.11.6
EDIT: While I was unable to use "Save as" to save as a TSV file, using the default save function keeps the TSV extension.