Community
You could just use the Excel Based Model Generation for Revit, this is part of the extensions and can be downloaded from Autodesk Exchange Apps, Here is a link to my blog which shows using this extension to model piling from an Excel Sheet.
Hope this helps,
lawrence