Character Optic Recognition: Convert Excel Data in an Image to an actual Excel file

[NewJerichoMan]

I have been provided with 45 images of an Excel rent roll that I'd love to convert to an actual Excel file with 45 pages.
"Get data" from picture hasn't worked.
Any ideas?

 

[Bosquedeguate]

do you have Adobe Acrobat? (Not the free reader). You could try opening the file with Acrobat, then to an OCR conversion.

or there appears to be several free websites that will do an OCR conversion.

You problem will be 1) cleaning up the converted data; 2) parsing the data for your worksheet(s).

Is this image file the only way you can recevie this data? Can you get it as a readable PDF?

 

[NewJerichoMan]

do you have Adobe Acrobat? (Not the free reader). You could try opening the file with Acrobat, then to an OCR conversion.

or there appears to be several free websites that will do an OCR conversion.

You problem will be 1) cleaning up the converted data; 2) parsing the data for your worksheet(s).

Is this image file the only way you can recevie this data? Can you get it as a readable PDF?

Have access to Adobe Acrobat. I received the files as images inside a Word doc. Converted Word doc to PDF. Free PDF converters only bring it into Excel as an image.

It's just fuzzy enough for OCR to NOT be able to "grab" it.

 

[Bosquedeguate]

Have access to Adobe Acrobat. I received the files as images inside a Word doc. Converted Word doc to PDF. Free PDF converters only bring it into Excel as an image.

It's just fuzzy enough for OCR to NOT be able to "grab" it.

I tried doing an OCR conversion with Arcobat and had the same problems. Also, the CONFIDENTIAL watermark on the page will create problems.
You need find a better image if you hope to successfully do OCR with the data. Even if you could successfully do the OCR there will be many misreads and bad values from the OCR. (Just my experience with working with scanned text.)

 

[alansidman]

Once you have it in PDF format, have you tried importing to Excel with Power Query (Get and Transform Data) found on the Data Tab.

 

[NewJerichoMan]

Once you have it in PDF format, have you tried importing to Excel with Power Query (Get and Transform Data) found on the Data Tab.

No dice. It's just fuzzy enough to make it undoable. The watermark is probably causing problems as well. Lobbied the attorneys several times to get it out but they say it is what it is.