/Office-File-Explorer

This tool can be used to view details of Office Open Xml formatted files (Word, Excel, PowerPoint) for troubleshooting purposes...Click here to download the tool:

Primary LanguageC#MIT LicenseMIT

Office-File-Explorer

NOTE: This tool is not actively being worked on, see the following for active development of the tool

https://github.com/desjarlais/Office-File-Explorer-v2

The purpose of this tool is to provide potential file specific troubleshooting of Office Open Xml formatted documents for Word, Excel and PowerPoint (.docx, .dotx, .docm, .xlsx, .xlst, .xlsm, .pptx, .pptm).

I've also added a couple of known document fixes where the xml tags in the underlying file format need to be tweaked to make the file openable again.

Warning

I've stopped actively developing this version of the tool, it was built on the .NET Framework and going forward, I wanted to change this to .NET Core. For the current version of the tool, click here Office File Explorer v2

Note

Keep in mind if you use this on a production document and choose to use something that changes or removes data, you should be working on a copy of the file, not the original.

Main Window

image

List of features

Word

  • List function to display (content controls, styles, hyperlinks, List Templates, fonts, footnotes, endnotes, document properties, authors, revisions/tracked changes, comments, field codes, bookmarks, paragraphs, paragraph styles)
  • Delete content (headers / footers, orphan list templates, page breaks, comments, hidden text, footnotes, endnotes)
  • Convert Macro enabled file (.docm) to non-macro enabled (.docx)
  • Fix corrupt documents
  • Fix corrupt bookmarks
  • Fix corrupt revisions
  • Fix corrupt endnotes
  • Fix orphan / unused ListTemplates (Numbering)
  • Fix corrupt table properties
  • Fix corrupt commments
  • Remove PII
  • Delete unused styles

Excel

  • List function to display (links, comments, worksheets, hidden rows & columns, shared strings, cell values, connections, defined names)
  • Delete content (comments, links)
  • Convert Macro enabled file (.xlsm) to non-macro enabled (.xlsx)
  • Convert Strict .xlsx format to non-Strict .xlsx format

PowerPoint

  • List function to display (hyperlinks, slide titles, slide text, comments)
  • Convert Macro enabled file (.pptm) to non-macro enabled (.pptx)
  • Reset note page size to default value (if the button doesn't fix the issue, go to File | Settings and enable the notes master checkbox)
  • Remove PII
  • Fix Presentation - fix corrupt notes slides / pages

Shared

  • List function to display (Ole Objects, shapes, custom properties, package parts)
  • Add custom properties for a file
  • Change theme for a file
  • Validate underlying xml file details
  • View Custom Xml - view custom xml files in Office documents

Batch File Processing Window

image

Batch File Processing (following features can be used to change many documents at one time)

  • Change Theme (Word, Excel, PowerPoint)
  • Add Custom Properties (Word, Excel, PowerPoint)
  • Reset note page size to default value (PowerPoint)
  • Fix corrupt bookmarks (Word)
  • Fix corrupt revisions (Word)
  • Fix corrupt table properties (Word)
  • Remove Personally Identifiable Information (Word)
  • Remove PII (PowerPoint)
  • Convert Strict xlsx format to non-Strict xlsx format (Excel)
  • Delete RequestStatus xml node - (Word, Excel, PowerPoint)