Excel cannot display UTF8 Data

Alice Tan 1 Reputation point
2022-11-25T04:00:25.017+00:00

Hi,

When i export some data in UTF8 format from a third-party software to excel.
It cannot display the UTF8 data(for example Vietnamese font) , but in third party software is no issue.
I had tested to set the language to Vietnamese it also cannot show the data.

May i know that is there any way we can change the encoding for the data after the data already display in excel? (we know that if manually import the file, we can set the encoding)

Environment: Win10 Pro Eng, installed with English and Vietnamese language

Standards and formats: English(US)

Encoding of source data : UTF8

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,715 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,689 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Dillon Silzer 56,521 Reputation points
    2022-11-25T05:27:13.723+00:00

    Hi @Alice Tan

    Please see the following post for importing UTF8 to Excel (answer by Jazlyn Xu MSFT):

    https://answers.microsoft.com/en-us/msoffice/forum/all/how-to-open-utf-8-csv-file-in-excel-without-mis/1eb15700-d235-441e-8b99-db10fafff3c2

    ----------------------------------

    If this is helpful please accept answer.