Save Excel Data as CSV Without Losing Important Workbook Features
Question details
The user wants to export Excel data as CSV while retaining important workbook information.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Saving a workbook as a CSV file for data exchange.
- Observed behavior
- Excel warns that some workbook features may be lost. Continuing creates a CSV without features such as formatting and formulas; canceling stops the CSV save.
Identify the worksheet you need to export and check that its formulas show the expected results. CSV stores only the active worksheet and cannot preserve workbook features such as formulas, formatting, or charts.
Keep an XLSX workbook and export a separate CSV
Use this method when you need a data-only CSV but also want to retain the original workbook features.
CSV is a plain-text format. It stores cell values rather than formulas, formatting, charts, or multiple worksheets. Formula cells are exported as results, so retain the XLSX file if you need to edit or recalculate them.
In Excel, select File > Save As and save the workbook as an Excel Workbook (*.xlsx).
Click the tab of the worksheet you want to export. A CSV file contains only the active worksheet.
Select File > Save As, choose a location, and select CSV UTF-8 (Comma delimited) (*.csv) or the CSV format required by the receiving application. Give the file a name and select Save.
When Excel warns that features may be lost, choose the option to continue saving as CSV. The separate XLSX file retains the workbook features.
Open the CSV in a text editor or import it into the receiving application. Check formula results, dates, special characters, and identifiers with leading zeros.

Export a CSV copy with WPS Spreadsheet
Use WPS Spreadsheet to keep an editable XLSX workbook and save a separate CSV copy of the worksheet data.
- 1. Open the workbook: Open WPS Spreadsheet and select Open to load your Excel workbook.
- 2. Keep an XLSX copy: Select Menu > Save As and save the workbook in XLSX format if it is not already saved.
- 3. Choose the worksheet: Click the sheet tab containing the data you want to export.
- 4. Save a CSV copy: Select Menu > Save As, choose a CSV file type and a file name, then select Save. Confirm any warning about features that CSV cannot retain.
- 5. Verify the export: Open the CSV in a text editor or the receiving application and check that the values and characters are correct.

Frequently Asked Questions
Can a CSV file keep Excel formulas and formatting?
No. CSV stores plain-text values, not formulas or cell formatting. Save an XLSX copy through File > Save As to retain those features.
What happens to formula cells when I save as CSV?
The CSV contains the formula results rather than the formulas. Check the results in the worksheet before exporting and keep the XLSX file if you need to recalculate them.
Can I save all worksheets in one CSV file?
No. A CSV export contains only the active worksheet. Select each sheet tab and save a separate CSV for each worksheet you need.
Why should I check leading zeros and special characters?
Applications may interpret identifiers, dates, or character encoding differently when importing CSV. Check the file in a text editor or the receiving application, and use CSV UTF-8 when appropriate.




