Using Dropdown Lists

A dropdown list can be used within Excel to expedite your work and ensure standardized values across your data.

Learn more:


Automatically Create a Dropdown

Ideate BIMLink will automatically create a dropdown list within the Excel file when these conditions are met:

  1. On the Link Tab within the Link Properties dialog, the box to “Export with dropdown values” must be selected. This setting will be saved within the Link Definition.
  2. The Link Definition must contain properties that are supported by this feature, as described below.

Supported Properties

Most of the properties supported by this functionality are built-in parameters where there are a controlled set of options for the allowed parameter values. Examples of this include, but are not limited to:  Schedule Keys, Level, Phase, Phase Filter, Workset, View Template, Scope Box, Family and Type, Electrical Equipment: Circuit Naming, Space: Space Type, Structural Usage (for Walls and Footings), View Reference, View: Discipline and Zone: Service Type. 

Additionally, custom parameters are also supported for any Material-based or Image-based parameter. To create dropdown lists in Excel for unsupported properties, refer to the topic Manually Create a Dropdown.

Unsupported Properties

Assembly Codes, Keynotes, Area Types and Area Schemes, and other custom parameters not mentioned above are not currently supported but can be managed by the manual methods described below.

Manually Create a Dropdown

A dropdown list can also be created within Excel by using the Data Validation tool.

Submit feature or issue request for Ideate Software

Thank you for taking time to inform us about a bug or feature request.

By entering your data above and clicking ‘SUBMIT’ you are consenting to the collection and use of that data to respond to your comments and inquires, as described in our Privacy Policy. We may also transfer the data you submit in the ‘Email Us’ form to our VAR partners for the limited purpose of a sales follow-up. Please review our Privacy Policy for more details on how and when we collect data and what we use it for.