Thursday, May 14, 2009

How to extract embedded images from .xls, .ods or .odt

icon_openoffice
Hi :)

It's simple. Just 4 steps:

  1. Save a copy of the file as ODS (OpenOffice.org Spreadsheet).

  2. Change the filetype of the copy to ZIP (for example rename File.xls to File.zip).

  3. Open the ZIP.

  4. In the directory called Pictures will be the images, just as in the original.



Update
For newser versions, it works also to save it as xlsx and rename to zip later. Extract it and in the embedded folder you'll find a mediafolder containing your pictures.