Instead use Data > Import External Data > Import Data. This will invoke the Text Import Wizard, which lets you choose the delimiter. Or, if you're using the newer interface, go to the Data tab > From Text: This will pull up a File Open dialog, followed by the same Text Import dialog.
Import Wizard Import any text file into Access, Excel or ODBC databases Import Wizard enables you to easily import text based report files into MS-Access, Excel, MS-SQL Server, MSDE, MySQL, or other databases.
Active2 years, 9 months ago
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.
lozzer
Microsoft quietly replaced the comfortable Text Import Wizard from Excel and replaced it with the “Get & Transform” tools. The “Get & Transform” tools offer a lot of options and are very powerful.
lozzerlozzer
5 Answers
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.
prpprp
The following steps work with Office 2003.
Rename .csv to .txt
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.
Rename .txt back to .csv after your edit is finished.
in main menu go to Data ->Get External Data ->Import Text File,
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).
DaddyMDaddyM
Microsoft Excel Text Import Wizard
See if this helps (MS Excel 2007 and above). Free text editor for mac.
Open Excel and click the MicrosoftOrb at the top and then click onExcel Options.
Go to Advanced, and then lookfor the Web Options button. Itshould be under General.
Go to the Encoding tab and pickJapanese Shift-JIS from the drop-down menu. Click Ok,restart Excel and try to open yourfile.
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 clickWe have a multi-language environment (En-Jp).
Text Import Wizard Delimited
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.
Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count). Would you like to answer one of these unanswered questions instead?
Excel Text Import Wizard For Large Files
Not the answer you're looking for? Browse other questions tagged microsoft-excelcsvcharacter-encodingcharactersshift-jis or ask your own question.