{"id":50819,"date":"2023-04-15T18:27:30","date_gmt":"2023-04-15T17:27:30","guid":{"rendered":"https:\/\/ekiwi-blog.de\/50819\/save-picture-inserted-in-excel-document-as-file\/"},"modified":"2023-08-06T10:31:36","modified_gmt":"2023-08-06T09:31:36","slug":"save-picture-inserted-in-excel-document-as-file","status":"publish","type":"post","link":"https:\/\/ekiwi-blog.de\/en\/50819\/save-picture-inserted-in-excel-document-as-file\/","title":{"rendered":"Save picture inserted in Excel document as file"},"content":{"rendered":"<p>In everyday office work with Excel it can happen that you receive an Excel file in which pictures are inserted. If you want to save these pictures as an image file, e.g. <em>*.jpeg<\/em> or <em>*.png<\/em>, you have a problem.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of content<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/ekiwi-blog.de\/en\/50819\/save-picture-inserted-in-excel-document-as-file\/#Save_as_image_file_not_possible\" >Save as image file not possible<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/ekiwi-blog.de\/en\/50819\/save-picture-inserted-in-excel-document-as-file\/#Procedure_1_Copy_and_paste_image\" >Procedure 1: Copy and paste image<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/ekiwi-blog.de\/en\/50819\/save-picture-inserted-in-excel-document-as-file\/#Procedure_2_Rename_Excel_file_to_Zip_file\" >Procedure 2: Rename Excel file to Zip file<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/ekiwi-blog.de\/en\/50819\/save-picture-inserted-in-excel-document-as-file\/#Procedure_3_Take_screenshotscreen_capture\" >Procedure 3: Take screenshot\/screen capture<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/ekiwi-blog.de\/en\/50819\/save-picture-inserted-in-excel-document-as-file\/#Procedure_4_Save_as_web_page\" >Procedure 4: Save as web page<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Save_as_image_file_not_possible\"><\/span>Save as image file not possible<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Unfortunately, Excel does not offer a direct way to save one or more images inserted into the Excel document. In <a href=\"https:\/\/ekiwi-blog.de\/en\/50969\/word-indent-bullet-listor-enumeration-within-a-table\/\" title=\"Word: Indent bullet list \/ enumeration within a table\">Word<\/a>, for example, this is easily possible by right-clicking on the image and then selecting &#8220;Save as graphic&#8230;. In Excel, unfortunately, this function is missing in <a href=\"https:\/\/ekiwi-blog.de\/en\/16747\/windows-11-return-to-the-classic-context-menu-in-explorer\/\" title=\"Windows 11 &#8211; return to the classic context menu in Explorer\">the context menu<\/a>.<\/p>\n<figure id=\"attachment_50778\" aria-describedby=\"caption-attachment-50778\" style=\"width: 650px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-50778 size-full\" src=\"https:\/\/ekiwi-blog.de\/wp-content\/uploads\/2023\/04\/cant-save-picture-from-excel-file.jpg\" alt=\"Screenshot Excel document: no possibility to save the inserted image directly\" width=\"650\" height=\"577\" srcset=\"https:\/\/ekiwi-blog.de\/wp-content\/uploads\/2023\/04\/cant-save-picture-from-excel-file.jpg 650w, https:\/\/ekiwi-blog.de\/wp-content\/uploads\/2023\/04\/cant-save-picture-from-excel-file-300x266.jpg 300w\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" \/><figcaption id=\"caption-attachment-50778\" class=\"wp-caption-text\">no option to save the pasted image<\/figcaption><\/figure>\n<p>In the following we show four possibilities to save the picture of the Excel document locally nevertheless.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Procedure_1_Copy_and_paste_image\"><\/span>Procedure 1: Copy and paste image<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>With this method, you also <strong>right-click<\/strong> on the image in question to select it. In the context menu that then opens, select <strong>&#8220;Copy&#8221;<\/strong>.<\/p>\n<p>Then open a graphics program of your choice, in our example the Windows program <strong>&#8220;Paint&#8221; was started<\/strong>. There you can paste the copied image or directly via the <strong><a href=\"https:\/\/ekiwi-blog.de\/en\/16333\/windows-no-context-menu-key-use-this-key-combination\/\" title=\"Windows: No context menu key? Use this key combination!\">key combination<\/a> &#8220;Ctrl+V&#8221;<\/strong>.<\/p>\n<figure id=\"attachment_50782\" aria-describedby=\"caption-attachment-50782\" style=\"width: 699px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-50782\" src=\"https:\/\/ekiwi-blog.de\/wp-content\/uploads\/2023\/04\/save-picture-from-excel-file-to-local-folder.jpg\" alt=\"Copy screenshot image to Excel file and then paste into Paint\" width=\"699\" height=\"377\" srcset=\"https:\/\/ekiwi-blog.de\/wp-content\/uploads\/2023\/04\/save-picture-from-excel-file-to-local-folder.jpg 699w, https:\/\/ekiwi-blog.de\/wp-content\/uploads\/2023\/04\/save-picture-from-excel-file-to-local-folder-300x162.jpg 300w\" sizes=\"auto, (max-width: 699px) 100vw, 699px\" \/><figcaption id=\"caption-attachment-50782\" class=\"wp-caption-text\">Copy image within Excel file and then paste into a drawing program<\/figcaption><\/figure>\n<p>Now the image can be saved via <strong>&#8220;File&#8221; \ud83e\udc0a &#8220;Save as&#8221;<\/strong> in any image format as a JPG or PNG file in a local folder. It is quicker again with the <strong>key combination &#8220;Ctrl+S&#8221;<\/strong>.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Procedure_2_Rename_Excel_file_to_Zip_file\"><\/span>Procedure 2: Rename Excel file to Zip file<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Many people are probably not aware that modern Office file formats, such as an Excel file, are actually many individual files and folders packed into a ZIP file. For this reason, you can simply rename the Excel document in which the inserted pictures are located into a ZIP file. This is also excellent for <a href=\"https:\/\/ekiwi-blog.de\/en\/50721\/save-all-images-of-a-word-file-at-the-same-time\/\">saving all the images of an Office document, such as Word, at once<\/a> and making them available for further processing.<\/p>\n<p>To do this, first use the <strong>rename<\/strong> function (right-click on the file in Windows Explorer) to change the file extension from <strong>&#8220;xlsx&#8221; to &#8220;zip&#8221;<\/strong>. If necessary, simply copy the Excel file before renaming it, if you are worried about damaging the original file in some way.<\/p>\n<figure id=\"attachment_50786\" aria-describedby=\"caption-attachment-50786\" style=\"width: 349px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-50786\" src=\"https:\/\/ekiwi-blog.de\/wp-content\/uploads\/2023\/04\/save-picture-from-excel-file-to-local-folder-renaming-to-zip-file.jpg\" alt=\"Change file extension to zip file\" width=\"349\" height=\"247\" srcset=\"https:\/\/ekiwi-blog.de\/wp-content\/uploads\/2023\/04\/save-picture-from-excel-file-to-local-folder-renaming-to-zip-file.jpg 349w, https:\/\/ekiwi-blog.de\/wp-content\/uploads\/2023\/04\/save-picture-from-excel-file-to-local-folder-renaming-to-zip-file-300x212.jpg 300w\" sizes=\"auto, (max-width: 349px) 100vw, 349px\" \/><figcaption id=\"caption-attachment-50786\" class=\"wp-caption-text\">Rename Excel file to a zip file<\/figcaption><\/figure>\n<p>You can then unzip the zip file or navigate directly within the zip file. Under the folder path <strong>&#8220;xl\/media&#8221;<\/strong> you will then find all the image files contained in the Excel document and can copy out the images you need.<\/p>\n<figure id=\"attachment_50790\" aria-describedby=\"caption-attachment-50790\" style=\"width: 649px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-50790\" src=\"https:\/\/ekiwi-blog.de\/wp-content\/uploads\/2023\/04\/save-picture-from-excel-file-to-local-folder-using-zip-file.jpg\" alt=\"Windows Explorer with open zip file and media folder\" width=\"649\" height=\"358\" srcset=\"https:\/\/ekiwi-blog.de\/wp-content\/uploads\/2023\/04\/save-picture-from-excel-file-to-local-folder-using-zip-file.jpg 649w, https:\/\/ekiwi-blog.de\/wp-content\/uploads\/2023\/04\/save-picture-from-excel-file-to-local-folder-using-zip-file-300x165.jpg 300w\" sizes=\"auto, (max-width: 649px) 100vw, 649px\" \/><figcaption id=\"caption-attachment-50790\" class=\"wp-caption-text\">navigate to &#8220;media&#8221; folder in zip file<\/figcaption><\/figure>\n<p>Now the image or images can be used like any other image file on the computer.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Procedure_3_Take_screenshotscreen_capture\"><\/span>Procedure 3: Take screenshot\/screen capture<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Admittedly, this is not the prettiest method and is similar in some ways to Procedure 1. But there is still the option of taking a screenshot and then pasting the screen capture into a graphics program such as &#8220;Paint&#8221;.<\/p>\n<p>You can take a screenshot with the <strong>press<\/strong> key. This will take a picture of the entire screen and paste it into the clipboard. With <strong>&#8220;Ctrl+V&#8221;<\/strong> you can now paste it into <strong>Paint<\/strong> as described above. The disadvantage is that you have first captured the entire screen and then have to crop the image to the desired image in the Excel program.<\/p>\n<p>Alternatively, you can use the <a href=\"https:\/\/ekiwi-blog.de\/en\/53877\/disable-windows-print-key-for-snipping-tool\/\" title=\"Disable Windows Print Key for Snipping Tool\">&#8220;Snipping Tool&#8221;<\/a>, which is installed by default under Windows. Simply enter <strong>&#8220;Snipping&#8230;&#8221; in the <a href=\"https:\/\/ekiwi-blog.de\/en\/16083\/windows-disable-search-the-web-in-start-menu\/\" title=\"Windows: Disable &#8220;Search the web&#8221; in start menu\">Windows search<\/a> and open the <strong>&#8220;Snipping Tool&#8221;<\/strong>.<\/strong><\/p>\n<figure id=\"attachment_50798\" aria-describedby=\"caption-attachment-50798\" style=\"width: 359px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-50798\" src=\"https:\/\/ekiwi-blog.de\/wp-content\/uploads\/2023\/04\/screenshot-of-picture-in-excel-with-snipping-tool.jpg\" alt=\"Enter snipping in Win menu and start snipping tool\" width=\"359\" height=\"233\" srcset=\"https:\/\/ekiwi-blog.de\/wp-content\/uploads\/2023\/04\/screenshot-of-picture-in-excel-with-snipping-tool.jpg 359w, https:\/\/ekiwi-blog.de\/wp-content\/uploads\/2023\/04\/screenshot-of-picture-in-excel-with-snipping-tool-300x195.jpg 300w\" sizes=\"auto, (max-width: 359px) 100vw, 359px\" \/><figcaption id=\"caption-attachment-50798\" class=\"wp-caption-text\">Open snipping tool via Windows menu<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<p>In the &#8220;Snipping Tool&#8221; then click on <strong>&#8220;New&#8221;<\/strong> and then <strong>with the mouse button held down, drag the frame<\/strong> to capture around the desired image in the Excel file. When you release the mouse button, the image of the drawn frame is copied to the clipboard.<\/p>\n<figure id=\"attachment_50794\" aria-describedby=\"caption-attachment-50794\" style=\"width: 649px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-50794\" src=\"https:\/\/ekiwi-blog.de\/wp-content\/uploads\/2023\/04\/screenshot-of-picture-in-excel-with-snipping-tool-2.jpg\" alt=\"Screenshot application of the snipping tool in Excel\" width=\"649\" height=\"374\" srcset=\"https:\/\/ekiwi-blog.de\/wp-content\/uploads\/2023\/04\/screenshot-of-picture-in-excel-with-snipping-tool-2.jpg 649w, https:\/\/ekiwi-blog.de\/wp-content\/uploads\/2023\/04\/screenshot-of-picture-in-excel-with-snipping-tool-2-300x173.jpg 300w\" sizes=\"auto, (max-width: 649px) 100vw, 649px\" \/><figcaption id=\"caption-attachment-50794\" class=\"wp-caption-text\">Drag snipping tool &#8220;New&#8221; and frame over Excel image to capture<\/figcaption><\/figure>\n<p>Now you can paste the image from the clipboard back into any graphics program as described above and save it there as an image file.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Procedure_4_Save_as_web_page\"><\/span>Procedure 4: Save as web page<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Many roads lead to Rome, and so there is another workaround. The Excel document in question can also be saved as an HTML page.<\/p>\n<p>To do this, go to <strong>&#8220;File&#8221; \ud83e\udc0a &#8220;Save as&#8221;<\/strong> and select &#8220;<em>Web page (*.htm, *.html)<\/em>&#8221; as the file type, give it a suitable name and select the desired storage location.<\/p>\n<figure id=\"attachment_50804\" aria-describedby=\"caption-attachment-50804\" style=\"width: 650px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-50804 size-full\" src=\"https:\/\/ekiwi-blog.de\/wp-content\/uploads\/2023\/04\/excel-as-website-save-to-receive-pasted-image-file.jpg\" alt=\"Screenshot Excel save as web page\" width=\"650\" height=\"577\" srcset=\"https:\/\/ekiwi-blog.de\/wp-content\/uploads\/2023\/04\/excel-as-website-save-to-receive-pasted-image-file.jpg 650w, https:\/\/ekiwi-blog.de\/wp-content\/uploads\/2023\/04\/excel-as-website-save-to-receive-pasted-image-file-300x266.jpg 300w\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" \/><figcaption id=\"caption-attachment-50804\" class=\"wp-caption-text\">Save the Excel document as a web page<\/figcaption><\/figure>\n<p>Under the chosen storage path, you will then find a htm-file as well as an associated folder containing all other files, including the image files, that are needed to display the Excel document as a web page.<\/p>\n<figure id=\"attachment_50811\" aria-describedby=\"caption-attachment-50811\" style=\"width: 500px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-50811\" src=\"https:\/\/ekiwi-blog.de\/wp-content\/uploads\/2023\/04\/html-file-and-folder-with-pictures.jpg\" alt=\"HTML file and associated folder in Windows Explorer\" width=\"500\" height=\"275\" srcset=\"https:\/\/ekiwi-blog.de\/wp-content\/uploads\/2023\/04\/html-file-and-folder-with-pictures.jpg 500w, https:\/\/ekiwi-blog.de\/wp-content\/uploads\/2023\/04\/html-file-and-folder-with-pictures-300x165.jpg 300w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><figcaption id=\"caption-attachment-50811\" class=\"wp-caption-text\">Images are located in the associated folder of the web page<\/figcaption><\/figure>\n<p>If you now open the relevant folder, you will find the pictures contained in the Excel document in file format and can copy them for further use.<\/p>\n<figure id=\"attachment_50807\" aria-describedby=\"caption-attachment-50807\" style=\"width: 500px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-50807\" src=\"https:\/\/ekiwi-blog.de\/wp-content\/uploads\/2023\/04\/image-files-from-excel-document.jpg\" alt=\"Screenshot of the image and media files of the website\" width=\"500\" height=\"277\" srcset=\"https:\/\/ekiwi-blog.de\/wp-content\/uploads\/2023\/04\/image-files-from-excel-document.jpg 500w, https:\/\/ekiwi-blog.de\/wp-content\/uploads\/2023\/04\/image-files-from-excel-document-300x166.jpg 300w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><figcaption id=\"caption-attachment-50807\" class=\"wp-caption-text\">Image files for the website<\/figcaption><\/figure>\n<p>As you can see, the original files are saved on one side and a merged file of the images on the other side. This was done by Excel so that the presentation as a web page is exactly the same as in the Excel file.<\/p>","protected":false},"excerpt":{"rendered":"<p>In everyday office work with Excel it can happen that you receive an Excel file in which pictures are inserted.<\/p>\n","protected":false},"author":2,"featured_media":4332,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1555],"tags":[1855,2888,2889,1857,1858,2168],"class_list":["post-50819","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-software-en","tag-excel-en-2","tag-graphic","tag-images-en","tag-microsoft-en-2","tag-microsoft-office-en-2","tag-office-en"],"_links":{"self":[{"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/posts\/50819","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/comments?post=50819"}],"version-history":[{"count":0,"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/posts\/50819\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/media\/4332"}],"wp:attachment":[{"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/media?parent=50819"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/categories?post=50819"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ekiwi-blog.de\/en\/wp-json\/wp\/v2\/tags?post=50819"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}