Skip to main content

Excel for BIM

BIM data, in the tool your team already uses.

Export, extend, colour-code the model from a spreadsheet, and feed it back to Power BI.

Frame Excel integration showing model properties in a spreadsheet alongside the Frame model viewer

Not everything belongs in a dashboard. Cost rates, procurement status, and site-verified quantities usually start life in a spreadsheet, and pretending otherwise just means they get typed twice.

An add-in, not a template

Excel works differently from the Power BI templates in this gallery. There is no .xltx to download — Frame connects to Excel through an add-in that reads your model data live.

Export

Pull model properties into a worksheet, define new ones, and build pivot tables against them the way you would with any other dataset.

Filters, both directions

Apply a filter in Excel and the model viewer follows. Filter in the viewer and the spreadsheet follows. The selection is the same selection, so a conversation about a subset of elements does not require re-deriving it in each tool.

Colours from conditional formatting

Excel’s conditional formatting drives colour-coding in the model. Colour by cost band, by procurement status, or by any column you have added yourself, using rules you write in Excel rather than in a separate configuration screen.

Back into Power BI

Columns you add in Excel come back into the Power BI reports alongside the model-derived fields. Your rates and statuses sit next to the quantities they apply to, in the same tables.

Read more

Build reports that drive action

Discover the benefits of Frame today.