excel: export csv file with japanese character

Question

In my excel file, the Japanese character is shown correctly,
while when I export it as csv,
the character become question marks
How should I output so that the character can be shown correctly?

Solution 1

1. Download and install Unicode CSV Addin for excel.
2. Save the csv from the new "Unicode CSV" menu as shown in picture below.

Solution 2

The point is, you need to save the file as UTF-8 and NOT as ASCII. Try this:

• (1) Open an Excel file where you have the info (.xls, .xlsx)
• (2) In Excel, choose "CSV (Comma Delimited) (*.csv) as the file type and save as that type.
• (3) In NOTEPAD (found under "Programs" and then Accessories in Start menu), open the saved .csv file in Notepad
• (4) Then choose -> Save As..and at the bottom of the "save as" box, there is a select box labelled as "Encoding". Select UTF-8 (do NOT use ANSI or you lose all accents etc). After selecting UTF-8, then save the file to a slightly different file name from the original.