Excel to Tab delimited (.txt) file with special character

excel utf-8 excel-2010 office-2010 export-to-text
TrueBlue10 picture TrueBlue10 · Apr 8, 2014 · Viewed 12k times · Source

I want to export Excel to Tab delimited (.txt) file with special character.

I've changethe format to UTF-8, but it still doesnt work.

The origin data is like Mädchen and what i got is M?dchen

Anyone can help me? Thank you

Answer

pcantalupo picture pcantalupo · Apr 23, 2014

This was similarly asked and answered before: Excel to CSV with UTF8 encoding. Take a look at Eric's answer.

Related questions

Excel to CSV with UTF8 encoding

I have an Excel file that has some Spanish characters (tildes, etc.) that I need to convert to a CSV file to use as an import file. However, when I do Save As CSV it mangles the "special" Spanish characters …

Read More
Is it possible to force Excel recognize UTF-8 CSV files automatically?

I'm developing a part of an application that's responsible for exporting some data into CSV files. The application always uses UTF-8 because of its multilingual nature at all levels. But opening such CSV files (containing e.g. diacritics, cyrillic letters, …

Read More
How to parse UTF-8 characters in Excel files using POI

I have been using POI to parse XLS and XLSX files successfully. However, I am unable to correctly extract special characters, such as UTF-8 encoded characters like Chinese or Japanese, from an Excel spreadsheet. I have figured out how to …

Read More