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...
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)
- will it put it into the columns for me or do i copy each column for each row and paste