Welcome Dialog

Welcome to the Community!

We have a brand new look! Take a tour with us and explore the latest updates on Adobe Support Community.


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, Windows

Views

52.9K

Likes

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

Adobe Community Professional , 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=sIJoabh12oYOY19AuTZ9ywThe 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.

Likes

Translate

Translate
Adobe Community Professional ,
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.

Likes

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??

Likes

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
Adobe Community Professional ,
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.

Likes

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!

Likes

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

Likes

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)

Likes

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!

Likes

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!

Likes

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.

Likes

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
Adobe Community Professional ,
Oct 20, 2021 Oct 20, 2021

Copy link to clipboard

Copied

LATEST

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

Likes

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!

Likes

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!!!

Likes

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
Adobe Community Professional ,
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

Likes

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>

Likes

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
Adobe Community Professional ,
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.

Likes

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

Likes

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
Adobe Community Professional ,
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).

Likes

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?

Likes

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
Adobe Community Professional ,
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

Likes

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.

Likes

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 ,
Nov 18, 2019 Nov 18, 2019

Copy link to clipboard

Copied

Me too, I already have a license, from my job. I did'nt find a place to log in either....? 

Likes

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 ,
Sep 03, 2016 Sep 03, 2016

Copy link to clipboard

Copied

hello,

i want to imrport a list from excel that contains two columns, one with the value that i want to appear in the drop down list and the another one with de export value.

do you know how to do this?

Likes

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 01, 2018 Feb 01, 2018

Copy link to clipboard

Copied

Hi, George,

This Acroscript is great! I wondering how to use this hack in Adobe Acrobat DC Pro. I'm in Prepare Form --> Dropdown properties. I've copied my list from the form you created, but where would I paste this data in the Dropdown properties?

Please let me know if you need more information. I'm using Pro DC on a Windows OS.

Thanks!

Cheers,

Elizabeth

Likes

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
Adobe Community Professional ,
Feb 01, 2018 Feb 01, 2018

Copy link to clipboard

Copied

First off , this isn't a hack. It's just list programming with Acrobat JavaScript.  populating any type of PDF list with data is very simple.

I haven't seen Georges sample, but if he's filling data from items pasted into a text field, then there are no properties on the drop down that need to be adjusted. Instead the data is loaded by pressing a button. The code on the button must be something like this

this.getField("DropDown").setItems(this.getField("TextField").value.split(/\s*/g));

Where "DropDown" is the name of the dropdown list and "TextField" is the name of the text field where the excel data is pasted.

The idea of Georges from is that you use it to create a filled droplist, then copy that dropdown onto your own form.

Here are some articles that explain list programming:

https://www.pdfscripting.com/public/List-Field-Usage-and-Handling.cfm

https://acrobatusers.com/tutorials/js_list_combo_livecycle

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

Likes

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
    • 1
    • 2