Data Formats
CSV vs Excel (XLSX): What’s the Difference?
CSV is delimited plain text. XLSX is a structured workbook format that can hold sheets, formulas, formatting, charts and richer cell metadata.
Published
CSV and XLSX are different kinds of files
| Feature | CSV | XLSX |
|---|---|---|
| Storage | Delimited plain text | ZIP-based workbook package |
| Sheets | One table per file | Multiple worksheets |
| Formulas/styles | Not preserved as workbook features | Supported |
| Interoperability | Very broad | Requires workbook-aware software |
Multiple sheets, formulas and formatting
CSV stores field text only. Worksheet names, formulas, styles, merged cells, charts and workbook settings require a workbook format such as XLSX.
Data types and spreadsheet interpretation
Spreadsheet software may interpret CSV fields as dates, numbers or formulas. Identifiers with leading zeros and formula-like text need careful import/export handling.
When to use CSV or XLSX
- Use CSV for pipelines, database exchange and simple exports.
- Use XLSX for human-facing workbooks with calculations or presentation.
- Keep a canonical typed source when repeated round trips could alter data.
JSON → CSV → spreadsheet workflow
Convert structured records to CSV, inspect quoting and columns, then import the file with explicit delimiter, encoding and type settings. Save as XLSX only when workbook features are required.
Try the example
Inspect spreadsheet-sensitive CSV values
Leading-zero identifiers, commas and embedded newlines reveal important import choices.
sku 00123 · note A, B · embedded newlineExpected result: The CSV is correctly quoted, while the guide explains that spreadsheet type interpretation happens after import.
Prepare interoperable data
Generate a clean CSV
Convert structured records to CSV and review values before opening them in spreadsheet software.