I've got a xls file with exactly 167 images that I must save and post on a website. The sheer number itself is painful, but what complicates things is that you can't directly save images from Calc - you need to copy it to Writer first and then save.

This isn't the way I would like to do things, so is there a way to save all the graphics in the file somehow?

  1. Open the xls file in OpenOffice or LibreOffice
  2. save it as a open document (.ods).
  3. rename file to have .zip extension
  4. uncompress that zip file

All images should be in a Pictures/ directory in that zip file.

This also works if you are given a .PPT which can be saved in Impress.

  • 2
    That - is - AWESOME! – Oxwivi Sep 8 '11 at 10:30
  • 1
    @Oxwivi: You welcome. This shows beauty of open standards. Isn't it? – Michał Šrajer Sep 8 '11 at 10:33
  • Indeed, stuff like these small workarounds makes me love open softwares and standards even more! – Oxwivi Sep 8 '11 at 12:58
  • 1
    nice tip! same works for open document presentation (.odp). – susis strolch May 21 '13 at 11:14

If you want to get scripty there are some perl scripts to unpack Open Document Formats at:


Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.