How-to Copy Numbers and Text from Pictures and Paste in an Excel Spreadsheets

Are you familiar with OCR?  It stands for Optical Character Recognition.  Well in this post I will show you how to copy and paste numbers and text from a picture and paste them into an Excel Spreadsheet.  How cool is that?

You can see a video demonstration and tutorial at the bottom of the post.  Well, let’s get to it!!

 

The Problem

You have an annual report or some other document that you want to analyze, but the copy you can get only has images.  And you just don’t want to retype all the data into Excel.  What can you do?





 

The Breakdown

1) Paste into One Note

2) “Copy Text From Picture”

3) Paste Data in an Excel Spreadsheet

 

Step-by-Step

1) Copy Image and Paste into One Note

Find any image with text and/or numbers.    Then Copy and paste or insert the picture into OneNote.SpreadsheetPicture

NOTE: If you are having trouble with getting to much data and not being able to separate it, then check out the video and only grab a column at a time with an image editor, or check out this post on how to break up data in Excel.





The Best Way to Separate Address Text to Multiple Columns

For this example:

I am going to use a photo or image editor, and only copy and paste one column of data for “March” as you see here.image

(You can copy and paste this column of data from the picture above directly into OneNote to try it out.)

 





If you found the website and tutorials helpful, please consider donating to keep the lights on.

Donate with PayPal here:





2) Right Click on Image in One Note and Select “Copy Text From Picture”

Now that you have the picture in OneNote, right click on the image and choose “Copy Text from Picture” in the pop-up menu:

image

You have now digitized the data from a picture/image in OneNote into Text/Numbers.  It is being held in the Clipboard on your computer.

 

3) Open an Excel Spreadsheet and Paste the Data





The image has now been converted into text and can be pasted into Excel as it is in the Clipboard.  Simply open up Excel and press the paste button or press Ctrl+V.

You will now see the data in your Excel Spreadsheet.image

It is just that simple!  How amazing is that?  Let me know what you think about it and how you could use this technique in the comments below.

 

Video Demonstration

Watch a video tutorial of this OCR technique here:

 

Let me know if you have any other awesome techniques like this in the comments below.  And thanks for being a fan!

Steve=True









16 COMMENTS




  1. If you found the website and tutorials helpful, please consider donating to keep the lights on.

    Donate with PayPal here:




  2. kindly can i get the link for this program i have problem i need to convert from picture to text at excel and i don’t know how .

    • Hi Tanya, did you check out the video as well to see? Steps are to copy image. Paste in OneNote. Right click on image and Select “Copy Text from Picture” then go to excel and paste.




  3. If you found the website and tutorials helpful, please consider donating to keep the lights on.

    Donate with PayPal here:




    • Hi Uday, I am using 2010, but it is the desktop application version (2010), NOT the trusted microsoft store app or online version. That one may have less features and could be your issue.

  4. Hi thanks for the post. I’m on Win 10, One Note and Excel 2016. Copied your example image to one note paste back to excel and only got half of the content..

    Mar
    $42 58

    • Hi Becky, glad it worked. I think I stated in the video that it is best to copy one column at a time. That way no data is missed and format holds.

LEAVE A REPLY

Please enter your comment!
Please enter your name here