0

Let's say, I save a csv file from notepad/notepad++ with below text Ákos Illés

notepad++

Then, after opening the same in excel sheet, it is showing as below. Ãkos Illés

excel application

Can anyone please suggest how to load this csv in excel properly.

I tried the steps in this link, but it is converting the csv to excel(.xlsx) format, but we need it in csv only.

Improve this question

1 Answer 1

Reset to default
1

The document encoding may be UTF8. Windows needs UTF8 with byte order mark (BOM) at the beginning, or it may not be able to detect the encoding. Alternatively, use the data import wizard and specify the encoding (CP 65001 UTF8)

Improve this answer
1
  • That is mentioned in the link I provided in the question. But it converts to xlsx,not csv file.
    – Sara June
    Commented Jan 6, 2022 at 2:08

You must log in to answer this question.

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