Import Data from a Picture into Excel Desktop | Convert Image to Data
Vložit
- čas přidán 29. 07. 2024
- Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
In this video, we explore a fantastic new feature in Excel Desktop - the ability to import data directly from pictures! Previously, you could just do this in the Office app. This tool can be a game-changer for Excel users, offering a simple way to digitize data from various sources like screenshots, websites, and even newspaper photos.
🔍 What's Inside:
▪️ Use Cases: We dive into practical scenarios where this feature shines, such as dealing with sensitive data in screenshots and extracting data from websites where traditional methods like Power Query fall short.
▪️ Step-by-Step Guide: Follow a detailed walkthrough on how to use this feature, from accessing it in Excel's Data tab to inserting and reviewing the imported data.
▪️ Real-Life Tests: Witness the feature in action with diverse examples, including a student's spreadsheet screenshot, Fortune Global 500 list data from a website, and a challenging newspaper photo.
▪️ Honest Review: I share my firsthand experience with the feature's current performance, highlighting its strengths and areas for improvement.
With the NEW Data from Picture feature in Excel for Windows, you can now convert an image of text & numbers into a worksheet. This could be a photo from a newspaper, a screenshot from a website or a jpg file. It's also a great trick when you can't use Power Query to get data from a website because the table isn't an html table. You could just grab a screen capture and import it in Excel desktop using the new "data from picture" feature. In this video I'll show you how it works and how well it gets the job done.
00:00 Import Data from Picture in Excel for Windows
01:16 Import Data from Screenshot
04:21 Import Data from Website
06:28 Import Data from Picture
08:21 Wrap Up
🌍 My Online Courses ► www.xelplus.com/courses/
🎬 LINKS to related videos:
Convert Image to Word or Excel - Office Mobile App: • How To Convert Image t...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel #office365
Stay ahead with our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter
I cannot find the button to import data from an image in excel. Is there anything I need to change in the settings?
I couldn't believe what I was reading when I saw this. Had to test it for myself since I've done so much manual entry and have been waiting for a better way. Phenomenal! With some data that didn't import well, like your darkened old fax-type image, I just had Excel "speak cells" to me as I proofed it to the original data from the Web. Not perfect, but a fantastic addition! Thank you for bringing it to us in your usual thorough and understandable way.
Again a very good, comprehensible practical tip. Thank you very much!
The first two methods are definitely valuable/useful. The third - with a numeric keypad, I could enter the data faster than I could verify and correct. Thanks for demonstrating.
As always I really enjoy watching your videos
I used this last week and it was brilliant. Took a screenshot of a table of data in a PowerPoint slide that was being presented to me over via Teams. Worked perfectly
There's an exceptional alternative to using a screenshot of a PowerPoint slide, if you can obtain the PowerPoint source file.
1. If the source file is not a .pptx file, it may need conversion to a .pptx type.
2. Change the source file's extension from .pptx to .zip.
3. Unzip the .zip file to create a new directory. The new directory will contain several subdirectories.
4. Open the new directory and browse the subdirectories. One will have the original image, spreadsheet, document, etc. file that was used in the PowerPoint.
If the file is a spreadsheet, most of the process is regular Excel operations. Other file types may need more extensive operations. Notably, images - possibly in better resolution than a screen capture - could be cropped or edited to remove extraneous data before Excel's new convert feature is used.
Thanks Leila for your great job! It is a great instrument for all of us who works with a data enter!
I tried with a grocery receipt because I was looking for a way to import those receipts to excel to track my expenses but also getting the item details to track categories aswell and not just the total. It surprisingly worked great!
Thank you. Excellent video. you make it easy to understand and use the feature.
You put so much effort into your videos. Appreciate it.
Wow, excellent! Thanks Leila!
Can’t wait for this feature to be available. Thanks for sharing!
Definitely will be using this 👌 thanks Leila
Great feature for sure! Thanks Leila for the useful demo! Waiting for availability soon, but wish it should have come much before, when I needed it most! 😁
🙌 thanks Vijay
Nicely demoed. Thanks!
Excellent feature in MS Excel. Thank you Laila for detailed information and review
Excellent Leila... Thank you for sharing
.
OH WOW - I could have used this last night!!!! Thank you for sharing!
Great feature - very good presentation, Thank you!
Crisp and Clear. Thank you for the video..!!
Nice..you explain this feature with amazing video 👍👍👍 thank you so much
Thx for that video. Great to have found out the functionality is already existing in the ipad Excel app, too !
This is really helpful! Thank you very much Leila
Awesome, thank you
Great, thanks for sharing this knowledge 👍
thanks leila for your help, i use some of you trucs... in my job and channel education it's so helpful.
Thank you very much, Leila. I have not imagined that excel is now able to bring data from pictures. Great!
Thank You, awesome, you make my work easy.
That's awesome! Thanks!
I love your videos Leila, they make so much sense. I always look for your videos first before any of the others.
Can someone maybe give me a timeline on when the features (especially for #1 - Screenshots) will be available? Has an announcement been made yet?
Great feature, Thanks a lot for sharing.
Hi Leila, I love your channel!
Is there any way this can be used to pick up the meta data from a photograph? Time & Date , location from the cameras GPS values and are all sorted with the picture?
Some great tips as usual Leila! Hopefully I won't need to wait too long until this is available to me :)
Love your new hair colour by the way :)
This is very useful. Thx
Nice! I don't have this yet...can't wait to get my hands on it
Thanks! Leila 😊
great one, thanks for sharing
Thank you, thank you and thank you.
I didnt know Excel has this feature - it could be a game changer for me as it will save lots of time - this is a keeper.
Very useful for scan documents as well as very old hard copies.
Seriously u saved my alot of time thanks alot
Appreciate so much
Nice tool. I look forward to the general release. For a long time, I've used a more involved process that uses features of Paint, Adobe Acrobat, and sometimes Word.
Thank you
so help full for me
lot's of thanks
... looks fantastic!
thank you for this tips
شكرا لك ... ممتاز جدا
This is exciting. I've tried the app with limited success. This will be much more helpful. Thank you as always.
Thank you! Glad you like it!
In scenario #2, it could be done by pasting the web data to Notepad, then save it as txt format, then import the file in Excel. This way, the data accuracy should be 100%.
I giggled a little bit when I saw the newspaper results. In my prior job we did a lot of cleaning up of these kinds of data captures (via OCR software) and the decimal points were always a problem. (We always worked to improve the image as much as possible.) We always knew we were going to have to check them. I won't even get into the 1, l, i problems. Still remarkable to have this kind of thing rather than having to type it all from scratch!
thanks
😃 what a great idea. 🤗Liela you're my best 🤩🤩
You read my mind, all I need to do now is wait for the feature TY L.
Very helpful
Great stuff. How did you create the Control Shift S shortcut for the Snipping tool?
Great tip! Is there a way to copy a bar chart image from Word and have Excel recreate it in the same chart format?
Subscribed, thanks for this video
Thanks for the sub!
Amazing tool for screenshots, didn't know that
Hi thanks for sharing the all the great info. 1 Quick question may be you can consider this one for you next video :) How can we split multiple worksheets in a spreadsheet to separate spreadsheets without losing or creating duplicates?
I'll try fine pics, and in case Sheet3 I think first you need to clarify the image then try to ocr it into excel, otherwise I'll retype it manually, it will be faster than check each number.
Thanks for hint Leyla! :)
Yo great tutorial :)
Hi Leila,
Thank you so much for the useful content you always share 😍
Do you know when this should be released? I tried to look for the info in Microsoft website but couldn't find anything,,, appreciate if you can share a link from the website as well 😘
Excellent video. It's probably OCR, optical character recognition.
Thank you so much! Saved me a ton of time!
Glad it was helpful!
@@LeilaGharani why does this no longer work? The "Data from Picture" button is greyed out and cannot be clicked"
Nice book shelf and rubber plant
Useful 👍
Another Good Video
Hi Leila, on your second example, I see you Ctr + Shift + S, it’s not working on my end, how can I make this work? Also, what happens if you don’t have the option to import data from a picture? Is there a way access that in Excel settings?
Hi Leila do you know if I can change the font colour of a file in windows 11
At the 8:42 mark " ... what do you think? Is it going to be useful to you? Prehaps to digitize old tax returns? ..."
Brilliant idea ... but I think I would only use it in 'one-off' situations. I would much prefer importing 'pdf' data (which I think you covered about a year ago). But once again ... I only learn about these features from Prof Leila ... thank you ... thank you ... thank you.
Thank you 😊 agree pdf data if available is accurate. That way you don’t have to worry about double-checking the numbers.
One word is enough, thanks
This looks good still not coming up on my 365 yet, but I have been using copy paste unified text for years and that seems less complicated than picture to data and it is accurate.
Another great video, Leila! Please tell us how you included the animated image in your email. Please...
You're a darling, Leila!!! This is Sooo awesome!
Thank you so much!!
Hi Leila, loving the channel. Just wondering if you can help. I have the latest version of 365 but for some reason on my `Data Tab` the get data by picture option isn`t there?? I have checked a couple of forums and nobody seems to be able to shed any light on this situation. Any help would be much appreciated.
Do you know how to use Excel cubes for data analysis, creating tables, updating data?
In the last example, tweaking the image just a bit beforehand will help greatly.
An app like Genius Scan to straighten and convert to black & white will work wonders with Excel's OCR.
Sadly, our version of Excel doesn't have this feature, yet.
i second this comment. a bit of quick image processing and you could drastically improve the import quality. simple levels adjust would do the trick here.
It was the first thing that I thought to!
@@ilPapu99 do tell which version should we use to avail this feature of data from picture?
@@muhammadfaizan1863 you can use something like Krita to adjust levels.
Is there a way we can classify/ categorize outlook emails using power automate
Amazing
Eagerly waiting for this same feature is available in oneNote, so I am using that so far
I have microsoft professional 2021 ver. cannot see the data from picture option. can you guide me.?
Cool feature.
Thanks i wanted exactly.i am a sr. Administrative officer and working in central government office and needed this badly
hi Leila, does it works with Google sheet as well? I couldn't find it. thank you!
May insert picture option is greyed out all the the other picture option located on ribbon to far left ,, it worked fine , mine when open , on. The “get data “ section right next to it say power query 16. 72 excel not sure if it’s the wrong format but i need access again to the inser option
I’m not getting the “Insert from picture” option in my ribbon. Is there something I need to enable?
Dear Leila why I cannot found the command Picture from File in my menu?
I'd like to get the Michelin Star list downloaded (from pictures and restaurant names) to just the restaurants names in an excel list but having issues? Any advice?
Hi Ma'am, I have a question. How can we copy paste a data which has data+images.??
If we are working in one Excel and there is data+ images ( just like BOQ or quotation) so how can we copy or paste the some data ? Because sometimes what happens that the images do not copy well in format. So need solution please.
Great..it's new..👍
Excelent video one more time Leila. Just a question. How could you expand the ribbon?
01:48
Thanks.
I think - Leila stretched the width of the window across the second monitor
EPIIIIIIIIIIIIIIIIIIIC
The icon Picture from File/Clipboard is missing on Excel 365 for Windows - any help how to activate it? thanks in advance
Is it possible in excel to select blank cells of all the work sheets to hide them in one go.
Hi Leila. I hope you are good. Can i ask you 1 question ? which version of ms office got this new feature? I have got office 2013 and i can't see it data tab.
Regards
maqsood
I have another tip, if you want to copy data-in optically tabular form-from a web page and then pasting into Word or Excel does not retain that tabular arrangement:
LibreOffice!
Not joking! 😃I'm using Mircosoft Office and Excel normally, but keep LibreOffice installed as a utility for some special cases.
And the LibreOffice Writer is much better in preserving the layout at Copy & Paste from web pages. Next step is simply a new copy in Writer and then paste into Word or Excel. That has helped me so many times already.
BTW, there is another problem where LibreOffice really does help: importing CSV files where fields contain multi-line text! Excel simply can't handle such multi-line cell content correctly. Just open such a CSV file with LibreOffice Calc, the save in Excel format-and the data is ready to be further processed with Excel.
Hope, that helps somebody to save time and effort.
I love you so much ❤❤❤
Please ma, I have office 365 E5 version but the is not found in Excel. Which version of Excel that have it?
Hi Leila
I have Excel Desktop for Office 365
The feature is not avaliable
please advice