Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing scanned data
Hi all
I have a substantial quantity of tabulated data presented in JPEG format from scanned hard copies. The data is typed and "clean". Is there a freebie utility out there that will "OCR" this data into .xls format? I appreciate that it will then need careful checking, but it would still be a lot quicker than typing it all in. Thanks -- Return email address is not as DEEP as it appears |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing scanned data
OK it was probably asking a bit much to find a free converter. Anyone know
of a good value one? "Jack Sheet" wrote in message ... Hi all I have a substantial quantity of tabulated data presented in JPEG format from scanned hard copies. The data is typed and "clean". Is there a freebie utility out there that will "OCR" this data into .xls format? I appreciate that it will then need careful checking, but it would still be a lot quicker than typing it all in. Thanks -- Return email address is not as DEEP as it appears |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing scanned data
Jack
The OCR application is employed at the time of scanning the data and creates a *.txt file or scans directly to a word processing Application like MS Word. The scanner most always comes with the OCR program. You cannot "convert" a jpeg to a a text file that Excel could read. Gord Dibben MS Excel MVP On Mon, 17 Jul 2006 12:25:45 +0100, "Jack Sheet" wrote: OK it was probably asking a bit much to find a free converter. Anyone know of a good value one? "Jack Sheet" wrote in message ... Hi all I have a substantial quantity of tabulated data presented in JPEG format from scanned hard copies. The data is typed and "clean". Is there a freebie utility out there that will "OCR" this data into .xls format? I appreciate that it will then need careful checking, but it would still be a lot quicker than typing it all in. Thanks -- Return email address is not as DEEP as it appears |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing scanned data
I try http://www.shareware.com
and then search for OCR. Maybe you can find something listed in: http://lists.thedatalist.com/ Jack Sheet wrote: Hi all I have a substantial quantity of tabulated data presented in JPEG format from scanned hard copies. The data is typed and "clean". Is there a freebie utility out there that will "OCR" this data into .xls format? I appreciate that it will then need careful checking, but it would still be a lot quicker than typing it all in. Thanks -- Return email address is not as DEEP as it appears -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing scanned data
I have a substantial quantity of tabulated data presented in JPEG
format from scanned hard copies. The data is typed and "clean". Is there a freebie utility out there that will "OCR" this data into .xls format? I appreciate that it will then need careful checking, but it would still be a lot quicker than typing it all in. The scanner most always comes with the OCR program. You cannot "convert" a jpeg to a a text file that Excel could read. I did an experiment. Starting with an Excel file containing a rectangular table of random numbers, I did: <Alt-Print Screen Paste the image into the "Paint" program Trim off the extraneous stuff in Paint. Print from Paint to MS-Office ImageWriter. (To replicate OP's situation, I could've started with a jpeg file and printed to ImageWriter.) In the resulting "Imaging" window, use Tools Send text to Word This made an MS-Word document containing a table. Copy the table and paste it back into a new blank Excel document. In this round-about round trip, only about 80% of the numbers were correct. The problems were primarily recognizing the decimal point. Sometimes it was omitted; other times, a digit next to the decimal point was turned into a letter. Draw your own conclusions. My conclusion is not to rely on ImageWriter's OCR for numerical data. Maybe other OCR programs would be better. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing scanned data
Gord
Thanks, but I don't have the scanner, I am only presented with the scanned data, and this is in jpg format. So at the moment I have no OCR capability at all, except as suggested by MyVeryOwnSelf (which I have not tried yet). I will look around. "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Jack The OCR application is employed at the time of scanning the data and creates a *.txt file or scans directly to a word processing Application like MS Word. The scanner most always comes with the OCR program. You cannot "convert" a jpeg to a a text file that Excel could read. Gord Dibben MS Excel MVP On Mon, 17 Jul 2006 12:25:45 +0100, "Jack Sheet" wrote: OK it was probably asking a bit much to find a free converter. Anyone know of a good value one? "Jack Sheet" wrote in message .. . Hi all I have a substantial quantity of tabulated data presented in JPEG format from scanned hard copies. The data is typed and "clean". Is there a freebie utility out there that will "OCR" this data into .xls format? I appreciate that it will then need careful checking, but it would still be a lot quicker than typing it all in. Thanks -- Return email address is not as DEEP as it appears |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing scanned data
Thanks for the links
"Dave Peterson" wrote in message ... I try http://www.shareware.com and then search for OCR. Maybe you can find something listed in: http://lists.thedatalist.com/ Jack Sheet wrote: Hi all I have a substantial quantity of tabulated data presented in JPEG format from scanned hard copies. The data is typed and "clean". Is there a freebie utility out there that will "OCR" this data into .xls format? I appreciate that it will then need careful checking, but it would still be a lot quicker than typing it all in. Thanks -- Return email address is not as DEEP as it appears -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing scanned data
Thanks for the attempt. I will give it a try.
"MyVeryOwnSelf" wrote in message ... I have a substantial quantity of tabulated data presented in JPEG format from scanned hard copies. The data is typed and "clean". Is there a freebie utility out there that will "OCR" this data into .xls format? I appreciate that it will then need careful checking, but it would still be a lot quicker than typing it all in. The scanner most always comes with the OCR program. You cannot "convert" a jpeg to a a text file that Excel could read. I did an experiment. Starting with an Excel file containing a rectangular table of random numbers, I did: <Alt-Print Screen Paste the image into the "Paint" program Trim off the extraneous stuff in Paint. Print from Paint to MS-Office ImageWriter. (To replicate OP's situation, I could've started with a jpeg file and printed to ImageWriter.) In the resulting "Imaging" window, use Tools Send text to Word This made an MS-Word document containing a table. Copy the table and paste it back into a new blank Excel document. In this round-about round trip, only about 80% of the numbers were correct. The problems were primarily recognizing the decimal point. Sometimes it was omitted; other times, a digit next to the decimal point was turned into a letter. Draw your own conclusions. My conclusion is not to rely on ImageWriter's OCR for numerical data. Maybe other OCR programs would be better. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Importing Data from Access | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Printing data validation scenarios | Excel Worksheet Functions |