Mac Forums

Mac Forums (http://www.mac-forums.com/forums/)
-   OS X - Apps and Games (http://www.mac-forums.com/forums/os-x-apps-games/)
-   -   Converting a pdf to Office Excel (http://www.mac-forums.com/forums/os-x-apps-games/137743-converting-pdf-office-excel.html)

mookish 01-19-2009 04:37 AM

Converting a pdf to Office Excel
 
Howdy folks,


Just wondering if there is an easy way to convert a pdf that is all text into an Excel Spreadsheet?

I am running Leopard and Office Mac 2008.

Thanks for your time.

louishen 01-19-2009 07:57 AM

is the text in tables?

technologist 01-19-2009 03:08 PM

Select the text (using the Text tool in Preview) then copy it, and paste it into Excel. (If the PDF is a scanned document, you won't be able to select the text unless/until it has been OCR'ed)

Use the Text to Columns tool (Data > Text to Columns) to break the text up once you've got it into Excel

mookish 01-19-2009 10:17 PM

The text is in columns and when I copy it to excel, it copies all into one column and wont separate out when I use the text to columns function.

dauber 01-20-2009 08:01 AM

Okay, I confess that I'm posting this having never used the OSX version of MS Office, but in the Windoze version, when you have a bunch of text to paste in, it gives you the option of "plain text" or "unicode text" -- does the OSX version do this as well? I'm guessing if it does you already tried, but see how each one works for you...that might be the key to getting the stuff to paste properly.


All times are GMT -4. The time now is 09:28 AM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.