# Exporting Furniture Info from Revit to Excel

**URL:** <https://forum.dynamobim.com/t/exporting-furniture-info-from-revit-to-excel/10390>\
**Category:** Revit\
**Tags:** revit, excel\
**Created:** [March 16, 2017, 4:58pm UTC](https://forum.dynamobim.com/t/exporting-furniture-info-from-revit-to-excel/10390 "2017-03-16T16:58:53Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![abutterfield](https://avatars.discourse-cdn.com/v4/letter/a/a88e57/32.png) [@abutterfield](https://forum.dynamobim.com/u/abutterfield)\
**Post date:** [March 16, 2017, 4:58pm UTC](https://forum.dynamobim.com/t/exporting-furniture-info-from-revit-to-excel/10390/1 "2017-03-16T16:58:53Z")

</div>

This is my first attempt at a dynamo script. I want to export several parameter values from Revit to an excel sheet and be able to edit the information in excel to import it back to Revit. But my first script is not even exporting the data correctly to excel. It just shows up as blank cells in the excel document but the sheet tab is renamed. What am I missing?

 ![](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/5/1/512a203886d7598a606418214024b734cce9dbf9.png)

---

<div class="post-metadata">

**Author:** ![4bimfercesp](https://avatars.discourse-cdn.com/v4/letter/4/b782af/32.png) [@4bimfercesp](https://forum.dynamobim.com/u/4bimfercesp)\
**Post date:** [March 16, 2017, 5:11pm UTC](https://forum.dynamobim.com/t/exporting-furniture-info-from-revit-to-excel/10390/2 "2017-03-16T17:11:50Z")

</div>

@abutterfield  
just wondering…do you actually have some elements on your model? normally a blank cell means to my experience the category you trying to collect may not be present in your model can you check this? I have nearly same script as yours and it working for me. the only difference is I do not have List.Transpose after the List.Create…

---

<div class="post-metadata">

**Author:** ![abutterfield](https://avatars.discourse-cdn.com/v4/letter/a/a88e57/32.png) [@abutterfield](https://forum.dynamobim.com/u/abutterfield)\
**Post date:** [March 16, 2017, 5:24pm UTC](https://forum.dynamobim.com/t/exporting-furniture-info-from-revit-to-excel/10390/3 "2017-03-16T17:24:37Z")

</div>

Good thought, but I have several furniture items in the model.  
[cid:image001.png@01D29E58.9BE284F0]

![](https://cdck-file-uploads-us1.s3.dualstack.us-west-2.amazonaws.com/flex022/uploads/dynamobim/original/3X/7/a/7a91af0760426de33a87cdfcab52118e2fe15d50.png)

---

<div class="post-metadata">

**Author:** ![4bimfercesp](https://avatars.discourse-cdn.com/v4/letter/4/b782af/32.png) [@4bimfercesp](https://forum.dynamobim.com/u/4bimfercesp)\
**Post date:** [March 16, 2017, 5:41pm UTC](https://forum.dynamobim.com/t/exporting-furniture-info-from-revit-to-excel/10390/4 "2017-03-16T17:41:03Z")

</div>

@abutterfield  
here you go…try this and let me know. there are also many ways you can do this but for me this works.

 ![](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/2/8/28ded5d439a2e4656e0f51820ba4078fdcd33df5.PNG)

hope this helps.

---

<div class="post-metadata">

**Author:** ![abutterfield](https://avatars.discourse-cdn.com/v4/letter/a/a88e57/32.png) [@abutterfield](https://forum.dynamobim.com/u/abutterfield)\
**Post date:** [March 16, 2017, 5:54pm UTC](https://forum.dynamobim.com/t/exporting-furniture-info-from-revit-to-excel/10390/5 "2017-03-16T17:54:52Z")

</div>

It worked! Apparently I needed to include the FamilyInstance.Type node. Thank you.

---

<div class="post-metadata">

**Author:** ![4bimfercesp](https://avatars.discourse-cdn.com/v4/letter/4/b782af/32.png) [@4bimfercesp](https://forum.dynamobim.com/u/4bimfercesp)\
**Post date:** [March 16, 2017, 6:09pm UTC](https://forum.dynamobim.com/t/exporting-furniture-info-from-revit-to-excel/10390/6 "2017-03-16T18:09:49Z")

</div>

@abutterfield  
no probs…glad to help.  
can you mark it solved.