How do Budget or Forecast exports to Excel work? (Beta)

Beta

Company Administrators can enable the Excel Export of Budget View beta in Procore Explore.

When you export your budget or forecasting view to an Excel (XLSX) file, Procore converts your view into a structured workbook. Excel exports preserve your table hierarchy, convert calculated columns into dynamic Excel formulas, and automatically include subtotals and grand totals.

How Column Types and Settings Export

Procore exports budget or forecast data differently based on the column type and settings configured in your budget or forecasting view.

Column Types

Column Type

Export Behavior in Excel

Calculated Columns

Exported as live Excel formulas on each row. Procore column references are translated into corresponding cell coordinates on that row.

Source Columns

Exported as raw numeric values. For example, Original Budget, Approved COs, and Revised Budget.

Forecast to Complete Columns

Exported as the current raw numeric value. Underlying forecasting build-ups or curve breakdowns are not included in the export.

Select, Direct Entry Columns

Ingested as raw values. Underlying Select column build-ups are omitted from the spreadsheet.

Column Settings

  • Lump Sum Overrides: When a Lump Sum Manual Entry override is applied to a cell, Procore exports the overridden value rather than any underlying build-up or calculation.

  • Cost Type Display Rules: If a cell's value is hidden in your budget or forecasting view due to Cost Type display rules, that value is not exported; the corresponding cell in Excel remains blank.

Calculated Columns & Hidden Dependency Columns

Live Formulas & Divide-by-Zero Protection

When your budget or forecasting view includes calculated columns, Procore writes them into the spreadsheet as native Excel formulas rather than hardcoded numbers. This allows you to adjust values in Excel and see dependent cells recalculate automatically.

To prevent spreadsheet errors, Procore wraps division operations in error-handling logic (such as IFERROR or zero-checks) so that dividing by zero (0) or blank cells does not break the sheet with #DIV/0! errors.

Hidden Dependency Columns on the Far Right

A calculated column in Procore may rely on data from another column that is currently hidden or excluded from your active budget view.

To ensure your Excel formulas remain valid and functional without altering your visible column layout:

  • Procore automatically appends any missing dependency columns to the far right of the same worksheet.

  • Procore hides those appended columns in Excel by default.

Note: If you notice skipped column letters at the right edge of your spreadsheet, do not delete them; doing so will cause reference (#REF!) errors in your calculated columns. For example, your visible columns end at Column M, and hidden columns exist at N and O.

Grouping, Subtotals, and Grand Totals

The structure of your exported Excel worksheet mirrors how your budget or forecasting view is organized in Procore at the time of export:

  • Grouped Views: When your budget or forecasting view is grouped, such as by Cost Code Division or Cost Type, Procore generates native Excel outlines:

    • Group Header Rows: Each group is separated by a formatted header row.

    • Expand & Collapse Controls: You can use Excel's outline margin controls (+ / - buttons or level numbers 1, 2, 3 in the top-left corner) to expand or collapse specific groups.

    • Dynamic Subtotals: Group header rows use Excel's SUBTOTAL function across numeric columns so totals automatically reflect visible rows.

  • Ungrouped Views: When no grouping is applied to your budget or forecasting view, the exported worksheet is completely flat and contains the same row structure as a CSV export.

  • Grand Totals: Every Excel export automatically includes a Grand Total row at the bottom of the table, saving you from having to manually add summary formulas after downloading.

See Also

Loading related articles...