Formatting and live formulas disappear because CSV is a plain-text table, not a complete Excel workbook. It can carry cell text and values, but not Excel’s styling, charts, multiple-sheet structure, or calculation behavior. Excel exports the active worksheet; formula cells normally become their displayed results, while formulas shown in the grid are converted to text.
Why Excel formatting disappears in a CSV
An XLSX workbook can store worksheet data alongside formatting and other workbook features. CSV stores rows and columns as text. It has no way to represent font choices, fills, borders, graphics, or the visual layout of an Excel sheet, so that presentation is lost when you save as CSV. Microsoft Support puts it plainly: “When you save a workbook in any of the text formats, all formatting will be removed.” Microsoft Support: Save a workbook to text format (.txt or .csv).
The underlying cell content may still be present, but its appearance is not. A value displayed with a particular number format, for example, should not be expected to retain that formatting in the CSV or look identical when another program opens it. The receiving application determines how it interprets and displays the text.
Does CSV keep Excel formulas?
No. A formula in Excel is an instruction the workbook’s calculation engine can recalculate. CSV does not store that calculation engine or a live formula relationship. In normal display mode, Excel exports the text and values shown in cells, so a formula cell ordinarily exports its displayed result rather than a working formula. If Excel is set to show formulas in cells instead of their results, Microsoft says those formulas are converted to text. That text will not recalculate in Excel as a formula when opened from the CSV. Microsoft Support: Excel formatting and features that are not transferred to other file formats.
Windows Errors? Fix Them Before They Spread
Repair common Windows errors and clear accumulated junk for a smoother, more stable PC - no reinstall needed.Free scan · no reinstallCrashes, No Sound, or Screen Glitches?
Random freezes, missing sound and display glitches usually trace back to one bad driver. Find and replace yours safely.Free scan · under a minuteWhy only one worksheet is in the CSV
CSV is a single flat table, not a multi-tab workbook. Excel saves the active worksheet to the CSV, so other sheets are not included in that file. Before exporting, select the sheet you intend to deliver. If several sheets are needed as CSV, save each one separately; if the recipient needs the whole workbook with its sheets and features, keep or send an XLSX copy. Microsoft’s guidance for saving text formats and its Mac file-format documentation describe the active-sheet limitation. Save a workbook to text format (.txt or .csv) · File formats supported in Excel for Mac.
What CSV does preserve—and what can vary
CSV is useful when another system needs plain tabular data. In Microsoft’s documented CSV behavior, columns are separated by commas, and a cell containing a comma is enclosed in double quotation marks. The format does not carry Excel’s visual styling, chart data, or workbook structure. Microsoft’s description of workbook formats explains the features that do not transfer, while its supported-format pages note that CSV options can vary by platform and version. Excel formatting and features that are not transferred to other file formats · File formats that are supported in Excel.
Do not assume every receiving application will interpret dates, leading zeros, or formatted numbers exactly as Excel displayed them. Formatting is removed, and applications may interpret imported text differently. Excel’s available CSV variants and encoding choices can also depend on platform and version; choose an export option that matches the destination’s requirements rather than assuming all CSV files behave identically.
Choose XLSX or CSV based on what the recipient needs
| Need | Better fit | Reason |
|---|---|---|
| Keep formulas available for recalculation, formatting, charts, or multiple worksheets | XLSX | XLSX supports workbook structure and features that a flat text file cannot represent. |
| Provide one worksheet as plain tabular data to another tool or service | CSV | CSV carries a single flat table of text and values, not the workbook’s presentation or behavior. |
| Deliver multiple worksheets as CSV tables | Separate CSV files, one per worksheet | Each CSV export contains the active sheet only. |
Microsoft describes XLSX as a format that preserves worksheet and chart data, formatting, and other supported features. CSV is appropriate when a recipient specifically needs a plain table. Microsoft Support: Excel formatting and features that are not transferred to other file formats.
Quick wins for a faster PC:
Scan for outdated or missing drivers - takes under a minuteDriver Scan →Clear out junk files and repair common Windows errorsFree Scan →Rank #3
How to export without losing the workbook you still need
- Keep the original workbook: Save or retain an XLSX copy if formulas, formatting, charts, or multiple sheets matter.
- Select the worksheet: Make the sheet you want to export the active sheet, since the CSV contains only that sheet.
- Save a CSV copy: Use Excel’s Save As or export workflow and select an appropriate CSV option for the receiving system. The exact options and labels can differ by platform and version.
- Check the exported file in its destination: Open or import it in the receiving application and inspect representative rows and columns, especially values whose display depends on formatting.
Microsoft’s current support documentation covers Microsoft 365 and versions including Excel 2024 and Excel 2021, but labels and CSV variants may differ across platforms. For the exact options available in your version, see Microsoft’s instructions for saving a workbook as text or CSV.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
