Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question
    
Which version of Excel? –  paulmorriss May 9 '11 at 9:26
    
2003 or 2010 (I skipped 2007) –  lozzer May 10 '11 at 17:49

4 Answers 4

up vote 13 down vote accepted

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.

share|improve this answer
    
works perfectly for xl2007 and xl2010 –  SooDesuNe Apr 27 '12 at 15:05
    
Sorry, I didn't check back until now. The "Data"->"From Text" approach works fine with xl2007 and xl2010. Not obvious but it works. –  lozzer Apr 22 '13 at 17:22

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.
share|improve this answer

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.

share|improve this answer
1  
This didn't work. My system is a Japanese system and so SHIFT-JIS is already set here as the default. But, I have my default editing language set for English (with Japanese also added). If I set the default editing language to Japanese, then the SHIFT-JIS csv file will open correctly. But this is messy. What if the file was some other encoding (e.g. Korean, Chinese)? What I really need is a place to set the encoding of the file (like I can in Open Office Calc). –  lozzer May 10 '11 at 18:12

Lozzer provided great feedback in the small print: "If I set the default editing language to Japanese, then the SHIFT-JIS csv file will open correctly...."

I have spent hours looking for a solution on how to open Japanese CSV with one simple click We have a multi-language environment (En-Jp).

Even though Excel showed Japanese menus (based on the control panels language settings), the default editing setting in File > Options > Language > Choose Editing Language (Top area) remained English. Changing that to Japanese (obviously no issue for Japanese users) solved our problem.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.