Problems · Conversion surprises
Why Is My CSV Opening Wrong in Excel?
“Broken CSV” is usually Excel auto-detect, not a corrupt file. Structured workbooks belong in XLSX.
Problem: CSV columns merge, dates shift, or leading zeros disappear in Excel.
Solution: Convert CSV → XLSX for Excel, or import via Data → From Text/CSV with the correct delimiter and UTF-8. Keep CSV for systems that require it.
Separators & locales
Commas vs semicolons differ by region — Excel may smash columns.
Type guessing
Leading zeros in IDs become numbers; long IDs become scientific notation.
Encoding
UTF-8 CSVs can mojibake if Excel assumes ANSI — import explicitly.
Fix it in three steps
- Convert CSV → XLSX. Use the CSV to Excel converter for a proper workbook.
- Or import carefully. In Excel, use From Text/CSV and set delimiter + UTF-8.
- Validate IDs. Check columns that need leading zeros.
Open the relevant converter
Convert privately in your browser — nothing is uploaded to a remote queue.
Related tools & guides
Related problems
FAQ
Why is my CSV opening wrong in Excel?
Excel guesses CSV separators and cell types, which can merge columns or drop leading zeros. Convert CSV to XLSX for Excel work, or import with explicit UTF-8 and delimiter settings.
Is CSV bad?
No — it’s great for interchange. Use XLSX when humans need formatting, multiple sheets, or typed columns.
Why this works locally
- No third-party converter queue — processing stays in this browser
- Convert a delivery copy — keep your master
- Same privacy-first engine as the rest of Format Convertly
Browse all guides, converters, or how to open.