I want to paste rows of exel into a fillable PDF form.

[Guest]

Hello,

This is my first time creating a pdf fillable form and i'm already facing a problem.

I am wondering if it is possible to paste multiple excel rows into a fillable PDF form like for example:

5343	296
5344	296
5345	296
5346	296
5347	296

Into an pdf fillable form into different text fields.

At this moment when I copy this data into my pdf form i get this:

5343 296 5344 296 5345 296 5346 296 5347 296 5348 296 5349 296 5351 296 5361 296 

into my first fillable text field.

Is there any way of creating a pdf fillable form where i can copy paste the excel data into and its seperates this data in the same format as in Excel? This because someone else needs to export this data later again into another excel document.

Sorry for my English, hopefully the question is clear.

[try67]

How would that work? Do you mean that you want to have a separate copy for each set of records?

If so, that's called a Mail Merge. It can be done using some versions of the Adobe PDFMaker plugin for Office, or by using a script, like this one I've developed: Custom-made Adobe Scripts: Acrobat -- Mail Merge and Email

[Guest]

Thanks for your answer but I dont think it is the thing i am looking for, i will try to explain it more clear.

So I am going to create a fillable pdf form. I send this fillable form to lets say multiple dealers who should be able to copy multiple rows (up to 20 rows) into the first 2 colums, for example into the following form:

Set up for fillable pdf:

ordernr	dealernr	option1	option2	option3	option4
		chkbox	chkbox	chkbox	chkbox
		chkbox	chkbox	chkbox	chkbox
		chkbox	chkbox	chkbox	chkbox
		chkbox	chkbox	chkbox	chkbox

So lets say the dealer copies his first 2 columns and 4 rows from excel into my fillable pdf sheets i want them to automatically line up with the checkboxes into the same rows.

What the pdf fillable form should look like after copying data from Excel to my fillable pdf form:

Dealername: [ textbox1]

Name requester : [ textbox]

ordernr	dealernr	Option1	Option2	Option3	Option4
5343	296	chkbox	chkbox	chkbox	chkbox
5345	296	chkbox	chkbox	chkbox	chkbox
5346	296	chkbox	chkbox	chkbox	chkbox
5347	296	chkbox	chkbox	chkbox	chkbox

So the dealer copies the first 2 columns out of his excel sheet (so he does not have to type 20 rows by hand), and should be filled in seperate boxes to export this to an excel sheet later on like underneath?

What my excel should look like:

ordernr	dealernr	dealername	name requeste	option1	option2	option3	option4
5343	296	cars bv	fred		yes
5344	296	cars bv	fred			yes
5345	296	cars bv	fred	yes	yes	yes
5346	296	cars bv	fred		yes		yes

But when they copy their 4 rows and 2 columns into my fillable pdf form what they get now is this:

What the fillable pdf form looks like now after copying data:

ordernr	dealernr	dealername	name requeste	option1	option2	option3	option4
5343 296 5344 296 5345 296 5346 296 5347 296 5348 296 5349 296 5351 296 5361 296

This example above is what i want to avoid, how do i do that?

Thanks in advance! Hopefully it is more clear now

[try67]

I think the best way to know what the structure of the file that you want to import should be is to fill out the PDF manually and then export the data to a text file. Then open that file in Excel and see how it is set up.

[George_Johnson]

If you paste the data into a multiline text field, you'll be able to later copy it and paste it back into a spreadsheet.