Can a .pdf talk to Excel?

Gingertrees

Well-known Member
Joined
Sep 21, 2009
Messages
697
I was creating a form in Excel:
BusinessName:___________________________________
Address:___________________________City:__________ (etc)

I'll be compiling the results into a larger spreadsheet or table.

...and I realized this would be better as a .pdf form (that's an option, since I have both full Acrobat and LiveCycle Designer 8). Then I thought, "I wonder if it's possible to export form data from a .pdf to an Excel spreadsheet (or Access table)." And I thought maybe my helpful online friends at MrExcel might know... so, guys? Yea or nay?

I've found surprisingly little about this on the Adobe forums or elsewhere online. There are a couple old similar questions like this on the board, none of them answered, but I thought maybe I'd take a stab at it. Anybody know if this is possible? Or is this a case where it's possible but inadvisable?
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
It's been a while since I looked into it, but I believe that it is possible to export PDF form data to a CSV, yes. I remember a couple years ago looking into a project that would auto-scrape data from hundreds of PDF forms for processing in excel.

I don't think it can read directly from the PDF, though - I believe you have to use a function within Acrobat to export the form data as a CSV
 
Upvote 0

Forum statistics

Threads
1,214,413
Messages
6,119,374
Members
448,888
Latest member
Arle8907

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top