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

Question

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

Do you want the delimiter to be a special character or are you referring to the characters in the data? — Raystafarian, Apr 08 '14 at 17:00
I want to export the excel to a text file with tab delimiter. And I want to extract the special characters on the new file. I dont know if i explain clear? — TrueBlue10, Apr 09 '14 at 08:31

score 2 · Answer 1 · edited May 23 '17 at 12:32

2

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

edited May 23 '17 at 12:32

Community

answered Apr 23 '14 at 00:02

pcantalupo

score 1 · Accepted Answer · answered Jul 07 '14 at 13:33

1

The best way to do it is to save the file as an Unicode text file. And save as the unicode text file, change the encoding to utf-8

answered Jul 07 '14 at 13:33

TrueBlue10

score 1 · Answer 3 · answered Feb 11 '16 at 12:09

1

Save it as Unicode text file. It will still save as Tab Delimited and preserve all the versatile non-English characters.

answered Feb 11 '16 at 12:09

Chamil

Isn't this a rephrase of the accepted answer of @TrueBlue10? – Philip Bijker Feb 11 '16 at 12:35

3 Answers3