{"id":10870,"date":"2019-05-31T14:37:01","date_gmt":"2019-05-31T21:37:01","guid":{"rendered":"https:\/\/www.zubairalexander.com\/stage\/?p=10870"},"modified":"2019-05-31T14:38:10","modified_gmt":"2019-05-31T21:38:10","slug":"insert-data-from-a-picture-into-microsoft-excel","status":"publish","type":"post","link":"https:\/\/www.zubairalexander.com\/blog\/insert-data-from-a-picture-into-microsoft-excel\/","title":{"rendered":"Insert Data from a Picture into Microsoft Excel"},"content":{"rendered":"<p>Microsoft is working on a pretty cool feature in Excel. The feature will allow you to insert data from a picture into Excel. According to <a href=\"https:\/\/support.office.com\/en-ie\/article\/insert-data-from-picture-3c1bb58d-2c59-4bc0-b04a-a671a6868fd7\" target=\"_blank\" rel=\"noopener noreferrer\">Microsoft<\/a>, this feature will work on Excel for iPhone, Excel of Androids, and Excel for Android Tablets.<\/p>\n<p>Here&#8217;s how you&#8217;ll be able to turn your picture data into an Excel table.<\/p>\n<ol>\n<li>You will open Excel and click on the <strong>Insert data from picture<\/strong> button on the Excel ribbon.<\/li>\n<li>Let&#8217;s say you want to copy the data from a printed paper. Take a picture of the spreadsheet, or portion of data, that you want to insert into Excel.<br \/>\n<a href=\"https:\/\/www.zubairalexander.com\/blog\/wp-content\/uploads\/2019\/05\/Excel-data.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-10878\" src=\"https:\/\/www.zubairalexander.com\/blog\/wp-content\/uploads\/2019\/05\/Excel-data.png\" alt=\"Insert image into Excel\" width=\"433\" height=\"915\" srcset=\"https:\/\/www.zubairalexander.com\/blog\/wp-content\/uploads\/2019\/05\/Excel-data.png 433w, https:\/\/www.zubairalexander.com\/blog\/wp-content\/uploads\/2019\/05\/Excel-data-142x300.png 142w\" sizes=\"(max-width: 433px) 100vw, 433px\" \/><\/a><\/li>\n<li>Excel&#8217;s AI engine will process the image and convert it to an Excel table.<\/li>\n<li>If there are any issues with the picture you will be able to correct it by clicking <strong>Edit<\/strong>, otherwise you will click <strong>Ignore<\/strong> to proceed.<\/li>\n<li>Press <strong>Insert<\/strong> and your data will show up in Excel. Pretty cool, eh?<br \/>\n<a href=\"https:\/\/www.zubairalexander.com\/blog\/wp-content\/uploads\/2019\/05\/Data-inserted-into-Excel.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-10879\" src=\"https:\/\/www.zubairalexander.com\/blog\/wp-content\/uploads\/2019\/05\/Data-inserted-into-Excel.png\" alt=\"Data inserted into Excel\" width=\"435\" height=\"496\" srcset=\"https:\/\/www.zubairalexander.com\/blog\/wp-content\/uploads\/2019\/05\/Data-inserted-into-Excel.png 435w, https:\/\/www.zubairalexander.com\/blog\/wp-content\/uploads\/2019\/05\/Data-inserted-into-Excel-263x300.png 263w\" sizes=\"(max-width: 435px) 100vw, 435px\" \/><\/a><\/li>\n<\/ol>\n<p>Check out this video from Microsoft for a preview of this feature.<\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/videoplayer\/embed\/RE2IGfu?pid=ocpVideo0-innerdiv-oneplayer&amp;postJsllMsg=true&amp;maskLevel=20&amp;market=en-us\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" class=\"alignnone size-full wp-image-10880\" src=\"https:\/\/www.zubairalexander.com\/blog\/wp-content\/uploads\/2019\/05\/ms-video.png\" alt=\"Microsoft Video - Insert data from a picture into Excel\" width=\"777\" height=\"443\" srcset=\"https:\/\/www.zubairalexander.com\/blog\/wp-content\/uploads\/2019\/05\/ms-video.png 777w, https:\/\/www.zubairalexander.com\/blog\/wp-content\/uploads\/2019\/05\/ms-video-300x171.png 300w, https:\/\/www.zubairalexander.com\/blog\/wp-content\/uploads\/2019\/05\/ms-video-768x438.png 768w\" sizes=\"(max-width: 777px) 100vw, 777px\" \/><\/a><\/p>\n<table>\n<tbody>\n<tr>\n<td style=\"background-color: #e3e3e3; text-align: left;\">Thanks for reading my article. If you are interested in IT training &amp; consulting services, please reach out to me. Visit <a href=\"https:\/\/www.zubairalexander.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">ZubairAlexander.com<\/a> for information on my professional background.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<hr \/>\n<p><span style=\"font-size: xx-small; font-family: Verdana;\">Copyright \u00a9 2019 <a href=\"https:\/\/www.seattlepro.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">SeattlePro Enterprises, LLC<\/a>. All rights reserved.<br \/>\n<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft is working on a pretty cool feature in Excel. The feature will allow you to insert data from a picture into Excel. According to Microsoft, this feature will work on Excel for iPhone, Excel of Androids, and Excel for Android Tablets. Here&#8217;s how you&#8217;ll be able to turn your picture data into an Excel [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":10873,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[14,43,31,11],"tags":[],"class_list":["post-10870","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-applications","category-articles","category-microsoft-office","category-tips-tricks"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/www.zubairalexander.com\/blog\/wp-content\/uploads\/2019\/05\/Excel_featured_1100x650.png","_links":{"self":[{"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/posts\/10870","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/comments?post=10870"}],"version-history":[{"count":0,"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/posts\/10870\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/media\/10873"}],"wp:attachment":[{"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/media?parent=10870"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/categories?post=10870"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.zubairalexander.com\/blog\/wp-json\/wp\/v2\/tags?post=10870"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}