# Read data from excel

**URL:** <https://forum.dynamobim.com/t/read-data-from-excel/3828>\
**Category:** Packages\
**Created:** [April 23, 2016, 2:33pm UTC](https://forum.dynamobim.com/t/read-data-from-excel/3828 "2016-04-23T14:33:58Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sam\_John](https://avatars.discourse-cdn.com/v4/letter/s/58f4c7/32.png) [@Sam\_John](https://forum.dynamobim.com/u/Sam_John)\
**Post date:** [April 23, 2016, 2:33pm UTC](https://forum.dynamobim.com/t/read-data-from-excel/3828/1 "2016-04-23T14:33:58Z")

</div>

Hey

Is it possible to make script like this:

1. Get all family and type from model
2. Check that family / type exists in An Excel spreadsheet
3. If so, take the code in Excel and place it in the type code parameter
4. Set consecutive number to the number of types of the objects

Here an example.

![Escel_type_1](https://cdck-file-uploads-us1.s3.dualstack.us-west-2.amazonaws.com/flex022/uploads/dynamobim/original/2X/0/00fb9b86c89fe48b951621eb7a18094e487bccb7.png)

&nbsp;

---

<div class="post-metadata">

**Author:** ![Kulkul](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/kulkul/32/49801_2.png) [@Kulkul](https://forum.dynamobim.com/u/Kulkul)\
**Post date:** [April 23, 2016, 10:08pm UTC](https://forum.dynamobim.com/t/read-data-from-excel/3828/2 "2016-04-23T22:08:01Z")

</div>

Hi Sam,

Yes it is possible. See below workflow. Good Luck!

 ![Untitled](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/2X/1/1c2e71d3c41649f4c2240c25ccbc0bfa2cffa164.png)

---

<div class="post-metadata">

**Author:** ![Sam\_John](https://avatars.discourse-cdn.com/v4/letter/s/58f4c7/32.png) [@Sam\_John](https://forum.dynamobim.com/u/Sam_John)\
**Post date:** [April 24, 2016, 1:33am UTC](https://forum.dynamobim.com/t/read-data-from-excel/3828/3 "2016-04-24T01:33:40Z")

</div>

Thank you for your quick reply.

Unfortunately this is not what I want ☹

I want:

1. dynamo makes a list of all objects in the model
2. in excel it checks whether the name of family can be found, if yes, then Dynamo take the code and put it in the “Type Mark” parameter and give the code a continuous number depending number of types of family … example. Door type xxx = DDD 01 and Door type yyy = DDD 02, Window type xxx=CCC 01 Window type yyy=CCC 02

Thanks in advance

Sam