Download a plan as a CSV file to open in Excel, send to a supplier, or load into another system. The file holds what the grid shows, or every measure line by line.
Anyone who can open a plan can export it. You see only what your access allows, and so does the file.
Steps
Open Plans and open the plan.
Set the grid up the way you want the file: Month, Quarter or Year; Show (quantity, revenue, margin, price or cost per unit); equivalent or native units; and Group by, which sets the order of the rows.
To export part of the plan, click its row in the grid (a vendor, a brand, a category).
Click Export at the right of the toolbar.
You should see a strip under the toolbar with Layout, Rows, Full precision and Download CSV.
Choose the Layout:
- As shown: one row per item, a column per month (or quarter, or the year) and a Total, in the measure the grid shows. This is the one to open in Excel.
- Every measure, a row per item and month: quantity, equivalent quantity, unit price, unit cost, revenue and gross margin on every row. This is the one for pivot tables, BI tools or another system's import.
Choose the Rows: Whole plan, or the row you clicked in step 3 with everything under it.
Tick Full precision only if you need every stored decimal. Without it, numbers are rounded as the grid shows them: whole numbers, and two decimals for prices and costs.
Click Download CSV.
You should see a file named after the plan and what it holds, for example FY2027 plan - Quantity by month.csv. It opens in Excel with one row per item, item number, description and unit first, then a column for each grouping (vendor, brand and so on).
Common mistakes
No Download CSV button, a note about a subscription instead. Export comes with a subscription, so a workspace on its free trial can't download plans (see Your trial and subscription).
A column of empty cells. The value has no meaning for that item, the same as โ in the grid: equivalent units for an item without a conversion factor. Export in native units, or set the item's factor in the items import.
Totals that don't match the grid's rounded months. Each total is calculated from the full values, then rounded, as the grid does. Tick Full precision to see the exact figures.
Expecting the comparison with actuals in the file. The file holds plan values only, even while the grid compares with actuals.
An item name starting with an apostrophe. Names that start with =, +, - or @ get a leading apostrophe, so Excel shows them as text instead of running them as a formula.