File Format & Compatibility

Prevent Excel Formulas and Formatting From Disappearing in CSV Files

Steve KSteve K Nov 20, 2026 869 views

Question details

The user wants to preserve formulas and formatting when working with data saved as a CSV file.

Prevent Excel Formulas and Formatting From Disappearing in CSV Files
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.
Before you start

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.

Solution 1Recommended

Save the original Excel workbook as XLSX

Use XLSX to keep formulas, formatting, and multiple worksheets in an editable workbook.

1
Open the original 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.

2
Choose Save As

Select File > Save As, then choose a location for the workbook.

3
Select the workbook format

In the file type list, select Excel Workbook (*.xlsx), enter a file name, and select Save.

4
Verify the saved file

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.

Save the original Excel workbook as XLSX
Keep macros in a different format: If the workbook contains VBA macros, choose Excel Macro-Enabled Workbook (*.xlsm) instead of XLSX. Saving a CSV as XLSX or XLSM cannot restore formulas or formatting already lost.
Preserve spreadsheet features

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. 1. Open the data: Open WPS Spreadsheets, select Open, and choose the CSV file or the original workbook.
  2. 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. 3. Save as XLSX: Select Menu > Save As, choose Excel Workbook (*.xlsx), and save the file with a new name.
  4. 4. Confirm the result: Reopen the XLSX file and select a formula cell to verify that its formula and formatting remain.
Save formulas and formatting in an editable workbookCompatible with Microsoft Excel XLSX filesWork with multiple worksheets in one workbookUse a familiar spreadsheet interface
microsoft office alternative - wps office

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.