How to Fix CSV Character Encoding Issues | One-Click Encoding Converter

Opened a CSV file in Excel only to find garbled characters everywhere? The root cause is a mismatch in character encoding. This guide explains why CSV encoding problems happen and how to fix them.

Why CSV Files Display Garbled Text

What Is Character Encoding?

Character encoding is the set of rules a computer uses to convert characters into numeric values. The same character "あ" is represented differently in UTF-8 and Shift_JIS. When the software reading a CSV uses a different encoding than the one used to create it, the characters cannot be decoded correctly — resulting in garbled text.

Common Encoding Problems

UTF-8 vs. Shift_JIS

How to Fix CSV Encoding Issues

Method 1: Use an Encoding Converter (Easiest)

1. Upload your CSV file to sakutto's CSV Encoding Converter
2. The current encoding is automatically detected
3. Select the target encoding (Shift_JIS or UTF-8)
4. Click "Convert" and download

The file is processed entirely in your browser — nothing is sent to a server. This makes it safe for CSVs containing confidential or personal data.

Method 2: Use Excel's "Get Data" Feature

You can specify the character encoding directly when importing a CSV into Excel.

1. Open Excel and go to the "Data" tab → "From Text/CSV"
2. Select the target CSV file
3. In the "File Origin" dropdown, change the encoding to "65001: Unicode (UTF-8)"
4. Confirm the garbled text is resolved in the preview, then click "Load"

Method 3: Convert Encoding with Notepad (Windows)

Convert character encoding using Notepad on Windows 11/10.

1. Right-click the CSV file → "Open with" → "Notepad"
2. Confirm the text displays correctly (Notepad handles UTF-8 properly)
3. Go to "File" → "Save As"
4. Change the "Encoding" dropdown to "ANSI" (= Shift_JIS) and save
5. Open the saved CSV in Excel

Method 4: Convert on Mac with TextEdit

1. Open the CSV file in TextEdit
2. Go to "File" → "Save" → set "Plain Text Encoding" to "Japanese (Shift JIS)"
3. Open the saved file in Excel

How to Check a CSV File's Encoding

Knowing the current encoding before converting helps avoid guesswork.

Check with a Browser Tool

Upload the file to sakutto's CSV Viewer and the encoding will be automatically detected and displayed.

Check with Notepad (Windows)

1. Open the CSV file in Notepad
2. The encoding name (e.g., "UTF-8" or "ANSI") appears in the status bar at the bottom right

Check via Command Line

# Windows (PowerShell)
Get-Content sample.csv -Encoding Byte -TotalCount 3
# First 3 bytes EF BB BF = UTF-8 with BOM

# Mac / Linux
file -i sample.csv

Recommended Encoding by Use Case

Opening CSVs in Excel

Convert to Shift_JIS or UTF-8 with BOM. Excel on Windows does not correctly recognize BOM-less UTF-8, so converting to Shift_JIS is the most reliable approach.

Uploading to Web Services

Most web services accept UTF-8. If a Shift_JIS CSV causes an error on upload, convert it to UTF-8 first.

Reading in Code

Modern programming languages (Python, JavaScript, PHP) use UTF-8 as the standard. Stick with UTF-8 unless you have a specific reason not to.

Frequently Asked Questions (FAQ)

Can I batch-convert multiple CSV files at once?

Yes. sakutto's CSV Encoding Converter supports batch uploads — select all CSVs in a folder and drag them in to convert them all at once.

What is the difference between UTF-8 with BOM and without BOM?

A BOM (Byte Order Mark) is a 3-byte marker (EF BB BF) at the start of the file. Excel uses this marker to recognize the file as UTF-8. Without a BOM, Excel is likely to misinterpret the file as Shift_JIS and display garbled text. However, for programmatic use, BOM-less UTF-8 is generally preferred.

Are Shift_JIS and ANSI the same thing?

In Japanese Windows environments, "ANSI" refers to Shift_JIS (technically Windows-31J / CP932). When Notepad shows "ANSI" for a file, it means the file uses Shift_JIS encoding.

What if text is still garbled after conversion?

Platform-dependent characters (①, ②, ③, 髙, 﨑, etc.) may not be representable in Shift_JIS. In such cases, keep the file in UTF-8 or convert the CSV to Excel format (.xlsx). sakutto's CSV to Excel converter can help with this.

Is my file sent to a server?

No. sakutto's CSV Encoding Converter processes everything in your browser. Your files are never uploaded to any external server, making it safe for personal and confidential data.

Summary

Garbled text in CSV files is caused by a character encoding mismatch. When opening a UTF-8 CSV in Excel, converting it to Shift_JIS is the most reliable fix. With sakutto's CSV Encoding Converter, just upload the file and convert with one click — and your data never leaves your browser.