New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
OS X - Apps and Games Discussion of applications and games available for Mac OS X.

Converting a pdf to Office Excel


Post Reply New Thread Subscribe

 
Thread Tools
mookish

 
Member Since: Jan 19, 2009
Posts: 2
mookish is on a distinguished road

mookish is offline
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.
QUOTE Thanks
louishen

 
louishen's Avatar
 
Member Since: Oct 22, 2007
Location: London
Posts: 8,935
louishen has a brilliant futurelouishen has a brilliant futurelouishen has a brilliant futurelouishen has a brilliant futurelouishen has a brilliant futurelouishen has a brilliant futurelouishen has a brilliant futurelouishen has a brilliant futurelouishen has a brilliant futurelouishen has a brilliant futurelouishen has a brilliant future
Mac Specs: Mac Mini Core i7 2012 | White 2009 MacBook 2 Ghz | 733 Mhz G4 Quicksilver

louishen is offline
is the text in tables?

Member of the Month September 2008 & August 2012 | Found advice useful? use the rep system
QUOTE Thanks
technologist

 
Member Since: Mar 30, 2004
Location: USA
Posts: 4,744
technologist has a reputation beyond reputetechnologist has a reputation beyond reputetechnologist has a reputation beyond reputetechnologist has a reputation beyond reputetechnologist has a reputation beyond reputetechnologist has a reputation beyond reputetechnologist has a reputation beyond reputetechnologist has a reputation beyond reputetechnologist has a reputation beyond reputetechnologist has a reputation beyond reputetechnologist has a reputation beyond repute
Mac Specs: 12" Apple PowerBook G4 (1.5GHz)

technologist is offline
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
QUOTE Thanks
mookish

 
Member Since: Jan 19, 2009
Posts: 2
mookish is on a distinguished road

mookish is offline
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.
QUOTE Thanks
dauber

 
dauber's Avatar
 
Member Since: Feb 14, 2008
Location: Chicago
Posts: 442
dauber is a jewel in the roughdauber is a jewel in the rough
Mac Specs: MacBook(3,1): C2D 2.2ghz, 4g RAM, 10.7.5; iMac(12,1): 2.5ghz i5, 16gb RAM, 10.9.1; iPhone5S iOS7.04

dauber is offline
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.
QUOTE Thanks

Post Reply New Thread Subscribe


« Macro: Is This Possible? | username greyed in mac mail »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
Excel to PDF jtessier OS X - Apps and Games 3 07-06-2007 05:42 PM
How to save/convert an excel srdsht into PDF? rcronin OS X - Apps and Games 7 04-05-2007 10:23 PM
office converting from PC to Mac, Parallels a viable platform? d.c.1 Running Windows (or anything else) on your Mac 5 12-07-2006 05:44 PM
Office and Adobe pdf tool bar mig.gentry OS X - Apps and Games 1 02-16-2005 12:24 PM

All times are GMT -4. The time now is 03:18 AM.

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

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?