# Sorting schedule as shown in Revit to Excel

**URL:** <https://forum.dynamobim.com/t/sorting-schedule-as-shown-in-revit-to-excel/41069>\
**Category:** Revit\
**Tags:** dynamo\
**Created:** [September 25, 2019, 1:06pm UTC](https://forum.dynamobim.com/t/sorting-schedule-as-shown-in-revit-to-excel/41069 "2019-09-25T13:06:42Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![muis.r](https://avatars.discourse-cdn.com/v4/letter/m/c4cdca/32.png) [@muis.r](https://forum.dynamobim.com/u/muis.r)\
**Post date:** [September 25, 2019, 1:06pm UTC](https://forum.dynamobim.com/t/sorting-schedule-as-shown-in-revit-to-excel/41069/1 "2019-09-25T13:06:43Z")

</div>

Hi All,

I can’t get solve this. I want to export the Revit Schedule to Excel as shown in the Schedule.  
The first column I can sort it as shown but after it I can’t figure out which type of sort by then I have to use. See the picture

Hope ya all can help me.

 ![Dynamo%20error](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/a/8/a830b0f2ec295ccb13b9c3a89c4e9072cf0f1917.jpeg)

---

<div class="post-metadata">

**Author:** ![Akli.baliche](https://avatars.discourse-cdn.com/v4/letter/a/9fc29f/32.png) [@Akli.baliche](https://forum.dynamobim.com/u/Akli.baliche)\
**Post date:** [September 25, 2019, 1:24pm UTC](https://forum.dynamobim.com/t/sorting-schedule-as-shown-in-revit-to-excel/41069/2 "2019-09-25T13:24:40Z")

</div>

it’s normal, you just sorted the column of numbers,  
you have to sort the set of elements  
add List.SortByKey after your elements

 ![Capture](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/c/d/cd02bf7ffeb3e214896c9ebedce0104dbb040e12.jpeg)

---

<div class="post-metadata">

**Author:** ![muis.r](https://avatars.discourse-cdn.com/v4/letter/m/c4cdca/32.png) [@muis.r](https://forum.dynamobim.com/u/muis.r)\
**Post date:** [September 25, 2019, 1:32pm UTC](https://forum.dynamobim.com/t/sorting-schedule-as-shown-in-revit-to-excel/41069/3 "2019-09-25T13:32:55Z")

</div>

Thanks, but still not really how it should supposed to be.

 ![Dynamo%20error%202](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/0/7/07398a54fb0ac762a2fc12d7dcfbc709e618488c.jpeg)

---

<div class="post-metadata">

**Author:** ![muis.r](https://avatars.discourse-cdn.com/v4/letter/m/c4cdca/32.png) [@muis.r](https://forum.dynamobim.com/u/muis.r)\
**Post date:** [September 25, 2019, 1:34pm UTC](https://forum.dynamobim.com/t/sorting-schedule-as-shown-in-revit-to-excel/41069/4 "2019-09-25T13:34:31Z")

</div>

Here is the complete list

 ![Complete%20list](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/1/e/1e3a29fb505a502f241c9e5f47bffa4858ec9262.jpeg)

---

<div class="post-metadata">

**Author:** ![Akli.baliche](https://avatars.discourse-cdn.com/v4/letter/a/9fc29f/32.png) [@Akli.baliche](https://forum.dynamobim.com/u/Akli.baliche)\
**Post date:** [September 25, 2019, 1:35pm UTC](https://forum.dynamobim.com/t/sorting-schedule-as-shown-in-revit-to-excel/41069/5 "2019-09-25T13:35:08Z")

</div>

look at my capture  
it is necessary to recover the values ​​of the sorted elements

 ![Capture](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/1/2/125632ea14ae7c6dcbb5b545c8c8cfffc218c5c9.jpeg)

---

<div class="post-metadata">

**Author:** ![muis.r](https://avatars.discourse-cdn.com/v4/letter/m/c4cdca/32.png) [@muis.r](https://forum.dynamobim.com/u/muis.r)\
**Post date:** [September 25, 2019, 1:42pm UTC](https://forum.dynamobim.com/t/sorting-schedule-as-shown-in-revit-to-excel/41069/6 "2019-09-25T13:42:20Z")

</div>

Thanks! That worked! Thanks for your fast reactions and help! 😃

---

<div class="post-metadata">

**Author:** ![muis.r](https://avatars.discourse-cdn.com/v4/letter/m/c4cdca/32.png) [@muis.r](https://forum.dynamobim.com/u/muis.r)\
**Post date:** [September 25, 2019, 1:46pm UTC](https://forum.dynamobim.com/t/sorting-schedule-as-shown-in-revit-to-excel/41069/7 "2019-09-25T13:46:11Z")

</div>

Is it also possible not to export the sheets I dissapear from the schedule list?

---

<div class="post-metadata">

**Author:** ![muis.r](https://avatars.discourse-cdn.com/v4/letter/m/c4cdca/32.png) [@muis.r](https://forum.dynamobim.com/u/muis.r)\
**Post date:** [September 25, 2019, 1:54pm UTC](https://forum.dynamobim.com/t/sorting-schedule-as-shown-in-revit-to-excel/41069/8 "2019-09-25T13:54:58Z")

</div>

![Dynamo%20error%203](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/4/1/4198f5a9961e0684f4439ec8636f49fe1dfa7bee.jpeg)

---

<div class="post-metadata">

**Author:** ![Akli.baliche](https://avatars.discourse-cdn.com/v4/letter/a/9fc29f/32.png) [@Akli.baliche](https://forum.dynamobim.com/u/Akli.baliche)\
**Post date:** [September 25, 2019, 2:15pm UTC](https://forum.dynamobim.com/t/sorting-schedule-as-shown-in-revit-to-excel/41069/9 "2019-09-25T14:15:13Z")

</div>

yes you can filter the andirons to the export, add the rules of filtering.  
if you already know the sheets, use “List.RemoveItemAtIndex” to your elements

---

<div class="post-metadata">

**Author:** ![muis.r](https://avatars.discourse-cdn.com/v4/letter/m/c4cdca/32.png) [@muis.r](https://forum.dynamobim.com/u/muis.r)\
**Post date:** [September 25, 2019, 5:21pm UTC](https://forum.dynamobim.com/t/sorting-schedule-as-shown-in-revit-to-excel/41069/10 "2019-09-25T17:21:49Z")

</div>

I get lost right now, I want to remove “T-00” and “S”. as a name. Not use a number to remove it because, in other projects it can have a different number if I have more or less sheets. With which and what do I have to connect “List.RemoveItemAtIndex”?

Big Thanks. (ps: I’m new at this and like to learn it)

 ![Dynamo%20error%204](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/9/e/9ef8cba0fe9eac805eb18c06c8fc6dcdaa115bc1.jpeg)

---

<div class="post-metadata">

**Author:** ![Akli.baliche](https://avatars.discourse-cdn.com/v4/letter/a/9fc29f/32.png) [@Akli.baliche](https://forum.dynamobim.com/u/Akli.baliche)\
**Post date:** [September 26, 2019, 6:50am UTC](https://forum.dynamobim.com/t/sorting-schedule-as-shown-in-revit-to-excel/41069/11 "2019-09-26T06:50:53Z")

</div>

That’s how you can use “List.RemoveItemAt Index”  
if not I advise you the other filter that automatically seeks the leaves to delete

 ![Capture%202](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/f/6/f6ae179615f91e6b7ecf08b5aad3ae4d458aed16.png)  
 ![Capture](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/6/8/68ebd148ce2c606e2ba7c036dd8fd9fc31445944.png)

---

<div class="post-metadata">

**Author:** ![muis.r](https://avatars.discourse-cdn.com/v4/letter/m/c4cdca/32.png) [@muis.r](https://forum.dynamobim.com/u/muis.r)\
**Post date:** [September 26, 2019, 9:28am UTC](https://forum.dynamobim.com/t/sorting-schedule-as-shown-in-revit-to-excel/41069/12 "2019-09-26T09:28:18Z")

</div>

Hi! I don’t really get it what you means with elements as the output from List.FilterByBooMask.  
I tried something (see screenshot) but nothing happens. It would be nice if I don’t need the Sheet numbers to delete it because in other projects, the consecution could be different but the name always is equal.

 ![Dynamo%20error%205](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/3/8/38dd7d2df3b5bc6afcbd7846f035f88dbfe80f0b.jpeg)

---

<div class="post-metadata">

**Author:** ![Akli.baliche](https://avatars.discourse-cdn.com/v4/letter/a/9fc29f/32.png) [@Akli.baliche](https://forum.dynamobim.com/u/Akli.baliche)\
**Post date:** [September 26, 2019, 9:35am UTC](https://forum.dynamobim.com/t/sorting-schedule-as-shown-in-revit-to-excel/41069/13 "2019-09-26T09:35:28Z")

</div>

Hello  
Either one or the other,

 ![Capture](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/c/7/c7a33a0241c55b60725de29584446bd044ad2156.jpeg)

---

<div class="post-metadata">

**Author:** ![muis.r](https://avatars.discourse-cdn.com/v4/letter/m/c4cdca/32.png) [@muis.r](https://forum.dynamobim.com/u/muis.r)\
**Post date:** [September 26, 2019, 10:01am UTC](https://forum.dynamobim.com/t/sorting-schedule-as-shown-in-revit-to-excel/41069/14 "2019-09-26T10:01:15Z")

</div>

I feel we’re close. Now it only shows only two sheets in excel. The other sheets are lost? You’re my hero if this is solved

 ![Dynamo%20error%206](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/2/b/2bb1542065d986fa8ea73f8b9bf18136a556fecb.jpeg)

---

<div class="post-metadata">

**Author:** ![Akli.baliche](https://avatars.discourse-cdn.com/v4/letter/a/9fc29f/32.png) [@Akli.baliche](https://forum.dynamobim.com/u/Akli.baliche)\
**Post date:** [September 26, 2019, 11:29am UTC](https://forum.dynamobim.com/t/sorting-schedule-as-shown-in-revit-to-excel/41069/15 "2019-09-26T11:29:25Z")

</div>

right button on the nod then lacing

 ![Capture](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/e/8/e8add8852dc7955865d73618a7929d6140fdedb4.jpeg)

---

<div class="post-metadata">

**Author:** ![muis.r](https://avatars.discourse-cdn.com/v4/letter/m/c4cdca/32.png) [@muis.r](https://forum.dynamobim.com/u/muis.r)\
**Post date:** [September 26, 2019, 11:51am UTC](https://forum.dynamobim.com/t/sorting-schedule-as-shown-in-revit-to-excel/41069/16 "2019-09-26T11:51:55Z")

</div>

It only shows false, do I do something wrong? It doesn’t work here

 ![Dynamo%20error%207](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/2/e/2ebb0ecc2b150893b2355e3f1d75d03abdb08f03.jpeg)

---

<div class="post-metadata">

**Author:** ![Akli.baliche](https://avatars.discourse-cdn.com/v4/letter/a/9fc29f/32.png) [@Akli.baliche](https://forum.dynamobim.com/u/Akli.baliche)\
**Post date:** [September 26, 2019, 11:58am UTC](https://forum.dynamobim.com/t/sorting-schedule-as-shown-in-revit-to-excel/41069/17 "2019-09-26T11:58:25Z")

</div>

“T-00” and “S” do not finally match your sheet.  
that’s it?  
it correlates to what parameter?

---

<div class="post-metadata">

**Author:** ![muis.r](https://avatars.discourse-cdn.com/v4/letter/m/c4cdca/32.png) [@muis.r](https://forum.dynamobim.com/u/muis.r)\
**Post date:** [September 26, 2019, 12:06pm UTC](https://forum.dynamobim.com/t/sorting-schedule-as-shown-in-revit-to-excel/41069/18 "2019-09-26T12:06:31Z")

</div>

It is the name of the (parameter: Sheet Number), I don’t have another name or number for it. It does export to excel. Do we have to use the “List.RemoveItemAtIndex”?

---

<div class="post-metadata">

**Author:** ![Akli.baliche](https://avatars.discourse-cdn.com/v4/letter/a/9fc29f/32.png) [@Akli.baliche](https://forum.dynamobim.com/u/Akli.baliche)\
**Post date:** [September 26, 2019, 12:11pm UTC](https://forum.dynamobim.com/t/sorting-schedule-as-shown-in-revit-to-excel/41069/19 "2019-09-26T12:11:01Z")

</div>

then replace “element.name” with “sheetnumber”  
 ![Capture](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/0/0/004529eddab9019803380e46ecbf3c026b51fc1c.png)

 ![Capture](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/f/b/fbc527763582b548099785eaa2a6e61e0689c3df.png)

---

<div class="post-metadata">

**Author:** ![muis.r](https://avatars.discourse-cdn.com/v4/letter/m/c4cdca/32.png) [@muis.r](https://forum.dynamobim.com/u/muis.r)\
**Post date:** [September 26, 2019, 1:09pm UTC](https://forum.dynamobim.com/t/sorting-schedule-as-shown-in-revit-to-excel/41069/20 "2019-09-26T13:09:30Z")

</div>

That only worked with “T-00” or “Z-00” (depends which starts first.) But not both together.

 ![Dynamo%20error%208](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/1/5/157e35432cd431c702a4f850171a7fce64d83e80.jpeg)

[Next page](https://forum.dynamobim.com/t/sorting-schedule-as-shown-in-revit-to-excel/41069.md?page=2)
