File Format & Compatibility

Fix Excel Formulas Disappearing After Saving a CSV File

Muhammad TalhaMuhammad Talha Nov 14, 2026 869 views

Question details

The user needs to preserve Excel formulas when saving and reopening a spreadsheet.

Fix Excel Formulas Disappearing After Saving a CSV File
Product
Microsoft Excel
Device & OS
not provided
Scenario
A spreadsheet containing formulas was saved as a CSV file and reopened.
Observed behavior
The reopened file contains calculated values, but the original formulas are gone.
Before you start

Check the file extension to confirm whether the spreadsheet was saved as .csv. Locate the original workbook or a previous version that still contains the formulas before saving it in an Excel format.

Solution 1Recommended

Save the original workbook as an Excel Workbook

Use this method when you still have a copy of the workbook containing the formulas.

1
Open the original workbook

In Excel, select File > Open and choose the original workbook. Click a formula cell and check the formula bar to confirm the formula is still present.

2
Choose Save As

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

3
Select an Excel format

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

4
Verify the formulas

Close and reopen the saved .xlsx file, then select a formula cell and check the formula bar.

Save the original workbook as an Excel Workbook
CSV does not preserve workbook formulas: Excel typically saves the calculated results to CSV rather than preserving the original formulas. Saving that CSV as .xlsx afterward does not restore the missing formulas.
Preserve formulas in WPS Spreadsheet

Save your formula-containing workbook as XLSX in WPS Office

Open the original workbook in WPS Spreadsheet and save it as an XLSX file to retain its formulas for later editing.

  1. 1. Open the original workbook: Open WPS Spreadsheet, select Open, and choose the workbook that still contains your formulas.
  2. 2. Check a formula: Click a formula cell and verify that its formula appears in the formula bar.
  3. 3. Save as XLSX: Select Menu > Save As, choose an Excel Workbook (*.xlsx) file type, and click Save.
  4. 4. Reopen and verify: Open the saved XLSX file in WPS Spreadsheet and check a formula cell again.
Preserve formulas by saving in XLSX rather than CSV.Open and save Microsoft Excel XLSX files.Use familiar spreadsheet tools to inspect formulas.Work with spreadsheets using the free WPS Office suite.
microsoft office alternative - wps office

Frequently Asked Questions

Why did my Excel formulas disappear after I saved the file?

The file was saved as CSV, which does not preserve Excel workbook formulas. Excel typically exports their calculated results instead.

Can I recover formulas by saving the CSV as XLSX?

No. Changing the CSV to XLSX does not recreate formulas that are already missing. Open the original workbook or a previous version containing the formulas instead.

Which format should I use to keep Excel formulas?

In Excel, select File > Save As and choose Excel Workbook (*.xlsx). If the workbook contains macros, choose an appropriate macro-enabled Excel format instead.

Where can I find an earlier version of my workbook?

For a workbook stored in OneDrive or SharePoint, open it in Excel and check File > Info > Version History. Open an earlier version and verify that it contains the formulas.