How to Populate a PDF Combo Box with Excel Data in Acrobat
Question details
The user wants to know if they can automatically populate a combo box (drop-down list) in a PDF form using data from an Excel column or via an ODBC data connection.

- Product
- Adobe Acrobat Pro XI
- Device & OS
- not provided
- Scenario
- Creating an interactive PDF form and needing to import a list of choices from an external spreadsheet into a drop-down menu.
- Observed behavior
- Acrobat Pro XI does not feature a built-in direct mapping tool or an ODBC connection to automatically populate combo boxes with Excel data.
Ensure your list of data is finalized and open in Excel. Since direct database mapping is not natively supported in standard PDF forms, you will need to manually copy the data or use a script.
Manually Paste Values from Excel
The simplest method for short lists is to copy the data from Excel and add it to the combo box properties in your PDF editor.
While you cannot map the field to update dynamically, you can easily transfer static data by copying it from your spreadsheet.
Open your Excel spreadsheet, highlight the column containing your list items, and copy them to your clipboard.
Open your PDF in Acrobat Pro XI, enter Form Editing mode, and double-click the target Combo Box to open its Properties.
Navigate to the 'Options' tab. You can paste your copied list into a temporary text document, then manually add the items one by one into the 'Item' field and click 'Add'.
Use JavaScript to Populate the Combo Box
For longer lists, you can use Document JavaScript in Acrobat to load an array of items into the combo box in one go.
Create the Form in an Alternative Office Suite
Bypass PDF editor limitations by designing your form in a word processor that supports form fields and exporting it directly to PDF.
Design and Export Interactive PDF Forms with WPS Office
If Acrobat's form tools are too complex or restrictive, WPS Office offers a straightforward way to create documents with drop-down fields and export them directly as interactive PDFs.
- 1. Create a New Document: Open WPS Writer and set up the layout for your new form.
- 2. Access Developer Tools: Go to the 'Developer' tab on the ribbon to access form controls.
- 3. Insert a Drop-Down Field: Click on 'Drop-Down Form Field' to insert it, then double-click to add your Excel list items in the Drop-Down Form Field Options.
- 4. Export as PDF: Go to 'Menu', select 'Export to PDF', and ensure your form fields are preserved for the final interactive PDF.

Frequently Asked Questions
Can I connect a PDF form directly to a live Excel database?
Generally, standard PDF forms do not support live database connections (ODBC) out of the box for security and portability reasons. You must use JavaScript or third-party server-side solutions for dynamic data mapping.
Is there a limit to how many items I can add to a PDF combo box?
While there is no strict numerical limit coded into the PDF standard, adding thousands of items can severely slow down the PDF's performance and make it difficult for users to scroll. It is recommended to keep lists manageable.
Can I populate PDF fields using a CSV file?
Yes, in Acrobat Pro, you can use the 'Import Data' feature to fill out existing form fields using a formatted CSV or tab-delimited text file. However, this feature is meant for filling the user's selected answers, not for building the available options in a drop-down menu.





