Share via

Save as CSV with UTF-8 encoding

Anonymous
2018-11-22T05:35:02+00:00

Hello,

How do I save the Excel workbook to a CSV with UTF-8 encoding? 

I try playing around and selecting UTF-8 in the Encoding tap of the "web option" from the "tools" dropdown menu in the save as dialog but the CJK character still shows up as ?????? in the saved CSV file.

Is saving as UTF-8 is a thing for Excel 365 in 2018?? I see people over on stackoverflow complaining and advise the programmer to just use Libre office for this job.

Thanks

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Vijay A. Verma 104.7K Reputation points Volunteer Moderator
    2018-11-22T05:39:04+00:00

    When you do save as, you have CSV UTF-8 as one of the formats. Does it work for you?

    1 person found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-11-22T05:47:11+00:00

    hmm, some how I didn't see that. Maybe grouping the CSV option together and try to clean it up a bit might help.

    Thanks

    0 comments
  2. Vijay A. Verma 104.7K Reputation points Volunteer Moderator
    2018-11-23T07:53:55+00:00

    Just wanted to follow up to know if the problem is resolved. Do you need further assistance?

    0 comments