I'm having trouble reading fields in Chinese when importing a csv data file to ArcMap. I imported the file by using 'add data' option in the tools section. I'm confused because some csvs work while some do not, meaning for some csvs the characters are clearly read in ArcMap while for the other csv all of them are garbled.

These files were all edited in R and Python and they were encoded as utf-8. They both do not get garbled characters when read in R, so I'm not sure why ArcMap would not display them correctly.

The garbled attribute table looks like this:

enter image description here

I tried turning the csv file to xlsx format and then tried importing it in ArcMap but I could not import the file. I'm using ArcMap 10.5.

Could it also have to do with long texts like one in the image? I have long descriptions of each data points (around 500+).

  • Please edit your question to describe how you imported the csv data into ArcMap.
    – Midavalo
    May 26, 2017 at 19:50
  • @Midavalo Amended.
    – halo09876
    May 27, 2017 at 6:43
  • Excel toolset may help.
    – Kazuhito
    May 28, 2017 at 11:23


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.