Boost Your BIM – making Revit even better

January 29, 2013

Family Parameter Editing in Excel – Data Round-trip

Filed under: Families, Parameters — Harry Mattison @ 2:21 pm

Yesterday’s post was about getting Family Parameter data out of Revit and into Excel. Here you can see:

  1. Parameter data exported to Excel for every family in a specified directory
    For this example I hard-coded “C:\ProgramData\Autodesk\RAC 2013\Libraries\US Imperial\Columns” but it could be any directory you want
  2. Data modified in Excel for multiple families
  3. Data read back into the family files
  4. Modified families saved to disk
  5. Families manually opened to show the changes made with the API commands


About these ads


  1. That’s great to be able to see all of the Family Parameters for several families at the same time in Excel! This would be perfect for the family creation work I do.

    Is it also possible to see Shared Parameters too or just Family Parameters? If so, could you also show the GUIDs for the Shared Parameters? One obvious use there is to easily verify that all of the Shared Parameters among several families have the same GUIDs.

    Comment by Ryan Moore (@RmooreID) — January 29, 2013 @ 5:33 pm

  2. I’am beginning to love you…this looks great.
    As Ryan indicated, it would be very very very nice if you can publish all parameters from the families….. it’s gold…..

    Comment by Arno — January 30, 2013 @ 2:29 am

  3. Very cool. I agree to the ability to work shared parameters in this would be outstanding.

    Comment by Jeff — January 31, 2013 @ 1:26 pm

  4. Would love to see how that macro was written, are there any tutorials for this workflow?
    Keep up the good work.
    Tom sweeney.

    Comment by Tom Sweeney (@sweenbox252) — November 24, 2013 @ 9:13 am

    • Thanks Tom. Much of the code behind this app is explained in my Revit API course at Or feel free to contact me at if you are interested in purchasing the complete source code of this program.

      Comment by harrymattison — November 24, 2013 @ 1:46 pm

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

The WordPress Classic Theme Blog at


Get every new post delivered to your Inbox.

Join 967 other followers