Excel to CSV and back: data workflows that do not break

Excel and CSV look interchangeable until a comma inside an address field shifts every column, or a UTF-8 export garbles Chinese characters in your CRM. Browser-based Excel to CSV and CSV to Excel tools handle everyday exports locally — this guide covers workflows that keep your data intact.

When to export Excel as CSV

Use CSV when another system expects plain text rows: databases, Python scripts, mail-merge tools, or government portals. CSV drops formulas, charts, and multiple sheets — only values from the active sheet export.

Keep the original .xlsx as your working file. Treat CSV as a snapshot for transfer, not long-term storage of complex models.

Excel to CSV: what gets lost

Formulas become their calculated values. Formatting, conditional rules, and macros disappear. Hidden rows and filtered views may still export depending on the tool — review before sending.

Multiple sheets require separate exports. Name files clearly (sales-q1.csv, sales-q2.csv) so imports do not overwrite each other.

Encoding and international characters

Always prefer UTF-8 CSV when your data includes accents, CJK characters, or emoji. Legacy Windows tools sometimes expect Latin-1 — if an import shows mojibake, try re-exporting with UTF-8 or open in Excel and Save As with explicit encoding.

Our Text Encoding tool can help inspect and convert between encodings when a vendor sends a mislabeled file.

CSV to Excel: wrapping data for humans

CSV to Excel creates an .xlsx wrapper so you can filter, sort, and chart without a text editor. Column types may all arrive as text — convert numbers and dates in Excel after import.

Large CSV files (millions of rows) may choke browsers. Split files or use desktop tools for big data; browser converters target typical office sizes under a few thousand rows.

JSON and CSV round trips

APIs often return JSON arrays; analysts want spreadsheets. JSON to CSV flattens nested objects into columns — review headers because deep nesting may produce wide sparse tables.

CSV to JSON is useful before feeding data to JavaScript apps or config files. For recurring pipelines, automate with scripts — browser tools excel at one-off exports from emailed attachments.

Import troubleshooting

If import fails: check encoding (UTF-8), verify column count matches headers, and open CSV in a text editor to spot stray commas inside unquoted fields.

Excel may auto-convert long numeric IDs to scientific notation — import columns as text when precision matters.