Import Room List without ID Assignment

Shows step by step how to import room lists without ID assignment into Revit.

Before you begin

You have an Excel list of rooms and parameters without Revit-specific ID assignment and want to add the content of this list to your model.

Requirements:

  • The file has to be in *.xlsx format.

  • The file may not be open.

Navigate to:

Revit Ribbon ➤ tab LINEAR

Menu bar Linear Revit

Procedure

  1. Click on Excel import in the Interoperability area.
  2. Select the XLSX file to import and click Open.

    The dialog Default settings opens.

    Dialog default settings Linear Revit
  3. Select the Room Allocation Mode and the worksheet you want to import.
  4. Check if the column and row specifications match the structure of the list and click Next.

    The dialog Room allocation opens.

  5. Activate an Excel parameter to be used for room allocation.
    Tip:

    If the assignment with one parameter is not unique, you can assign additional parameters for the assignment.

  6. To subsequently link all other Excel parameters with Revit parameters, you can
    • try an automatic assignment of Excel parameters to Revit parameters by clicking on , or
    • click on in the corresponding row of the Select parameters dialog to make a manual assignment.
    Note: A prerequisite for the automatic assignment is an exact match of the parameter names between the Excel file and the Revit project.
    Dialog Room allocation Linear Revit
  7. Activate the checkbox Create other rooms as non-placed spaces and click Next.

    The dialog Import: … opens.

  8. Select the Excel parameters that you want to import.
    Notice: If necessary, you can carry out any missing parameter assignments in this dialog.
    Dialog Import Room Linear Revit
  9. Click Import.
    Tip:

    If parameters should be written to an element which is write-protected, an error message is displayed during import and you can display the error log with more detailed information about the cause of the error.

Results

The values of the parameters selected for the import were taken over and the so far non-existing rooms were created as non-placed spaces.

Tab construction architecture Linear Revit

What to do next

The non-placed rooms can now be assigned.