Feb 06 2017 08:33 AM
Hi
Would like to check out is there any way to recover and excel file with format and details that are wrongly save as CSV format.
The orginal raw file is a CSV format but had done some tabulation and format on the file that was accidentally save as CSV and deleted the recovery file as well.
Please advise is there way to recover the file to excel format from the CSV format.
Thank you
Feb 06 2017 09:24 AM
Afraid no way if you opened it as CSV, made some formatting and save as CSV again.
Feb 06 2017 09:08 PM
@Yanping . wrote:Hi
Would like to check out is there any way to recover and excel file with format and details that are wrongly save as CSV format.
The orginal raw file is a CSV format but had done some tabulation and format on the file that was accidentally save as CSV and deleted the recovery file as well.
Please advise is there way to recover the file to excel format from the CSV format.
Thank you
Hello,
You can try to convert CSV file to Excel. I know the three ways
Good Luck
Jan 30 2019 06:12 PM
@Robin Shanab wrote:
@Yanping .wrote:Hi
Would like to check out is there any way to recover and excel file with format and details that are wrongly save as CSV format.
The orginal raw file is a CSV format but had done some tabulation and format on the file that was accidentally save as CSV and deleted the recovery file as well.
Please advise is there way to recover the file to excel format from the CSV format.
Thank you
Hello,
You can try to convert CSV file to Excel. I know the three ways
- Directly open CSV file in Excel: Open MS Excel and go to Open. Select the CSV file and open it. When you select the CSV file then click on the file type Text Files (*.prn, *.txt, *.csv). This selection will help to list the the file of these formats.
- Open CSV file using Windows explorer: This is the quickest way open the CSV file in Excel format. Right-click on the CSV file and select Open with option. choose default program from the context menu. Click on the Excel (Desktop) under recommended program. check the box "Always use the selected program to open this kind of file". Click Ok.
- Import CSV to Excel: Open MS Excel, go to Data tab. Select From Text option. Now brows for the CSV file, select the file and click on the Import button.
Good Luck
Thanks, @Robin Shanab! Option 3 from your list has literally saved my life!
Feb 21 2019 09:52 PM
Good to know that solution 3 worked for you.
Keep reading!
Regards,
Robin Shanab
May 20 2020 01:21 PM
Apr 26 2021 07:13 PM
May 27 2021 11:55 PM
Jun 06 2021 12:27 AM
Jul 26 2021 02:02 AM
May 09 2022 09:41 AM
I did the same think. Hours of work wasted. I did learn a valuable lesson so I guess it was worth it. I do wonder why the other tabs were even permitted without a prompt to change the format to save it. It is a fault for some program I think. I was on the alternate tab when I saved it so I would think it shoud be somewhere!
May 11 2022 01:17 PM
@Rhonda910 I just did the same thing and lost all the data on other tabs.
To help avoid this in the future, in Excel go to File > Options > Save under Save workbooks, and check "Show data loss warning when editing comma delimited file (*.csv)"
Now when I open a csv file I get this warning:
Nov 06 2022 06:05 AM
The same thing just happened to me and I tested to see if I was receiving an alert and Excel is not giving an alert that it is a CSV file. Just started happening because in the past I was able to resave as an excel file. I am so frustrated litterly hours of lost work because when I saved it said it saved but never saved all the worksheets!!!!
Feb 07 2023 12:33 AM
Found this on Reddit. It's always worth a try:
C:\Users%username%\AppData\Roaming\Microsoft\Excel\ might have something if your lucky.
Feb 28 2023 07:17 AM
thank you!!! This absolutely worked for me, there were several different files to choose from and I chose the one with the latest time stamp. All my spreadsheet tabs were included even though I had been working on it in .txt format when my computer shut down.
May 16 2023 06:39 AM
@12kylen Same. I can't believe the program would allow this. I am furious.
Feb 10 2024 10:57 PM
Thank you for this! Maybe it will save me in the future. I wish that were the default setting.
Feb 10 2024 11:00 PM