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:
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+).