# How to create excel matrix from revit data through Dynamo **URL:** \ **Category:** Revit\ **Tags:** revit, excel, dynamo\ **Created:** [January 6, 2020, 9:01pm UTC](https://forum.dynamobim.com/t/how-to-create-excel-matrix-from-revit-data-through-dynamo/45152 "2020-01-06T21:01:08Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![LievX](https://avatars.discourse-cdn.com/v4/letter/l/7ea924/32.png) [@LievX](https://forum.dynamobim.com/u/LievX)\ **Post date:** [January 6, 2020, 9:01pm UTC](https://forum.dynamobim.com/t/how-to-create-excel-matrix-from-revit-data-through-dynamo/45152/1 "2020-01-06T21:01:08Z")
Hello, I am trying to create a table in excel from revit, the problem is a follow: in column A: Parameter info (rooms) in row A: Parameter info (rooms) body of table: room name that matches both Parameters stated in Column A and Row A Example: [![](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/4/0/405e9fca7a9efbde9db77c188b8a8e209a70d060.jpeg) ](https://dl.dropboxusercontent.com/s/7s47cr7xapc6oic/MATRIX.jpg?dl=0) ---
**Author:** ![jacob.small](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jacob.small/32/161030_2.png) [@jacob.small](https://forum.dynamobim.com/u/jacob.small)\ **Post date:** [January 6, 2020, 10:50pm UTC](https://forum.dynamobim.com/t/how-to-create-excel-matrix-from-revit-data-through-dynamo/45152/2 "2020-01-06T22:50:06Z")
I’m beyond a bit lost on this one, and I think it’s because I don’t know what you currently have set up. Can you post the graph you have built, a camera export of it with previews expanded, and a small sample Revit file (you only need like 4 rooms on two levels to do this on a list)? ---
**Author:** ![LievX](https://avatars.discourse-cdn.com/v4/letter/l/7ea924/32.png) [@LievX](https://forum.dynamobim.com/u/LievX)\ **Post date:** [January 6, 2020, 10:54pm UTC](https://forum.dynamobim.com/t/how-to-create-excel-matrix-from-revit-data-through-dynamo/45152/3 "2020-01-06T22:54:14Z")
Ok, I am not at the office right now, tomorrow as soon as I get there I do it, thank you! ---
**Author:** ![stillgotme](https://avatars.discourse-cdn.com/v4/letter/s/e480ec/32.png) [@stillgotme](https://forum.dynamobim.com/u/stillgotme)\ **Post date:** [January 7, 2020, 5:48am UTC](https://forum.dynamobim.com/t/how-to-create-excel-matrix-from-revit-data-through-dynamo/45152/4 "2020-01-07T05:48:10Z")
what you wanna achieve can be done by using OOTB node WriteToFile(Excel) whereby each item in list represents columns data, and each list represents row data. Check out this [blog post](http://aectechy.com/new-and-improved-visualisation-node/) for a cool visualisation node. ---
**Author:** ![LievX](https://avatars.discourse-cdn.com/v4/letter/l/7ea924/32.png) [@LievX](https://forum.dynamobim.com/u/LievX)\ **Post date:** [January 7, 2020, 5:25pm UTC](https://forum.dynamobim.com/t/how-to-create-excel-matrix-from-revit-data-through-dynamo/45152/5 "2020-01-07T17:25:46Z")
Hi @jacob.small, how are you? I send you here the .dyn and a sample file, please take note that the “level” parameter is not the default “Level” one, is a project parameter created afterwards, also, I believe I am getting where I need now, but, still it needs some tweaks > **[Dynamo Issues](https://www.dropbox.com/sh/13nvma73ydoocyn/AADtkRL7a8v0lDcI972f6Gx7a?dl=0)** > > Shared with Dropbox thank you! ---
**Author:** ![LievX](https://avatars.discourse-cdn.com/v4/letter/l/7ea924/32.png) [@LievX](https://forum.dynamobim.com/u/LievX)\ **Post date:** [January 15, 2020, 7:14pm UTC](https://forum.dynamobim.com/t/how-to-create-excel-matrix-from-revit-data-through-dynamo/45152/6 "2020-01-15T19:14:20Z")
hello, I manage to get the result I wanted, however, it only works if, for each “level” every room has consecutive “bahia” numbers, and in some projects there are some “bahia” missing at certain “level”, ![Data Matrix Full](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/c/5/c5ef1b1cba53f2b1f3f6f944196a5e629230f243.png) ---
**Author:** ![LievX](https://avatars.discourse-cdn.com/v4/letter/l/7ea924/32.png) [@LievX](https://forum.dynamobim.com/u/LievX)\ **Post date:** [January 15, 2020, 7:18pm UTC](https://forum.dynamobim.com/t/how-to-create-excel-matrix-from-revit-data-through-dynamo/45152/7 "2020-01-15T19:18:17Z")
Just to try it out, I deleted the room with “bahia” number 12 at “level” number 01, but it still exists on the other “levels”, the result should be: at xls, column stated as “bahia” 12: blank for “level” 01, “cafeteria” for “level” 02 and “sprinkler” for “level” 03; however I get this result… I don’t know how to solve it… any help please? ![Data Matrix missing 12](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/8/b/8b45b67aa667ce2be91532b2013bfe6ee9bf5f06.jpeg) ---
**Author:** ![LievX](https://avatars.discourse-cdn.com/v4/letter/l/7ea924/32.png) [@LievX](https://forum.dynamobim.com/u/LievX)\ **Post date:** [January 15, 2020, 7:38pm UTC](https://forum.dynamobim.com/t/how-to-create-excel-matrix-from-revit-data-through-dynamo/45152/8 "2020-01-15T19:38:50Z")
hi, @stillgotme how are you? I know the OOTB node, and I know how it works, as a matter of fact I am using that same node in this routine, however ,that node is the last one, and it works just fine, the problem is the data collecting, I don’t want the data to come out just like that, I need to put the info togheter first and that is my actual headache, if you take a look at what I need to achieve you may understand, every row is the list of rooms that share a parameter, and every column is the list of rooms that share another parameter, it is a data matrix