Document Editing Problems

How to Import an Excel List into a Word Drop-Down Control

Phi Hung Vo Oct 12, 2026 869 views

Question details

The user wants to dynamically import a large list of data from an Excel spreadsheet into a Microsoft Word drop-down menu instead of typing the entries manually.

How to Import an Excel List into a Word Drop-Down Control

Product: Word and Excel
Device & OS: not provided
Scenario: Creating dynamic document templates or forms in Word that require users to select options from an extensive, pre-existing Excel dataset.
Observed behavior: Legacy Word drop-down form fields have a strict limitation of 25 items, preventing the successful importation and display of hundreds of entries.

Before you start

Ensure you have enabled the Developer tab in your Word ribbon, as you will need access to Content Controls, UserForms, and Visual Basic for Applications (VBA) to accomplish this task.

Solution 1Recommended

Use Content Controls or UserForms with VBA

Bypass the 25-item legacy form field limit by using a Drop-Down List Content Control or a UserForm, populated automatically via a VBA script reading from your Excel file.

Because legacy form fields restrict you to just 25 entries, they are entirely unsuitable for lists with hundreds of items. Modern Word Content Controls and ActiveX Combo Boxes do not share this severe limitation.

To prevent manual data entry, you can write a Visual Basic for Applications (VBA) macro. This script will programmatically open your Excel workbook in the background, read the specified range of cells, and populate the Word drop-down control or UserForm with those values.

Enable the Developer Tab

Open Word, go to File > Options > Customize Ribbon. In the right pane, check the box for 'Developer' and click OK.

Insert a Content Control

Click the Developer tab on the ribbon. Place your cursor where you want the list in the document, and click the 'Drop-Down List Content Control' icon in the Controls group.

Open the VBA Editor

Still on the Developer tab, click 'Visual Basic' to open the VBA editor. Here, you can insert a new Module to write your macro.

Create a UserForm for Large Lists

If your Excel list has around 200 entries or more, an in-document drop-down becomes difficult to scroll. In the VBA editor, go to Insert > UserForm, then drag a 'ComboBox' or 'ListBox' onto the form from the Toolbox for better usability.

Add the VBA Code

Write a script utilizing 'CreateObject("Excel.Application")' to link your workbook. Use a loop to iterate through your target Excel range and add each cell's text to your control using the '.DropdownListEntries.Add' method.

Use Content Controls or UserForms with VBA

VBA Code Examples: Writing cross-application VBA can be complex. You can find excellent, ready-to-use code templates for importing Excel lists into Word drop-downs within Greg Maxey’s Word resources online.

Free Microsoft Office alternative

Upgrade Your Document Editing with WPS Office

Struggling with Word's complex legacy limits or difficult VBA integration? WPS Office provides a lightweight, highly compatible, and free alternative. It fully supports VBA macros and standard Office formats (.docx, .xlsx), allowing you to build professional documents and spreadsheets seamlessly.

1. Download WPS Office: Visit the official WPS website and download the free desktop application.
2. Install the Suite: Run the quick installer and follow the on-screen prompts to set up the software.
3. Open your Documents: Launch WPS Writer and open your existing .docx files to seamlessly continue your work.

Seamless format compatibility with Microsoft Word, Excel, and PowerPoint filesBuilt-in Developer tools and VBA macro support for complex form creationFamiliar user interface that ensures a zero-learning-curve migrationFree, all-in-one lightweight office suite that runs quickly on any system

microsoft office alternative - wps office

Frequently Asked Questions

What is the maximum number of items allowed in a legacy Word drop-down field?

Legacy drop-down form fields in Microsoft Word are strictly limited to a maximum of 25 items. If you need more entries, you must transition to using Content Controls, ActiveX Combo Boxes, or UserForms.

Can I link a Word drop-down directly to Excel without using VBA macros?

No, Word does not have a built-in, no-code feature to dynamically populate drop-down controls directly from an external Excel file. You must use VBA macros to read the Excel data and insert it into the Word control.

Why should I use a UserForm instead of a standard drop-down for large lists?

Standard in-document drop-down lists become cumbersome and difficult to navigate when dealing with hundreds of entries. A UserForm creates a custom dialog box where a ListBox or ComboBox can provide much better scrolling, displaying more items at once for the user.

Document & File Issues