# Dynamo: Automated Placement of Marker Family from Excel with Custom Attributes **URL:** \ **Category:** Revit\ **Tags:** revit, excel, dynamo\ **Created:** [January 8, 2025, 1:37pm UTC](https://forum.dynamobim.com/t/dynamo-automated-placement-of-marker-family-from-excel-with-custom-attributes/107082 "2025-01-08T13:37:52Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Jobez7](https://avatars.discourse-cdn.com/v4/letter/j/e9a140/32.png) [@Jobez7](https://forum.dynamobim.com/u/Jobez7)\ **Post date:** [January 8, 2025, 1:37pm UTC](https://forum.dynamobim.com/t/dynamo-automated-placement-of-marker-family-from-excel-with-custom-attributes/107082/1 "2025-01-08T13:37:52Z")
Hello everyone, I am seeking your help with a Dynamo project. As a beginner, I would like to accomplish the following task: I have an Excel file containing: - Point coordinates (X, Y, Z) - A ‘value’ column associated with each point My goal is to automate the placement of a ‘Marker’ family on each of these points, following these conditions: 1. Each family must be placed at the exact coordinates of the corresponding point 2. The ‘STG\_PHOTO 360’ attribute of each family must be filled with the ‘value’ associated with the point Concrete example: For point #1 with specific coordinates and a value of 10, I want to: - Place a ‘Marker’ family at these coordinates - Fill its ‘STG\_PHOTO 360’ attribute with the value 10 I have started creating a Dynamo script for this task. You can download it here : [Unique Download Link | WeTransfer](https://we.tl/t-QHxJpvNAgj) Thank you in advance for your help. ---
**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 8, 2025, 2:24pm UTC](https://forum.dynamobim.com/t/dynamo-automated-placement-of-marker-family-from-excel-with-custom-attributes/107082/2 "2025-01-08T14:24:35Z")
Hey, You seemed pretty close… I think you need the ‘End’ node, because you can’t set a parameter until the Placing of the family has been completed. Also, you need to be a little careful of data types… Your value was Text, but it seemed to be coming in as a Number (there is a ‘read as strings’ input on the Excel if you want to force everything to a String, but mostly life is a bit more complex than that!) I suspect your next question will be about Coordinate systems, if so, drop us an example setup with your shared coordinates setup and links 🙂 Hope that helps, Mark P.S People like it if you drop a screen grab in the post, you’ll see Dynamo has a button for that on the top right. ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/c/a/cab269114f1d264c47aa5d349b02d4ca4dd50e58.png) ![test](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/9/0/903462d1f2682b330fb6cd394a6a7e53bb7c8363.png) [PLACEPHOTOONPOINT\_01.dyn](https://forum.dynamobim.com/uploads/short-url/4A9y7lvCyu49iREdD8Qt5GWe5gn.dyn) (977.3 KB) ---
**Author:** ![Jobez7](https://avatars.discourse-cdn.com/v4/letter/j/e9a140/32.png) [@Jobez7](https://forum.dynamobim.com/u/Jobez7)\ **Post date:** [January 8, 2025, 3:02pm UTC](https://forum.dynamobim.com/t/dynamo-automated-placement-of-marker-family-from-excel-with-custom-attributes/107082/3 "2025-01-08T15:02:02Z")
Hi, Thank you for your help. I tried your script and it works perfectly for placing the families at the correct coordinates. However, I noticed an issue with the values: they appear with trailing zeros (e.g., “9,000000” or “500,000000” instead of just “9” or “500”). ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/c/6/c62b139b23ae3df6301c9e4247e7e78a7c93799a.png) ---
**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 8, 2025, 3:03pm UTC](https://forum.dynamobim.com/t/dynamo-automated-placement-of-marker-family-from-excel-with-custom-attributes/107082/4 "2025-01-08T15:03:46Z")
Hey, It’s when Dynamo converts a number to a string, perhaps i hadn’t hit save on it when i dropped the link… if you look at the screen grab, it splits the string to drop them… Cheers, Mark ---
**Author:** ![Jobez7](https://avatars.discourse-cdn.com/v4/letter/j/e9a140/32.png) [@Jobez7](https://forum.dynamobim.com/u/Jobez7)\ **Post date:** [January 8, 2025, 3:21pm UTC](https://forum.dynamobim.com/t/dynamo-automated-placement-of-marker-family-from-excel-with-custom-attributes/107082/5 "2025-01-08T15:21:44Z")
😭 😭 😭 😭 What should I do to remove them? I looked at the screenshot but it’s the same ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/1/e/1e570808e7d482706329ed5e99996723ca61d051.png) ---
**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 8, 2025, 3:24pm UTC](https://forum.dynamobim.com/t/dynamo-automated-placement-of-marker-family-from-excel-with-custom-attributes/107082/6 "2025-01-08T15:24:38Z")
Try changing the . to , in the ‘Code Block’ 🙂 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/b/9/b982f021299b9ec6db381d00dd7d156a628aca78.png) It’s a Europe / UK thing 🙂 ---
**Author:** ![Jobez7](https://avatars.discourse-cdn.com/v4/letter/j/e9a140/32.png) [@Jobez7](https://forum.dynamobim.com/u/Jobez7)\ **Post date:** [January 8, 2025, 3:27pm UTC](https://forum.dynamobim.com/t/dynamo-automated-placement-of-marker-family-from-excel-with-custom-attributes/107082/7 "2025-01-08T15:27:46Z")
Thank you so much for your help Mark! I really appreciate the time you took to solve my problem. Your solution was exactly what I needed and works perfectly now. Thanks again for your valuable assistance! 🫵 👍 👏 🙌 🙏 🙏 🙏 🙏 ---
**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 8, 2025, 3:28pm UTC](https://forum.dynamobim.com/t/dynamo-automated-placement-of-marker-family-from-excel-with-custom-attributes/107082/8 "2025-01-08T15:28:14Z")
No worries 🙂 ---
**Author:** ![emrullah.yildiz](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/emrullah.yildiz/32/177572_2.png) [@emrullah.yildiz](https://forum.dynamobim.com/u/emrullah.yildiz)\ **Post date:** [January 10, 2025, 1:37am UTC](https://forum.dynamobim.com/t/dynamo-automated-placement-of-marker-family-from-excel-with-custom-attributes/107082/9 "2025-01-10T01:37:09Z")
Hi @Jobez7, It will be helpful for the community if you mark the answer that solves your problem as solution. 🙂