0

I have a CSV file with German words in its entries. Here's an excerpt:

enter image description here

As one can see, a number, a number of entries contain words with German words that contain characters that are depicted somewhat oddly. For instance, in C10 we see a “square root” symbol. Something similar happens in B6 and C5.

Here's the xlsx and the csv files.

Question: how can I change the format of these letters in such a way that the correct (German) characters are depicted? If this is impossible, I would also be content with characters without accents (e.g., O instead of Ö).

Max Lonysa Muller
  • 139

1 Answers1

1

You need to set the character encoding of the file being imported. You can keep trying different encodings until you find one that works. Try UTF-8 first.

The easiest is to use import "from text" on the data ribbon.

Also see this post: How to set character encoding when opening Excel

ExcelEverything
  • 3,194