Select the UTF file, and then click "Open" to launch the Text Import Wizard. Change the "File Origin" setting to "65001: Unicode (UTF-8)." Follow the directions of the wizard to define your text ...

Japanese characters often become garbled when you work with CSV or text files in Microsoft Excel. To avoid the problem, use the Unicode encoding option when importing the data into Excel.