1

Hello I'm trying to convert the encoded text data back to excel file. I have an excel file(.xlsx), when it is opened in notepad, it show encoded text data. And I'm getting the data in the encoded text which I need to convert back to excel file.

I have an excel- file which when I tried to open in notepad it looks like: (excel_file_txt.txt)

 PK      ! ¤Y€¼ h  ¥    xl/worksheets/sheet1.xmlœ½[“ý¸qåû~>…

¢ßµE7Â!{bÔU¬[ĉs}î‘Ú–b$µCÝÏ|ûá®]õWe&2mIÑ’øC,®
XL ¿ý/ÿó/þÕÿøño?

ÿ駿þãwëmùîW?þõ÷?ýáOý—üîÿýŽ_ïßýêç_~øë~øóOýñ¿û_?

þüÝù§ÿã·ÿþÓßþûÏüñÇ_~užà¯?ÿãwüå—ý‡ßüæçßÿñÇ¿üðóí§ýñ¯'ùçŸþö—~9ÿïßþå7?

ÿëß~üáïAùóo¶e‰¿ùËúëwÏ3üÃß®œã§þç?ýþÇ—Ÿ~ÿoùñ¯¿<Oò·ÿüÃ/çåÿüÇ?

ýëÏßýÓoÿð§“=þž_ýíÇþÇïþëú#8÷Ýoþé·ïuÿúñßþò¿õËÿíÿþñÏ?þþ—ÿpÞï~õøÓþÛO?

ý÷,ç¡åú{¼_Öÿù·_ýáÇþáßþüËÿõÓ¿ßüÓ¿üñ—ó$áòûŸþüóû?õ—?ýõýÌùá>køÓ~ùã

£Ø-­Kv)<îñÿúóïð÷ÿöó/?ýåÿÿ(òq

I tried to save this text file as using SAVEAS excelfile.xlsx & encoding as "UNICODE" (I even tried other encodings like UTF-8, ANSII.).

But when opened in excel it shows as: (excel_file_txt_encode_save.xlsx)

enter image description here

However, the original excel files looks like: (excel_file.xlsx)

enter image description here

Can someone help me to get back the excel file from the encoded text data or another way to get it done.

David
  • 366
  • 3
  • 22
  • 2
    Why are you trying to open an xlsx file in notepad? The internal format of these files is zip compressed xml. You could try unziping the file to get the raw xml from it. – JGNI Jun 25 '19 at 09:39
  • @JGNI - Actually I'm getting the data which looks same as when excel file is opened in notepad. Thing is I want to convert the incoming data (encoded form) back to excel (i.e in .xslx file) – David Jun 25 '19 at 10:02
  • OK so when you open it in Excel it's strange. Id the file type and file associations correct you can test this by running the `assoc` and `ftype` programs from the windows command line. – JGNI Jun 25 '19 at 10:20
  • My magic glassball says: The original file is a CSV file, not an XLSX file, that's why it "works" in Notepad. – daxim Jun 25 '19 at 11:33
  • @daxim - Thanks daxim, but the excel file link which is provided that's the same original file which is in .xlsx file if you checked the extension of it – David Jun 25 '19 at 11:50
  • If my guess is correct, then the extension is a lie. – daxim Jun 25 '19 at 15:15

0 Answers0