3

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.

1
  • As already answered, Excel can't do that. You may use a macro to save your file, delete previous version, than rename it. – Máté Juhász Sep 20 '18 at 4:39
3

You cannot using the default capabilities of Excel.

The "correct" method for Excel is to save as a Tab Separated Value (.txt) and then rename the extension, which appears to be what you're currently doing.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.