# Create a 3d arc by reading excel points

**URL:** <https://forum.dynamobim.com/t/create-a-3d-arc-by-reading-excel-points/49188>\
**Category:** Geometry\
**Created:** [April 11, 2020, 11:37am UTC](https://forum.dynamobim.com/t/create-a-3d-arc-by-reading-excel-points/49188 "2020-04-11T11:37:32Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![georgekon](https://avatars.discourse-cdn.com/v4/letter/g/6a8cbe/32.png) [@georgekon](https://forum.dynamobim.com/u/georgekon)\
**Post date:** [April 11, 2020, 11:37am UTC](https://forum.dynamobim.com/t/create-a-3d-arc-by-reading-excel-points/49188/1 "2020-04-11T11:37:32Z")

</div>

Hello everyone!

Just started to learn dynamo in order to make a uni project.  
Long story short  
I have an excel sheet of xyz coordinates of every start,center and end point of each arc and I want to make a loop that makes an arc for each one of those set of points .  
While I managed to import the coordinates, I have trouble at getting the right point from the list and at finding how to make this a loop (loopwhile and range doesn’t seem to work )  
Any advice is welcome

---

<div class="post-metadata">

**Author:** ![Jaafar\_Al\_Nasire](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jaafar_al_nasire/32/92812_2.png) [@Jaafar\_Al\_Nasire](https://forum.dynamobim.com/u/Jaafar_Al_Nasire)\
**Post date:** [April 11, 2020, 11:42am UTC](https://forum.dynamobim.com/t/create-a-3d-arc-by-reading-excel-points/49188/2 "2020-04-11T11:42:43Z")

</div>

Hi @georgekon

How is your excel data is arranged can you send a picture of it

Regards

---

<div class="post-metadata">

**Author:** ![georgekon](https://avatars.discourse-cdn.com/v4/letter/g/6a8cbe/32.png) [@georgekon](https://forum.dynamobim.com/u/georgekon)\
**Post date:** [April 11, 2020, 3:55pm UTC](https://forum.dynamobim.com/t/create-a-3d-arc-by-reading-excel-points/49188/3 "2020-04-11T15:55:20Z")

</div>

![εικόνα](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/d/9/d9d464192aea101b5117a403af471c5e2c67ca46.png)

here it is!

---

<div class="post-metadata">

**Author:** ![Jaafar\_Al\_Nasire](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jaafar_al_nasire/32/92812_2.png) [@Jaafar\_Al\_Nasire](https://forum.dynamobim.com/u/Jaafar_Al_Nasire)\
**Post date:** [April 11, 2020, 5:15pm UTC](https://forum.dynamobim.com/t/create-a-3d-arc-by-reading-excel-points/49188/4 "2020-04-11T17:15:38Z")

</div>

Hi @georgekon  
I suggest a little bit of organizing should do the trick and no need for looping.  
first, in your sheet make sure that all the numbers are numeric values  
so if it was my project I prefer to make each point in a separate sheet, for example, all the center point coordinates in a single sheet as well as the other ends points  
after importing each one to dynamo you will get three lists from each sheet corresponding to x,y,x

 ![Capture](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/c/f/cfe90b4ad3e4e64f4bb8a4069df8e439b2d2ab0b.png)

Regards

---

<div class="post-metadata">

**Author:** ![georgekon](https://avatars.discourse-cdn.com/v4/letter/g/6a8cbe/32.png) [@georgekon](https://forum.dynamobim.com/u/georgekon)\
**Post date:** [April 11, 2020, 6:51pm UTC](https://forum.dynamobim.com/t/create-a-3d-arc-by-reading-excel-points/49188/5 "2020-04-11T18:51:43Z")

</div>

thanks a lot! I will try it out and text you back with the results!
