 need a quick way to import data stored as an image into Excel. Stay tuned and we'll tell you all about this new update released to Excel. Hello everyone and welcome back to another video. So previously I've experienced this and I'm sure you have as well. You've received a screenshot of a table and what you need to do is now manually enter this data into Excel. Obviously that can be quite a time consuming task. So Microsoft has now released a recent update to Excel which enables you to import the data direct from an image into Excel. So obviously it's gonna save you a lot of time and it's just a lot better way of going about this. So it's a real simple scenario of solutions, shall I say. All we need to do is obviously have the image in question that contains the data we wish to import which for us is a list of results per individual. So with that put aside, all we need to do is go into our desired Excel file or of course you could be using any blank file just to do this import process. And what you'll need to do is along the ribbon top here you need to navigate to the data tab and you'll see there's now this option from picture. So all we're gonna do is click this dropdown and simply go picture from file. You also have the option to go picture from clipboard but we're assuming that you've probably saved that file already to your desktop. So we'll go picture from file and it will open up obviously your explorer and you'll just need to navigate to where the picture is stored. For us it's this one called user results. So what I'm gonna do is select the image itself and click on insert and what will happen you'll see and it sort of did it quite quickly there. It will process obviously your image and depending on the size and obviously the content of it it could take longer or less but for us it was done in a number of seconds and we can see clearly via this preview option down the bottom here that we can scroll through and see there are no errors. So everything is looking as per the image. If there was an error it would be highlighted in red. So this could happen if you've got maybe numbers in like a user ID maybe you've got on those columns. So it might get slightly confused between zeros and the letter O but hopefully you won't have that scenario. If you do like I say it'll be highlighted in red but for us we can see that everything has been captured as desired. All we're gonna do there is simply click on insert data and it says you are responsible for that validating the accuracy of all data. This is obviously just a pop up just to ensure that you are checking because as I mentioned just then issues can happen if there's a complication from reading the file. Again it's probably worth noting that you need to probably have a fairly decent quality of image. You can see the one we're using here is slightly blurred but it's still fairly straightforward about understanding what the letters and characters are. Upon doing our review we can go insert data and you can see it's now being added for us. So we can now obviously perform another review if required but we can see clearly from the limited data we've got that everything has been captured as desired. So what we can do now is obviously copy or move that data and generally interact with it as we would like as we'd expect with data in Excel. So if you enjoyed that video please don't forget to hit the like button. It's not only greatly appreciated by me but it does help that all important YouTube algorithm and ensures that more people are able to find this video. If you've watched our videos before and you're still yet to subscribe please can ask you to hit that subscribe button and also that bell notification button that way you'll be notified of all our videos as they come out in the future. If you do have any questions at all please drop me a comment below this video and I will get back to you as soon as possible. Thank you very much again for watching and we'll see you in the next video.