Recover Lost Excel Notes After Saving a Workbook as CSV
Question details
The user wants to know whether notes lost after saving an Excel workbook as a CSV file can be recovered.
- Product
- Microsoft Excel and CSV files
- Device & OS
- not provided
- Scenario
- An Excel workbook containing cell notes was saved or exported as a CSV file.
- Observed behavior
- The CSV file contains plain text cell values but does not contain the workbook's notes.
Do not overwrite or repeatedly save the CSV file while checking recovery options. Identify the original workbook name and search the same folder, cloud storage location, and Excel recovery locations for an earlier XLSX or XLSM version.
Restore an earlier XLSX or XLSM workbook version
Use this method when the workbook was stored in OneDrive, SharePoint, Dropbox, or another service that keeps file version history.
CSV is a plain-text format and cannot store Excel notes, comments, formatting, formulas, charts, or tables. Notes can only be restored from an earlier workbook version that was still saved in an Excel workbook format, such as XLSX or XLSM.
Open File Explorer or Finder and search for the workbook name with the .xlsx and .xlsm extensions. Open any earlier Excel workbook copy and check the cells that originally contained notes.
In OneDrive, SharePoint, or Dropbox, locate the original workbook, select Version history, and review versions created before the file was saved as CSV.
Select the version that still contains the notes, then choose Restore or Download a copy. Open the restored XLSX or XLSM file in Excel and verify the notes.
In Excel, select File > Save As and save the recovered file as Excel Workbook (*.xlsx) or Excel Macro-Enabled Workbook (*.xlsm) before creating a separate CSV export.
Check Excel AutoRecover and unsaved workbook files
Use this option when Excel closed unexpectedly or when an unsaved workbook copy may have existed before the CSV conversion.
Look for a computer backup or previously copied workbook
Use this method when cloud history and Excel recovery files do not contain the original workbook.
Use WPS Office to Preserve Notes in Excel Workbook Files
WPS Office is a free, lightweight office suite with a familiar spreadsheet interface and seamless migration from Microsoft Excel. It opens and saves Excel workbook formats while helping you keep workbook content in a format that supports notes, instead of relying on CSV for features it cannot store.
Frequently Asked Questions
Can a CSV file store Excel notes or comments?
No. CSV stores plain-text cell values separated by delimiters. It does not retain Excel notes, comments, formatting, formulas, charts, tables, or multiple worksheets.
Where can I find an earlier Excel version with my notes?
Check the original folder for XLSX or XLSM files, then review Version history in OneDrive, SharePoint, or Dropbox. You can also use Excel's File > Open > Recent > Recover Unsaved Workbooks option.
Will changing the CSV extension to XLSX bring notes back?
No. Renaming a .csv file to .xlsx does not restore data that was removed during CSV saving. You need an earlier XLSX, XLSM, AutoRecover, cloud-history, or backup copy.
How should I save a workbook when I need both notes and a CSV export?
Keep the master file as an Excel Workbook (*.xlsx) or Excel Macro-Enabled Workbook (*.xlsm) using File > Save As. Then use File > Save As or File > Export to create a separate CSV copy for data transfer.
