I am trying to import a csv file in Indesign using data merge. This csv file contains both Korean and English and I saved it via google spreadsheet. The file is encoded in Unicode format.
Whenever I try to import it, all the Korean texts are broken and a bunch of Chinese and Japanese characters along with question marks replace the texts.
I know that some fonts do not support Korean and that the texts appear broken when you type them in without using the right font. In this case it works when you change the font. However, the imported csv file would remain broken even if I change the font.
I have tried changing the language settings in adobe creative cloud to korean & reinstalled indesign, and also tried opening it in textedit to save it as a txt file but none of it has worked.