My friend and colleague, John Miller, taught me a nice trick the other day.
My compression software of choice is 7-Zip. As you know, modern Excel files are nothing more the zipped XML packages. If you change the extension of your file from xlsx to zip, you can unpack the xml using any compression software that supports zip (which is probably all of them).
7-Zip has a menu item that I’ve never used. It’s the first on the list and it’s called
When you use
Open archive, 7-Zip doesn’t care what the file extension is. It looks at the file contents, determines how it was compressed, and displays its contents.
From here you can navigate to
xl/worksheets, for example, to see all the sheet XML files and their sizes.
That’s much easier that changing file extensions. Of course you can use this for inspecting anything in the file, not just worksheets.