How to set character encoding when opening a CSV file in Excel?

Is it possible to set the default encoding for Excel (any version, e.g. 2010) when opening files like csv files (like you can in Open Office Calc)?

I When I try to open a csv file encoded in Japanese SHIFT-JIS, it opens but with mojibake (corrupted characters). In Open Office Calc, if you click on a csv file with a non-standard encoding like SHIFT-JIS, it automatically opens a dialog where you can set the encoding.

Solution 1:

Use the import function under "Data" tab where Excel allows us to specify the encoding. Select "from text" and choose your csv file then Select Japanese shift-jis encoding.

Solution 2:

The following steps work with Office 2003.

1. Rename .csv to .txt
2. Open .txt file from Excel (don't do it with right click on file then open with Excel), Excel will open a Text Import Wizard dialog, ask ask for the format of .txt file, including character encoding of text file.
3. Rename .txt back to .csv after your edit is finished.

Solution 3:

On Excel 2016 for Mac:

1. create blank worksheet,
2. in main menu go to Data -> Get External Data -> Import Text File,
3. follow steps in wizard - choose the encoding until you will see the correct preview and on the next step choose columns delimiter (delimiters differ from csv to csv files).

Solution 4:

See if this helps (MS Excel 2007 and above).

1. Open Excel and click the Microsoft Orb at the top and then click on Excel Options.

2. Go to Advanced, and then look for the Web Options button. It should be under General.

3. Go to the Encoding tab and pick Japanese Shift-JIS from the drop-down menu. Click Ok, restart Excel and try to open your file.