# Duplicate Excel Sheets **URL:** https://forum.dynamobim.com/t/duplicate-excel-sheets/52449 **Category:** Uncategorized **Tags:** excel, python, dynamo **Created:** [June 30, 2020, 4:30pm UTC](https://forum.dynamobim.com/t/duplicate-excel-sheets/52449 "2020-06-30T16:30:07Z") **Posts on this page:** 5 **Page:** 1
### Author: ![Daan](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/daan/32/82246_2.png) [@Daan](https://forum.dynamobim.com/u/Daan) #### Post date: [June 30, 2020, 4:30pm UTC](https://forum.dynamobim.com/t/duplicate-excel-sheets/52449/1 "2020-06-30T16:30:07Z")
Hello everyone, I have made a single template Sheet in Excel which i would like to duplicate with Dynamo (To later put data on each sheet but not having to duplicate this template sheet by hand. ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/a/7/a7225d6808b81265fccb37f6ddcb9c09e25c9ea7.png) Does anyone know how i could achieve this? Thanks in advance! - Daan PS. I couldnt find a right category ---
### Author: ![Nick\_Boyts](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/nick_boyts/32/76313_2.png) [@Nick\_Boyts](https://forum.dynamobim.com/u/Nick_Boyts) #### Post date: [June 30, 2020, 4:33pm UTC](https://forum.dynamobim.com/t/duplicate-excel-sheets/52449/2 "2020-06-30T16:33:33Z")
When you write to excel you can just provide a new sheet name. If a sheet name does not already exist, excel will create it for you. Read the info from your template sheet and then write it back to however many new sheets you need. ---
### Author: ![Daan](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/daan/32/82246_2.png) [@Daan](https://forum.dynamobim.com/u/Daan) #### Post date: [June 30, 2020, 4:45pm UTC](https://forum.dynamobim.com/t/duplicate-excel-sheets/52449/3 "2020-06-30T16:45:08Z")
how can i use this template as input? All the lay-out and colors etc. need to be copied aswell @Nick_Boyts ---
### Author: ![Nick\_Boyts](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/nick_boyts/32/76313_2.png) [@Nick\_Boyts](https://forum.dynamobim.com/u/Nick_Boyts) #### Post date: [June 30, 2020, 5:20pm UTC](https://forum.dynamobim.com/t/duplicate-excel-sheets/52449/4 "2020-06-30T17:20:39Z")
It’s been a while but I think Bumblebee can handle those properties. Otherwise you would have to use the Excel API to write your own code. ---
### Author: ![Daan](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/daan/32/82246_2.png) [@Daan](https://forum.dynamobim.com/u/Daan) #### Post date: [June 30, 2020, 9:40pm UTC](https://forum.dynamobim.com/t/duplicate-excel-sheets/52449/5 "2020-06-30T21:40:29Z")
This is quite a nice and simple solution, but i couldnt copy my existing “template sheet” and populate the new sheets with data in the same dynamo script, so i split them up in two and just use the other one when we update the template file, the only downside of this is that we (almost) always have too many pages in the Excel-file which are just empty templates.