Microsoft Excel on Windows will soon import data from photos
Many applications can already read and sort data from photos and document scans using optical character recognition, and soon this functionality will be available in Excel for Windows.
Microsoft has a “Data from Picture” feature in Excel for Mac, as well as the iPhone and Android apps, that lets you scan a document (like a receipt or a screenshot of a spreadsheet from a website) and put the results into an Excel spreadsheet. However, the option is not available on Excel for Windows.
Microsoft is now beginning to test image data in Excel for Windows with Office Insiders testers, starting with Beta Channel 2208 (Build 15402.20002). The option is available by clicking the Data tab in the ribbon bar and then clicking “From Image” in the ribbon. You can import an image from your clipboard or local files – there is no option to take a new photo and scan it immediately (for PCs with rear-facing cameras), du least not yet.
After you import an image, Excel analyzes it and tries to convert the results into rows of data. You can review the results afterwards, and if everything looks good, the new data will be added to the current document.
Microsoft says the image data only works with text written in English, Bosnian, Croatian, Czech, Danish, Dutch, Finnish, French, German, Hungarian, Italian, Norwegian, Polish, Portuguese, Romanian, Serbian, Slovak, Slovenian, Spanish, Swedish, and Turkish. The feature is also still limited to Office Insiders testers, but if no significant bugs are found, it could soon be rolling out to everyone with Microsoft 365.
Source: Office Insider