Skip navigation
TechnoGeek
Currently Being Moderated

How to export invoice to excel?  vs XIpro

Feb 1, 2013 3:54 AM

I've got a PDF which is essentially an invoice for purchases.   There are a few individual fields (contact info for who ordered it, who it was sent to) and then a dozen or so transaction records.

What's the simpliest approach (most transparent to the user) to get the transaction records into rows in an excel spreadsheet for future analysis?

 
Replies
  • Currently Being Moderated
    Feb 1, 2013 3:59 AM   in reply to TechnoGeek

    What application do the users use? If Reader, there are not many options available to you. In that case the simplest approach would probably be to write out the form data to a console window or a dialog, and then have them copy it over to Excel or an external text file.

     
    |
    Mark as:
  • Currently Being Moderated
    Feb 1, 2013 5:05 AM   in reply to TechnoGeek

    Basically a loop that iterates over all the fields and outputs their value

    to the console.

    However, Acrobat has a built-in function to export form data directly to a

    CSV file, which can be opened in Excel.

    That's probably a better way of doing it. In Acrobat 10 it should be Under

    Tools - Forms - More Form Options - Export Data.

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points