8

I often receive table data in PDF files. I want to be able to get that into Excel in a tabluar format but it often comes out strangely when I copy paste.

I want to be able to get tables out of PDF and into Excel and maintain their structure.

  • If an answer was helpful to you, then please consider marking it as the accepted answer so others may more easily find it in the future. This is also a polite way to thank the person answering your question for helping you out. – Andrea Lazzarotto Jan 7 '17 at 19:07
6

Use pdftables.com.

Sample input:

sample input

Output:

output

3

ABLE2EXTRACT PDF CONVERTER does this brilliantly well. You can check demo video on their page. The thing I love about this software is (and I think its unique to this product alone):

  1. You can just select an area from a page (a table in our case) on PDF and ask it to convert.
  2. While converting it gives us two options: Automatic or Manual (I just love this). We can guide the software in recognizing proper columns and rows of the table.
  3. After conversion it takes care of Number formatting too.

They have a free online converter too for casual users. Here is a sample:

In a PDF page: enter image description here

After Automatic conversion: enter image description here

0

You might be interested in PDFGenie.

This blog post goes over the product in more detail.

Sample input and output are in the download.

The output is XHTML, so you would have to do some post processing to get something you could pass to Excel.

-2

Try using Foxit PhantomPDF. Be careful though, if the PDF contain text outside the table, it will be aligned to the left.

Here is the output

enter image description here

  • 2
    Could you please add an input/output sample like in Andrea's answer? Thanks! – Nicolas Raoul Jun 30 '16 at 6:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.