# Parameter transfer from Excel to Revit **URL:** \ **Category:** Revit\ **Tags:** revit, excel, dynamo\ **Created:** [July 8, 2020, 10:29am UTC](https://forum.dynamobim.com/t/parameter-transfer-from-excel-to-revit/52750 "2020-07-08T10:29:00Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![Gokhan](https://avatars.discourse-cdn.com/v4/letter/g/7993a0/32.png) [@Gokhan](https://forum.dynamobim.com/u/Gokhan)\ **Post date:** [July 8, 2020, 10:29am UTC](https://forum.dynamobim.com/t/parameter-transfer-from-excel-to-revit/52750/1 "2020-07-08T10:29:00Z")
Hello, I’m tryint to transfer data from Excel to Revit. Common parameter “Line No” in Excel and Revit. I want to transfer other data to Revit according to “Line No” parameter in Excel. There is an error like the photo below. Can you help me? ![00_Riser Diagram-Import_Family Type](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/4/1/419ea6bac0c98275467758d0462a8fb83cfdebc0.png) ![01_Warning](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/c/1/c1f795f1b716cd31697187c158ed4f509a57d087.jpeg) ![02_Excel Data](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/f/7/f7afdc2e1332bc039f4381135710eb7ef7e8016c.jpeg) Thank you in advance! ---
**Author:** ![Marcel\_Rijsmus](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/marcel_rijsmus/32/8539_2.png) [@Marcel\_Rijsmus](https://forum.dynamobim.com/u/Marcel_Rijsmus)\ **Post date:** [July 8, 2020, 10:58am UTC](https://forum.dynamobim.com/t/parameter-transfer-from-excel-to-revit/52750/2 "2020-07-08T10:58:42Z")
Hi, You are not feeding elements to the node. check this, > **[Taking a Return Trip From Revit to Excel Using Dynamo](https://www.revit.com.au/1564/)** > > Last week I wrote about using note block schedules to create specification sheets and I explained how you can use addins such as BIMLink, custom macros or C# addins or Dynamo to get the data out to… ---
**Author:** ![Bjorn\_Keulemans1](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/bjorn_keulemans1/32/54676_2.png) [@Bjorn\_Keulemans1](https://forum.dynamobim.com/u/Bjorn_Keulemans1)\ **Post date:** [July 8, 2020, 11:00am UTC](https://forum.dynamobim.com/t/parameter-transfer-from-excel-to-revit/52750/3 "2020-07-08T11:00:03Z")
You are feeding Strings (your Line Numbers) into an input where Dynamo want Revit elements. Your logic is also dangerous because the sorting will not sort the elements,so you are not sure to push the right Breaker into the right element. Read up on Dictionaries in Dynamo. Make a Line No-Breaker Dictionary based on your excel columns, collect the Revit elements in Dynamo, read the Line No parameter, look in the Dictionary for the Breaker, push that into the element. No need for all kinds of complicated sorting. ---
**Author:** ![Gokhan](https://avatars.discourse-cdn.com/v4/letter/g/7993a0/32.png) [@Gokhan](https://forum.dynamobim.com/u/Gokhan)\ **Post date:** [July 8, 2020, 12:13pm UTC](https://forum.dynamobim.com/t/parameter-transfer-from-excel-to-revit/52750/4 "2020-07-08T12:13:13Z")
Hi, I have reviewed the website you submitted, but my situation is different. First, match the “Line No” parameter in Revit model and Excel file and then filling the other parameters with reference to “Line No” numbers. ---
**Author:** ![Gokhan](https://avatars.discourse-cdn.com/v4/letter/g/7993a0/32.png) [@Gokhan](https://forum.dynamobim.com/u/Gokhan)\ **Post date:** [July 9, 2020, 3:34pm UTC](https://forum.dynamobim.com/t/parameter-transfer-from-excel-to-revit/52750/5 "2020-07-09T15:34:07Z")
Thank you for comments. I am trying to transfer columns in Excel to Revite, but if I manage to trasnfer a column, I will transfer all parts in order. ---
**Author:** ![Gokhan](https://avatars.discourse-cdn.com/v4/letter/g/7993a0/32.png) [@Gokhan](https://forum.dynamobim.com/u/Gokhan)\ **Post date:** [October 19, 2020, 2:54pm UTC](https://forum.dynamobim.com/t/parameter-transfer-from-excel-to-revit/52750/6 "2020-10-19T14:54:03Z")
I haven’t done yet. Can you help me? ---
**Author:** ![yanveras](https://avatars.discourse-cdn.com/v4/letter/y/5daacb/32.png) [@yanveras](https://forum.dynamobim.com/u/yanveras)\ **Post date:** [October 20, 2020, 1:36am UTC](https://forum.dynamobim.com/t/parameter-transfer-from-excel-to-revit/52750/7 "2020-10-20T01:36:53Z")
I think you can use DictionaryByKeyValues from clockworks if you have the same code in the elements and in the excel. This node can pair both information for you. The you can use the set parameter value by name. ---
**Author:** ![Gokhan](https://avatars.discourse-cdn.com/v4/letter/g/7993a0/32.png) [@Gokhan](https://forum.dynamobim.com/u/Gokhan)\ **Post date:** [October 20, 2020, 8:14am UTC](https://forum.dynamobim.com/t/parameter-transfer-from-excel-to-revit/52750/8 "2020-10-20T08:14:08Z")
I use Dynamo 1.3.4 version. I added “Clockwork for Dynamo 1.x” package but I can’t find “DictionaryByKeyValues” node. ---
**Author:** ![blsalvio](https://avatars.discourse-cdn.com/v4/letter/b/ad7895/32.png) [@blsalvio](https://forum.dynamobim.com/u/blsalvio)\ **Post date:** [October 20, 2020, 8:25am UTC](https://forum.dynamobim.com/t/parameter-transfer-from-excel-to-revit/52750/9 "2020-10-20T08:25:05Z")
hi @Gokhan can you provide a sample revit file, sample excel file and your dynamo script? it would be helpful to the people around here who are willing to help you. -biboy ---
**Author:** ![Gokhan](https://avatars.discourse-cdn.com/v4/letter/g/7993a0/32.png) [@Gokhan](https://forum.dynamobim.com/u/Gokhan)\ **Post date:** [October 20, 2020, 10:33am UTC](https://forum.dynamobim.com/t/parameter-transfer-from-excel-to-revit/52750/10 "2020-10-20T10:33:48Z")
I atteched Revit,Excel and Dynamo script file.I want to transfer other data to Revit according to “Line No” parameter in Excel. Revit File Format : 2019, Dynamo Script 1.3.4 [Riser Diagram.dyn](https://forum.dynamobim.com/uploads/short-url/brAEsUNddhlQVerWNsvXoO5RGkr.dyn) (32.6 KB) [Riser Diagram.xlsx](https://forum.dynamobim.com/uploads/short-url/7Cav4DMk93o54ZCXVKUs1081u7X.xlsx) (20.1 KB) [Sample Project.rvt](https://forum.dynamobim.com/uploads/short-url/aDn1np1d4KWcvQEnL5mPXCBO46v.rvt) (3.4 MB) ---
**Author:** ![blsalvio](https://avatars.discourse-cdn.com/v4/letter/b/ad7895/32.png) [@blsalvio](https://forum.dynamobim.com/u/blsalvio)\ **Post date:** [October 20, 2020, 11:50pm UTC](https://forum.dynamobim.com/t/parameter-transfer-from-excel-to-revit/52750/11 "2020-10-20T23:50:04Z")
hi @Gokhan, i am very sorry, we only have dynamo 2.6 in the office, i cannot help you with this. I am so sorry again. -biboy ---
**Author:** ![Jean-Marc](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jean-marc/32/79122_2.png) [@Jean-Marc](https://forum.dynamobim.com/u/Jean-Marc)\ **Post date:** [October 21, 2020, 7:17am UTC](https://forum.dynamobim.com/t/parameter-transfer-from-excel-to-revit/52750/12 "2020-10-21T07:17:44Z")
for excel parameter value transfer, I would not bother with so much with dynamo and go the plugin/addin way with diroots sheetlink, or bimone import export excel, free tools, no headache… Why reinventing the wheel? I know dynamo is fun. Still.