Fix Excel Formulas Disappearing After Saving a CSV File
Question details
The user needs to preserve Excel formulas when saving and reopening a spreadsheet.

- 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.
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.
Save the original workbook as an Excel Workbook
Use this method when you still have a copy of the workbook containing the formulas.
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.
Select File > Save As and choose a location for the workbook.
In the file type list, select Excel Workbook (*.xlsx), enter a file name, and click Save.
Close and reopen the saved .xlsx file, then select a formula cell and check the formula bar.

Look for a previous version of the original workbook
Use version history if the original formula-containing workbook was stored in a location that supports it.
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. Open the original workbook: Open WPS Spreadsheet, select Open, and choose the workbook that still contains your formulas.
- 2. Check a formula: Click a formula cell and verify that its formula appears in the formula bar.
- 3. Save as XLSX: Select Menu > Save As, choose an Excel Workbook (*.xlsx) file type, and click Save.
- 4. Reopen and verify: Open the saved XLSX file in WPS Spreadsheet and check a formula cell again.

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.




