Share via

Excel is not considering csv UTF-8-BOM file as UTF-8

Ani 0 Reputation points
2024-04-03T11:04:16.22+00:00

I have csv file in UTF-8-BOM format which I am trying to open with excel(2016) but it recognizes file as ANSII and not UTF-8. Is it problem connected with file or it is excel setup issue?

Microsoft 365 and Office Excel For business Windows

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff
    2024-04-04T01:36:06.87+00:00

    Hi,

    You can go to data- From Text option- you can select the File origin from list manually:

    User's image

    Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

    If the response is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.