CSV vs XLSX: Which File Should You Send or Upload?
Send CSV when the receiving system requires a plain data table. Send XLSX when the recipient needs a workbook’s sheets, formatting and spreadsheet features. Keep the original workbook, then create the export the recipient actually needs. Changing the filename extension is not the same as converting the file.
CSV is a data handoff, not a workbook replacement
Microsoft’s format guidance explains that CSV exports the active worksheet’s displayed text and values; workbook formatting and features do not carry across as they do in XLSX. A CSV should therefore be treated as a particular table export rather than an equivalent copy of a multi-sheet working file.
Imagine a workbook with a data sheet, a calculation sheet and a chart. A portal requesting the data table does not necessarily want the entire workbook. A colleague reviewing how a result was calculated may need the workbook instead. Ask what the recipient will do with the file before choosing.
Choose by the receiving task
| Task | Format to consider | Check before sending |
|---|---|---|
| Upload rows to a system requesting CSV | CSV | Required columns and accepted encoding |
| Review a workbook’s formulas and multiple sheets | XLSX | Included sheets and working calculations |
| Share a fixed visual report | A suitable report export | Layout and whether editable data is also needed |
The receiving system’s instructions take priority over a general preference. Some uploads require exact column names, ordering or date conventions. A well-formatted spreadsheet can still be rejected if its exported fields do not match that specification.
Export deliberately and reopen the result
Work from a copy or keep the original saved before exporting. Select the intended sheet, confirm its headers, and remove unrelated rows from the export dataset when necessary. Filtering a working display and preparing an approved export are separate tasks.
After saving the export, check it against a small expected sample. Reopening a CSV in a spreadsheet application can reinterpret values, so compare the source strings as well as the displayed cells. Pay attention to dates, leading-zero identifiers and text containing punctuation.
- Confirm the exported row count.
- Inspect the first and last records.
- Check blank fields and special characters.
- Test representative identifiers.
- Confirm that the receiving tool reads the intended columns.
Keep the master and the handoff distinct
Use filenames that distinguish the working workbook from the export. For example, “requests-working.xlsx” and “requests-upload.csv” explain their roles. Include a date when it helps identify the snapshot, without suggesting the export is continuously updated.
Tell the recipient what is included and what is not. “This CSV contains the approved request table” is clearer than “Here is the spreadsheet” when the original has several sheets.
Before exporting numeric-looking codes, use our guide to keeping leading zeros in Excel. For collaboration on the underlying data, read Google Sheets filters versus filter views.
