Excel exported UTF-16 CSV Playbook

Excel exported UTF-16 CSV. Practical troubleshooting runbook for repeatable fixes and safer conversions.

TL;DR: Validate -> locate exact failing spot -> fix the minimal part -> re-validate.

Execution steps

  1. Validate input locally. Start with a validator or parser-friendly converter.
  2. Locate root cause. Use line/position/error token to isolate one failing place.
  3. Apply a minimal fix. Do not refactor all content at once.
  4. Re-validate and continue. Once clean, convert/export safely.

Recommended tools

Relevant guides

Auto-selected from existing guides for this topic. Need more: search by keyword.

Guides by topic

Browse troubleshooting and conversion guides grouped by topic (JSON, CSV, XML, YAML, encoding, config formats, privacy).

Convert UTF‑16 CSV exports (no upload)

Some Excel exports use UTF‑16. Learn the symptoms, how to re-export as UTF‑8, and how to convert without uploads.

Encoding issues in CSV/JSON: UTF‑8, BOM, and weird characters

Fix encoding issues like UTF‑8 BOM, strange header characters, and broken symbols in CSV/JSON. Convert locally and validate output (no upload).

CSV export from Excel: why formats differ (and what to do)

Excel CSV exports vary by locale (comma vs semicolon) and quoting rules. Learn what changes and how to convert safely to JSON locally (no upload).

wrong number of fields: what it means and how to fix it

Fix CSV parser error (wrong number of fields): delimiter/quotes/row mismatches cause shifted columns. Find the broken row and validate locally (no upload).

bare " in non-quoted-field: what it means and how to fix it

Fix CSV parser error (bare " in non-quoted-field): delimiter/quotes/row mismatches cause shifted columns. Find the broken row and validate locally (no upload).

Preserve leading zeros when converting CSV/JSON (no upload)

How to preserve leading zeros (IDs, zip codes) when moving between CSV, JSON, and Excel—without uploading your data.

Avoid scientific notation issues (no upload)

Excel may convert large numbers to scientific notation. Preserve exact strings and validate locally.

Related actions

Related playbooks

Related by intent

Expert signal

Expert note: Excel exported UTF-16 CSV usually resolves fastest when triage starts from strict validation and then branches to comparison/alternative paths based on input quality.

Data snapshot 2026

MetricValue
Intent confidence score90/100
Predicted CTR uplift potential22%
Target crawl depth< 3 clicks

Trust note: All processing happens locally in your browser. Files are never uploaded.

Privacy & Security
All processing happens locally in your browser. Files are never uploaded.