# Link excel revit - large schedule **URL:** \ **Category:** Revit\ **Tags:** excel\ **Created:** [December 18, 2018, 5:17pm UTC](https://forum.dynamobim.com/t/link-excel-revit-large-schedule/29865 "2018-12-18T17:17:25Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![baFJCRF](https://avatars.discourse-cdn.com/v4/letter/b/a3d4f5/32.png) [@baFJCRF](https://forum.dynamobim.com/u/baFJCRF)\ **Post date:** [December 18, 2018, 5:17pm UTC](https://forum.dynamobim.com/t/link-excel-revit-large-schedule/29865/1 "2018-12-18T17:17:25Z")
Hello Dynamo Users, I am new to this program and was looking for a way to Link Revit to Excel with Dynamo. I know there are many posts relating to the topic but I can’t find the answer to what I am trying to do. The Existing Sheet Index that I am trying to link is pretty big: ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/b/7/b7bff8b6fcb25a34a80e12f677a0c79a524a8ff7.png) Is there a way to export this schedule to Excel by **EXPORT -\> REPORT -\> SCHEDULES.** And after editing in Excel- import it back to Revit thru Dynamo. Or better yet, only update the column or row that has been changed? Can you please direct me to the right post if this has already been answered? Thanks a lot! ---
**Author:** ![Steven](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/steven/32/112504_2.png) [@Steven](https://forum.dynamobim.com/u/Steven)\ **Post date:** [December 18, 2018, 6:30pm UTC](https://forum.dynamobim.com/t/link-excel-revit-large-schedule/29865/2 "2018-12-18T18:30:03Z")
Yes, you can export and import to and from Revit and Excel. In my experiences you will want two separate graphs for this. One for exporting to excel and one for importing to Revit. (you always can just export -\> Reports… as you stated above too). you can also update only the new data however this will take a lot of list work and management on your part. So with all of that said there probably is not a post with your answer. There are however let’s say 15 posts with partial answers that will get you to what you need. The best way for the forum to help you is for you to roll up your sleeves and get started so you can ask specific questions. Start a graph and see how you can import and export (in a test project) and then take it to the next step. Feel free to start a new post with an exact question. ---
**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:** [December 18, 2018, 6:52pm UTC](https://forum.dynamobim.com/t/link-excel-revit-large-schedule/29865/3 "2018-12-18T18:52:37Z")
When using excel to export and import always try to use ElementId or UniqueId. You need a key so that when importing the data the value gets set to the correct item/Sheet. Now that you have sheets, you can use the Sheet Number since that is an unique key too. > [@How to select elements in a revit model from the list UniqueID or GUID available in excel spreadsheet](https://forum.dynamobim.com/t/how-to-select-elements-in-a-revit-model-from-the-list-uniqueid-or-guid-available-in-excel-spreadsheet/23488): > > I have a list of ID’s which you see in the attached spreadsheet. Please help to select the elements in my revit model which correspond to these unique ID’s. Thank you.[Capture] ---
**Author:** ![Steven](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/steven/32/112504_2.png) [@Steven](https://forum.dynamobim.com/u/Steven)\ **Post date:** [December 18, 2018, 7:12pm UTC](https://forum.dynamobim.com/t/link-excel-revit-large-schedule/29865/4 "2018-12-18T19:12:50Z")
To help manage match the data as in the way Marcel is suggesting I would recommend this node from a standalone package. Search If Equal Return Index Updated in the package manager. ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/a/b/ab61226b448508e123a6b70a7db53843b1c75f3d.png) This is where list management is going to be key for you ---
**Author:** ![baFJCRF](https://avatars.discourse-cdn.com/v4/letter/b/a3d4f5/32.png) [@baFJCRF](https://forum.dynamobim.com/u/baFJCRF)\ **Post date:** [December 19, 2018, 3:15pm UTC](https://forum.dynamobim.com/t/link-excel-revit-large-schedule/29865/5 "2018-12-19T15:15:03Z")
Steven, Marcel, Thank you so much for the Feedback. I will try the “ElementId” and the “if Equal Return Index Updated” package! Happy Holidays! ---
**Author:** ![TonyTowers](https://avatars.discourse-cdn.com/v4/letter/t/e5b9ba/32.png) [@TonyTowers](https://forum.dynamobim.com/u/TonyTowers)\ **Post date:** [December 19, 2018, 4:16pm UTC](https://forum.dynamobim.com/t/link-excel-revit-large-schedule/29865/6 "2018-12-19T16:16:09Z")
Hi @baFJCRF, there is a tool really useful ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/9/6/96e4ee76e67ca9a07c237b5b6b52899a44e13d73.png) “[http://www.rushforthprojects.com/](http://www.rushforthprojects.com/)”. this tool does all what you need, is free for 30 days, then you need a licence. Is worthy to have. Regards ---
**Author:** ![Steven](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/steven/32/112504_2.png) [@Steven](https://forum.dynamobim.com/u/Steven)\ **Post date:** [December 19, 2018, 5:16pm UTC](https://forum.dynamobim.com/t/link-excel-revit-large-schedule/29865/7 "2018-12-19T17:16:38Z")
The Sheet number should be Unique enough (as there can only be one). Element Id’s can change so if you are ever going to match things I would use element GUID (except with sheet to and from the same model). If you would like to know more about Element Id’s and GUID’s you can read up on them here. > **[Understanding the Use of the UniqueId](https://thebuildingcoder.typepad.com/blog/2015/02/understanding-the-use-of-the-uniqueid.html)** > > Here is a thread from the Revit API discussion forum on understanding the use of the UniqueId between Erik Eriksson and Arnošt Löbel, Sr. Principal Engineer of the Autodesk Revit R&D team, that I find very valuable and therefore edited, for... ---
**Author:** ![baFJCRF](https://avatars.discourse-cdn.com/v4/letter/b/a3d4f5/32.png) [@baFJCRF](https://forum.dynamobim.com/u/baFJCRF)\ **Post date:** [December 19, 2018, 8:01pm UTC](https://forum.dynamobim.com/t/link-excel-revit-large-schedule/29865/8 "2018-12-19T20:01:10Z")
Thank you Tony, I am looking into **Ideate BimLink**. I will also check RushForth. Regards