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?
@Stan_sprinkle
2 жыл бұрын
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
@c17nav
2 жыл бұрын
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.
@RadarRose
2 жыл бұрын
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.
@pegmolter3542
Ай бұрын
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.
@carlheroux777
2 жыл бұрын
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!
@joep9617
2 жыл бұрын
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.
@ilPapu99
2 жыл бұрын
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.
@Viazm
2 жыл бұрын
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.
@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%.
@VeretenoVids
2 жыл бұрын
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!
@DroisKargva
2 жыл бұрын
Pro tip: use Paint to make 3 additional lines. This will help excel to recognize each cell on newspaper.
@ninotsotsoria9788
2 жыл бұрын
წილადებს? ცალ-ცალკე ხომ ვერ ჩამოუვლი...
@DroisKargva
2 жыл бұрын
@@ninotsotsoria9788 ხაზი ჩამოუსვი 25 მაისი რომ აწერია იმის მარცხნივ რო უჯრა გააკეთო. წილადებზე თუ არ ჩანს კარგად წერტილი შეგიძლია დასვა.
@maisaad1432
2 ай бұрын
As always I really enjoy watching your videos
@o.nature
2 жыл бұрын
You put so much effort into your videos. Appreciate it.
@chh8860
2 жыл бұрын
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.
@LeilaGharani
2 жыл бұрын
Thank you 😊 agree pdf data if available is accurate. That way you don’t have to worry about double-checking the numbers.
@chrism9037
2 жыл бұрын
Wow, excellent! Thanks Leila!
@andreasmueller-alwart2517
2 жыл бұрын
Again a very good, comprehensible practical tip. Thank you very much!
@mramsch
2 жыл бұрын
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.
@gurucool80
2 жыл бұрын
Excellent feature in MS Excel. Thank you Laila for detailed information and review
@salvadorperez5488
2 жыл бұрын
Excelent video one more time Leila. Just a question. How could you expand the ribbon? 01:48 Thanks.
@petr6617
2 жыл бұрын
I think - Leila stretched the width of the window across the second monitor
@vijayarjunwadkar
2 жыл бұрын
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! 😁
@LeilaGharani
2 жыл бұрын
🙌 thanks Vijay
@Rice0987
2 жыл бұрын
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! :)
@jennycollihole5004
2 жыл бұрын
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?
@itsthe9216
2 жыл бұрын
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.
@ABG_7
2 жыл бұрын
Nice! I don't have this yet...can't wait to get my hands on it
@billharm6006
2 жыл бұрын
"The first time Mac is ahead of Windows, at least in Excel." Nope. I had an original Mac... the tiny screen thing that I upgraded to 512K and added a 30 meg external hard drive to complement the single, internal, 3 1/2" floppy drive. I also had Excel 1.0 (still have the discs and manuals). Windows didn't exist. The IBM PC running DOS did not even have a version of Excel (Bonus question: What "high price" operating system was offered with the original IBM PC? {Hint: DOS was the low cost option at that time}). Yup... mid 80's stuff. That origin story is not especially meaningful anymore, but your statement kicked off some fun nostalgia. More to the point of the video, YES it will be useful. I often seek out engineering data (usually product specific) from the web. Sometimes it is a simple copy/paste away from being useful. In other cases, an image conversion (currently entirely manual on my time) is needed. I look forward to the general rollout to 365. ...and the answer to the bonus question is...(drum roll).... CP/M-86
@Strodie567
2 жыл бұрын
Correct. Microsoft Excel was introduced in September 1985, as a Mac application. Windows 1.0 was introduced in November of that year. The first version of Excel for Windows was version 2, introduced in 1987. But it was essentially unusable like almost everything on the first two versions of Windows. Windows became actually usable when Windows 3.0 was introduced in 1990, the same year Excel 3.0 was introduced..
@AliensTech
2 жыл бұрын
Crisp and Clear. Thank you for the video..!!
@bhardwajism
2 жыл бұрын
Thank you very much, Leila. I have not imagined that excel is now able to bring data from pictures. Great!
@Viazm
2 жыл бұрын
Thanks Leila for your great job! It is a great instrument for all of us who works with a data enter!
@syarifalqadrisyahrir1401
2 жыл бұрын
Nice..you explain this feature with amazing video 👍👍👍 thank you so much
@GerhardHolzer911
2 жыл бұрын
Thx for that video. Great to have found out the functionality is already existing in the ipad Excel app, too !
@RamaKrishna-zj8fl
2 жыл бұрын
Excellent Leila... Thank you for sharing .
@Stepford
2 жыл бұрын
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 :)
@Alazen.
2 жыл бұрын
Amazing tool for screenshots, didn't know that
@heimoernstweiss8207
2 жыл бұрын
Great feature - very good presentation, Thank you!
@denconstutube
2 жыл бұрын
Thank you. Excellent video. you make it easy to understand and use the feature.
@leiterservices
2 жыл бұрын
OH WOW - I could have used this last night!!!! Thank you for sharing!
@Ticky66MN
2 жыл бұрын
This is exciting. I've tried the app with limited success. This will be much more helpful. Thank you as always.
@LeilaGharani
2 жыл бұрын
Thank you! Glad you like it!
@MP-iw4bw
2 жыл бұрын
Very useful for scan documents as well as very old hard copies.
@berwick666
2 жыл бұрын
Definitely will be using this 👌 thanks Leila
@YouGotUnlucky
2 жыл бұрын
Can’t wait for this feature to be available. Thanks for sharing!
@mariostudio7
2 жыл бұрын
When I read the title I was hoping for Excel to give us the capability to convert raster images into arrays of pixel values based on brightness, contrast etc. Ironically, part of the coding for finding and importing the data is already doing this. Especially now with the dynamic arrays, it would be a game changer if Excel could do this.
@RoyBorgman
2 жыл бұрын
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 :)
@nishanair9781
2 жыл бұрын
Thanks i wanted exactly.i am a sr. Administrative officer and working in central government office and needed this badly
@johnyouseph4038
2 жыл бұрын
Great, thanks for sharing this knowledge 👍
@cimbro9457
2 жыл бұрын
Wow! That dissing roasted at 1:12
@ruudb72
2 жыл бұрын
Nicely demoed. Thanks!
@Entgkar7
2 жыл бұрын
This feature would save me so much time extracting tables from pdf to Excel!
@mramsch
2 жыл бұрын
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?
@MasteryAITECH17
2 жыл бұрын
thanks leila for your help, i use some of you trucs... in my job and channel education it's so helpful.
@shrs.3448
2 жыл бұрын
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.
@sarmadimdad3314
2 жыл бұрын
what version are you using for excel, i cannot find the image option on my excel
@joep9617
2 жыл бұрын
Beta version. I know, once again I am looking for a cool feature that I don't have.
@HasanAhmed-ex6jv
2 жыл бұрын
You read my mind, all I need to do now is wait for the feature TY L.
@shoboyjr
2 жыл бұрын
This is really helpful! Thank you very much Leila
@madhusudanrao600
2 жыл бұрын
Excellent video. It's probably OCR, optical character recognition.
@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.
@anteep4900
2 жыл бұрын
EPIIIIIIIIIIIIIIIIIIIC
@Aditiyan
2 жыл бұрын
Masha'Allah. You are a very intelligent lady. Thanks for all the help
@LeilaGharani
2 жыл бұрын
It's my pleasure
@ismailwayne4392
2 жыл бұрын
You're a darling, Leila!!! This is Sooo awesome!
@LeilaGharani
2 жыл бұрын
Thank you so much!!
@trikk9964
2 жыл бұрын
... looks fantastic!
@sowmivis66
2 жыл бұрын
This is very useful. Thx
@moneymachine100
2 жыл бұрын
Nice book shelf and rubber plant
@gobluekurt
2 жыл бұрын
Awesome, thank you
@nitigya_aswani
2 жыл бұрын
Seriously u saved my alot of time thanks alot
@canirmalchoudhary8173
2 жыл бұрын
Eagerly waiting for this same feature is available in oneNote, so I am using that so far
@vivekluthra21
Жыл бұрын
Thanks! Leila 😊
@davidchow923
2 жыл бұрын
Hi Leila, could you please introduce PDF convert to excel format, and the data is in a cell regularly
@Azhar_Khan383
2 жыл бұрын
Thank You, awesome, you make my work easy.
@GabletzOfGhinletz
2 жыл бұрын
I’m not getting the “Insert from picture” option in my ribbon. Is there something I need to enable?
@albertoleotta6231
Жыл бұрын
Dear Leila why I cannot found the command Picture from File in my menu?
@mazdanaqvy3754
Жыл бұрын
Great feature, Thanks a lot for sharing.
@Kiwi19927
Жыл бұрын
I m looking for a solution to insert an image in EXCEL MAC into a cell. By double clicking the little image I like to raise it big as the screen is. Any solution for that ?
@amateurtorque6709
Жыл бұрын
You could try inserting a comment on the cell. You can then insert a picture to the comment, so when you hover over the cell the comment appears and instead of text you get the desired picture.
@claudesavard8171
Жыл бұрын
Is this feature still in beta mode. I have 365 desktop for Windows and the feature is not there
@j.ballsdeep420
Жыл бұрын
This is in beta for x86 (Mac, iOS, and Android work as those are Excel for ARM). You can currently do this using PowerAutomate and AI Builder pretty easily along with a lot of benefits such as when you receive images regularly being able to upload to a SharePoint hosted workbook. Also, it appears to be far more accurate as I have been getting 100% accurate with none of this manual formatting garbage.
@j.ballsdeep420
Жыл бұрын
3:56 was Ctrl+X btw. Copy would have left that data
@j.ballsdeep420
Жыл бұрын
Furthermore the AI builder works WAY better than this with HTML code, PDF, or web image capture. Frankly this is a really poor tool compared to PowerAutomate
@lets-find-out
11 ай бұрын
Thank you
@j.ballsdeep420
2 жыл бұрын
Damn it, this was the passive aggressive way of punishing someone and manually entering the data. Luckily no one will figure this out for years to come
@LeilaGharani
2 жыл бұрын
😂
@elsayedabdalla1640
2 жыл бұрын
Hi Leila I have Excel Desktop for Office 365 The feature is not avaliable please advice
@malaekafirdous2033
2 жыл бұрын
I can't find the option 'from picture' or 'from clipboard' !
@AlThePal78
2 жыл бұрын
Yo great tutorial :)
@PemberiSolusi
2 жыл бұрын
thank you for this tips
@Grofoca
2 жыл бұрын
Hi, thank you in advance for your response. How you get the tab "from picture" I don't have it in my excel program, I have subscription 365 and I could not find it
@sandrap.3399
2 жыл бұрын
you need the beta insider version
@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"
@Shri_V
2 жыл бұрын
Great tip! Is there a way to copy a bar chart image from Word and have Excel recreate it in the same chart format?
@MrSupernova111
2 жыл бұрын
That's awesome! Thanks!
@tifouraamina1761
2 жыл бұрын
😃 what a great idea. 🤗Liela you're my best 🤩🤩
@onesuperpower
2 жыл бұрын
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?
@mehtaka
2 жыл бұрын
I have microsoft professional 2021 ver. cannot see the data from picture option. can you guide me.?
@pomonoli
Жыл бұрын
Oh shit this is going to save me a lot of time at work.
@c17nav
2 жыл бұрын
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.
@samratpramanick5196
2 жыл бұрын
so help full for me lot's of thanks
@Rickmc1427b
2 жыл бұрын
Great stuff. How did you create the Control Shift S shortcut for the Snipping tool?
@dragonshadow1902
2 жыл бұрын
When moving the revenue numbers you show keyboard shortcut ctrl C. Then when you do the ctrl V the data moved...shouldn't the shortcut been ctrl X?
@Steven_Herrmann
2 жыл бұрын
Yep! Small error but visually we get the idea!
@erikguzik8204
2 жыл бұрын
Love the Feature, but like you Very MIXED results. Doing help files from Facebook, many people do post screen shots, so it's nice to input the data table. The biggest thing i see it NOT getting is when there is a header row Dark Cell color with White text. almost never gets it. Still, Awesome to have this.
@unnikrishnansanthosh
2 жыл бұрын
great one, thanks for sharing
@raj_patel_43
2 жыл бұрын
Subscribed, thanks for this video
@LeilaGharani
2 жыл бұрын
Thanks for the sub!
@bbcao1142
Жыл бұрын
Appreciate so much
@rukshik
2 жыл бұрын
is it available in office 365? i don't see an option under Data tab --> Get Data --> to get from picture..
@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 😘
@AmjadGraphicsDesigner
2 жыл бұрын
Dear madam this option not showing in my office 2022 please solve my problem. Mw wait...
@excelkiclass3424
2 жыл бұрын
which office version u r using bcoz i dont have these option in my office version.?
@PrepareYourBusinessForSale
2 жыл бұрын
KZitem needs a triple thumbs-up feature.
@SaRiiey
10 ай бұрын
I'm using 365 Excel my company, why can't I find those button in my 365 Excel?
@maciejprzepiorka
2 жыл бұрын
Nice feature, but... I was thinking why couldn't they just send you xls file instead of a screenshot? What will be next, sending a video of computer screen recorded on smartphone? :)
Пікірлер: 237