# Edit Family parameters with Excel **URL:** \ **Category:** Revit\ **Created:** [July 24, 2019, 11:56pm UTC](https://forum.dynamobim.com/t/edit-family-parameters-with-excel/38681 "2019-07-24T23:56:36Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![BlakeBunn](https://avatars.discourse-cdn.com/v4/letter/b/a3d4f5/32.png) [@BlakeBunn](https://forum.dynamobim.com/u/BlakeBunn)\ **Post date:** [July 24, 2019, 11:56pm UTC](https://forum.dynamobim.com/t/edit-family-parameters-with-excel/38681/1 "2019-07-24T23:56:36Z")
Hello, I am new to Dynamo, i have used prebuilt scripts and have barely scratched the surface on what can be done with it (i was pumped when i got my excel data into dynamo without help, so definitely not a “power user”). I am trying to edit two parameters on every pipe fitting. I have created an excel sheet that shows what the family name is in one column and what I want to change the product description to in another. By default the family name and product description are the same in sysque fittings, so i was thinking you can have it open the family and edit the type parameter “Product Description” within the family. I know this is a big undertaking and I’m not sure where to start. I’ve looked around online and have found a few things on it, but could use a little direction on this. The second parameter is a simple check box “allow slope adjustment” and i just need to make sure its checked. These are both easy to do but i have to do it for over 700 fittings each project and i figured it would be a good intro to Dynamo. I imagine it as "is number ##(from List 1) in project (Y/N). if yes run Element.SetParameterByName with number ## (from List 2) input as the value. TLDR; i want to open each family, name is column b in excel, and edit the “Product Description” to whats in column a in excel [Fitting list 2.xlsx](https://forum.dynamobim.com/uploads/short-url/1cpf49CumWkmzksVf6bgaoQPlRd.xlsx) (17.7 KB) ---
**Author:** ![BlakeBunn](https://avatars.discourse-cdn.com/v4/letter/b/a3d4f5/32.png) [@BlakeBunn](https://forum.dynamobim.com/u/BlakeBunn)\ **Post date:** [July 25, 2019, 8:25pm UTC](https://forum.dynamobim.com/t/edit-family-parameters-with-excel/38681/2 "2019-07-25T20:25:02Z")
i got revit to place the fittings by building the group pictured in the “Close Up” but it needs one module for each fitting which means i have to copy it, one for each fitting, and manually select each fitting and location. im wondering if there is a better way to do this. this is a small stepping stone to getting dynamo to edit these family type parameter. ![Close%20Up%20of%20Place%20Fittings](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/a/c/acc6bdebca93b6b8939469f0c57ae430aa299e66.png) ![Full%20View%20of%20Place%20Fittings](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/e/b/eb6cb2c9e8da81ab2cd9eb6f4045e0772e079518.png) [Place All Fittings in Project.dyn](https://forum.dynamobim.com/uploads/short-url/dvYBneC6Vkxq6gWqPxovdjLc99W.dyn) (488.4 KB) ![Read%20Excel%20File](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/3/4/34037381767ce0a2aaad8462f7057da1e62e230e.png) [Rename Product Description.dyn](https://forum.dynamobim.com/uploads/short-url/74MoYIfJ7So84f36nfKOVjxcQH4.dyn) (16.9 KB) ---
**Author:** ![BlakeBunn](https://avatars.discourse-cdn.com/v4/letter/b/a3d4f5/32.png) [@BlakeBunn](https://forum.dynamobim.com/u/BlakeBunn)\ **Post date:** [July 25, 2019, 9:02pm UTC](https://forum.dynamobim.com/t/edit-family-parameters-with-excel/38681/3 "2019-07-25T21:02:23Z")
im trying to update this post with whatever i slowly figure out so it might get messy, sorry! so i got the data i want into dynamo and have attached images. i essentially want to take the family (listed in picture 1) and open it and edit its product description parameter to its corresponding number in picture 2. is this possible? since i have the names whats the next best step? get these families open? any help is apreciated! ![Picture%201](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/7/5/75fc509aa223f28f625006a82d3e8c1a85f17ac1.png) ![Picture%202](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/c/b/cbf3a238790ec20b08b055cf5217df17dd727a6c.png) ---
**Author:** ![stillgotme](https://avatars.discourse-cdn.com/v4/letter/s/e480ec/32.png) [@stillgotme](https://forum.dynamobim.com/u/stillgotme)\ **Post date:** [July 31, 2019, 8:49am UTC](https://forum.dynamobim.com/t/edit-family-parameters-with-excel/38681/4 "2019-07-31T08:49:05Z")
take look at Orchid package, and search the forum for it. i believe there are quite a few similar threads out there with solutions provided. ---
**Author:** ![BlakeBunn](https://avatars.discourse-cdn.com/v4/letter/b/a3d4f5/32.png) [@BlakeBunn](https://forum.dynamobim.com/u/BlakeBunn)\ **Post date:** [September 6, 2019, 7:27pm UTC](https://forum.dynamobim.com/t/edit-family-parameters-with-excel/38681/5 "2019-09-06T19:27:17Z")
![Rename%20Product%20Description](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/b/7/b70d22dae0ab0e5b1b41984fdb96ab1313861d6c.png) still struggling with this here is where i am at. i am still doing research and trying to figure this out but i figured i would share this and see if anyone has suggestions. here is the dynamo file [Current PD Renaming .dyn](https://forum.dynamobim.com/uploads/short-url/1wAHi4qKbMZV0U62OgfUoiV5iT6.dyn) (59.6 KB) i can share a project file as an example.