Helping people with computers... one answer at a time.
Read the article that everyone's commenting on.
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
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?
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.
now i have to check if my scanner came with ocr, thanks for the tip..
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!
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.
how do i scan a document into my computer?
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..
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.
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.
Question? Ask Leo!
The Tip Jar: Buy Leo a Latte!
By Date |
Business Card |
Advertisements do not imply my endorsement of any product or service.
Copyright © 2003-2013 Puget Sound Software, LLC and Leo A. Notenboom
Ask Leo! is a registered trademark ® of Puget Sound Software, LLC
Terms, Conditions & Privacy
Product Reviews, Recommendations and Affiliate Links Disclosure