Search code examples
excelcsvexport-to-csvrecoveryopencsv

Recovery other sheets in .CSV format


I worked on .csv format file and I made some different sheets. I Saved my .CSV file and close my file. Right now when I open my file, I just can see one sheet. All of my sheets is disappeared. Is there any way to recovery other sheets?


Solution

  • No, CSV files do not support sheets. Excel will only save the active worksheet when saved to .csv format. This has to do with how csv files are merely "flat files" where .xls/.xlsx formats are not.

    Like some of the comments have mentioned - it may exist in some temporary file, but your work is most likely lost.