# Exporting the list of Revisions to Excel **URL:** \ **Category:** Revit\ **Created:** [March 2, 2016, 9:40am UTC](https://forum.dynamobim.com/t/exporting-the-list-of-revisions-to-excel/3322 "2016-03-02T09:40:44Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Daniel\_Hurtubise](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/daniel_hurtubise/32/146534_2.png) [@Daniel\_Hurtubise](https://forum.dynamobim.com/u/Daniel_Hurtubise)\ **Post date:** [March 2, 2016, 9:40am UTC](https://forum.dynamobim.com/t/exporting-the-list-of-revisions-to-excel/3322/1 "2016-03-02T09:40:44Z")
I’ve made some progress but now I’m stuck. Im retrieving 4 parameters for each sheet (Sheet Number, Revision Number, Revision Description and Revision Date). So far so good. My problems comes when i want to format the information to send to Excel. I was thinking of having the first column as the Sheet Number, the second one the Revision Number and so on. When i retrieve the information i only get 1 Sheet Number but i can get 2 different revisions for it. So my first problem is to be able to repeat the Sheet Number X number of time (unless someone knows a better way to send to Excel). Here’s where i am so far and I’ve included the DYN Thanks for any help ![RevisionsToExcel](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/2X/2/27304cb710909c53e5237deff2b9d2e173eab926.jpg) [0.9.1\_RevisionToExcel](http://dynamobim.org/wp-content/uploads/forum-assets/danielhurtubise/03/02/0.9.1_RevisionToExcel.dyn) ---
**Author:** ![Mostafa\_El\_Ayoubi](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/mostafa_el_ayoubi/32/7815_2.png) [@Mostafa\_El\_Ayoubi](https://forum.dynamobim.com/u/Mostafa_El_Ayoubi)\ **Post date:** [March 2, 2016, 10:19am UTC](https://forum.dynamobim.com/t/exporting-the-list-of-revisions-to-excel/3322/2 "2016-03-02T10:19:08Z")
Hi, would this work for you ? ![list transp](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/2X/9/9a3c4cad9c50346646bef0c0f792710e4aea0c01.png) ---
**Author:** ![Daniel\_Hurtubise](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/daniel_hurtubise/32/146534_2.png) [@Daniel\_Hurtubise](https://forum.dynamobim.com/u/Daniel_Hurtubise)\ **Post date:** [March 2, 2016, 10:27am UTC](https://forum.dynamobim.com/t/exporting-the-list-of-revisions-to-excel/3322/3 "2016-03-02T10:27:23Z")
Im gonna say no as each sublist needs to have the same amount of items to fill the row properly ---
**Author:** ![Mostafa\_El\_Ayoubi](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/mostafa_el_ayoubi/32/7815_2.png) [@Mostafa\_El\_Ayoubi](https://forum.dynamobim.com/u/Mostafa_El_Ayoubi)\ **Post date:** [March 2, 2016, 10:53am UTC](https://forum.dynamobim.com/t/exporting-the-list-of-revisions-to-excel/3322/4 "2016-03-02T10:53:48Z")
Got it   how about this ?   ![excel]|1746x838](upload://xHxHajuneHujAr8iceAPNkeIE9o.png) ---
**Author:** ![Daniel\_Hurtubise](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/daniel_hurtubise/32/146534_2.png) [@Daniel\_Hurtubise](https://forum.dynamobim.com/u/Daniel_Hurtubise)\ **Post date:** [March 3, 2016, 2:37am UTC](https://forum.dynamobim.com/t/exporting-the-list-of-revisions-to-excel/3322/5 "2016-03-03T02:37:55Z")
That got me close enough to finish it 🙂 I was missing the damn long lacing in the count ☹ and i added a List.Map at the end, result is spot on 🙂 Thanks a lot for your help ![RevisionsToExcel_Result](https://cdck-file-uploads-us1.s3.dualstack.us-west-2.amazonaws.com/flex022/uploads/dynamobim/original/2X/7/7d180e03eafb570d3efe2929de51e186c262d829.jpg) ---
**Author:** ![Mostafa\_El\_Ayoubi](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/mostafa_el_ayoubi/32/7815_2.png) [@Mostafa\_El\_Ayoubi](https://forum.dynamobim.com/u/Mostafa_El_Ayoubi)\ **Post date:** [March 3, 2016, 2:50am UTC](https://forum.dynamobim.com/t/exporting-the-list-of-revisions-to-excel/3322/6 "2016-03-03T02:50:46Z")
Glad it helped! ---
**Author:** ![Igoitz\_Garagarza](https://avatars.discourse-cdn.com/v4/letter/i/35a633/32.png) [@Igoitz\_Garagarza](https://forum.dynamobim.com/u/Igoitz_Garagarza)\ **Post date:** [April 5, 2016, 8:03am UTC](https://forum.dynamobim.com/t/exporting-the-list-of-revisions-to-excel/3322/7 "2016-04-05T08:03:38Z")
Hi Daniel first of all, thank you for your post. I am trying to produce something similar to yours. I had a look at your dyn file attached, but when I tested it came up with the following error: “Custom node definition is not loaded” my biggest challenge here is retrieving revision data. I think I tried all the nodes I have in dynamo but so far none of them worked. looks like the trick is in the “Revision on Sheet” node. If you could help me with that I would very much appreciate you. Regards Igm PD: I am new in dynamo and have no programming experience ![Capture1](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/2X/3/397052f42174fe90a1125abaa2fd4fd8e9265c44.jpg) ---
**Author:** ![Konrad\_K\_Sobon](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/konrad_k_sobon/32/8838_2.png) [@Konrad\_K\_Sobon](https://forum.dynamobim.com/u/Konrad_K_Sobon)\ **Post date:** [April 5, 2016, 4:46pm UTC](https://forum.dynamobim.com/t/exporting-the-list-of-revisions-to-excel/3322/8 "2016-04-05T16:46:22Z")
that node is from a custom package called [archi-lab.net](http://archi-lab.net) so just search for that. Look under package manager. ---
**Author:** ![Igoitz\_Garagarza](https://avatars.discourse-cdn.com/v4/letter/i/35a633/32.png) [@Igoitz\_Garagarza](https://forum.dynamobim.com/u/Igoitz_Garagarza)\ **Post date:** [April 12, 2016, 8:45am UTC](https://forum.dynamobim.com/t/exporting-the-list-of-revisions-to-excel/3322/9 "2016-04-12T08:45:36Z")
GOT IT, Thanks Konrad!!   Wel, I managed to make the node works, but I cannot make the outcome looks as I wanted on a excel sheet. I can only manage to show the info in one column as if it was a long list. What I would like though, is to display the data in columns and rows. Attached a snapshot of what I am getting in excel and dyn. file if anyone wants to have a look and let me know what I am doing wrong and why I am getting the data in one column. Thank you!RevisionRevitToExcel ---
**Author:** ![bendgrim](https://avatars.discourse-cdn.com/v4/letter/b/278dde/32.png) [@bendgrim](https://forum.dynamobim.com/u/bendgrim)\ **Post date:** [May 26, 2018, 11:38pm UTC](https://forum.dynamobim.com/t/exporting-the-list-of-revisions-to-excel/3322/10 "2018-05-26T23:38:48Z")
Hi, Can you tell me what the story is with these nodes? I downloaded the .dyn file from Daniel at the start of this thread and it contains a node called “Revisions on Sheet” which seems to return the revision numbers for each sheet in the example. But when I search for that node I end up with “sheet.Revisions” instead and I have not been able to get the revision numbers out of it. Any help here would be greatly appreciated. ![Capture](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/4/2/42eb144485a99704ae876f79330e96e3f2661b5a.PNG)