• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
1

Importing or copying Excel list into drop down list

Community Beginner ,
Jun 18, 2012 Jun 18, 2012

Copy link to clipboard

Copied

Can anyone help me with this??  I have a list of 115 departments that I would like to populate the drop down box in an acrobat pdf form and dont have the time to enter them one by one..  Is it possible to either import this list or do a copy and paste??  Please help..  Thanks so much!!

TOPICS
Create PDFs

Views

70.4K

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

LEGEND , Jun 18, 2012 Jun 18, 2012

Here's a link to a very simple PDF that demonstrates how you can populate a combo box (aka drop down) with a list of items that can be pasted into a text field, after copying them from Excel (or some other source): https://acrobat.com/#d=sIJoabh12oYOY19AuTZ9yw

The idea is that once the drop-down is populated after clicking the "Populate combo box" button, you can copy & paste the field to your form. Be sure to check for duplicates and blank lines.

Votes

Translate

Translate
LEGEND ,
Jun 18, 2012 Jun 18, 2012

Copy link to clipboard

Copied

Here's a link to a very simple PDF that demonstrates how you can populate a combo box (aka drop down) with a list of items that can be pasted into a text field, after copying them from Excel (or some other source): https://acrobat.com/#d=sIJoabh12oYOY19AuTZ9yw

The idea is that once the drop-down is populated after clicking the "Populate combo box" button, you can copy & paste the field to your form. Be sure to check for duplicates and blank lines.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Jun 18, 2012 Jun 18, 2012

Copy link to clipboard

Copied

Thanks for your response George!  I still dont understand how to get it back into the drop down list.  It doesnt allow you to paste all the list..  Its just pastes the very first line of the list..  What am I doing wrong??

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Jun 18, 2012 Jun 18, 2012

Copy link to clipboard

Copied

Where you able to use the form to populate the drop down that it contains? If so, you're then supposed to then copy & paste the actual field (the entire thing) from the demo form to your form. You can then change it's appearance to suit your needs.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Jun 19, 2012 Jun 19, 2012

Copy link to clipboard

Copied

Yes, that worked!  Thanks so much George!!  I very much appreciate your help..  Have a great day!

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Apr 09, 2013 Apr 09, 2013

Copy link to clipboard

Copied

Once I get the list in, it is way too big. How can I make it smaller so I can move it? I read earlier about setting a preference, but I cannot find that. Please help!

Thanks,

Kristen Hernandez

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Jan 27, 2021 Jan 27, 2021

Copy link to clipboard

Copied

Hi George,

I cannot get the combo box list to populate.

I pasted an abbreviated list of my VERY long list, clicked populate combo box, but then nothing displays in the combo box.  I've tried this in Chrome and in Edge.

 

Not sure if I'm doing something wrong or if there is an issue.

*AcroForm combo box dropdown populate demo (acroscript.net)

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Apr 28, 2015 Apr 28, 2015

Copy link to clipboard

Copied

Hi George,

Seems like the link you provided some years ago is no longer active. Any chance you might recall the title the link lead to?

Thanks!

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Jul 22, 2020 Jul 22, 2020

Copy link to clipboard

Copied

Hi George,

I've used ComboPopulateTest several times and it's a real lifesaver.  I was wondering if there was an answer to an earlier question on how to modify the input field and/or the javascript to include each line's export value as well as the item itself.  I've read up on SetItems, which requires a comma-separated list and the number of columns (ie 2), but have now got stuck.

Many thanks in advance!

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Oct 05, 2021 Oct 05, 2021

Copy link to clipboard

Copied

This link is dead and I can't find it anywhere.  Poor UI, adobe.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Oct 20, 2021 Oct 20, 2021

Copy link to clipboard

Copied

Specifically, which link is dead?  All the important ones work for me.

 

 

Thom Parker - Software Developer at PDFScripting
Use the Acrobat JavaScript Reference early and often

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Mar 13, 2023 Mar 13, 2023

Copy link to clipboard

Copied

the link did take mea to a file

do u have an updated link, or any new suggestions, i need a drop down list for countries or nationalities on a form

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Mar 13, 2023 Mar 13, 2023

Copy link to clipboard

Copied

Here is a pdf file that demonstrates how to copy a list of text items into the items of a dropdown. 

https://www.pdfscripting.com/public/FreeStuff/PDFSamples/PDFS_CopyPastListEntries.pdf

 

 

Thom Parker - Software Developer at PDFScripting
Use the Acrobat JavaScript Reference early and often

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Oct 13, 2023 Oct 13, 2023

Copy link to clipboard

Copied

I have a list of 150 departments that I would like to populate the drop down box in an acrobat pdf form and dont have the time to enter them one by one..  Is it possible to either import this list or do a copy and paste??

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Oct 13, 2023 Oct 13, 2023

Copy link to clipboard

Copied

LATEST

Did you read the posts?

That's kinda the point of this thread.

 

Thom Parker - Software Developer at PDFScripting
Use the Acrobat JavaScript Reference early and often

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Jan 08, 2015 Jan 08, 2015

Copy link to clipboard

Copied

Hi all

This PDF seems to have disappeared from the internet! Is anyone able to help out with this same issue?

Cheers!

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Feb 17, 2016 Feb 17, 2016

Copy link to clipboard

Copied

The link in your post only takes me to a page to buy Adobe DC!! I've tried it several times, and all I can get is a big fat page to buy buy buy.  Grrrrrrrr!!!

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Feb 17, 2016 Feb 17, 2016

Copy link to clipboard

Copied

Here's a new link to the sample form: http://acroscript.net/pdf/demos/comboPopulateTest.pdf

In practice, I use something else that I've developed that is more useful and a lot more efficient. Feel free to contact me by email if interested: acroscript at gmail dot com

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Feb 17, 2016 Feb 17, 2016

Copy link to clipboard

Copied

I appreciate that, but I'm on a temp job (I'm retired and only come back

for 3 months during the admissions process), and will only be creating ONE

form, so it is not feasible for me to spend $50 to create one form. I have

a list of 71 colleges and a list 270 countries that I need to import. I

already did the colleges, I guess I'll have to do the countries too.

Thanks anyway.

On Wed, Feb 17, 2016 at 1:50 PM, George_Johnson <forums_noreply@adobe.com>

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Feb 17, 2016 Feb 17, 2016

Copy link to clipboard

Copied

OK, I hope you find the demo useful for the form you're developing.

In case others who may be interested read this, there is a fee for the utility I mentioned, but it's considerably less than $50.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Engaged ,
Mar 23, 2018 Mar 23, 2018

Copy link to clipboard

Copied

George_Johnson  wrote

OK, I hope you find the demo useful for the form you're developing.

In case others who may be interested read this, there is a fee for the utility I mentioned, but it's considerably less than $50.

Hi George,

You sample worked like a charm, and ... I am looking for something similar but the reverse. The users provided us good number of Acrobat Forms with a lot of drop-down fields that are populated with items. We need to export the list of group of items by field, and separated into a raw list, comma separated or each item on a separate line. After that, we want to import the items back into Adobe LiveCycle Form after adding a code for each item (value, Text).

I was wondering of you have idea how to do that to save time.

Appreciate your help.

Tarek

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Mar 23, 2018 Mar 23, 2018

Copy link to clipboard

Copied

Tarek,

The utility I mentioned (which can export to tab-delimited (item/export value on new line) and FDF) is designed to work with Acroforms (forms created with Acrobat), not XFA forms (forms created with LiveCycle Designer).

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Engaged ,
Mar 26, 2018 Mar 26, 2018

Copy link to clipboard

Copied

George,

Yes, I understand. Can I see a demo how the tool works? I want to export the drop-down items from Acroforms PDF to a text format (each item on a separate line), then finally paste to Adobe LiveCycle Form Drop-Down Field.

Will it work?

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Mar 26, 2018 Mar 26, 2018

Copy link to clipboard

Copied

Extracting items from an AcroForm list is pretty simple.  Run this code in the console window,

var oFld = this.getField("MyList");

for(var i=0;i<oFld.numItems;i++)

  console.println(oFld.getItemAt(i,true);

This code will print the export values of the list items in the console window.

Thom Parker - Software Developer at PDFScripting
Use the Acrobat JavaScript Reference early and often

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Engaged ,
Mar 26, 2018 Mar 26, 2018

Copy link to clipboard

Copied

Yes, it worked. Thanks a lot.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines