CODEWITHSUNDEEP
exceltextimportutf-8emoji
LDG
LDG

Reputation: 41

import text with emojis in excel

I have a lot of txt-files containing text with emojis and other "special" characters (such as é, à, ç...), as well as some Japanese, Hebrew, Cyrillic... in it (encoding is UTF-8). The files always contain multiple texts and metadata about the texts separated by "/". I need to import these files into Excel, have it separated in different rows and columns and then save the document as a CSV-file as well. I have no problem importing and sorting my data in Excel, but the problem is that all of my "special" characters are changed to question marks and I really need them to stay as they are. Does anyone know how to solve this problem? Thank you!

edit: my greeting at the beginning keeps disappearing, sorry!

Upvotes: 0

Views: 3002

Answers (1)

PaichengWu
PaichengWu

Reputation: 2689

Please try the steps:

  1. In Excel, click Data tab and click From Text.
  2. Select your file in dialog.
  3. In wizard, select your encoding.

Upvotes: 2

Related Questions