Managing Revit Type Catalogues with Excel – 2 of 2

Start by creating shared parameter for the components as well as parameters for their price.

Manage > Settings > Shared Parameters

1

Group them appropriately.

2

3

Include the shared parameters in the families they are meant to occur in (they will apply across all of the types within the family).

Create > Properties > Family Types

4

New Parameter

5

Select the shared parameters to include as type parameters.

6

7

List them under the appropriate Property Headings

8

Since the family is to be managed though a type catalog, it is not necessary to indicate values for the type parameters in the family itself.

9

Now export the Family types.

Application Menu > Export > Family Types

10

This saves as a text file in a comma delimited text file (CSV) which in turn is opened in Microsoft Excel (make sure to choose “All Files” so that the .txt file is visible).

11

In the Text Import Wizard, choose “Delimited” for the original file type, and click next.

12

Make sure to add “Comma” as a delimiter and click next.

13

Choose Text as the Column Data Format (stops Excel from modifying data) and click Finish

14

Save it as an excel file. This excel file is what will be used to manage the Type catalogue. Do the same for the Second family.

These Excel files may have their Rows and Columns sorted as the Row Order and column order is not of consequence to Revit when it populates data for families from type catalogues.

15

Now write the file out as a MS DOS CSV File and afterwards change the extension from .csv to .txt. Move the text file into the directory containing the family. The next time the family is loaded into a project it will read the values for the parameters from the .txt type catalogue.

Insert > Load from Library > Load Family

16

Was this helpful?

Thanks for your feedback!

About the Author

SHARE

About the Author

SHARE
Privacy Overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.