How to Convert a Table from PDF to Excel

Narbhflaith

Hi,

I am trying to copy a table from a PDF document to Excel but I can't get it to work for me!

Does anyone have any tips on how to do this successfully?

Thank You

homer911

How are you pasting the table into Excel?

Have you tried converting the pdf document to Word and pasting from it?

If its a public domain document, would you like to post a link to it and I'm sure someone would oblige..

Capt'n Midnight

Ask the copyright holder to send you the original document that the pdf was generated from.

depending on the settings you can simply copy/ paste text from pdf or the settings could be set to disable printing and copying, I'd normally also print it as a graphic to obstrufucate text extraction when putting security on a pdf.

check the file properties to see what restrictions have been imposed, remembering that copyright automatically exists on every document

Dan_Solo

It might be easier to save the page as a flat text and paste that into Word? Then convert it to a table? If you don't need to edit the data it, is there any way to paste it as a .bmp?
I've never tried it, but it doesn't sound like something that would be transferred intact automatically.

bhickey

Narbhflaith wrote: »

I am trying to copy a table from a PDF document to Excel but I can't get it to work for me!

Any chance you could attach the document? If you can copy/paste into something simple like Notepad, then adding Tabs in between the data in each columns will allow you to then copy/paste directly from Notepad into Excel. Of course that would be a real pain if you'd a lot of rows of data to copy.

Overheal

Pain in the ass. Tried exploring this for my old job. All you can really do is either transcribe the material manually, or get the publisher of the data to provide you an actual spreadsheet. Theres pay software out there that claims to do it, but thats only if you like @s and $s and Yen symbols showing up in your documents. Thats as far as I got with it, eventually just went back to time-heavy manual input.

towger

In Acrobat change the view from one page to continuous. Then Select All and Copy. In Excel, Paste ..... try a few paste options ... formatted, unformatted, etc and see what you get. May not not be perfect, but hopefully you'll have all the data at least which you can then reformat.

try

Narbhflaith wrote: »

Hi,

I am trying to copy a table from a PDF document to Excel but I can't get it to work for me!

Does anyone have any tips on how to do this successfully?

Thank You

This works well and for multi page pdf sheets is far better than the adobe pro.

Tomo87

http://www.pdftoexcelonline.com/