Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

6
  • 3
    Does this answer your question? How to set character encoding when opening a CSV file in Excel?
    – Tetsujin
    Commented Aug 9, 2023 at 14:53
  • This is an automatically-generated file so it would be a hassle to manually do every time the procedure described. Thank you anyway for your suggestion.
    – dr_
    Commented Aug 9, 2023 at 14:56
  • 1
    Did you read all the answers, or just the first one?
    – Tetsujin
    Commented Aug 9, 2023 at 17:32
  • 1
    Your desired characterset is UTF-8. Excel currently is displaying the text with your local ANSI representation, so splitting up the multibyte chracters in two (or more) characters. The à is quite typical.
    – dodrg
    Commented Aug 9, 2023 at 17:58
  • 1
    There is no "setting" within excel to do this. You can write a re-usable procedure using Power Query or the Legacy import wizard to set the code page when you import the file. Or you can process the file before opening it in Excel to insert a BOM at the beginning of the file EF BB BF which will tell Excel it is UTF-8 encoding. There are examples of both on the stackoverflow forum. Commented Aug 12, 2023 at 23:28