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 Ö).

Improve this question
7
  • 1
    can you create a small example csv file that demonstrates the problem, edit the post to include a link to it. This way we can test different approaches.
    – Scott Craner
    Dec 2, 2020 at 21:19
  • Access denied on the link.
    – Scott Craner
    Dec 2, 2020 at 21:33
  • @ScottCraner I'm now entirely how to add an example csv in the post. I've put a link to a public google document in the question instead, is that okay too?
    – Max Muller
    Dec 2, 2020 at 21:33
  • @ScottCraner Better now?
    – Max Muller
    Dec 2, 2020 at 21:35
  • 1
    I want the csv, not the xlsx file.
    – Scott Craner
    Dec 2, 2020 at 21:36

1 Answer 1

Reset to default
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

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .