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?
Excel: export csv file with japanese character
csvexportjapanesemicrosoft excel
Best Answer
You need to save the Excel spreadsheet as a Unicode Text file and then open the text file in Notepad and replace all tab characters with a comma.
In Excel, click the Office button in the top, left-hand corner, and then click Save As...
Choose a file name and select Unicode Text from the Save as type drop-down box.
Open the file you just saved in Notepad
Under the Edit menu, select Replace... (or press Ctrl+H)
In the Find what: field, paste a Tab character.
In the Replace with: field, enter a comma.
Click Replace All and then save the text file.