# Room Data Sheets

**URL:** <https://forum.dynamobim.com/t/room-data-sheets/18853>\
**Category:** Revit\
**Created:** [February 6, 2018, 7:42pm UTC](https://forum.dynamobim.com/t/room-data-sheets/18853 "2018-02-06T19:42:23Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![asma.salim](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/asma.salim/32/40994_2.png) [@asma.salim](https://forum.dynamobim.com/u/asma.salim)\
**Post date:** [February 6, 2018, 7:42pm UTC](https://forum.dynamobim.com/t/room-data-sheets/18853/1 "2018-02-06T19:42:23Z")

</div>

Hi @viktor_kuzev

I am having a similar problem with completing room data sheets. Is there a link to where I can get a python code to substitute certain words in an excel document (as you suggested) in below link.

> [@Revit Room Data Sheets, Duplicate Excel Sheet and write excel to specific cells](https://forum.dynamobim.com/t/revit-room-data-sheets-duplicate-excel-sheet-and-write-excel-to-specific-cells/11000):
>
> Hello all, I am new to dynamo and visual programming, and I was hoping I can get a hand from someone on the forum. OVERVIEW I am trying to get my script to produce a Room Data Sheet per room in Excel, so that’s a separate excel file or excel worksheet for each room. so at the end of it, I want to be able to mass produce a room data sheet for each of the 300 rooms in our building with a set of excel files that all look the same. Now I might have approached this all wrong!, but the script is cu…

Thanks!

---

<div class="post-metadata">

**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 7, 2018, 9:25am UTC](https://forum.dynamobim.com/t/room-data-sheets/18853/2 "2018-02-07T09:25:13Z")

</div>

You don’t need python for this- a simple string.replace node will do it.  
It gets more complicated if there are multiple replacements- in which case you may be better off using dictionaries

 ![20180207%20Dynamo%20string%20replace](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/c/2/c218f5b4e573616ff28840d2ad884060f204b6fc.PNG)

incidentally- the method described in the linked post for creating & formatting room data sheets in Dynamo works, but can be very complicated and error prone. In my experience, it is easier to export all the data (using either Dynamo or the build-in ODBC export) then format/sort/group the data to your heart’s content. I used Access

 ![20180207%20Revit%20room%20data%20sheets](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/e/b/eb00f68302dd2ad84e7dac7aaa166bab21ff1cc1.gif)

Andrew
