Skip to content

PlaidXL is the PlaidCloud add-in for Microsoft Excel. It connects a workbook to your PlaidCloud workspace so your models and reports read from authoritative project tables and dimensions, not from a copy that goes stale the next time a workflow runs.

You can work with PlaidXL in three ways, and most workbooks use all of them:

  • The task pane — browse your projects, pick a table or dimension, choose columns and filters, and retrieve the data into a worksheet. Refresh keeps it current, and Save to PlaidCloud writes an edited table back. Other tabs build a formula or a whole report for you, explain where a number comes from, and let you ask Weave in plain words.
  • Custom functions — formulas such as =PLAIDXL.TABLE.GET_TABLE("Sales"), =PLAIDXL.CELL(...) and =PLAIDXL.METRIC("Net Revenue") that read PlaidCloud data straight into cells. Use them to list tables and dimensions, lay out a hierarchy, calculate rolled-up values for a report, and read governed metrics.
  • The ribbon and the right-click menu — drill a dimension from any cell, pick members, refresh, explain a number or show the rows behind it, with a keyboard shortcut for each.
Excel workbook PlaidXL task pane browse, filter, retrieve, refresh PLAIDXL.* functions tables, hierarchies, values in cells PlaidCloud workspace Project tables dimensions and hierarchies signed in as you rows, nodes, values
The task pane and the custom functions both read from the project you select, with your own PlaidCloud permissions.

PlaidXL reads from PlaidCloud, and it changes a project table only when you write to it yourself: type a number over a CELL value, or save a retrieved sheet with Save to PlaidCloud. Either is written straight away, and Undo last write reverses it. See Type Values Into PlaidCloud.

  • Excel for Microsoft 365, or Excel 2021 or later, on Windows or Mac. The PlaidCloud ribbon tab, the right-click menu and the task pane run in desktop Excel.
  • A PlaidCloud account in at least one workspace, and access to the projects you want to read. PlaidXL shows only the projects, tables and dimensions your account can already see in PlaidCloud.

New to PlaidXL? The Work in Excel With PlaidXL tutorial takes you from installing the add-in to a first report in about 20 minutes.