[ad_1]
You have a desk on paper however want the information listed in Excel? Fortunately, there’s a easy trick for importing information on bodily papers (or some other photographs) into Excel spreadsheets.
Take your smartphone and take a photograph of the information, then ship the photograph to your PC by way of e-mail, OneDrive, flash drive, or some other method. Once the image is in your PC, open Excel, choose the Data tab after which the command From Picture > Picture from File from the “Retrieve and Transform Data” space.
Step 1 when importing information into Excel by photograph is to take a photograph of the desk. It is healthier to not embrace surrounding textual content. The picture part on this instance is simply too massive.
IDG
Select the photograph you have got simply taken. presto!
Excel carries out textual content recognition and shows the information discovered within the right-hand aspect of your spreadsheet. There you possibly can examine the information or insert it immediately into the spreadsheet.
Step 2 when importing information is the command “Data -‘ From Picture -‘ Picture from File”. On the precise aspect you possibly can examine the information earlier than importing or insert it immediately into the spreadsheet.
IDG
This article was translated from German to English and initially appeared on pcwelt.de.
[adinserter block=”4″]
[ad_2]
Source link