scanning data into excel

R

Rick

I am just curious if it is possible using a scanner, to scan data int
excel. I am open for all options...would it be easier to scan to
text document, and then import to excel? But if anyone can tell me i
its possible and how to do it with just excel that would be super!!
thank
 
P

Peo Sjoblom

It's hard to tell you how to do it without knowing the scanner/OCR software
you have. I can do it either way with my software. Either text file
importing into excel or save as excel file.. I use paperport deluxe 9.0 and
abby fine reader pro.
Both programs can do it. Of course with all OCR software you are bound to
get mistakes (sometimes very funny ones)
 
D

David McRitchie

Hi Rick,
The software that you have may include TextBridge which is
also now owned along with PaperPort by ScanSoft. I've received
both of them with on of my scanners. The additional
software may or may not install automatically so you should look
at the CD that came with the scanner. TextBridge will scan as a
speadsheet, the best results I had were the 2nd time I used it,
fiddling with contrast and brightness can also affect the quality
of the scan.

I think my version of PaperPort specifies a that the scan must be 200 to
400 dpi if you want to use a scanned file. It is very important to put
the sheet is perfectly straight relative to the printing on the page.
The use of a spell checker and some macros found on my
Reformatting web page may help with the errant data
http://www.mvps.org/dmcritchie/excel/join.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Peo Sjoblom said:
It's hard to tell you how to do it without knowing the scanner/OCR software
you have. I can do it either way with my software. Either text file
importing into excel or save as excel file.. I use paperport deluxe 9.0 and
abby fine reader pro.
Both programs can do it. Of course with all OCR software you are bound to
get mistakes (sometimes very funny ones)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top