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.

How to Copy Delimited Text to Excel. If you have data in delimited text files from other programs that you need to get into an Excel workbook, you can use the import wizard to import delimited ...

Learn how to import or export data from a Text file to convert a Text (.txt or .csv) file into an Excel (.xlsx) spreadsheet easily using this procedure.