Need to convert price list table in pdf to Excel

[eric_g_007]

We have a 9 column table with a few hundred listings in a PDF. We need
to make a spreadsheet just like it and would like to avoid re-typing if
possible. Does anyone have any suggestions?

Excel 11.2.5
OS 10.4.7

 

[Jim Gordon]

Hi Eric,

If the PDF file was saved with restrictions about using the text
features, then using optical character recognition software such as
ReadIrisPro would be able to extract the table.

Ordinarily you can use the Text tool in Adobe's Reader program to copy
the text.

-Jim Gordon
Mac MVP

 

[Jay]

We have a 9 column table with a few hundred listings in a PDF. We need
to make a spreadsheet just like it and would like to avoid re-typing if
possible. Does anyone have any suggestions?

Excel 11.2.5
OS 10.4.7

Just google the following:

PDF to Excel conversion

There are lots of mini apps which do this - I'm not sure of the cost, or
whether it would be justified if this exercise is a one-off. But if
it's something you may need to do a lot then it could be the way to go.

Jason

 

[Paul Berkowitz]

Surely copying the text, pasting it into Word, selecting it and using Word's
Table/Convert->Text to Table, then copying the table and pasting it into
Excel, would do the trick?

I suppose it depends on how the initial copy from Adobe Reader teats the
gaps between the words. If they're copied as tabs, you can probably just
paste straight into Excel, without Word. If they're copied as spaces,
fiddling in Word's Convert to Table can probably manage it. If there's no
space nor any other character at all, you've got problems.

--
Paul Berkowitz
MVP MacOffice
Entourage FAQ Page: <http://www.entourage.mvps.org/faq/index.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Microsoft Office you are using -
**2004**, X or 2001. It's often impossible to answer your questions
otherwise.