All Integrations
Excel
x

Connect Excel to Pigment and skip manual exports

Give FP&A, Supply Chain, HR, and Sales teams Pigment data inside the Excel workbooks they already use, without exporting files or copying and pasting. Pull figures from a Pigment View into a sheet, refresh them with one click, and push updated inputs back into Pigment.

Excel

Excel

Connect Pigment Applications with Excel to pull planning data into your workbooks and push inputs back into Pigment

Category

Spreadsheets

Integration method

Native Connector
API

Best for

Reporting packs · Ad hoc analysis · Budget collection

See documentation

What can you do with Excel and Pigment?

  • Build the monthly reporting pack once. An FP&A analyst connects each tab to a saved Pigment View, then pulls the latest figures each month instead of rebuilding the tabs.
  • Collect budget submissions in Excel. A finance manager gathers department inputs in a workbook template and pushes each range into the right Pigment Block, so nobody reconciles a spreadsheet copy against the plan.
  • Review a forecast region by region. An analyst switches the Page selector on a connection and pulls again to see the same View for another region.
  • Refresh the whole board workbook. Before a board meeting, the finance team clicks Pull All to update every connected sheet at once.

How the Excel integration works

Pigment Connector for Excel is a free Office Add-in on Microsoft AppSource, and you sign in with your Pigment account. Each pull connection maps an Application, Block, and View to a target sheet and cell, with one connection per sheet. Pulls work with Metrics and Tables but not Dimension or Transaction Lists, and they refresh only when someone clicks Pull or Pull All. Each push connection sends a cell range or Named cells to a Block through its import configuration, which starts an import in Pigment.

Key capabilities

  • Pull only what each user can read. Every pull applies Pigment access rights, so each person sees only the data they have Read access to.
  • Match the formatting of the View. Turn on Include View Format to carry over number formats, sign reversal, colors, borders, and tree indentation from Metrics and Tables.
  • Hand off workbooks without reconfiguring. Connection settings save in the Excel file, so other users who installed the add-in can reuse them.
  • See whether each push landed. Each push shows In progress, Failed, or Success, and Open last import summary opens the full import report.
  • Roll out without desktop installs. Office Add-ins don't install on individual desktops, so IT can deploy Pigment Connector for Excel centrally through Microsoft 365.

Frequently Asked Questions

Which Pigment data can I pull into Excel?

You can pull data from any View in an Application you can access, as long as the View is on a Metric or Table. Pulls don't support Dimension or Transaction Lists. Use a saved View rather than the default View, since any change to the default View also changes what the next pull returns.

Can I push data from Excel back into Pigment?

Yes. A push connection sends a cell range or Named cells to a Block through an import configuration you select, and each push starts an import in Pigment.

Does the Excel connection respect Pigment access rights?

Yes. Users with the Display Application Permission can pull data, and access rights limit them to the data they have Read access to. A user can still see every Page option, but if they lack access to US data, for example, selecting US pulls nothing.

How does IT deploy the add-in, and which Excel versions are supported?

Pigment Connector for Excel runs in Microsoft 365 Excel on Windows and Mac, Excel on the web, and Excel 2019 or later on Mac. If users can’t find it in AppSource, IT can deploy it centrally through Microsoft 365. See the docs for supported Windows versions.

Can I keep my own calculations next to pulled Pigment data?

Yes, but keep them on a separate sheet. If a new pull returns fewer rows or columns, anything in the cells outside the pulled data can be lost.

See Pigment in action

The fastest way to understand Pigment is to see it in action. Sign up today and explore how agentic AI can transform the way you plan.

Three colleagues focused on an iMac screen in a bright office with plants and modern artwork.

From 8 days to 4 min

Update P&L actuals & financial forecasting

80%

Time cut on data aggregation

12 hours

Saved per month on executive reporting

6 days faster

For scenarios creation and analysis