Prevent Excel Formulas and Formatting From Disappearing in CSV Files
Question details
The user wants to preserve formulas and formatting when working with data saved as a CSV file.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A spreadsheet needs to retain formulas, formatting, and potentially multiple worksheets after saving.
- Observed behavior
- The CSV file retains cell data as plain text but does not preserve Excel formatting, multiple worksheets, or formulas as workbook features.
Check whether you still have the original Excel workbook containing the formulas and formatting. If you only have the CSV, you may need to recreate those features after importing it.
Save the original Excel workbook as XLSX
Use XLSX to keep formulas, formatting, and multiple worksheets in an editable workbook.
In Excel, select File > Open and choose the workbook that still contains your formulas and formatting. If only the CSV is available, open it instead and recreate any missing features.
Select File > Save As, then choose a location for the workbook.
In the file type list, select Excel Workbook (*.xlsx), enter a file name, and select Save.
Open the saved XLSX file and select a formula cell to check its formula in the formula bar. Confirm that the formatting and worksheets are present.

Keep an Excel workbook alongside the CSV export
Use this approach when another system requires CSV but you still need an editable Excel copy.
Save CSV data as an editable workbook in WPS Spreadsheets
Open CSV data in WPS Spreadsheets, add any needed formulas and formatting, and save it as an XLSX workbook. If those features were already lost from the CSV, they must be recreated.
- 1. Open the data: Open WPS Spreadsheets, select Open, and choose the CSV file or the original workbook.
- 2. Check formulas and formatting: Select cells to inspect their contents, then enter missing formulas and use the Home tab to apply formatting as needed.
- 3. Save as XLSX: Select Menu > Save As, choose Excel Workbook (*.xlsx), and save the file with a new name.
- 4. Confirm the result: Reopen the XLSX file and select a formula cell to verify that its formula and formatting remain.

Frequently Asked Questions
Why did my formulas disappear after saving as CSV?
CSV is a plain-text format, not an Excel workbook format. Excel generally exports formula results rather than preserving the formulas as editable workbook formulas. Save the original workbook as XLSX to retain them.
Can I recover formatting by converting a CSV file to XLSX?
No. Saving a CSV as XLSX creates a workbook for future edits, but it cannot restore formatting or formulas that were not stored in the CSV. Reopen the original workbook if available, or recreate the missing features.
Which format should I use for a workbook with macros?
In Excel, select File > Save As and choose Excel Macro-Enabled Workbook (*.xlsm) to retain VBA macros along with workbook features such as formulas and formatting.
Can a CSV file contain multiple Excel worksheets?
No. CSV stores data from one worksheet per file. Save the workbook as XLSX to keep multiple sheets, or export each sheet to a separate CSV if required.




