Forum Discussion
can i scan a printed page from a workbook then have the data imported into correct rows of sheet
I have a bunch of years data from a job. i need to get all the data from each time each year we did that job the info has been handwritten onto a print out of the blank excel sheet is there a...
You could use Data | Get Data | From File | From PDF
or if it's a picture:
Data | Geta Data | From Other Sources | From Picture (Not all versions of 365 have this feature)
The above methods will do a quick OCR and allow you to review the data before placing it in the sheet. You might also consider scanning the hard copy to PDF then try to open the PDF directly in Word to see if the conversion is better than Excel. This may be a difficult task with scanned hard copies with hand written information.
will it put the data in the correct columns i want it to go in or does it put it on a new page?
- It's difficult to say. The OCR can be unpredictable. In the very least, you can review the conversion before inserting the data in the sheet.
- i downbloaded microsoft lens and scanned it but how do i move it to excel
The features I mentioned above are available within Excel.
You could use Data | Get Data | From File | From PDF
or if it's a picture:
Data | Geta Data | From Other Sources | From Picture (Not all versions of 365 have this feature)