I have followed all the directions. I created a test form in Excel and saved it as a TXT (text delimiated file) and I thought I had figured it all out because all I would have to do to import that data into the fillable PDF I made in adobe DC. When I went to import the TXT file data all options for importing were greyed out and I cannot figure out what file type they want me to import or what the issue is. I am including a screenshot of the Excel form I quickly made and the greyed out txt file in Adobe DC. What file type should I be trying to import into Adobe DC to fill out the form with the Excel data?
Click on the "Options" button and select "Text Files"
It doesn't show it, but the default is FDF
Hi Thom, I have the same issue but i am not following your answer? Currently, i have a fillable pdf and a txt file with data from excel. I am using ms 365 with latest versions and current channel updates. When i try to import the txt file to my pdf form i get the pop-up box with data and once i select it to add it to the form, I get the error message as above. Any help on solving this would be amazing.
So you are selecting the Tab Delimited File with the (.txt) extension? What exactly is the error message displayed? The first poster wasn't even getting that far, so it was a different issue.
Thanks for responding Thom. The error msg: some data in the text file was not imported successfully. Yes on the .txt extension.
That would seem to indicate there were column names in the txt file that don't match field names in the PDF. There must be a one to one correspondance between the column names in the txt file and the field names on the PDF. Is this true?
I made sure the headers matched on both. Didn't work. Then i created a simple pdf fillable form from scratch starting with a table from excel without any security features built in or any erroneous pdf markings and it still didn't work. I am thinking maybe there is a switch that needs to be turned on somewhere?
Can you post both the txt file and your test PDF file?
Sure, I will post it tomorrow once back in office.
In the text file you use the columns
UNIT PRICE AMOUNT
In the PDF file I can't see any field with this names.
Hi Bernd, thanks for looking. On my PDF in the gray header just above the fillable boxes, i have the field names 'UNIT PRICE', 'AMOUNT'. Are you suggesting that these need to be setup as fillable boxes as well?
The fields under the header have the wrong names.
Okay, i thought they were the same on both docs, but I will see if i can redo the sample docs and try again. Do you know if there is a way to auto fill multiple boxes without having to write a scipt for it?
Bernd is correct, the fields in your PDF have the wrong names. The text on the PDF page is irrellevant. It has no effect what-so-ever on the field data. The only thing that is important is the name of the form field. This is how Acrobat maps the data from the "data file" into the fields on the PDF.
Please Read the section on form field names here, and watch the video:
Next, your form has several rows. When data is imported, it maps one to one with a specific field on the form. If you want to filll all the rows, then you need to a plan, because there is no feature in Acrobat for just importing text from a data file in to a bunch of rows.
So, the first thing you'll need to do is create a set of hidden form fields to capture the imported data. Then depending on exactly how you want this to work, the data is then transfered it to one or more of the rows.
If you are the only one filling the form, then I'd write a folder level automation tool to do the form filling. If the users need to be able to import, you'll need a button on the form that runs a script for this purpose.
You can find more info on data handling here (there are also example tools and scripts for performing almost the exact task you are trying to do, but they are not free):
Thom, I want to thank you for your time on this. Really appreciate it. I believe you gave me enough info to be able to figure it out at this point. I will try again and thanks for the additional info on auto filling.