EXCEL: EXPORT .CSV FILE WITH JAPANESE CHARACTER

  • AUTHOR: // CATEGORY: Development, IT, PC, Windows

    No Comments

     

    To fully retain the characters while saving it on a CSV format and to somehow be able to import/re-use the data in the future.

    You can follow these steps.

    1. In Microsoft Excel, open the *.xlsx file.
    2. Select Menu | Save As.
    3. Enter any name for your file.
    4. Under “Save as type,” select Unicode Text.
    5. Click Save.
    6. Open your saved file in Microsoft Notepad.
    7. Replace all tab characters with commas (“,”).
    • Select a tab character (select and copy the space between two column headers)
    • Open the “Find and Replace” window (Press Ctrl+H) and replace all tab characters with comma .

    Replace Tabs with commas in Notepad

    1. Click Save As.
    2. Name the file, and change the Encoding: to UTF-8.
    3. Change the file extension from .txt to .csv.
    4. Click Save.
    5. Open the .csv file in Excel to view your data.

    Credit:

    https://stackoverflow.com/questions/24087432  /excel-xlsx-file-saving-as-csv-file-korean-and-japanese-cracking-badly

COMMENTS

0 Responses to Excel: Export .csv file with Japanese character

LEAVE A REPLY