PlaidXL
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.
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.
Requirements
Section titled “Requirements”- 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.
Topics
Section titled “Topics”- Install — add PlaidXL to Excel and open the task pane
- Sign In — connect to your workspace, sign out, and switch workspaces
- Work With Tables and Dimensions — pick a project, filter a table, retrieve it into a sheet, refresh it, and save it back
- Custom Functions — every
PLAIDXLfunction, its arguments, and what it returns - Build a Report — lay out a live report from the task pane, or with formulas
- Drill, Pick Members and Explain Numbers — drill from a cell, pick members, explain a number and show its detail rows
- Type Values Into PlaidCloud — plan by typing over report values, and undo any write
- Ask Weave in Excel — build, drill and fix from plain-language requests
- The PlaidCloud Ribbon — every command, the right-click menu and keyboard shortcuts
- Troubleshooting — fixes for the most common problems
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.
Related
Section titled “Related”- Projects — what a project holds and how to find one
- Tables and Views — the tables PlaidXL retrieves
- Using Dimensions — the hierarchies PlaidXL lays out and rolls up