CSV and Excel (.xlsx) files both store tabular data, and both open in spreadsheet applications — so people often treat them as interchangeable. They are not. The difference matters every time you import, export or share data.
The core difference
CSV is plain text. It stores only values, separated by commas, with no styling, formulas, multiple sheets or metadata. Any program on any operating system can read it.
Excel (.xlsx) is a structured document format. It stores values plus formulas, cell formatting, multiple worksheets, charts, merged cells and more, inside a compressed XML structure.
Practical differences
| Aspect | CSV | Excel (.xlsx) |
|---|---|---|
| Content | Values only | Values, formulas, formatting, charts, multiple sheets |
| Compatibility | Opens anywhere — text editors, any language, any platform | Needs a compatible application or library |
| File size | Small (plain text) | Larger (compressed XML) |
| Data integrity on round-trip | Stable — what you save is what you get | Auto-formatting can alter data (dates, leading zeros, long numbers) |
| Formulas and styling | Not supported | Fully supported |
| Typical role | Exchange and import/export format | Working and analysis format |
When to use Excel
- You are actively working with data: sorting, pivoting, charting, calculating.
- You need formulas that update when values change.
- You need multiple related sheets in one file.
- Human presentation matters — colors, formatting, comments.
When to use CSV
- You are moving data between systems — imports, exports, migrations.
- The file will be processed by a script or program.
- You need a format that will still open in ten years regardless of software.
- You want the smallest, simplest possible file.
The round-trip trap
The most common workflow is: export a CSV, open it in Excel to check it, re-save it — and break it. Excel quietly reformats values on open and save: SKUs lose leading zeros, dates get rewritten to your locale's format, long numbers become scientific notation. If you must inspect a CSV in Excel, treat it as read-only and re-export from the original source instead of saving over it.
Converting between them
Converting Excel → CSV is built into every spreadsheet application (Save As / Download as CSV). Going the other way, opening a CSV in Excel works but triggers the auto-formatting above. For product data — where SKUs, prices and variant structures matter — a tool that parses CSV properly without spreadsheet side effects is the safer path. CSV Pilot reads CSV directly and lets you review and export without the round-trip corruption risk.