Skip to main content
Participant
April 18, 2019
Answered

exporting only some parts of a PDF to Excel

  • April 18, 2019
  • 2 replies
  • 1272 views

I have a pdf file with over 500 invoices, some of them are 2 pages, I need to export to an Excel file the customer information(name, address, account number, phone number(sometimes up to 3 phones numbers) and the total amount of the invoice.

Being new to acrobat, I read the tutorials, looked in FAQ and in the support bur I didn<t find my answer.

Can you help me ???

This topic has been closed for replies.
Correct answer Dov Isaacs

Simply stated, “out of the box” there is no way whatsoever of accomplishing what you have described.

PDF is a final form file format and unless there was some metadata put into the PDF file when it was created (not something that standard PDF file creation does) to indicate exactly where each of the customer information fields were physically located on each page for each individual invoice, it would be fairly difficult even with a “custom-made script” to accomplish this.

          - Dov

2 replies

Dov Isaacs
Dov IsaacsCorrect answer
Legend
April 18, 2019

Simply stated, “out of the box” there is no way whatsoever of accomplishing what you have described.

PDF is a final form file format and unless there was some metadata put into the PDF file when it was created (not something that standard PDF file creation does) to indicate exactly where each of the customer information fields were physically located on each page for each individual invoice, it would be fairly difficult even with a “custom-made script” to accomplish this.

          - Dov

- Dov Isaacs, former Adobe Principal Scientist (April 30, 1990 - May 30, 2021)
try67
Community Expert
Community Expert
April 18, 2019

It might be possible using a custom-made script, but without seeing the actual file it's impossible to say for sure.