AvklarePlan Help Sign in Start a free trial

Help โ€บ

Export a plan to a spreadsheet

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

  1. Open Plans and open the plan.

  2. 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.

  3. To export part of the plan, click its row in the grid (a vendor, a brand, a category).

  4. Click Export at the right of the toolbar.

    You should see a strip under the toolbar with Layout, Rows, Full precision and Download CSV.

  5. 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.
  6. Choose the Rows: Whole plan, or the row you clicked in step 3 with everything under it.

  7. 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.

  8. 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

All guides

An unhandled error has occurred. Reload ๐Ÿ—™