How to do optical character recognition excel mapping?

Asked By morgan sallyy 10 points N/A Posted on - 02/03/2013

I just want to ask questions about this thing that I am doing. I tried Optical Character Recognition (OCR) excels mapping image, that is to scan documents into excel. Well this is what I have done.

First, I clicked on the "start" button on the taskbar and select "All programs" then "Microsoft Office" and "Office Tools".

Second, I clicked the "Microsoft Document Imaging", clicked "File", "Open" tab select the file I want to scan on excel and clicked "open".

I selected the entire document and clicked "Edit " menu then "Copy".

Now my question is that why is it that the document doesn't appear on the excel?

• Status: Open
• Question Views: 865
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Munguia Roya

Go To Solution

Best Answer

Best Answer

Answered By Munguia Roya 0 points N/A #170024

How to do optical character recognition excel mapping?

Hi Morgan,

 

Okay, here is how it goes.

 

1. Go to Start -> All Programs -> Microsoft Office -> Office Tools.

2. Open 'Microsoft Office Document Imaging' from your 'Office Tools'

3. Now Open your file that needs to be scanned by going to File -> Open Menu. Now select the required file and click 'Open'

 

You have done right till this. 

4. Next you need to click on the Icon with an eyeball, 'Recognize text using OCR'. This will run the document through OCR

 

5. Now Select the entire document or required pages using mouse once the OCR process is done. After selecting GOTO Edit -> Copy Image from the top menu.

6. Now open the Excel and open the sheet where you want the document to appear. Go to Edit -> Paste.

 

Now the document will appear in the Excel.

 

Let me know if you still face problem scanning docs.

About Munguia Roya

Questions
2

Answers
12

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 02/19/2013
• Question Category: MS Excel

Answered By Laz Zebbena 0 points N/A #170025

How to do optical character recognition excel mapping?

Hi,

It seems you have missed to run the document through the OCR process, which is required before putting the document in an excel file.

When you selected the file that you want to scan into Excel and clicked on Open, after that you need to select the eyeball icon from the lower-right corner of the screen.

Then select the entire document, when the OCR process is complete and click on Edit and select Copy

Now open Excel and open the workbook where you want to add data and click Edit from the top menu and select Paste

Regards,

Laz Zebbena

About Laz Zebbena

Questions
2

Answers
101

Best Answers
14

• Vote Up 0 Vote Down

• Posted on - 02/19/2013
• Question Category: MS Excel