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 way to scan the written notes and have it add it to that years full data log (it has the same columns etc so its just exporting data from handwritten to new log for that entire year
or is there an app for it
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.
