💻 Software
How to set character encoding when opening a CSV file in Excel?
Fresh5 days ago
Mar 15, 2026555788 viewsConfidence Score1%
1%
Problem
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.
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: How to set character encoding when opening a CSV file in Excel?
Low Risk
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.
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix