Modelling Revit Piling from Microsoft Excel

Recently a few contractors have indicated that they would like to be able to create a 3D model of piling from a piling schedule produced by a consultant. This is achievable using the Excel Based model generator which can be found on the Extensions ribbon. You will need to have Microsoft Excel 2010 installed if you are using Revit 2013.

Excel Based Model Generation

I have started off by taking an existing pile schedule from an FPS spread sheet and then copying this into the Excel Based model generator. You can see that I have used some of the spare columns to convert some values from meters to millimeters  anything outside of the marked columns you can use for your own calculations.

Format of Data

Make sure that you have the families that you want to use loaded into the active project and that you use the Footings tab as shown in the above image. Also take note of the default units and make sure you convert to the correct values. Once this is done and you think you have all the correct values in the spread sheet you can verify the data. You will see this on the quick access toolbar at the top of the Excel based model generator. If the data is verified then the last icon will proceed to produce a Revit model.

3D piling model  in Revit

That’s it, pretty straight forward and potentially a massive time saver.


About lawrenceh

I am employed by Excitech, one of the largest Autodesk resellers in the UK, to provide training and other services such as implementation and project support to our clients. The main products I get involved with are Autodesk Revit Structure, Dynamo & Autodesk Inventor. My personal interests include aviation, engineering and walking.
This entry was posted in Tips and Tricks and tagged , , , , . Bookmark the permalink.

8 Responses to Modelling Revit Piling from Microsoft Excel

  1. Johan Moens says:

    Thanks for sharing this idee. Keep on reviting !

  2. lawrenceh says:

    No problem, glad you enjoyed it.

  3. rtaube says:

    This is great!, but I don’t see where to find this extension. Is there a website I go to download it?

  4. this very good information I would get excel
    Greetings from Peru

  5. Has anyone tried to use a feature like this to export data from Revit and into Microstation using the data from the spreadsheet as the median.

  6. Pingback: Modelling Piling from Microsoft Excel using Revit & Dynamo | Autodesk Revit Structure

  7. Pingback: Modelling Piling from Microsoft Excel using Revit & Dynamo - Revit news

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 )

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s