in this Excel video I'm going to show you how to take a photo or a screenshot of data and then import it into Microsoft Excel and convert it into Data that can be used in a spreadsheet let's get started you can see that I have a couple of screenshots of data and I just found this data out on the internet I was surfing the internet took screenshots of it because I wished I could have that data in Excel let's look at how to make that happen here in Microsoft Excel I'm just going to go to the data Tab and I'm going to look for an option called picture from file now in many cases you will see those actual words on the ribbon when you click on the data tab for me though it's just an icon it's right here so I'm just going to click and choose picture from file and Microsoft Excel gives me a pop-up window a dialog box and then I can just navigate my computer to find the picture that I want to turn into a table for me it's here in downloads it's this one here although double click on it and Microsoft Excel is now trying to analyze the data and convert it so that it can import it into Microsoft Excel now at first glance it seems like this worked flawlessly here's the picture and here's the data that's been interpreted now if it's very important that your data be exactly right you will probably need to review this data very carefully but if it's not a life or death situation that you get the data exactly right chances are this is going to be perfectly fine so I'm going to click insert data Excel gives us this notice that we are responsible for validating the accuracy of the data so I click insert data and what once was a photo is now a table of data in Microsoft Excel I can now format this however I would like to I can apply formulas to that data to add up the sum or average or whatever I want to do now unfortunately it's not always quite that smooth of a process let's take another look I'm going to go back to data and click on the picture from file button again this time I'm going to pick a picture I took of the top 10 or 15 NBA shot blockers so here's the picture and you'll notice that this time the results are a little different some of the results came in in pink also I have a review button that's blue I'm going to click on that review button and what it does is it zooms in on the text or data in question so Nick Claxton bkn for Brooklyn Nets Excel just isn't sure that it interpreted that correctly in this case it did so I'll click accept Excel has a question about Brook Lopez as well I'll accept that Miles Turner and Joel embiid and one more Isaiah Jackson Indiana so I'm just clicking accept on all of those because it did interpret them correctly and I'll just click accept insert data once again I get that notice from Excel but I'll go ahead and click in insert data now you'll notice that this time the results even though it came in successfully there are some issues for some reason our first result here was put in the wrong cell so I just clicked on the very edge of the cell and dragged the data into the correct cell and then I can click here on a23 in this case and put in the number one again there are some other flaws in the data and I would have to examine this carefully to make sure that I've got the data right but you can see there's some random numbers in the wrong place and it may or may not be a good idea for me to just delete these but in my case that's what I'm going to do in fact I'm going to use the row numbers by clicking and dragging to select the rows that I want to delete and then I'll just right click delete and then I can just right click on these other row numbers that I want to delete and then just go ahead and delete them so this is a great exciting feature in Microsoft Excel I really like it sometimes it works flawlessly like in this case other times you may need to make some corrections and clean up the data a little bit but I think this is a great feature in Excel that's going to come in handy for a lot of people thanks for watching I hope you found this tutorial to be helpful if you did please like follow And subscribe and when you do click the bell and you'll be notified when I post another video if you'd like to support my channel you can do that by clicking the thanks button below the video or you could support me through my patreon account or by buying Channel merch and you'll see information about those options in the description below the video speaking of patreon I want to give a quick shout out to my five dollar patreon supporters thank you so much for all you do also thank you to my other patreon supporters I appreciate you all so much thank you foreign