Import Data from a Picture into Excel Desktop | Convert Image to Data

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

🎬 LINKS to related videos:

🚩Let’s connect on social:

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

[giancarlobuenavidez]

I cannot find the button to import data from an image in excel. Is there anything I need to change in the settings?

[RadarRose]

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.

[andreasmueller-alwart]

Again a very good, comprehensible practical tip. Thank you very much!

[carlheroux]

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!

[Viazm]

Thanks Leila for your great job! It is a great instrument for all of us who works with a data enter!

[Stan_sprinkle]

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

[jennycollihole]

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?

[o.nature]

You put so much effort into your videos. Appreciate it.

[denconstutube]

Thank you. Excellent video. you make it easy to understand and use the feature.

[vijayarjunwadkar]

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! 😁

[gurucool]

Excellent feature in MS Excel. Thank you Laila for detailed information and review

[YouGotUnlucky]

Can’t wait for this feature to be available. Thanks for sharing!

[syarifalqadrisyahrir]

Nice..you explain this feature with amazing video 👍👍👍 thank you so much

[GerhardHolzer]

Thx for that video. Great to have found out the functionality is already existing in the ipad Excel app, too !

[bhardwajism]

Thank you very much, Leila. I have not imagined that excel is now able to bring data from pictures. Great!

[Stepford]

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 :)

[AliensTech]

Crisp and Clear. Thank you for the video..!!

[MasteryAITECH]

thanks leila for your help, i use some of you trucs... in my job and channel education it's so helpful.

[heimoernstweiss]

Great feature - very good presentation, Thank you!

[leiterservices]

OH WOW - I could have used this last night!!!! Thank you for sharing!