OCR'ing a screenshot - can I?

rholmes01 · rholmes01 #1 (**permalink**)

04-22-2010, 12:13 PM

I have received a Windows document that has in it a screen shot of a large number of different lists of members. However, I need to somehow to get these names into a spreadsheet so the that they can be sorted, un-duplicated, that kind of thing etc etc.

I can see the doc fine with iWork and the screenshot itself can be selected ok, but, I suppose I need to do some form of OCR on the screenie to copy the names and then paste them into the spreadsheet to allow me to do the manipulation.

Any ideas how I can do this - I have no OCR software and don't know if this is a feature of OSX anyway.

Thanks for any help...!

MacInWin · MacInWin #2 (**permalink**)

04-22-2010, 12:54 PM

What is the format of the screen shot? I have had some success with copy/paste from PDF to spreadsheets, but true images are usually not good for that.

rholmes01 · rholmes01 #3 (**permalink**)

04-22-2010, 02:24 PM

The screenshot is just a cut out of Paint that has been pasted into a .docx and is literally just a list of 30 or so names

MacInWin · MacInWin #4 (**permalink**)

04-22-2010, 02:51 PM

I would recommend just typing them into the spreadsheet. For 30 names, any other way will be even more work.

Aqua · Aqua #5 (**permalink**)

04-23-2010, 03:18 AM

I had old OCR software for the mac but it doesn't work with anything above OS 10 so I can't remember what the image format needed to be in. I do remember on my PC that the image format was tif, so as long as you could convert your image to tif format then you could OCR it. If you google there are some OCR software for mac.. If you have Microsoft Office (PC) then it includes MODI (Microsoft Office Document Imaging), If you have Adobe Acrobat then the ability to OCR is in it too (I know it's in 7 pro).

ref: Apple - Support - Discussions - Microsoft Office Document Imaging on OS ... and How to use OCR scans in Acrobat 7 Professional | Video « Wonder How To

chas_m · chas_m #6 (**permalink**)

04-23-2010, 07:46 AM

Here's something to try: PDF OCR X

Aqua #5 (permalink)
Member Since: Sep 05, 2007 Location: Canada Posts: 448 Mac Specs: Macbook Pro, 2.4GHz Core2 Duo 10.6.8, MacMini	04-23-2010, 03:18 AM I had old OCR software for the mac but it doesn't work with anything above OS 10 so I can't remember what the image format needed to be in. I do remember on my PC that the image format was tif, so as long as you could convert your image to tif format then you could OCR it. If you google there are some OCR software for mac.. If you have Microsoft Office (PC) then it includes MODI (Microsoft Office Document Imaging), If you have Adobe Acrobat then the ability to OCR is in it too (I know it's in 7 pro). ref: Apple - Support - Discussions - Microsoft Office Document Imaging on OS ... and How to use OCR scans in Acrobat 7 Professional \| Video « Wonder How To “invincible ignorance” is an example of ignorance that can not be removed by any amount of evidence. It's now a widespread form of pollution. (Revised quote) An apple a day, keeps the psychiatrist away.. If you play a Windows install CD backwards it has satanic verses
	QUOTE Thanks

chas_m #6 (permalink)
Member Since: Jan 22, 2010 Location: Victoria, BC Posts: 13,696 Mac Specs: 2009 MacBook Pro, Black speakers, Black Benq second monitor, black iPhone 4, Black 2012 iPad, etc.	04-23-2010, 07:46 AM Here's something to try: PDF OCR X Cheers, chas_m -- My essay for switchers and newbies
	QUOTE Thanks

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
High Resolution Screenshot!	jacunivac	Images, Graphic Design, and Digital Photography	6	03-30-2011 12:10 PM
Often forgot screenshot method...	schweb	OS X - Operating System	113	06-30-2010 10:33 PM
Colour Mismatch between Photoshop & Apple screenshot	stooboy	Images, Graphic Design, and Digital Photography	3	03-30-2009 08:58 AM
My World of Warcraft character screenshot	rberry88	Images, Graphic Design, and Digital Photography	4	11-08-2005 07:42 PM
Often forgot screenshot method...	schweb	Images, Graphic Design, and Digital Photography	0	03-12-2003 08:37 AM

OCR'ing a screenshot - can I?

Internet Services

Web Development

Digital Marketing

Consumer Tech

rholmes01 #1 (permalink)
Member Since: May 05, 2009 Location: UK Posts: 35 Mac Specs: iMac 3.06 GT130 1Tb	04-22-2010, 12:13 PM I have received a Windows document that has in it a screen shot of a large number of different lists of members. However, I need to somehow to get these names into a spreadsheet so the that they can be sorted, un-duplicated, that kind of thing etc etc. I can see the doc fine with iWork and the screenshot itself can be selected ok, but, I suppose I need to do some form of OCR on the screenie to copy the names and then paste them into the spreadsheet to allow me to do the manipulation. Any ideas how I can do this - I have no OCR software and don't know if this is a feature of OSX anyway. Thanks for any help...!
	QUOTE Thanks

MacInWin #2 (permalink)
Member Since: Jul 07, 2008 Location: Winchester, VA Posts: 708 Mac Specs: 2011 MBP, 2008 iMac, iPhone 4S, iPad (Retina), 13" MBP and MacMini	04-22-2010, 12:54 PM What is the format of the screen shot? I have had some success with copy/paste from PDF to spreadsheets, but true images are usually not good for that.
	QUOTE Thanks

MacInWin #4 (permalink)
Member Since: Jul 07, 2008 Location: Winchester, VA Posts: 708 Mac Specs: 2011 MBP, 2008 iMac, iPhone 4S, iPad (Retina), 13" MBP and MacMini	04-22-2010, 02:51 PM I would recommend just typing them into the spreadsheet. For 30 names, any other way will be even more work.
	QUOTE Thanks

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)