Exporting Revit Schedules to Excel in one sheet

I found a script that will let me export schedules to excel into one excel document but they export into separate tabs. I’ve gotten as far as exporting them into one tab but they are writing over each other (when I run the file, I can see each schedule in the excel but they get overwritten by the next schedule thats loaded).
How can I export it so they load next to each other?

Hi @noeline03,

There must be a way to do this task using Dynamo.

But I would use a VBA to merge all sheets.

This VBA works for me.

Sub Combine()
    Dim J As Integer
    On Error Resume Next
    Sheets(1).Name = "Combined"
    For J = 2 To Sheets.Count
        Selection.Copy Destination:=Sheets(1).Range("A65536").End(xlUp)(5)
    Dim xWs As Worksheet
        Application.ScreenUpdating = False
        Application.DisplayAlerts = False
        For Each xWs In Application.ActiveWorkbook.Worksheets
            If xWs.Name <> "Combined" Then
            End If
        Application.DisplayAlerts = True
        Application.ScreenUpdating = True
    End Sub

You might have to tweak the code a bit to get the desired output based on your panel templates.

How to use VBA in Excel

  1. Press Alt + F11 to go to VBA page
  2. From the Menu choose insert – Module
  3. Copy and paste the below VBA code in the code window.
  4. Press F5 to run the code.
1 Like

@AmolShah Regarding your reply above, I am trying to export panel schedules from Revit to Excel, the export is successful however the panel schedules do not look graphically the way they appear in Revit.

Do you think the above will work?

Please advise. I really appreciate your help.


@agandhi Nope, that won’t help.

Rather using Dynamo, I would suggest using an add-in for this task.

I’ve seen people use these:

See if it helps.

@AmolShah I just installed it… the tool is great, it just does not let me export panel schedules to excel. It does let me export the other schedules like a drawing list and so on.

I am having trouble with exporting panel schedules from Revit to Excel.