HI anyone,
Is it possible to convert a scanned document image into a excel sheet?
Any help on this would be kindly appreciated.
Thanks in advance.
Scanned Document Into Excel Sheet
-
- SilverLounger
- Posts: 2347
- Joined: 23 Feb 2010, 12:07
Scanned Document Into Excel Sheet
Best Regards,
Adam
Adam
-
- Administrator
- Posts: 7210
- Joined: 15 Jan 2010, 22:52
- Location: Middle of England
Re: Scanned Document Into Excel Sheet
If you have suitable OCR software, it may be possible to obtain text that could be copied or imported into a spreadsheet, but it would depend on the OCR output and the suitability of the resulting format.
Alternatively, you could simply insert the scan as a picture into the worksheet.
Alternatively, you could simply insert the scan as a picture into the worksheet.
Leif
-
- 5StarLounger
- Posts: 847
- Joined: 24 Jan 2010, 06:35
- Location: A Magic Forest in Deepest, Darkest, Kent
Re: Scanned Document Into Excel Sheet
Adam, this is nigh on impossible due to the complexity of the grid format of Excel. This blog sums up the issues quite eloquently
How do I scan a document into Excel - Ask Leo
How do I scan a document into Excel - Ask Leo
Jerry
I’ll be more enthusiastic about encouraging thinking outside the box when there’s evidence of any thinking going on inside it
I’ll be more enthusiastic about encouraging thinking outside the box when there’s evidence of any thinking going on inside it
-
- Panoramic Lounger
- Posts: 8178
- Joined: 25 Jan 2010, 09:09
- Location: retirement
Re: Scanned Document Into Excel Sheet
As already indicated, if all you want is a picture of the document in your workbook then that's straightforward. To capture the contents of the scan and get that into an Excel sheet in one step is almost certainly a none starter.
How about first using an OCR scan to get the doc into Word. You will have to edit the scan but Word is designed to handle text so it shouldn't be hard to work the raw scan into a neat table. Once you've done that you can then copy & paste the table from Word to Excel. Finally in Excel you can add any formulae you need.
Ken
How about first using an OCR scan to get the doc into Word. You will have to edit the scan but Word is designed to handle text so it shouldn't be hard to work the raw scan into a neat table. Once you've done that you can then copy & paste the table from Word to Excel. Finally in Excel you can add any formulae you need.
Ken
-
- GoldLounger
- Posts: 2599
- Joined: 24 Jan 2010, 15:26
- Location: Olympia, WA
Re: Scanned Document Into Excel Sheet
What is contained on/in the "Document"?
If it a hardcopy of a spreadsheet, then most any REAL OCR program should be able to scan and OCR it into a spreadsheet.
I use OmniPage Pro and have done many a hardcopy spreadsheet into Excel.
If it a hardcopy of a spreadsheet, then most any REAL OCR program should be able to scan and OCR it into a spreadsheet.
I use OmniPage Pro and have done many a hardcopy spreadsheet into Excel.
I am so far behind, I think I am First
Genealogy....confusing the dead and annoying the living
Genealogy....confusing the dead and annoying the living