Ask Your Question

Recover overwritten CSV files with multiple worksheets

asked 2020-05-03 03:54:26 +0200

saint1729 gravatar image
  • I have a CSV file with one worksheet.
  • After editing with Libre Office, I saved it and opened it with Libre Office again.
  • I created a new sheet in the Libre Office.
  • I saved it and opened it with Sublime Text.
  • I couldn't see the data from both sheets. Still, I edited in Sublime Text and saved the .csv file.
  • I reopened the workbook with Libre Office again. All my previous worksheets are lost. Only the last worksheet is remaining.

I have been working on the other sheets for almost the past 10 days. All the work seems like it's gone. Ultimate frustration :( Is there a way to restore the lost data?

edit retag flag offensive close merge delete


A lesson to learn: never work in foreign file formats. Only in ODF. Only having finished export as necessary. If you did not save to ODS before exporting to CSV, no luck.

gabix gravatar imagegabix ( 2020-05-03 09:43:20 +0200 )edit

Yes, man. Poor design of such stable software. It should have warned me at least.

saint1729 gravatar imagesaint1729 ( 2020-05-03 18:27:30 +0200 )edit

It always warns.

gabix gravatar imagegabix ( 2020-05-03 19:13:54 +0200 )edit

It no longer warns if you say don't warn.

saint1729 gravatar imagesaint1729 ( 2020-05-03 19:17:11 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-05-03 07:38:27 +0200

Cookievore gravatar image

Hello saint1729,

I'm sorry to have to write again, no backup done, most likely no chance.

By luck you're maybe working under Windows (which you did not mention as part of the requested information). There you could have activated 'System Protection' (it is part of 'advanced system settings'). If so, you could maybe access 'previous versions' of your file with the file manager.

Take a minute to understand what kind of fileformat csv is. It is simple plain text. ASCii. It is not possible to store more than one sheet in it. That and a lot of other things calc would like to store in a file.

For the future consider to store more than one version of your file. E. g. by adding a revision number to the filename or a date. So you could also go back in history of this file in case something went wrong.


edit flag offensive delete link more


@Cookievore: Thanks for your reply. I know CSV is a plain text format. But, in that case, calc should not even allow me to create a new worksheet in CSV file format. It should repeatedly repeatedly repeatedly and indefinitely warn me saying that "You idiot, you might lose your data. Store in .ods format. I am not smart enough to understand your mind".

saint1729 gravatar imagesaint1729 ( 2020-05-03 18:31:43 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-05-03 03:54:26 +0200

Seen: 36 times

Last updated: May 03