# Create or copy new excel sheet in dynamo for each space

**URL:** <https://forum.dynamobim.com/t/create-or-copy-new-excel-sheet-in-dynamo-for-each-space/58826>\
**Category:** Revit\
**Created:** [December 30, 2020, 9:24pm UTC](https://forum.dynamobim.com/t/create-or-copy-new-excel-sheet-in-dynamo-for-each-space/58826 "2020-12-30T21:24:57Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ghassan.abusultanah2](https://avatars.discourse-cdn.com/v4/letter/g/e9bcb4/32.png) [@ghassan.abusultanah2](https://forum.dynamobim.com/u/ghassan.abusultanah2)\
**Post date:** [December 30, 2020, 9:24pm UTC](https://forum.dynamobim.com/t/create-or-copy-new-excel-sheet-in-dynamo-for-each-space/58826/1 "2020-12-30T21:24:57Z")

</div>

I am trying to create new excel sheet for each space in Revit, and name the excel sheet = space name.

Is that possible ?

---

<div class="post-metadata">

**Author:** ![SeanP](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/seanp/32/42560_2.png) [@SeanP](https://forum.dynamobim.com/u/SeanP)\
**Post date:** [December 31, 2020, 2:08am UTC](https://forum.dynamobim.com/t/create-or-copy-new-excel-sheet-in-dynamo-for-each-space/58826/2 "2020-12-31T02:08:49Z")

</div>

I think the Excel.Write node will create a worksheet by the name given if it does not exist. Have you tried that?

---

<div class="post-metadata">

**Author:** ![Bjorn\_Keulemans1](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/bjorn_keulemans1/32/54676_2.png) [@Bjorn\_Keulemans1](https://forum.dynamobim.com/u/Bjorn_Keulemans1)\
**Post date:** [December 31, 2020, 8:05am UTC](https://forum.dynamobim.com/t/create-or-copy-new-excel-sheet-in-dynamo-for-each-space/58826/3 "2020-12-31T08:05:23Z")

</div>

As Sean says, the Excel export will create a Sheet in the Excel file for you.

Instead of giving it 1 Sheet Name and a list with lists of data (Rows) you now have to give it a list of Sheet Names (Space Names) and a list of lists (by Space) of data (Rows).

---

<div class="post-metadata">

**Author:** ![ghassan.abusultanah2](https://avatars.discourse-cdn.com/v4/letter/g/e9bcb4/32.png) [@ghassan.abusultanah2](https://forum.dynamobim.com/u/ghassan.abusultanah2)\
**Post date:** [January 4, 2021, 11:34pm UTC](https://forum.dynamobim.com/t/create-or-copy-new-excel-sheet-in-dynamo-for-each-space/58826/4 "2021-01-04T23:34:09Z")

</div>

Yes, I tried that and works fine except that I can’t keep the excel sheet format the same each time it create new sheet.  
My goal is to extract data from Revit and export it to ready formatted excel sheet.  
I was reading couple of articles about some packages like " bumblebee" and other have something like that, but I couldn’t figure out how it works and I was hopping someone used it before can show me example how that would be done.
