How to recover an excel file with format and details that are wrongly save as CSV format?

%3CLINGO-SUB%20id%3D%22lingo-sub-44218%22%20slang%3D%22en-US%22%3EHow%20to%20recover%20an%20excel%20file%20with%20format%20and%20details%20that%20are%20wrongly%20save%20as%20CSV%20format%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-44218%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3EWould%20like%20to%20check%20out%20is%20there%20any%20way%20to%20recover%20and%20excel%20file%20with%20format%20and%20details%20that%20are%20wrongly%20save%20as%20CSV%20format.%3C%2FP%3E%3CP%3EThe%20orginal%26nbsp%3Braw%20file%20is%20a%20CSV%20format%20but%20had%20done%20some%20tabulation%20and%20format%20on%20the%20file%20that%20was%26nbsp%3Baccidentally%20save%20as%20CSV%20and%20deleted%20the%20recovery%20file%20as%20well.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20advise%20is%20there%20way%20to%20recover%20the%20file%20to%20excel%20format%20from%20the%20CSV%20format.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-44218%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-355143%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20recover%20an%20excel%20file%20with%20format%20and%20details%20that%20are%20wrongly%20save%20as%20CSV%20format%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-355143%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20to%20know%20that%20solution%203%20worked%20for%20you.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKeep%20reading!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3ERobin%20Shanab%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-328326%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20recover%20an%20excel%20file%20with%20format%20and%20details%20that%20are%20wrongly%20save%20as%20CSV%20format%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-328326%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F35851%22%20target%3D%22_blank%22%3E%40Robin%20Shanab%3C%2FA%3E%26nbsp%3Bwrote%3A%3CBR%20%2F%3E%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F38897%22%20target%3D%22_blank%22%3E%40Yanping%20.%3C%2FA%3Ewrote%3A%3CBR%20%2F%3E%3CP%3EHi%3C%2FP%3E%3CP%3EWould%20like%20to%20check%20out%20is%20there%20any%20way%20to%20recover%20and%20excel%20file%20with%20format%20and%20details%20that%20are%20wrongly%20save%20as%20CSV%20format.%3C%2FP%3E%3CP%3EThe%20orginal%26nbsp%3Braw%20file%20is%20a%20CSV%20format%20but%20had%20done%20some%20tabulation%20and%20format%20on%20the%20file%20that%20was%26nbsp%3Baccidentally%20save%20as%20CSV%20and%20deleted%20the%20recovery%20file%20as%20well.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20advise%20is%20there%20way%20to%20recover%20the%20file%20to%20excel%20format%20from%20the%20CSV%20format.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20try%20to%20convert%20CSV%20file%20to%20Excel.%20I%20know%20the%20three%20ways%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3COL%3E%3CLI%3EDirectly%20open%20CSV%20file%20in%20Excel%3A%20Open%20MS%20Excel%20and%20go%20to%20Open.%20Select%20the%20CSV%20file%20and%20open%20it.%20When%20you%20select%20the%20CSV%20file%20then%20click%20on%20the%20file%20type%20%3CSTRONG%3EText%20Files%20(*.prn%2C%20*.txt%2C%20*.csv).%26nbsp%3B%3C%2FSTRONG%3EThis%20selection%20will%20help%20to%20list%20the%20the%20file%20of%20these%20formats.%3C%2FLI%3E%3CLI%3EOpen%20CSV%20file%20using%20Windows%20explorer%3A%20This%20is%20the%20quickest%20way%20open%20the%20CSV%20file%20in%20Excel%20format.%20Right-click%20on%20the%20CSV%20file%20and%20select%20Open%20with%20option.%20choose%20default%20program%20from%20the%20context%20menu.%20Click%20on%20the%20Excel%20(Desktop)%20under%20recommended%20program.%20check%20the%20box%20%22Always%20use%20the%20selected%20program%20to%20open%20this%20kind%20of%20file%22.%20Click%20Ok.%3C%2FLI%3E%3CLI%3E%3CSTRONG%3EImport%20CSV%20to%20Excel%3A%20Open%20MS%20Excel%2C%20go%20to%20Data%20tab.%20Select%20From%20Text%26nbsp%3Boption.%20Now%20brows%20for%20the%20CSV%20file%2C%20select%20the%20file%20and%20click%20on%20the%20Import%20button.%26nbsp%3B%3C%2FSTRONG%3E%3C%2FLI%3E%3C%2FOL%3E%3CP%3EGood%20Luck%3C%2FP%3E%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BThanks%2C%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F35851%22%20target%3D%22_blank%22%3E%40Robin%20Shanab%3C%2FA%3E!%20Option%203%20from%20your%20list%20has%26nbsp%3Bliterally%20saved%20my%20life!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-44458%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20recover%20an%20excel%20file%20with%20format%20and%20details%20that%20are%20wrongly%20save%20as%20CSV%20format%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-44458%22%20slang%3D%22en-US%22%3E%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F38897%22%20target%3D%22_blank%22%3E%40Yanping%20.%3C%2FA%3E%20wrote%3A%3CBR%20%2F%3E%3CP%3EHi%3C%2FP%3E%3CP%3EWould%20like%20to%20check%20out%20is%20there%20any%20way%20to%20recover%20and%20excel%20file%20with%20format%20and%20details%20that%20are%20wrongly%20save%20as%20CSV%20format.%3C%2FP%3E%3CP%3EThe%20orginal%26nbsp%3Braw%20file%20is%20a%20CSV%20format%20but%20had%20done%20some%20tabulation%20and%20format%20on%20the%20file%20that%20was%26nbsp%3Baccidentally%20save%20as%20CSV%20and%20deleted%20the%20recovery%20file%20as%20well.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20advise%20is%20there%20way%20to%20recover%20the%20file%20to%20excel%20format%20from%20the%20CSV%20format.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20try%20to%20convert%20CSV%20file%20to%20Excel.%20I%20know%20the%20three%20ways%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3COL%3E%3CLI%3EDirectly%20open%20CSV%20file%20in%20Excel%3A%20Open%20MS%20Excel%20and%20go%20to%20Open.%20Select%20the%20CSV%20file%20and%20open%20it.%20When%20you%20select%20the%20CSV%20file%20then%20click%20on%20the%20file%20type%20%3CSTRONG%3EText%20Files%20(*.prn%2C%20*.txt%2C%20*.csv).%26nbsp%3B%3C%2FSTRONG%3EThis%20selection%20will%20help%20to%20list%20the%20the%20file%20of%20these%20formats.%3C%2FLI%3E%3CLI%3EOpen%20CSV%20file%20using%20Windows%20explorer%3A%20This%20is%20the%20quickest%20way%20open%20the%20CSV%20file%20in%20Excel%20format.%20Right-click%20on%20the%20CSV%20file%20and%20select%20Open%20with%20option.%20choose%20default%20program%20from%20the%20context%20menu.%20Click%20on%20the%20Excel%20(Desktop)%20under%20recommended%20program.%20check%20the%20box%20%22Always%20use%20the%20selected%20program%20to%20open%20this%20kind%20of%20file%22.%20Click%20Ok.%3C%2FLI%3E%3CLI%3EImport%20CSV%20to%20Excel%3A%20Open%20MS%20Excel%2C%20go%20to%20Data%20tab.%20Select%20%3CSTRONG%3EFrom%20Text%26nbsp%3B%3C%2FSTRONG%3Eoption.%20Now%20brows%20for%20the%20CSV%20file%2C%20select%20the%20file%20and%20click%20on%20the%20Import%20button.%26nbsp%3B%3C%2FLI%3E%3C%2FOL%3E%3CP%3EGood%20Luck%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-44281%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20recover%20an%20excel%20file%20with%20format%20and%20details%20that%20are%20wrongly%20save%20as%20CSV%20format%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-44281%22%20slang%3D%22en-US%22%3E%3CP%3EAfraid%20no%20way%20if%20you%20opened%20it%20as%20CSV%2C%20made%20some%20formatting%20and%20save%20as%20CSV%20again.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1406768%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20recover%20an%20excel%20file%20with%20format%20and%20details%20that%20are%20wrongly%20save%20as%20CSV%20format%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1406768%22%20slang%3D%22en-US%22%3EI%20had%20accidentally%20saved%20csv%20file%20and%20lost%20my%20other%20tabs%20(sheets)%20%2C%3CBR%20%2F%3EWhat%20should%20I%20have%20to%20do%20%3F%3CBR%20%2F%3ECan%20I%20get%20it%20back%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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

 

5 Replies
Highlighted

Afraid no way if you opened it as CSV, made some formatting and save as CSV again.

Highlighted

@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

 

  1. 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.
  2. 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.
  3. 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

Highlighted

 


@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

 

  1. 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.
  2. 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.
  3. 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!

Highlighted

Good to know that solution 3 worked for you. 

 

Keep reading!

 

Regards,

Robin Shanab

Highlighted
I had accidentally saved csv file and lost my other tabs (sheets) ,
What should I have to do ?
Can I get it back