# Huge tree table in Excel, how can I get this into Revit **URL:** \ **Category:** Packages\ **Created:** [February 8, 2016, 9:18pm UTC](https://forum.dynamobim.com/t/huge-tree-table-in-excel-how-can-i-get-this-into-revit/3128 "2016-02-08T21:18:48Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![Al\_Steven](https://avatars.discourse-cdn.com/v4/letter/a/858c86/32.png) [@Al\_Steven](https://forum.dynamobim.com/u/Al_Steven)\ **Post date:** [February 8, 2016, 9:18pm UTC](https://forum.dynamobim.com/t/huge-tree-table-in-excel-how-can-i-get-this-into-revit/3128/1 "2016-02-08T21:18:48Z")
Hi There, I am very new to Dynamo and think it will be of great benifit. I have a table from a surveyor who has completed a Tree survey for us but think 4oo trees will take too long to put in maually. If someone can help me Id really appreciate it. I would have so many uses for this as I receive coordinates all the time and usually use points to place from a CAD link. Anyway my list is here in meters. List has Point number Easting Northing Tree Spread Tree height and trunk Diameter. sample tree list Can dynamo make this work? Just with any generic tree. I only have 3 trees in this one. Thanks and I look forward to learning more about dynamo. Cheers Allan   ---
**Author:** ![Andrew\_Hannell](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/andrew_hannell/32/103315_2.png) [@Andrew\_Hannell](https://forum.dynamobim.com/u/Andrew_Hannell)\ **Post date:** [February 9, 2016, 6:13pm UTC](https://forum.dynamobim.com/t/huge-tree-table-in-excel-how-can-i-get-this-into-revit/3128/2 "2016-02-09T18:13:27Z")
Hi Allan Yes it can. However, you would need to work through how the properties in the spreadsheet relate to Revit objects: For example - is the diameter an instance parameter, or a type parameter - Is the 'height' the height of the tree above ground, or the elevation above a datum (level) - What is the elevation of the base of the tree ? - Is the point column meant as the tree number or a 'mark'   Andrew ---
**Author:** ![Al\_Steven](https://avatars.discourse-cdn.com/v4/letter/a/858c86/32.png) [@Al\_Steven](https://forum.dynamobim.com/u/Al_Steven)\ **Post date:** [February 9, 2016, 6:47pm UTC](https://forum.dynamobim.com/t/huge-tree-table-in-excel-how-can-i-get-this-into-revit/3128/3 "2016-02-09T18:47:05Z")
Gday Andrew, Many thanks for your reply, its much appreciated. I will try and answer your questions. I am obviously new at this so apologies for anything that I don’t understand. I usually create a surface using Civil3d (triangulated) and CAD link in the file to datum rl0.0 using that layer “Triangles”. This way the surface is at the correct Australia Height Datum. So the height of the tree should sit at the correct height. The elevation of the tree is at ground level (where the trunk meets the ground). We can forget about the tree number I guess, its relevant in Civil3d (Tree table but probably not for REVIT). I am not sure about what you meant by this…??? is the diameter an instance parameter, or a type parameter ??? What would be awesome would be to have the tree (see attached) to come in with all the aboveto say this generic tree. [3D Tree - Ellipse (AUS)](http://dynamobim.org/wp-content/uploads/forum-assets/astevencmssurveyors-com-au/02/10/3D-Tree-Ellipse-AUS.rfa) I Have also attached a pdf of the tree I want to place, as you can see properties that I would like the tree to adopt from the excel file. Again Andrew your help…any…is much appreciated. Thanks Allan [tree doc](http://dynamobim.org/wp-content/uploads/forum-assets/astevencmssurveyors-com-au/02/10/tree-doc.pdf) ---
**Author:** ![Andrew\_Hannell](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/andrew_hannell/32/103315_2.png) [@Andrew\_Hannell](https://forum.dynamobim.com/u/Andrew_Hannell)\ **Post date:** [February 9, 2016, 9:49pm UTC](https://forum.dynamobim.com/t/huge-tree-table-in-excel-how-can-i-get-this-into-revit/3128/4 "2016-02-09T21:49:32Z")
Hi Allan Instance parameters can be different for each instance- easiest to do all your tree parameters as instance. I suggest reading up on this- someone else can explain it better than me. Refer attached for a 5 minute try Basic steps are: 1. Read in data 2. Split into columns 3. Feed into data into family It would need an hour or two to finesse. You can see I have set the elevation (Z) of all trees to zero- you might need another column for this and put it into the ‘offset’ parameter I have also fixed up the units in the spreadsheet to mm   Andrew [sample-tree-list](http://dynamobim.org/wp-content/uploads/forum-assets/andrew-hannelleicactiv-com/02/10/sample-tree-list.xlsx) [tree importer](http://dynamobim.org/wp-content/uploads/forum-assets/andrew-hannelleicactiv-com/02/10/tree-importer.rvt) [sample-tree-list](http://dynamobim.org/wp-content/uploads/forum-assets/andrew-hannelleicactiv-com/02/10/sample-tree-list.xlsx)   ![20160210 tree importer](http://dynamobim.org/wp-content/uploads/forum-assets/andrew-hannelleicactiv-com/02/10/20160210-tree-importer.png) ---
**Author:** ![Al\_Steven](https://avatars.discourse-cdn.com/v4/letter/a/858c86/32.png) [@Al\_Steven](https://forum.dynamobim.com/u/Al_Steven)\ **Post date:** [February 9, 2016, 10:20pm UTC](https://forum.dynamobim.com/t/huge-tree-table-in-excel-how-can-i-get-this-into-revit/3128/5 "2016-02-09T22:20:17Z")
Thanks Andrew, This is great. Do you have the dynamo screenshot I can have a look at? Or you can send me? Thanks again for you time on this its much appreciated. Cheers Allan ---
**Author:** ![Andrew\_Hannell](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/andrew_hannell/32/103315_2.png) [@Andrew\_Hannell](https://forum.dynamobim.com/u/Andrew_Hannell)\ **Post date:** [February 9, 2016, 10:39pm UTC](https://forum.dynamobim.com/t/huge-tree-table-in-excel-how-can-i-get-this-into-revit/3128/6 "2016-02-09T22:39:10Z")
sorry, I meant to attach the dyn file, not the excel file twice [tree importer v1](http://dynamobim.org/wp-content/uploads/forum-assets/andrew-hannelleicactiv-com/02/10/tree-importer-v1.dyn) tree importer v1 It looks more complicated than it is   ---
**Author:** ![Al\_Steven](https://avatars.discourse-cdn.com/v4/letter/a/858c86/32.png) [@Al\_Steven](https://forum.dynamobim.com/u/Al_Steven)\ **Post date:** [February 9, 2016, 10:41pm UTC](https://forum.dynamobim.com/t/huge-tree-table-in-excel-how-can-i-get-this-into-revit/3128/7 "2016-02-09T22:41:49Z")
Thanks Mate. Legend! Cheers Allan ---
**Author:** ![Al\_Steven](https://avatars.discourse-cdn.com/v4/letter/a/858c86/32.png) [@Al\_Steven](https://forum.dynamobim.com/u/Al_Steven)\ **Post date:** [February 10, 2016, 9:32pm UTC](https://forum.dynamobim.com/t/huge-tree-table-in-excel-how-can-i-get-this-into-revit/3128/8 "2016-02-10T21:32:39Z")
Hi Andrew, I have managed to get the trees working for position, Tree height and spread. BUT one thing I cant for the life work out is to get the trees to associate to the elevation (RL) in row G? the “Z” value. [CMS-tree-importer-v1](http://dynamobim.org/wp-content/uploads/forum-assets/astevencmssurveyors-com-au/02/11/CMS-tree-importer-v1.dyn) [sample-tree-list](http://dynamobim.org/wp-content/uploads/forum-assets/astevencmssurveyors-com-au/02/11/sample-tree-list.xlsx) Any ideas, sorry to be a pain, no worries if not… Regards Allan   ---
**Author:** ![Andrew\_Hannell](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/andrew_hannell/32/103315_2.png) [@Andrew\_Hannell](https://forum.dynamobim.com/u/Andrew_Hannell)\ **Post date:** [February 11, 2016, 6:19pm UTC](https://forum.dynamobim.com/t/huge-tree-table-in-excel-how-can-i-get-this-into-revit/3128/9 "2016-02-11T18:19:34Z")
Refer attached [CMS-tree-importer-v2](http://dynamobim.org/wp-content/uploads/forum-assets/andrew-hannelleicactiv-com/02/11/CMS-tree-importer-v2.dyn) You had got the columns mixed up- by adding an extra column- you need to take every 7th item, not 6th (in the green sections) There is probably a more graceful way to split up the columns (The trunk diameter column in the spreadsheet also needs to be corrected)   ![20160212 tree importer dynamo 2](http://dynamobim.org/wp-content/uploads/forum-assets/andrew-hannelleicactiv-com/02/11/20160212-tree-importer-dynamo-2.png) ![20160212 tree importer dynamo](http://dynamobim.org/wp-content/uploads/forum-assets/andrew-hannelleicactiv-com/02/11/20160212-tree-importer-dynamo.png)   Andrew ---
**Author:** ![Al\_Steven](https://avatars.discourse-cdn.com/v4/letter/a/858c86/32.png) [@Al\_Steven](https://forum.dynamobim.com/u/Al_Steven)\ **Post date:** [February 11, 2016, 7:11pm UTC](https://forum.dynamobim.com/t/huge-tree-table-in-excel-how-can-i-get-this-into-revit/3128/10 "2016-02-11T19:11:24Z")
Andrew, I owe you a beer! Thanks so much you have saved me so much time. Cheers Allan ---
**Author:** ![samuelfc90](https://avatars.discourse-cdn.com/v4/letter/s/9fc29f/32.png) [@samuelfc90](https://forum.dynamobim.com/u/samuelfc90)\ **Post date:** [April 22, 2020, 4:52pm UTC](https://forum.dynamobim.com/t/huge-tree-table-in-excel-how-can-i-get-this-into-revit/3128/11 "2020-04-22T16:52:27Z")
Hi there, @Andrew_Hannell I am having the same problem myself (4 years later, the files are not available anymore). Could you share it again? I have been trying all day to do it, but nothing. Would you mind? Thanks, and hope you are ok during this crazy times. Best Regards, Sam F. ---
**Author:** ![Andrew\_Hannell](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/andrew_hannell/32/103315_2.png) [@Andrew\_Hannell](https://forum.dynamobim.com/u/Andrew_Hannell)\ **Post date:** [April 22, 2020, 10:15pm UTC](https://forum.dynamobim.com/t/huge-tree-table-in-excel-how-can-i-get-this-into-revit/3128/12 "2020-04-22T22:15:35Z")
@samuelfc90 surprised myself by finding them: [CMS-tree-importer-v2.dyn](https://forum.dynamobim.com/uploads/short-url/rikrMKM7jc5bnhnTCK8381zMrrQ.dyn) (32.1 KB) [sample-tree-list.xlsx](https://forum.dynamobim.com/uploads/short-url/fVvPNRGce4tANBqbkmAzNG5HD2g.xlsx) (9.3 KB) [tree importer.rvt](https://forum.dynamobim.com/uploads/short-url/via9Cb5fXnbvzGtPqQyl9UK4bM1.rvt) (3.4 MB) ---
**Author:** ![samuelfc90](https://avatars.discourse-cdn.com/v4/letter/s/9fc29f/32.png) [@samuelfc90](https://forum.dynamobim.com/u/samuelfc90)\ **Post date:** [April 23, 2020, 11:12am UTC](https://forum.dynamobim.com/t/huge-tree-table-in-excel-how-can-i-get-this-into-revit/3128/13 "2020-04-23T11:12:17Z")
That is great!! thanks so much