Hi guys
I'm using Acrobat Pro X (version 10.1.1)
This might be a difficult question, but I need help with a way to save a fillable-PDF file so that I can export the data to Excel so that they placed in one row (maybe semicolon can separates the different datafields).
I've been testing the different export-functions and these are my export options:
1. FDF
2. HTML
3. XFDF
4. PDF
1. When I open the FDF-file in Excel, the Text Import Wizard pops up and I think I can do what I'm asking for here, but I don't really understand or know what to do.
2. HTML - Why does does it send as tmp-file when it says HTML? Outlook sends it as tmp-file and blocks it because it identifies it as dangerous file.
3. When I open the XFDF-file in Excel, it comes out in many rows, instead of one row. Is it possible to change this?
4. Sends as a PDF file - It's too much manual work to copy and paste each field.
So I think only option 1 and 3 can help me. And 2, but HTML doesn't seem to work.
Can someone please help me?
How to extract filled-in PDF file to Excel...?
2011-12-04 11:59:07
Answered
My Product Information:
Acrobat Pro 10.1, Windows
Acrobat Pro 10.1, Windows
2011-12-04 13:14:58
#2
There's a better option.
Go to Tools - Forms - More Form Options - Manage Form Data - Export Data...
Select the file format to be a plain-text file (.txt). The result is a tab-delimited file with the field names in the first row and the data in the second.
You can easily import this file in Excel.
Oh wow, so I can just save as a normal PDF and then use the Export Data-function when I receive back the PDF?Go to Tools - Forms - More Form Options - Manage Form Data - Export Data...
Select the file format to be a plain-text file (.txt). The result is a tab-delimited file with the field names in the first row and the data in the second.
You can easily import this file in Excel.
(Can users with just normal Acrobat Reader export data as well?)
2011-12-04 13:18:35
#3
Accepted Answer
Yes and no. This function is not available in Reader, but if they submit the file to you as a filled-in PDF then you can export it yourself.If you're interested, though, I can create for you a script that will send the filled-in data as plain-text in an email, from both Reader and Acrobat. I also developed a tool for Reader that displays the form data as plain-text in the console, so that it can be easily copied and saved as a stand-alone file. Here: http://try67.blogspot.com/2011/11/reader-display-form-data.php
2011-12-04 13:24:50
#4
Yes and no. This function is not available in Reader, but if they submit the file to you as a filled-in PDF then you can export it yourself.
If you're interested, though, I can create for you a script that will send the filled-in data as plain-text in an email, from both Reader and Acrobat. I also developed a tool for Reader that displays the form data as plain-text in the console, so that it can be easily copied and saved as a stand-alone file. Here: http://try67.blogspot.com/2011/11/reader-display-form-data.php
try67: thank you so much for your help, the world needs more people like you.If you're interested, though, I can create for you a script that will send the filled-in data as plain-text in an email, from both Reader and Acrobat. I also developed a tool for Reader that displays the form data as plain-text in the console, so that it can be easily copied and saved as a stand-alone file. Here: http://try67.blogspot.com/2011/11/reader-display-form-data.php
I am not sure if my work allow custommade scripts, but I will talk to them :)
Once again, thank you for your contribution to this community!
2011-12-05 13:07:03
#5
Yes and no. This function is not available in Reader, but if they submit the file to you as a filled-in PDF then you can export it yourself.
If you're interested, though, I can create for you a script that will send the filled-in data as plain-text in an email, from both Reader and Acrobat. I also developed a tool for Reader that displays the form data as plain-text in the console, so that it can be easily copied and saved as a stand-alone file. Here: http://try67.blogspot.com/2011/11/reader-display-form-data.php
Can you create a script that I can place inside the SEND-button in the PDF, so that when I press SEND, it sends the PDF-file + a txt-file/Excel-file at the same time?If you're interested, though, I can create for you a script that will send the filled-in data as plain-text in an email, from both Reader and Acrobat. I also developed a tool for Reader that displays the form data as plain-text in the console, so that it can be easily copied and saved as a stand-alone file. Here: http://try67.blogspot.com/2011/11/reader-display-form-data.php
If creating the Excel-file is not possible, the txt-file has to be able to be imported to Excel in one row (just like the Export-function you showed me).
Message me if this is possible.
2011-12-05 13:52:38
#6
Hi Mikey,
It might be possible, but it depends a lot on the environment in which the file is used.
Contact me personally (my email address is in my signature) to discuss it further.
It might be possible, but it depends a lot on the environment in which the file is used.
Contact me personally (my email address is in my signature) to discuss it further.
Go to Tools - Forms - More Form Options - Manage Form Data - Export Data...
Select the file format to be a plain-text file (.txt). The result is a tab-delimited file with the field names in the first row and the data in the second.
You can easily import this file in Excel.
- AcrobatUsers Community Expert - Contact me personally at try6767 [at] gmail [dot] com
Check out my custom-made scripts website: http://try67.blogspot.com