Results 1 to 4 of 4

Thread: linking excel into revit

  1. #1
    Member
    Join Date
    2014-07
    Location
    Redlands, CA
    Posts
    3
    0 Did you find this post helpful? Yes

    Default linking excel into revit

    I'm relatively new to revit and am trying to figure out how I can import an excel spreadsheet into a revit sheet. I'm sure its simple but the process is eluding me.

    much appreciated.

  2. #2
    Active Member
    Join Date
    2007-04
    Posts
    62
    0 Did you find this post helpful? Yes

    Default Re: linking excel into revit

    Quote Originally Posted by chardt676993 View Post
    I'm relatively new to revit and am trying to figure out how I can import an excel spreadsheet into a revit sheet. I'm sure its simple but the process is eluding me.

    much appreciated.
    Hi,

    There is no way to do it directly. You can use an addin like Excel2R to create a table in a drafting view that will be populated with the excel data.

    If you want to use Excel to drive your model/families I'd recommend using Dynamo (it gives you almost unlimited possibilities with manipulating the data) or there is a number of other addins to do that.

    Personally I think that if the information in a schedule that is placed on a Revit sheet is not extracted from the model, it should stay in Excel.

    Thanks,

    Maciej

  3. #3
    All AUGI, all the time
    Join Date
    2008-11
    Location
    Australia
    Posts
    627
    0 Did you find this post helpful? Yes

    Default Re: linking excel into revit

    As mentioned above there are several add-in pieces of software on the market (not by autodesk) that can handle linking between revit and excel.
    It is possible otherwise, but you need to double handle the excel file by routing it through autocad.
    Link the excel file into autocad as usual, and then you link the autocad file with the excel embed into revit and this works just fine also. Depending on how you need to place the excel file will depend on what kind of view to place it in, if it is only going on one sheet then link your autocad file into a drafting view, but if you want it over multiple views then you will need to link into a legend

  4. #4
    AUGI Addict MikeJarosz's Avatar
    Join Date
    2003-09
    Location
    New York NY
    Posts
    1,326
    0 Did you find this post helpful? Yes

    Default Re: linking excel into revit

    If you are attempting to link a live Excel file into a construction document in order to update the CD from Excel, my advice is don't do it. Once CDs have been issued and construction begun, your CDs become a legally binding contract. Changes, revisions or other updates must follow strict notification procedures if you want to stay out of court. Making changes to a drawing from an external source is risky business. Even if you are aware of this risk, are you sure that every time you make a revision in Excel you are going to go to the Revit drawing and cloud the change and enter it into the revision schedule?

    Are you sure that the task you are doing in Excel can't be done more effectively directly in Revit? I have seen people do door schedules in Excel then paste a jpeg into Revit! Creating the Excel file is twice the amount of work as doing it in native Revit. Then, any changes to the doors in Revit will not reflect in the Excel file, creating a conflict between the model and schedules.

    The drawing list is another place people think an Excel file is the way to go, except the Excel list manager doesn't know that Joe in the Chicago office just changed the title of sheet A-372 from "Elevations" to "INTERIOR ELEVATIONS BUILDING A", then created A-373 for Building B elevations. I have worked on huge airport projects with dozens of consultants. The Excel drawing list becomes a work of fiction sometime after the first thousand sheets are issued. C'mon......this problem is just what Revit was created to solve!

    In Acad, I wrote a program to read every sheet in a project and dump the title block info into Excel. For an airport, that can be thousands of sheets. We could run it daily if needed. You would be amazed at the number of changes that happen to title blocks on a project of that size that the list manager is unaware of.

    When you have so many sheets, how will you know that sheet M-692 changed scale from 1/8"=1'-0" to "as noted"? Your Excel file will probably still read eighth scale. Contractor estimators look for such mistakes.
    "everything you know is wrong...." -FST

Tags for this Thread

Posting Permissions

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