PDF Editing Issues

How to Populate a PDF Combo Box with Excel Data in Acrobat

Jason MillerJason Miller Nov 3, 2026 870 views

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.

How to Populate a PDF Combo Box with Excel Data
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.
Before you start

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.

Solution 1

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.

1
Copy Excel Data

Open your Excel spreadsheet, highlight the column containing your list items, and copy them to your clipboard.

2
Access PDF Form Properties

Open your PDF in Acrobat Pro XI, enter Form Editing mode, and double-click the target Combo Box to open its Properties.

3
Add Items to Combo Box

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'.

Create PDF Forms Easily

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. 1. Create a New Document: Open WPS Writer and set up the layout for your new form.
  2. 2. Access Developer Tools: Go to the 'Developer' tab on the ribbon to access form controls.
  3. 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. 4. Export as PDF: Go to 'Menu', select 'Export to PDF', and ensure your form fields are preserved for the final interactive PDF.
Easily insert drop-down form fields and pre-populate them with Excel dataHighly compatible with Microsoft Word (.docx) and Excel formatsFree and lightweight alternative to heavy PDF editorsSeamlessly export documents to interactive PDF forms in one click
microsoft office alternative - wps office

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.