ABBYY Finereader Professional Edition (I have used v8) makes a good job of scanning and converting columnar data automatically into Excel format where the rows and columns are well defined (ie with horizontal/vertical lines in the original document). If they are not well defined the software enables you to put in "separators" yourself - something that can be done quite quickly. You can also load .pdf documents into it, OCR them and also output to Excel format. However, regardless of the source, once loaded in Excel all numbers are treated as text and use of one of Excel's text to number features is necessary to convert the numerical information into numbers.
Hope this helps
Robert Sorem
August 1, 2008 11:53 AM
I am interested in David's comment on3/23/07. I want to scan an Excel document with vert. and horiz. data that is calculated by formulae in the document. Will the scanned in document include the fomulae?
y
January 22, 2009 10:53 AM
Robert, man that takes the cake. and the pie too. thanks for making my day. And will send you a new cupholder for your terminal.
roland m
February 12, 2009 6:19 AM
now i have to check if my scanner came with ocr, thanks for the tip..
Gary
February 14, 2009 2:49 PM
I had a Excel spreadsheet that I had printed out years ago but I couldn't find the file on my computer. I did have a copy of the printout and I just tried using ABBYY "Scan to Office" program and it worked great! It's a lot cheaper than the ABBYY Finereader Professional, too!
Guaro
October 19, 2009 10:49 PM
Another tip I have used successfully is to draw the vertical lines with a ruler and a pen in the document (the original or a copy). Then, after scanning it into word it is easily recognizable as a table, and then you can paste it into excel.
Alva Lichtenstein
January 5, 2010 12:51 PM
how do i scan a document into my computer?
TONI KLEMKO
March 31, 2010 12:03 PM
Abbyy Scan to Office is a great little program but you are not able to buy it anywhere. Abbyy in their wisdom have discontinued a perfectly usable program for everyday people and have replaced it with another program that does not have a trial period and cost $50 more..
wonderhowto
August 22, 2010 7:58 PM
OCR softwares are everywhere nowadays. I prefer online ones they don't need installation and most of them are free, like this one: Free OCR.
Nayandeep
January 21, 2011 6:44 AM
i have tiff image and fonts are in French script Mt and i tried so many software. can u help me.
Comments
Read the article that everyone's commenting on.
March 23, 2007 10:38 PM
ABBYY Finereader Professional Edition (I have used v8) makes a good job of scanning and converting columnar data automatically into Excel format where the rows and columns are well defined (ie with horizontal/vertical lines in the original document). If they are not well defined the software enables you to put in "separators" yourself - something that can be done quite quickly. You can also load .pdf documents into it, OCR them and also output to Excel format. However, regardless of the source, once loaded in Excel all numbers are treated as text and use of one of Excel's text to number features is necessary to convert the numerical information into numbers.
Hope this helps
August 1, 2008 11:53 AM
I am interested in David's comment on3/23/07. I want to scan an Excel document with vert. and horiz. data that is calculated by formulae in the document. Will the scanned in document include the fomulae?
January 22, 2009 10:53 AM
Robert, man that takes the cake. and the pie too. thanks for making my day. And will send you a new cupholder for your terminal.
February 12, 2009 6:19 AM
now i have to check if my scanner came with ocr, thanks for the tip..
February 14, 2009 2:49 PM
I had a Excel spreadsheet that I had printed out years ago but I couldn't find the file on my computer. I did have a copy of the printout and I just tried using ABBYY "Scan to Office" program and it worked great! It's a lot cheaper than the ABBYY Finereader Professional, too!
October 19, 2009 10:49 PM
Another tip I have used successfully is to draw the vertical lines with a ruler and a pen in the document (the original or a copy). Then, after scanning it into word it is easily recognizable as a table, and then you can paste it into excel.
January 5, 2010 12:51 PM
how do i scan a document into my computer?
March 31, 2010 12:03 PM
Abbyy Scan to Office is a great little program but you are not able to buy it anywhere. Abbyy in their wisdom have discontinued a perfectly usable program for everyday people and have replaced it with another program that does not have a trial period and cost $50 more..
August 22, 2010 7:58 PM
OCR softwares are everywhere nowadays. I prefer online ones they don't need installation and most of them are free, like this one: Free OCR.
January 21, 2011 6:44 AM
i have tiff image and fonts are in French script Mt and i tried so many software. can u help me.
To post a comment on "How do I scan a document into Excel?", please return to that article's main page.