# Export FamilyInstance.location to excel, then import coordinates

**URL:** <https://forum.dynamobim.com/t/export-familyinstance-location-to-excel-then-import-coordinates/57262>\
**Category:** Revit\
**Created:** [November 14, 2020, 5:18pm UTC](https://forum.dynamobim.com/t/export-familyinstance-location-to-excel-then-import-coordinates/57262 "2020-11-14T17:18:29Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Remi](https://avatars.discourse-cdn.com/v4/letter/r/ed8c4c/32.png) [@Remi](https://forum.dynamobim.com/u/Remi)\
**Post date:** [November 14, 2020, 5:18pm UTC](https://forum.dynamobim.com/t/export-familyinstance-location-to-excel-then-import-coordinates/57262/1 "2020-11-14T17:18:29Z")

</div>

Hi everyone,  
I’m new to this forum and I hope to be doing things correctly. If not, please tell me and I’ll correct it 🙂

I’m learning both Revit and Dynamo by myself, using videos or forums like this one where I already get answers to my issues. Then, thanks for what you’ve done here, for the answers and the asks.

To do it as short as possible :  
I have to export the insertion point of some objects to Excel. For that, I used the FamilyInstance.Location to grab XYZ coordinates. For example, I get this value :  
Point(X = -99.803, Y = 45.468, Z = -0.950)  
This node has a “Point” output, then it means I should be able to use it to position something on that point.  
I then have to use those coordinates to create objects in another project. But when I try to use the value as insertion point, I get an error because a point can’t be a string…

Do you know if I can deal with it in some ways ?  
Here’s a picture of my dynamo if it can help you understand what I need to do… 🙂

 ![Insert Résa 2020-11-14_06-14-25](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/b/6/b647d32b51b2a78751b75a9e98b46fae17de431e.png)

Thanks for the help, I hope you’ll be able to understand me… I’m french and I didn’t learn english that much at school 😃

---

<div class="post-metadata">

**Author:** ![Daan](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/daan/32/82246_2.png) [@Daan](https://forum.dynamobim.com/u/Daan)\
**Post date:** [November 14, 2020, 6:26pm UTC](https://forum.dynamobim.com/t/export-familyinstance-location-to-excel-then-import-coordinates/57262/2 "2020-11-14T18:26:27Z")

</div>

Bonsior @Remi😜 ,

Have you tried using the nodes **Point.X** , **Point.Y** and **Point.Z** as export values into an Excel-file? Then when you need these points again, you can read these from Excel and recreate points with the **Point.ByCoordinates** Node. (If you need help with this, i would be more than happy to assist you 🙂 )

Regards,  
Daan

PS: glad to hear that you are learning Dynamo and Revit by yourself!!

---

<div class="post-metadata">

**Author:** ![Remi](https://avatars.discourse-cdn.com/v4/letter/r/ed8c4c/32.png) [@Remi](https://forum.dynamobim.com/u/Remi)\
**Post date:** [November 14, 2020, 7:46pm UTC](https://forum.dynamobim.com/t/export-familyinstance-location-to-excel-then-import-coordinates/57262/3 "2020-11-14T19:46:12Z")

</div>

Thanks a lot @Daan !  
Both Dynamo and Revit are stimulating, I really enjoy it 🙂 There’s a lot of ways to complete goals, and maybe it was why I spent my time trying to use the inapropriate node 😛  
I was wondering I could use the location node to save rows (and time maybe…) but your solution is 100%sure to use the data ^^

Thanks again for your answer !

---

<div class="post-metadata">

**Author:** ![Daan](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/daan/32/82246_2.png) [@Daan](https://forum.dynamobim.com/u/Daan)\
**Post date:** [November 15, 2020, 1:21pm UTC](https://forum.dynamobim.com/t/export-familyinstance-location-to-excel-then-import-coordinates/57262/4 "2020-11-15T13:21:33Z")

</div>

I think it is easier to just export your individual X,Y and Z coordinates 🙂