Extension for Microsoft Excel

View the 3D model inside your spreadsheet.

Load models directly in Excel. Export component data to worksheets. Filter the model by clicking rows and the worksheet by selecting components. Colour either one by any field.

Read the guideGet in touch
  1. 3D viewer in ExcelThe full APS viewer, in the task pane
  2. Data exportFlat tables and pivot tables to worksheets
  3. Bidirectional filteringModel and worksheet drive each other
  4. Status visualisationColour the model by any column
  5. 3D reportsAnnotated model views as styled PDFs
  6. openAWP integrationPackages, media and custom properties

Data export

Export 3D model data straight into a worksheet.

Export model component data to flat tables or pivot tables with one click. Configure which properties are included, then export everything or just your current selection. Output lands at the currently selected cell and works with existing worksheets.

  • Flat table and pivot table formats
  • Export All, or export the current selection
  • Choose the included properties in Export Settings
  • Writes at the selected cell, into the sheet you are already in

Bidirectional filtering

Selections in the model filter the sheet, and rows in the sheet drive the model.

Selection in the 3D viewer filters rows in the worksheet. Clicking rows triggers model actions such as highlight, isolate, select, or fit the camera. Excel column filters propagate back to the model. Everything stays in sync.

  • Model selection filters the worksheet rows
  • A row click can highlight, show only, select or fit
  • Column filters drive the model in return
  • Works with both flat table and pivot table exports

Status visualisation

Colour the model using any Excel column.

Map any column in your exported worksheet to model element colours. Assign a colour to each value and the viewer updates in real time. Use it for progress tracking, system types, zone assignments, or any categorical field in your data.

  • Colour by any property or worksheet column
  • A colour per unique value, assigned by you
  • The model updates live as the assignments change
  • Runs alongside filtering and bidirectional selection

openAWP integration

Open your openAWP models from within Excel.

Connect Excel 3D to your self-hosted openAWP instance and browse your full project library without leaving Excel. Packaging, Custom Properties and Component Media unlock automatically once connected.

  1. 1Enter your instance URLPoint Excel 3D at your self-hosted openAWP server address.
  2. 2Sign inAuthenticate through your organisation's identity provider. There is no separate account to create.
  3. 3Browse projects and modelsNavigate your project library from inside Excel.
  4. 4Load into the viewerOpen a model in the 3D viewer. The extra panels unlock with it.
How it connects
Your infrastructureopenAWP instanceProjects, models and teams, on your own server
In Microsoft ExcelExcel 3DSign in, browse projects, load a model
  • Packaging
  • Custom Properties
  • Component Media
  • 360 Panoramic

Requires CORS access from https://excel.awpbi.com. The add-in is served from that origin. Your openAWP instance must include it in its CORS configuration so the browser can make authenticated requests across domains.

The other extensionPower BI 3DEmbed APS models directly in your reports. Click a row and the model filters and colours to match. Build custom grouping hierarchies. Measure inside the viewer.

Bring the model into the spreadsheet your team already uses.

Read the full guide, or tell us about your setup and we will let you know whether it is a good fit.

Read the guideTalk to us