How to Import an Excel List into an Acrobat PDF Dropdown Field
Question details
The user needs to populate a PDF form dropdown (combo box) with approximately 115 items from an Excel spreadsheet, requiring both display values and separate export values, without entering them manually.
- Product
- Adobe Acrobat PDF
- Device & OS
- not provided
- Scenario
- Building an interactive PDF form that requires a long list of departments to be selectable via a dropdown, pulling the source data from an existing Excel database.
- Observed behavior
- Users are struggling to bulk-import items with paired display and export values, as manual entry is too tedious and previous online demonstration files or tutorial links are no longer available.
Ensure your Excel list is clean by removing any duplicate entries or blank lines. If your dropdown requires separate display and export values, organize them side-by-side in two distinct columns within your spreadsheet.
Use a Helper Text Field and JavaScript to Populate the Combo Box
By pasting your Excel data into a temporary text field and running a custom JavaScript, you can automatically parse and populate a dropdown field with hundreds of items in seconds.
Because Adobe Acrobat does not have a native 'import from Excel' button for combo boxes, a standard workaround involves using a temporary text field to hold the copied Excel data and a short script to format it into the dropdown.
If you need paired values (e.g., 'HR Department' as the display value and 'HR-01' as the export value), the script will read the tabs separating the pasted Excel columns and assign them accordingly.
Open your spreadsheet and ensure column A contains the display values and column B contains the export values. Highlight all the rows for the 115 departments and press Ctrl+C to copy the data.
Open your PDF in Acrobat and enter 'Prepare Form' mode. Add a new Text Field to the document, open its Properties, and under the Options tab, check 'Multi-line'. Close the properties, exit form editing mode, and paste your Excel data directly into this new text field.
Press Ctrl+J (or Cmd+J on Mac) to open the JavaScript Debugger. Write a script that reads the value of your helper text field, splits the string by newlines to create an array of rows, and splits each row by tabs to separate the display and export values. Use the 'setItems()' method to push this array into your target dropdown (combo box) field.
Click on your dropdown field to verify that all 115 departments are listed correctly and that the export values are functioning. Once confirmed, go back to 'Prepare Form' mode and delete the temporary helper text field.
Create and Manage Interactive PDF Forms with WPS Office
While bulk importing complex paired values requires scripting, WPS Office provides a highly intuitive PDF editor for creating forms, adding combo boxes, and managing daily document workflows. It is a powerful, lightweight suite that handles PDFs, Spreadsheets, and Word documents effortlessly.
- 1. Open your PDF in WPS Office: Launch WPS Office and open your existing PDF document using the built-in WPS PDF tool.
- 2. Access the Form editing tools: Navigate to the 'Form' tab on the top ribbon to reveal the interactive form controls.
- 3. Insert and configure your Dropdown: Click the 'Combo Box' tool and place it on your page. Double-click the field to easily add, manage, and arrange your list items within the properties menu.
Frequently Asked Questions
How do I handle separate display and export values in a PDF dropdown?
In the dropdown field's properties, you can set the 'Item Name' (what the user sees) and the 'Export Value' (the background data recorded when the form is submitted) independently. When using a JavaScript import array, you must format it as a 2D array where each element contains both the display string and the export string.
Why did the previous Adobe DC tutorial links for this issue stop working?
Official Adobe forums and third-party tutorial sites frequently update their directory structures or archive older posts. Direct links to sample PDF demonstration files hosted on personal cloud drives often expire, which is why it is safer to rely on the documented JavaScript logic rather than downloading a template.
Can I bulk import a dropdown list without using JavaScript?
No, without a script, most advanced PDF editors require you to enter dropdown items manually one by one through the field's property menu. Scripting is currently the only native workaround to perform a bulk import of 100+ items directly from an Excel spreadsheet into a PDF combo box.
