# Dynamo to Excel: Create an Excel file for spot coordinate **URL:** \ **Category:** Revit\ **Tags:** revit, excel, python, dynamo\ **Created:** [January 14, 2019, 4:51am UTC](https://forum.dynamobim.com/t/dynamo-to-excel-create-an-excel-file-for-spot-coordinate/30647 "2019-01-14T04:51:50Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![Nissal](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/nissal/32/67016_2.png) [@Nissal](https://forum.dynamobim.com/u/Nissal)\ **Post date:** [January 14, 2019, 4:51am UTC](https://forum.dynamobim.com/t/dynamo-to-excel-create-an-excel-file-for-spot-coordinate/30647/1 "2019-01-14T04:51:50Z")
Hi, Im trying to make an excel file of spot coordinates of model elements(mainly assets). I had reached to file one phase of generating XYZ coordinates in Watch node. Next part of creating an excel, im putting a value in string node but it is not generating. I had typed in variables like x, X, projectPosition.EastWest, EastWest, .EastWest, Name, East, x= projectPosition.EastWest. Below are the screenshots. ![Doubt1](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/b/8/b835798f5faeaf6ceead6ec194ad7b9a8e61d686.jpeg) [Wetransfer link for dynamo file reference] [https://we.tl/t-Hi6B9RJb0S](https://we.tl/t-Hi6B9RJb0S) I dont know how to proceed further. Please put your valuable suggestion. It would be thoughtful for me ---
**Author:** ![salvatoredragotta](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/salvatoredragotta/32/10078_2.png) [@salvatoredragotta](https://forum.dynamobim.com/u/salvatoredragotta)\ **Post date:** [January 14, 2019, 5:01am UTC](https://forum.dynamobim.com/t/dynamo-to-excel-create-an-excel-file-for-spot-coordinate/30647/2 "2019-01-14T05:01:37Z")
@Nissal Dynamo Points don’t have a parameter ---
**Author:** ![Nissal](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/nissal/32/67016_2.png) [@Nissal](https://forum.dynamobim.com/u/Nissal)\ **Post date:** [January 14, 2019, 5:09am UTC](https://forum.dynamobim.com/t/dynamo-to-excel-create-an-excel-file-for-spot-coordinate/30647/3 "2019-01-14T05:09:53Z")
> [@salvatoredragotta](#): > > Dynamo Points don’t have a paramete Ok. so how should i proceed? To make that watch box as an excel file. -Thank you for your response salvatoredragotta 😊 ---
**Author:** ![salvatoredragotta](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/salvatoredragotta/32/10078_2.png) [@salvatoredragotta](https://forum.dynamobim.com/u/salvatoredragotta)\ **Post date:** [January 14, 2019, 5:13am UTC](https://forum.dynamobim.com/t/dynamo-to-excel-create-an-excel-file-for-spot-coordinate/30647/4 "2019-01-14T05:13:14Z")
@Nissal I’m not sure what you are trying to do. if you just need the x,y,z just use Point.X, Point.Y, Point.Z nodes ---
**Author:** ![Nissal](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/nissal/32/67016_2.png) [@Nissal](https://forum.dynamobim.com/u/Nissal)\ **Post date:** [January 14, 2019, 5:20am UTC](https://forum.dynamobim.com/t/dynamo-to-excel-create-an-excel-file-for-spot-coordinate/30647/5 "2019-01-14T05:20:33Z")
> [@salvatoredragotta](#): > > Point.X I will clear again. XYZ are spot coordinates of elements. As in revit it shows North East of an element.Z is the height. Trying to make that in excel format. I had tried your inputs Point.X , Point.x, point.X, point.x, Point\_X, Point=X (with all caps small also) ---
**Author:** ![salvatoredragotta](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/salvatoredragotta/32/10078_2.png) [@salvatoredragotta](https://forum.dynamobim.com/u/salvatoredragotta)\ **Post date:** [January 14, 2019, 5:21am UTC](https://forum.dynamobim.com/t/dynamo-to-excel-create-an-excel-file-for-spot-coordinate/30647/6 "2019-01-14T05:21:56Z")
@Nissal are you using nodes? ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/c/d/cd5ce6b2defcd1519e40aade02f8366ac9acdae4.png) ---
**Author:** ![Nissal](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/nissal/32/67016_2.png) [@Nissal](https://forum.dynamobim.com/u/Nissal)\ **Post date:** [January 14, 2019, 5:34am UTC](https://forum.dynamobim.com/t/dynamo-to-excel-create-an-excel-file-for-spot-coordinate/30647/7 "2019-01-14T05:34:37Z")
I didnt tried that. I havent seen how to use that. I was referring to youtube link for dynamo. At 9.10, he used the same string node and generated his output. ![doubt4](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/6/f/6faeceb7a2c31e576d9e28749512714ac990099d.jpeg) image bit blur. he typed Name in string node and got his room names in output ---
**Author:** ![salvatoredragotta](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/salvatoredragotta/32/10078_2.png) [@salvatoredragotta](https://forum.dynamobim.com/u/salvatoredragotta)\ **Post date:** [January 14, 2019, 5:36am UTC](https://forum.dynamobim.com/t/dynamo-to-excel-create-an-excel-file-for-spot-coordinate/30647/8 "2019-01-14T05:36:29Z")
> [@Nissal](#): > > I didnt tried that. I havent seen how to use that. Try it and see if you get what you want ---
**Author:** ![kennyb6](https://avatars.discourse-cdn.com/v4/letter/k/7ba0ec/32.png) [@kennyb6](https://forum.dynamobim.com/u/kennyb6)\ **Post date:** [January 14, 2019, 5:53am UTC](https://forum.dynamobim.com/t/dynamo-to-excel-create-an-excel-file-for-spot-coordinate/30647/9 "2019-01-14T05:53:27Z")
Point.X isn’t a variable you can call using the GetParameterValueByName node, it is its own node/method. GetParameterValueByName is mostly used to get parameters from Revit elements, not Dynamo geometry. You can get parameters of Dynamo geometry using built-in nodes, as seen here: [http://dictionary.dynamobim.com/#/Geometry/Point/Query/X](http://dictionary.dynamobim.com/#/Geometry/Point/Query/X) ![pointx](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/d/5/d5172cd0babdd3a09b9aeed714c46487df0101f3.png) ---
**Author:** ![Nissal](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/nissal/32/67016_2.png) [@Nissal](https://forum.dynamobim.com/u/Nissal)\ **Post date:** [January 14, 2019, 9:04am UTC](https://forum.dynamobim.com/t/dynamo-to-excel-create-an-excel-file-for-spot-coordinate/30647/10 "2019-01-14T09:04:07Z")
Hi tried to used to point X node. Still not getting how to connect these values in excel format ![doubt%205](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/8/9/89aaddbba6a42ac3da25a9e14a7a9f80f3b2b299.jpeg) ---
**Author:** ![salvatoredragotta](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/salvatoredragotta/32/10078_2.png) [@salvatoredragotta](https://forum.dynamobim.com/u/salvatoredragotta)\ **Post date:** [January 14, 2019, 10:18pm UTC](https://forum.dynamobim.com/t/dynamo-to-excel-create-an-excel-file-for-spot-coordinate/30647/11 "2019-01-14T22:18:27Z")
@Nissal Exporting to excel is very trivial. Search this forum or google it. [http://dictionary.dynamobim.com/#/Office/Excel/Action/WriteToFile](http://dictionary.dynamobim.com/#/Office/Excel/Action/WriteToFile) ---
**Author:** ![Mark.Ackerley](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/mark.ackerley/32/79310_2.png) [@Mark.Ackerley](https://forum.dynamobim.com/u/Mark.Ackerley)\ **Post date:** [January 15, 2019, 12:21pm UTC](https://forum.dynamobim.com/t/dynamo-to-excel-create-an-excel-file-for-spot-coordinate/30647/12 "2019-01-15T12:21:17Z")
Hey, Maybe don’t over think it? ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/1/a/1afeb99ff0c161b1c19caadc37e3c50cf2e8622f.png) ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/c/1/c1129cd9ef9939904d5881f8c55fbaa9142593fe.png) If you want the Mark you can do this… ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/d/4/d414846af90c9c31ed780f4d6fdce0479992c5c3.png) ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/a/f/afb67335cc064715f23532f76b4e8d64d71e002f.png) And if you want headers, you can do this… ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/6/3/634c792f7c3b9fc5a345cb7206b672f4696c04bb.png) ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/6/b/6be016846ef00a623e772508d12bf4253e44406d.png) If you want the location as separate columns, here’s an alternative approach if you’re interested… ![Capture](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/9/f/9fadf14a1a9efed2f2d93002814c623da2a9d3e9.png) ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/6/d/6d85c204a5a53cbdfe2cd0f3a9898a09987806a5.png) Hopefully that’s enough to get you going… Don’t be afraid to just play with the settings. Cheers, Mark ---
**Author:** ![ashwinash112](https://avatars.discourse-cdn.com/v4/letter/a/58956e/32.png) [@ashwinash112](https://forum.dynamobim.com/u/ashwinash112)\ **Post date:** [January 25, 2019, 12:29pm UTC](https://forum.dynamobim.com/t/dynamo-to-excel-create-an-excel-file-for-spot-coordinate/30647/13 "2019-01-25T12:29:04Z")
[Spot Coordinate v 1.0.dyn](https://forum.dynamobim.com/uploads/short-url/gobO8cx930muycXupVxZcdp5D9y.dyn) (24.3 KB) ---
**Author:** ![Nissal](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/nissal/32/67016_2.png) [@Nissal](https://forum.dynamobim.com/u/Nissal)\ **Post date:** [February 12, 2019, 7:11am UTC](https://forum.dynamobim.com/t/dynamo-to-excel-create-an-excel-file-for-spot-coordinate/30647/14 "2019-02-12T07:11:03Z")
Mark.Ackerley salvatoredragotta kennyb6 ashwinash112 Big thank you to all of you. Resolved my query. 🙂 -Cheers 🥳