11

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

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

Improve this question
1
  • 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
    Commented Jan 7, 2017 at 19:07

4 Answers 4

Reset to default
6

Use pdftables.com.

Sample input:

sample input

Output:

output

Improve this answer
2
5

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

Improve this answer
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.

Improve this answer
-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

Improve this answer
1
  • 2
    Could you please add an input/output sample like in Andrea's answer? Thanks!
    – Nicolas Raoul ♦
    Commented Jun 30, 2016 at 6:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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