From picture to Excel data, and handling issues
Excel has a new feature allowing you to convert a picture of a table to an Excel table (from image to Excel), which has many use cases. I go through how to do it (use a screenshot with Win Shift S for best results), then insert it from the Data Tab. If you have issues with Excel not recognizing borders, or misinterpreting numbers, dates or more check out my video. I also show how to use it with Power BI that has a very long laborious way to extract data from a Power BI visual to Excel.
Example files can be found here: www.xlconsulting-asia.com/youtube-files
Watch this for more info on getting pdf & more complex images to Excel: • Extract images & PDFs to Excel (singl...
To subscribe to Solve & Excel's monthly newsletter with Excel enhancements and more, click here: https://solveandexcel.ca/excel_news/
00:00 - Introduction
02:36 - Convert Power BI data
03:23 - Combining text values
05:01 - Highlight what isn't a number
06:04 - Change image contrast
06:50 - Add custom lines to picture
07:26 - Dates
08:51 - Check version for feature
09:38 - Complex poor quality image