Donate Now Goal amount for this year: 2500 USD, Received: 1627 USD (65%)

Results 1 to 5 of 5
Like Tree1Likes
  • 1 Post By J.Merlan

Thread: Import an Excel Sheet into a Revit family

  1. #1
    New Member
    Join Date
    July 6, 2016
    Posts
    4
    Current Local Time
    04:41 PM

    Import an Excel Sheet into a Revit family

    Hello all ,
    I am creating a floor based Revit family with several types. The client has provided us the information of each type in an Excel Sheet. One of the ways of representing the information is by the use of Shared parameters i.e create shared parameter & assign the required value to that parameter. This is a manual way of including information in a Revit family. Is there any way that I can import an Excel sheet with product information into Revit family and link it with shared parameters?
    In other words , is there any method that allows importing Product data into Revit family & link them with shared parameters ?
    Please share your thoughts about this.

    Thanks in advance,
    Pavan

  2. #2
    Senior Member
    Join Date
    December 16, 2010
    Posts
    856
    Current Local Time
    09:11 PM
    In short, yes there are ways of doing it.
    You will need, however, an add in for linking revit with excel. (it costs about 90 dollars)
    It may also be parameters that you can "push" through your family using Dynamo, but I am not well versed in Dynamo so you would need to ask the dynamo specialists.

    The long answer, is that this is an advanced family creation procedure, and its really impossible to tell you how to do it for a few reasons
    1. I've never had to do it
    2. I don't have the excel add in
    3. It will be specifically customized to your specific family.

    But, before you go trying to reinvent the wheel, there are many existing products that work with an excel link (stud wall framing generators etc) so if its something a bit "standard" have a good look around see if there is a program that exists already. Even if it costs 250 bucks, you're saving money by buying it rather than trying to spend hours and hours recreating it.
    Last edited by Karalon10; September 28th, 2016 at 11:55 AM.

  3. #3
    Senior Member
    Join Date
    August 19, 2011
    Location
    New Hampshire
    Posts
    503
    Current Local Time
    07:11 AM
    Would it be feasible to create a type catalog from the supplied excel sheet?

  4. #4
    New Member
    Join Date
    July 6, 2016
    Posts
    4
    Current Local Time
    04:41 PM
    Is it possible to make use of Macro manager in Revit family editor to import Excel sheet?

  5. #5
    Member J.Merlan's Avatar
    Join Date
    August 19, 2016
    Posts
    55
    Current Local Time
    04:11 AM
    You can accomplish this with Lookup Tables. While there isn't a direct way to use the Excel spreadsheet as a lookup table, you can always convert it to a CSV to be used with your families.

    https://knowledge.autodesk.com/suppo...3E216-htm.html

    Edit: More specifically, you will need to create a Type Catalog: https://knowledge.autodesk.com/suppo...C3CE9-htm.html
    cganiere likes this.

Similar Threads

  1. import excel spreadsheet into revit
    By waikikigirl in forum MEP - General
    Replies: 8
    Last Post: July 29th, 2016, 12:26 PM
  2. Import data from excel
    By rdon in forum MEP - General
    Replies: 4
    Last Post: August 21st, 2015, 12:52 PM
  3. Replies: 0
    Last Post: July 13th, 2015, 11:45 AM
  4. Replies: 0
    Last Post: February 8th, 2012, 01:16 AM
  5. Import from Excel possible?
    By MartinGT in forum Architecture and General Revit Questions
    Replies: 2
    Last Post: August 25th, 2011, 12:49 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •