Stay ahead with our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter
@giancarlobuenavidez9723 Жыл бұрын
I cannot find the button to import data from an image in excel. Is there anything I need to change in the settings?
@pegmolter35423 күн бұрын
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.
@RadarRose2 жыл бұрын
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.
@Stan_sprinkle2 жыл бұрын
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
@c17nav2 жыл бұрын
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.
@carlheroux777 Жыл бұрын
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!
@o.nature2 жыл бұрын
You put so much effort into your videos. Appreciate it.
@andreasmueller-alwart25172 жыл бұрын
Again a very good, comprehensible practical tip. Thank you very much!
@Viazm2 жыл бұрын
Thanks Leila for your great job! It is a great instrument for all of us who works with a data enter!
@YouGotUnlucky2 жыл бұрын
Can’t wait for this feature to be available. Thanks for sharing!
@bhardwajism2 жыл бұрын
Thank you very much, Leila. I have not imagined that excel is now able to bring data from pictures. Great!
@AliensTech2 жыл бұрын
Crisp and Clear. Thank you for the video..!!
@denconstutube2 жыл бұрын
Thank you. Excellent video. you make it easy to understand and use the feature.
@chrism90372 жыл бұрын
Wow, excellent! Thanks Leila!
@gurucool802 жыл бұрын
Excellent feature in MS Excel. Thank you Laila for detailed information and review
@Stepford2 жыл бұрын
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 :)
@maisaad143229 күн бұрын
As always I really enjoy watching your videos
@leiterservices2 жыл бұрын
OH WOW - I could have used this last night!!!! Thank you for sharing!
@GerhardHolzer9112 жыл бұрын
Thx for that video. Great to have found out the functionality is already existing in the ipad Excel app, too !
@RamaKrishna-zj8fl2 жыл бұрын
Excellent Leila... Thank you for sharing .
@vijayarjunwadkar2 жыл бұрын
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! 😁
@LeilaGharani2 жыл бұрын
🙌 thanks Vijay
@heimoernstweiss82072 жыл бұрын
Great feature - very good presentation, Thank you!
@ruudb722 жыл бұрын
Nicely demoed. Thanks!
@berwick6662 жыл бұрын
Definitely will be using this 👌 thanks Leila
@syarifalqadrisyahrir14012 жыл бұрын
Nice..you explain this feature with amazing video 👍👍👍 thank you so much
@shoboyjr2 жыл бұрын
This is really helpful! Thank you very much Leila
@jennycollihole5004 Жыл бұрын
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?
@shrs.34482 жыл бұрын
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.
@MasteryAITECH172 жыл бұрын
thanks leila for your help, i use some of you trucs... in my job and channel education it's so helpful.
@johnyouseph40382 жыл бұрын
Great, thanks for sharing this knowledge 👍
@ABG_72 жыл бұрын
Nice! I don't have this yet...can't wait to get my hands on it
@Ticky66MN2 жыл бұрын
This is exciting. I've tried the app with limited success. This will be much more helpful. Thank you as always.
@LeilaGharani2 жыл бұрын
Thank you! Glad you like it!
@sowmivis662 жыл бұрын
This is very useful. Thx
@Azhar_Khan3832 жыл бұрын
Thank You, awesome, you make my work easy.
@mazdanaqvy3754 Жыл бұрын
Great feature, Thanks a lot for sharing.
@gobluekurt2 жыл бұрын
Awesome, thank you
@MrSupernova1112 жыл бұрын
That's awesome! Thanks!
@user-vm4jx5jw4m Жыл бұрын
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%.
@VeretenoVids2 жыл бұрын
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!
@c17nav2 жыл бұрын
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.
@tifouraamina17612 жыл бұрын
😃 what a great idea. 🤗Liela you're my best 🤩🤩
@MP-iw4bw2 жыл бұрын
Very useful for scan documents as well as very old hard copies.
@trikk9964 Жыл бұрын
... looks fantastic!
@HasanAhmed-ex6jv2 жыл бұрын
You read my mind, all I need to do now is wait for the feature TY L.
@vivekluthra21 Жыл бұрын
Thanks! Leila 😊
@unnikrishnansanthosh2 жыл бұрын
great one, thanks for sharing
@nitigya_aswani Жыл бұрын
Seriously u saved my alot of time thanks alot
@bbcao1142 Жыл бұрын
Appreciate so much
@PemberiSolusi2 жыл бұрын
thank you for this tips
@AlThePal782 жыл бұрын
Yo great tutorial :)
@samratpramanick51962 жыл бұрын
so help full for me lot's of thanks
@raj_patel_432 жыл бұрын
Subscribed, thanks for this video
@LeilaGharani2 жыл бұрын
Thanks for the sub!
@Alazen.2 жыл бұрын
Amazing tool for screenshots, didn't know that
@kasberrr363 Жыл бұрын
شكرا لك ... ممتاز جدا
@Rice09872 жыл бұрын
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! :)
@lets-find-out10 ай бұрын
Thank you
@joep96172 жыл бұрын
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.
@ilPapu992 жыл бұрын
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.
@Viazm2 жыл бұрын
It was the first thing that I thought to!
@muhammadfaizan1863 Жыл бұрын
@@ilPapu99 do tell which version should we use to avail this feature of data from picture?
@ilPapu99 Жыл бұрын
@@muhammadfaizan1863 you can use something like Krita to adjust levels.
@mohammedbatheri7062 жыл бұрын
Very helpful
@anteep49002 жыл бұрын
EPIIIIIIIIIIIIIIIIIIIC
@ronrogerson154 Жыл бұрын
Thank you so much! Saved me a ton of time!
@LeilaGharani Жыл бұрын
Glad it was helpful!
@chadh9688 Жыл бұрын
@@LeilaGharani why does this no longer work? The "Data from Picture" button is greyed out and cannot be clicked"
@nishanair9781 Жыл бұрын
Thanks i wanted exactly.i am a sr. Administrative officer and working in central government office and needed this badly
@onesuperpower2 жыл бұрын
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?
@ismailwayne43922 жыл бұрын
You're a darling, Leila!!! This is Sooo awesome!
@LeilaGharani2 жыл бұрын
Thank you so much!!
@patrickpointer83802 жыл бұрын
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?
@madhusudanrao6002 жыл бұрын
Excellent video. It's probably OCR, optical character recognition.
@Shri_V2 жыл бұрын
Great tip! Is there a way to copy a bar chart image from Word and have Excel recreate it in the same chart format?
@awilliams27922 жыл бұрын
Another Good Video
@farisalhaboubi4048 Жыл бұрын
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 😘
@moneymachine1002 жыл бұрын
Nice book shelf and rubber plant
@aq22372 жыл бұрын
Useful 👍
@itsthe92162 жыл бұрын
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.
@khayalhajiyev87792 жыл бұрын
I love you so much ❤❤❤
@fantamadydoumbouya1526 Жыл бұрын
One word is enough, thanks
@Entgkar72 жыл бұрын
This feature would save me so much time extracting tables from pdf to Excel!
@mramsch2 жыл бұрын
Except when your PDF files actually only contain pixel images, the better way probably is Excel's 'Import form PDF' directly. Does this not work for you?
@canirmalchoudhary81732 жыл бұрын
Eagerly waiting for this same feature is available in oneNote, so I am using that so far
@pakarsolidworks78210 ай бұрын
thanks
@edbecke2 жыл бұрын
Another great video, Leila! Please tell us how you included the animated image in your email. Please...
@chh88602 жыл бұрын
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.
@LeilaGharani2 жыл бұрын
Thank you 😊 agree pdf data if available is accurate. That way you don’t have to worry about double-checking the numbers.
@Rickmc1427b2 жыл бұрын
Great stuff. How did you create the Control Shift S shortcut for the Snipping tool?
@dharmmu2 жыл бұрын
Great..it's new..👍
@RoyBorgman2 жыл бұрын
Off topic: pretty sure that’s a picture of Lago di Braies (Pragser Wildsee) on your wall! Been there twice, awesome place, a must see when you visit the Dolomites :)
@excelangola27272 жыл бұрын
Amazing
@pomonoli Жыл бұрын
Oh shit this is going to save me a lot of time at work.
@Aditiyan2 жыл бұрын
Masha'Allah. You are a very intelligent lady. Thanks for all the help
@LeilaGharani2 жыл бұрын
It's my pleasure
@salvadorperez54882 жыл бұрын
Excelent video one more time Leila. Just a question. How could you expand the ribbon? 01:48 Thanks.
@petr66172 жыл бұрын
I think - Leila stretched the width of the window across the second monitor
@zzota2 жыл бұрын
Cool feature.
@TheLunaSoleada2 жыл бұрын
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?
@Gaminiheraliyawala Жыл бұрын
Hi Leila, your tutorials have always been excellent and highly professional. But, to try this lesson I don't find "Picture From File" in my DATA tab, May I know whether I got to make a setting? Appreciate your advice.
@lr8556 Жыл бұрын
Check your license. I do not have the option in my ribbon in MS Office Professional Plus 2019, but when I open my Office 365, I have the button in my ribbon. This appears to only be available in 365.
@mehtaka Жыл бұрын
I have microsoft professional 2021 ver. cannot see the data from picture option. can you guide me.?
@rukshik2 жыл бұрын
is it available in office 365? i don't see an option under Data tab --> Get Data --> to get from picture..
@excelkiclass3424 Жыл бұрын
which office version u r using bcoz i dont have these option in my office version.?
@nofarturgeman539 Жыл бұрын
hi Leila, does it works with Google sheet as well? I couldn't find it. thank you!
@dremztheprophet2419 Жыл бұрын
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
@ianmross12 жыл бұрын
Hi Leila do you know if I can change the font colour of a file in windows 11
@elsayedabdalla16402 жыл бұрын
Hi Leila I have Excel Desktop for Office 365 The feature is not avaliable please advice
@samuel97ification2 жыл бұрын
Do you know how to use Excel cubes for data analysis, creating tables, updating data?
@mramsch2 жыл бұрын
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.
@Traveldaily11 Жыл бұрын
what is your excel version? I can not file this icon in may excel query version 2021
@abbott100 Жыл бұрын
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.
@AmjadGraphicsDesigner Жыл бұрын
Dear madam this option not showing in my office 2022 please solve my problem. Mw wait...