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.