WorkVellWorkVell
Troubleshooting·Support CodeTS-003

Fixing Garbled Text When Opening CSV in Excel

WorkVell exports CSVs in UTF-8, which can cause garbled text in Excel. Here's how to fix it.

[Why it happens]

WorkVell exports in UTF-8, but Excel defaults to Shift-JIS on Windows, causing garbled characters.

[Fix ① (Windows Excel)]

  1. 1.Open Excel
  2. 2.Data tab → From Text/CSV
  3. 3.Select the file
  4. 4.Set encoding to 65001 (UTF-8)
  5. 5.Set delimiter to Comma
  6. 6.Load

[Fix ② Export with BOM]

Select "UTF-8 with BOM" in the export dialog (if available) so Excel auto-detects encoding.

[Mac]

Mac Excel usually handles UTF-8 correctly. If garbled, check the encoding option in the formula bar.

[Google Sheets alternative]

Upload the CSV to Google Drive and open with Google Sheets — no encoding issues.

fixinggarbledtextopeningcsvexcel

Was this article helpful?

More in this category

People also viewed