8

I can rename an Excel file extension from .XLSX to .zip and extract out the xml files.

How do I combine individual Excel xml files back into a single XLSX file?

I tried zipping up the folder and renaming the .zip extension back to .XLSX but then Excel has a problem opening the file.

Jeremy Thompson
  • 1,286
  • 1
  • 13
  • 24

2 Answers2

17

Found it! Seems I was zipping up the entire folder, you need to zip up the three folders and XML file:

_rels
docProps
xl
[Content_Types].xml

Then rename the zip files extension to xslx and it opens fine.

Jeremy Thompson
  • 1,286
  • 1
  • 13
  • 24
0

You need the zip up:

  1. [Content_Types].xml (file)
  2. _rels (folder)
  3. docProps (folder)
  4. xl (folder)

The Content_Types.xml should be the first file in the archive. You can ensure this, by using the zip/archive utility of your choice, you first add [Content_Types].xml saving the archive (close the archive utility if you like) and then adding the objects (folders).

Bastiaan Quast
  • 129