# How to load datasheet values from excel to corresponding family types in Revit

**URL:** <https://forum.dynamobim.com/t/how-to-load-datasheet-values-from-excel-to-corresponding-family-types-in-revit/23731>\
**Category:** Revit\
**Tags:** excel\
**Created:** [July 14, 2018, 12:34pm UTC](https://forum.dynamobim.com/t/how-to-load-datasheet-values-from-excel-to-corresponding-family-types-in-revit/23731 "2018-07-14T12:34:13Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Arun\_Prakash](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/arun_prakash/32/89820_2.png) [@Arun\_Prakash](https://forum.dynamobim.com/u/Arun_Prakash)\
**Post date:** [July 14, 2018, 12:34pm UTC](https://forum.dynamobim.com/t/how-to-load-datasheet-values-from-excel-to-corresponding-family-types-in-revit/23731/1 "2018-07-14T12:34:13Z")

</div>

Hi All,

This post is in continuation with a previous post.,

> [@How to scan spreadsheet get Intersecting cell](https://forum.dynamobim.com/t/how-to-scan-spreadsheet-get-intersecting-cell/23679):
>
> Hi All, I have a radiator datasheet, I need to select the capacity from looking into its type and length. [image] Progress as of now: [image] How do I get the intersecting cell? for eg: [image]

I now have Radiators loaded in the Project, and on the other end, I have powers for the standard Radiators in Excel Spreadsheet.

I don’t know how to use the logic to load in Power to all the instances in the project

Progress as od now:

 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/6/c/6c63ffba18ac894bf531fb72d6d368b65d91e3fd.jpg)

Sample Datasheet for reference:

 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/8/b/8bb4194af0033b4b50f742f228718657b0119ae8.jpg)

---

<div class="post-metadata">

**Author:** ![Arun\_Prakash](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/arun_prakash/32/89820_2.png) [@Arun\_Prakash](https://forum.dynamobim.com/u/Arun_Prakash)\
**Post date:** [July 14, 2018, 1:00pm UTC](https://forum.dynamobim.com/t/how-to-load-datasheet-values-from-excel-to-corresponding-family-types-in-revit/23731/2 "2018-07-14T13:00:03Z")

</div>

Made some progress:

 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/4/2/42164167b1151378a14284948fcb2b38561b3162.jpg)