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?
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.
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.