Export Component Lists to an Excel File

Shows step by step how to export component lists from Revit to an Excel file.

Before you begin

You want to export a component list from Revit to an Excel file in order to edit this list outside Revit.

Requirement:

The component list is defined and contains elements.

Navigate to:

Revit Ribbon ➤ Tab LINEAR

LINEAR tab in the Revit Ribbon of the LINEAR Solutions

Procedure

  1. Click Excel-Export in the Interoperability section.

    The dialog Export component / quantity lists opens.

    “Export component / quantity lists” dialog in the LINEAR Solutions for Autodesk Revit
  2. Select Worksharing-ID as row identification.
  3. Activate the check boxes of the component list you want to export and click OK.
  4. Select a storage location and save the file.
  5. Click the appearing window Export successful to open the exported file directly in the table editing program.

Results

The XLSX file contains all elements of the component list. If you have exported several lists, you will find each list in a separate worksheet.