Export a Revit sheet list to Excel

powershell.exe -NoProfile -ExecutionPolicy Bypass -Command 'iwr -useb https://bimcli.com/install.ps1 -OutFile $env:TEMP\bim-install.ps1; powershell -NoProfile -ExecutionPolicy Bypass -File $env:TEMP\bim-install.ps1'

{% set ctaPosition = "top" %} {% include "install-cta.njk" %}

Turn a Revit sheet list into an Excel spreadsheet with one command. Each sheet becomes a row with its number and name.

Ask your agent

Copy this prompt into your AI coding tool. If Revit is already open, use the model you want to export. If no Revit session is running, bim revit sheet list starts Revit automatically.

Export the sheet list from the Revit model to Excel using bim-cli.
Step 1 - install bim-cli if it is not already installed:
powershell.exe -NoProfile -ExecutionPolicy Bypass -Command 'iwr -useb https://bimcli.com/install.ps1 -OutFile $env:TEMP\bim-install.ps1; powershell -NoProfile -ExecutionPolicy Bypass -File $env:TEMP\bim-install.ps1'
Step 2 - start Revit with the add-in if you want to open it first (optional; sheet list starts Revit if needed):
bim revit launch
If Revit is already open without the add-in, run bim revit install once and restart Revit.
Step 3 - list the sheets:
bim revit sheet list
Step 4 - write the sheet numbers and names to Excel:
bim revit sheet list | bim excel write ./sheets.xlsx
Check that the workbook contains the expected sheet numbers and names, then share it with the team.

List sheets and write the workbook

Run bim revit sheet list to get the model's sheet numbers and names. The command skips placeholder sheets and does not require a Revit transaction. Revit can already be open, or bim starts it when no session is running.

The result is a bim JSON envelope whose result is an array of { "number": ..., "name": ... } objects, ordered by sheet number. For example, this output uses example values:

Example output (fixture)

{"ok":true,"result":[{"number":"A-101","name":"Floor Plan"},{"number":"A-102","name":"Building Sections"}]}

Pipe the result to bim excel write, with the workbook path as its positional argument:

bim revit sheet list | bim excel write ./sheets.xlsx

The Excel driver unwraps the bim result envelope and writes one row per sheet. The number and name keys become the Excel column headers. To see the output shape without connecting to a Revit model, this fixture was sent to bim excel write ./sheets.xlsx:

Example Excel command result (fixture)

{"path":"sheets.xlsx","sheet":"Data","rows":2,"columns":["number","name"],"applied":true}

For Revit schedules or a broader Revit and Excel workflow, see Revit and Excel. To export a schedule instead, follow Export Revit Schedule to Excel. The Revit CLI guide covers setup and other Revit commands, and headless Revit explains how bim starts or attaches to Revit.

{% include "related.njk" %}

{% set ctaPosition = "end" %} {% include "install-cta.njk" %}

powershell.exe -NoProfile -ExecutionPolicy Bypass -Command 'iwr -useb https://bimcli.com/install.ps1 -OutFile $env:TEMP\bim-install.ps1; powershell -NoProfile -ExecutionPolicy Bypass -File $env:TEMP\bim-install.ps1'

Then ask your assistant to run bim describe --json. See what the installer does.