Share via

Extracting text from an image

Anonymous
2019-01-18T17:46:50+00:00

I am trying to extract text from an image. I am needing to do this to hundreds of images. I use OneNote quite a bit and I use the Right-Click feature, then select "Copy Text from Picture" option. I have an issue though. I am trying to extract data from an image that is a picture of a table. When extracting the data in this fashion, the text is copied, but the associated data is scrambled all over the place. Is there a way to extract text from a table and keep the formatting. Ideally, I'd like to be able to paste this into Excel. I have attached the image I am trying to extract data from. Thanks!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

4 answers

Sort by: Most helpful
  1. Anonymous
    2019-01-18T18:21:55+00:00

    Hi Kyle,

    What you are looking for is called Optical Character Recognition. Whether it will be enough is the question. OneNote has OCR built into it, but is far from the only choice.

    One that is highly respected is ABBYY Finereader.

    https://www.abbyy.com/en-us/finereader/what-is-...

    You can download a free trial from here:

    https://www.abbyy.com/en-us/finereader/

    Note also that OCR, while much better than it was 5 years ago, is far from perfect.

    This forum is a user-to-user support forum. I am a fellow user. I hope this information helps.

    You are asked below whether this response solved your problem, please do not answer that question for this or any response unless the answer is "yes" or unless you feel that the response is not helpful to you in resolving your problem. Otherwise it reports the response as not being helpful. A "no" answer on any response will not give you any more help than not answering but will give negative reinforcement to the person who responded. On the other hand, a "yes" answer to that question helps other users with the same or a similar question by directing them to the response.

    Please let me know if you have any more questions or require further help by clicking on Reply.

    Regards

    4 people found this answer helpful.
    0 comments No comments
  2. Anonymous
    2019-03-04T16:08:06+00:00

    Hi Kyle, 

    Converting text from images to digital is what OCR technology does. Yes you are correct, OneNote has OCR built-in  and helps to convert image text to digitized text. But in real scenario it is evident that to extract data from a image documents which are text, table, check box etc. of different layout types needed complex algorithm. you can read more from internet on this.

    There would be many in the industry whic provides data extraction from images, but few those I know very good are as follows:

    1. Nuance - OmniPage SDK : : This is an OCR library SDK (Software Development Kit). you can develop your own OCR solution using this OmniPage OCR SDK.  Nuance data extraction Custom solutions: Nuance also provides custom solution using its OCR engine which is again both on-premise and on cloud. 
    2. ABBYY FineReader , FlexiCapture SDK : This is same as above.
    3. Free SDK that you can use to develop your own OCR Solution are :

    MODI - Microsoft Office Document Imaging OCR engine

    Google - Tesseract

    1. Another one is End to End OCR on-premise solution is using DigiContext which is a product of http://GetNext.co.in team. This solution has capability to integrate ABBYY Fine Reader, Nuance Omnipage , MODI in a single configuration. So you visit their web site and connect with them for more information.

    Regards

    Niranjan

    3 people found this answer helpful.
    0 comments No comments
  3. Anonymous
    2019-03-02T09:54:49+00:00

    The following is an illustration of what you get with FineReader's screen shot capture tool (Version 12) when your screen shot is captured as a table to Excel. As you can see, it is not perfect, but close.

    1 person found this answer helpful.
    0 comments No comments
  4. Anonymous
    2019-03-02T08:04:03+00:00

    This video will help you to retrive text from image

    https://youtu.be/T8PR4NITMYw

    1 person found this answer helpful.
    0 comments No comments