0

I want to open the path xl\worksheets\sheet1.xml of an Excel file.

When I Google how to do this, an article asks me to rename the Excel file to .zip, and then unzip the file and check out the structure.

But even after I zip and unzip the Excel file, I don't find any such XML files in the extracted files. I find the .xlsx file alone.

Update: Based on the answers provided, I have renamed the Excel file to .zip, without actually zipping it. Then I have downloaded 7-zip software, which provides an option to open the .zip file when right-clicked. I can now see the XML structure of the Excel file in 7-zip.

LAKSHMI
  • 21
  • 1
  • 7
  • Look into a nice zipfile tool like 7-zip (which is now very popular and dependable). This will let you have extract option on right-click context menu. Then you just extract to folder, and it does it all for you without renaming the original Excel file. – MacroMarc Oct 20 '17 at 11:08
  • @marcomarc. Thank you, I have installed 7-zip and used it to open the renamed file. I could see the XML structure of the Excel file. – LAKSHMI Oct 20 '17 at 11:29
  • No problem. Just to reiterate - you don't have to rename the file when using 7-Zip. – MacroMarc Oct 20 '17 at 12:15

2 Answers2

3

You just have to rename the file from .xlsx to .zip (without zipping it).

Then, you can unzip with any unzipper like 7zip or WinRar on Windows, and Unarchiver on Mac OS.

Erdal G.
  • 2,694
  • 2
  • 27
  • 37
  • Thanks for your reply. I did as you said, I have renamed the file to xyz.zip. But, I am not sure how to unzip this file manually. When I right click it, I don't get any option to extract files/unzip it. – LAKSHMI Oct 20 '17 at 10:03
  • @LAKSHMI just saw your message, you guessed it right :) – Erdal G. Feb 21 '18 at 12:40
  • You don't even have to rename the file if you just on unarchive it, that will do it – Joe Shakely Oct 05 '22 at 23:29
1

Based on the answers and comments provided, I have renamed the Excel file to .zip, without actually zipping it.

Then I have downloaded 7-zip software, which provides an option to open the .zip file when right-clicked. I can now see the XML structure of the Excel file in 7-zip.

Thank you for helping me out!

LAKSHMI
  • 21
  • 1
  • 7