# How can I get X,Y,Z in individual column in excel by using Dynamo

**URL:** <https://forum.dynamobim.com/t/how-can-i-get-x-y-z-in-individual-column-in-excel-by-using-dynamo/71526>\
**Category:** Revit\
**Tags:** revit, excel, dynamo\
**Created:** [December 20, 2021, 2:47am UTC](https://forum.dynamobim.com/t/how-can-i-get-x-y-z-in-individual-column-in-excel-by-using-dynamo/71526 "2021-12-20T02:47:00Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![natcha.jita](https://avatars.discourse-cdn.com/v4/letter/n/dfb087/32.png) [@natcha.jita](https://forum.dynamobim.com/u/natcha.jita)\
**Post date:** [December 20, 2021, 2:47am UTC](https://forum.dynamobim.com/t/how-can-i-get-x-y-z-in-individual-column-in-excel-by-using-dynamo/71526/1 "2021-12-20T02:47:00Z")

</div>

Hello.  
I want to separate coordinates X,Y,Z in to individual column in excel by using Dynamo. Can someone help me please, Thank you.

 ![DynamoQues1.1](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/4/0/402a9cb3c5813c7aff85e6e296cf4553696db904.png)  
 ![DynamoQues1.2](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/4/8/485191cd63158c48510e9c2db93866b3a373bf73.png)

---

<div class="post-metadata">

**Author:** ![jacob.small](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jacob.small/32/161030_2.png) [@jacob.small](https://forum.dynamobim.com/u/jacob.small)\
**Post date:** [December 20, 2021, 2:58am UTC](https://forum.dynamobim.com/t/how-can-i-get-x-y-z-in-individual-column-in-excel-by-using-dynamo/71526/2 "2021-12-20T02:58:10Z")

</div>

Point.X, Point.Y and Point.Z nodes

You might want to include the GUID as well so you have something to tie the data back to.

---

<div class="post-metadata">

**Author:** ![natcha.jita](https://avatars.discourse-cdn.com/v4/letter/n/dfb087/32.png) [@natcha.jita](https://forum.dynamobim.com/u/natcha.jita)\
**Post date:** [December 20, 2021, 3:34am UTC](https://forum.dynamobim.com/t/how-can-i-get-x-y-z-in-individual-column-in-excel-by-using-dynamo/71526/4 "2021-12-20T03:34:41Z")

</div>

Thank you for helping me. But I have some confusion about that nodes, so if it’s not bothering you, could you show me how to use Point X, Point Y, and Point Z nodes with my Dynamo form in the picture above. Thank you so much. 🙂

---

<div class="post-metadata">

**Author:** ![honeyjain619](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/honeyjain619/32/121215_2.png) [@honeyjain619](https://forum.dynamobim.com/u/honeyjain619)\
**Post date:** [December 20, 2021, 4:21am UTC](https://forum.dynamobim.com/t/how-can-i-get-x-y-z-in-individual-column-in-excel-by-using-dynamo/71526/5 "2021-12-20T04:21:04Z")

</div>

Hello @natcha.jita

Currently you are getting lines as an output from “Element.Location” and for the line you need to specify which point you want like stating point, end point, mid point of the line.  
if i am assuming you want both the point start and end point of the line then you can take the reference of this script.

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

---

<div class="post-metadata">

**Author:** ![natcha.jita](https://avatars.discourse-cdn.com/v4/letter/n/dfb087/32.png) [@natcha.jita](https://forum.dynamobim.com/u/natcha.jita)\
**Post date:** [December 20, 2021, 6:13pm UTC](https://forum.dynamobim.com/t/how-can-i-get-x-y-z-in-individual-column-in-excel-by-using-dynamo/71526/6 "2021-12-20T18:13:37Z")

</div>

Thank you so much for helping me. 🤍