These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Troubles entering data into form using Excel spreadsheet

unimark
Registered: Sep 3 2008
Posts: 3

Hi everyone,

I'm having issues entering information into a form. I'm using Acrobat 7 Professional. My goal is to generate multiple forms using data from an Excel spreadsheet. The data is essentially names and contact information, all very simple.

I have created a form using Designer and just used text boxes. Do I have to use anything like tags to distinguish the text boxes and link to the Excel sheet by chance?

In the excel form I created column headings which match the form (but again, maybe I need to tag the form?), and then entered all my data below those headings. For example:

NAME ADDRESS PHONE# EMAIL
John Doe 123 Fake St. 555-1234 john [at] doe [dot] com
Mary Mae 543 Broadway 677-3545 mary [at] mae [dot] com
Tom Johnson 12 Green St. 453-2438 tom [at] johnson [dot] com

I want to be able to import the set of data from each row into their own form, so that in this case I would end up with 3 forms with the data automatically entered in the text boxes on the 3 separate forms.

I've tried using the import data option and saving the Excel sheet as a .txt and a .xml but this didn't work for me. I imagine I'm missing something fairly obvious to a more seasoned user of Acrobat.

Thanks in advance!

Mark

My Product Information:
Acrobat Pro 7.0, Windows
gkaiseril
Online
Expert
Registered: Feb 23 2006
Posts: 4307
Have you made a database named area in the Excel sheet. Then you can use the Data Connection of LiveCycle Designer to retrieve each row since an Excel DataBase confirms to the SQL standard.

George Kaiser

erica
Registered: Nov 14 2007
Posts: 14
I'm also trying to do the exact same thing.
I'm trying to create an "annual update your contact information" fillable form.
My boss wants it pre-filled with the info we already have.
I have an excel file with over 50 clients on each row. I've converted it to a TXT file and matched the column heading to the field names so they'll import.
Instead of getting 50 filled-in pdfs, I'm only getting one filled in pdf, which is the 1st row in the TXT file.

I created the fillable pdf by converting an excel file into a pdf file. Then running form field recognition.

Please help. Trying to get an unorganized company organized, and this'll really help.