There is an option in Excel 2016 to export as a UTF-8 comma delimited CSV file. I don't want commas between fields- i want tabs.
I save the file as a tab-delimited txt file. In the Save As dialogue, I go to "Tools" then "Web Options" then "Encoding" and choose UTF-8. Then I open it with Sublime Text 3- the IDE I use to write python scripts to manipulate the file (It's too big to open in Notepad).
It's a large file with around 200,000 Russian sentences along with translations. The other text looks fine, but the Russian characters all show up as ???? ????. Completely useless.
The comma delimited CSV works perfectly. Is there just no way to successfully save a tab-delimited UTF-8 CSV file in Excel?