# Export coordinates

**URL:** <https://forum.dynamobim.com/t/export-coordinates/87881>\
**Category:** Revit\
**Tags:** revit, dynamo\
**Created:** [March 27, 2023, 8:07pm UTC](https://forum.dynamobim.com/t/export-coordinates/87881 "2023-03-27T20:07:03Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![Suresh\_Chotrani](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/suresh_chotrani/32/27760_2.png) [@Suresh\_Chotrani](https://forum.dynamobim.com/u/Suresh_Chotrani)\
**Post date:** [March 27, 2023, 8:07pm UTC](https://forum.dynamobim.com/t/export-coordinates/87881/1 "2023-03-27T20:07:03Z")

</div>

Hi,

I need help on correct the file on exporting points in excel for a particular family. I have so far worked on gettings points for the family however, need to transform that into data to export in excel.

Kindly review the image and assist.

 ![Untitled](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/e/4/e4ca6692c8fd4d38cd7ae3010250f905a2c61c99.jpeg)

---

<div class="post-metadata">

**Author:** ![staylor](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/staylor/32/94307_2.png) [@staylor](https://forum.dynamobim.com/u/staylor)\
**Post date:** [March 27, 2023, 8:24pm UTC](https://forum.dynamobim.com/t/export-coordinates/87881/2 "2023-03-27T20:24:53Z")

</div>

Hi @Suresh_Chotrani  
Use the Point.Deconstruct from WombatDynamo package or Points.DeconstructPoint from Lunchbox. From that point, you will need to format the data with how you want it inputted into the spreadsheet.

![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/7/3/73573ecb089621e7eb3c9f9b3500e3a9f0ba9bc5.png)

---

<div class="post-metadata">

**Author:** ![Suresh\_Chotrani](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/suresh_chotrani/32/27760_2.png) [@Suresh\_Chotrani](https://forum.dynamobim.com/u/Suresh_Chotrani)\
**Post date:** [March 27, 2023, 8:42pm UTC](https://forum.dynamobim.com/t/export-coordinates/87881/3 "2023-03-27T20:42:46Z")

</div>

Thanks @staylor  
I have installed Lunchbox, after installation should I search on the left side to find Points.DeconstructPoint.

 ![Untitled](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/b/7/b7714f88c5a704d3416135669e3c88ace4797e98.jpeg)

---

<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:** [March 27, 2023, 8:53pm UTC](https://forum.dynamobim.com/t/export-coordinates/87881/4 "2023-03-27T20:53:42Z")

</div>

No need for lunchbox or wombat here.

`Point.X`, `Point.Y`, and `Point.Z` nodes will return the values you need.

From there it’s a matter of List.Create, List.Transpose, and export to excel.

Alternatively `[pnt.X, pnt.Y, pnt.Z]` in a code block will generate the list you need.

---

<div class="post-metadata">

**Author:** ![staylor](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/staylor/32/94307_2.png) [@staylor](https://forum.dynamobim.com/u/staylor)\
**Post date:** [March 27, 2023, 8:55pm UTC](https://forum.dynamobim.com/t/export-coordinates/87881/5 "2023-03-27T20:55:37Z")

</div>

Thanks @jacob.small  
You are way more advanced in the ways of the Jedi, than I am.

---

<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:** [March 27, 2023, 8:57pm UTC](https://forum.dynamobim.com/t/export-coordinates/87881/6 "2023-03-27T20:57:22Z")

</div>

We all start somewhere!

Speaking of Jedi… I have to get back to the day (night?) job, got a light sabre to model tonight for a coming Dynamo Office Hour!

---

<div class="post-metadata">

**Author:** ![Suresh\_Chotrani](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/suresh_chotrani/32/27760_2.png) [@Suresh\_Chotrani](https://forum.dynamobim.com/u/Suresh_Chotrani)\
**Post date:** [March 27, 2023, 8:58pm UTC](https://forum.dynamobim.com/t/export-coordinates/87881/7 "2023-03-27T20:58:09Z")

</div>

Kindly review

 ![Untitled](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/7/f/7f711ec6c2fcc326a4174965d4614411471a3f00.jpeg)

---

<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:** [March 27, 2023, 8:59pm UTC](https://forum.dynamobim.com/t/export-coordinates/87881/8 "2023-03-27T20:59:02Z")

</div>

You aren’t providing a sheet name, but a function. use a string node to type `Sheet1` or edit the code block to be `"Sheet1"` and you should be all set.

---

<div class="post-metadata">

**Author:** ![Suresh\_Chotrani](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/suresh_chotrani/32/27760_2.png) [@Suresh\_Chotrani](https://forum.dynamobim.com/u/Suresh_Chotrani)\
**Post date:** [March 27, 2023, 9:07pm UTC](https://forum.dynamobim.com/t/export-coordinates/87881/9 "2023-03-27T21:07:34Z")

</div>

![Untitled](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/5/2/52f7dc87700dc8fffee256018cd95190d7040529.jpeg)

---

<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:** [March 27, 2023, 9:08pm UTC](https://forum.dynamobim.com/t/export-coordinates/87881/10 "2023-03-27T21:08:02Z")

</div>

And there we have a solution. 🙂
