Skip to content
Item Planning Review app iconItem Planning ReviewReview

Excel Export for Microsoft Dynamics 365 Business Central

Some planning questions are easier to answer in a spreadsheet: sorting by a ratio, grouping by vendor, or sharing a list with a manager before anything changes.

Item Planning Review results can be sent to Excel for analysis, and the planner then makes the agreed changes on the Item Planning Review page.

How Excel export works in Item Planning Review

  1. The planner generates the review for a filtered group of items.
  2. The planner sends the results to Excel.
  3. The planner and the team analyze the list and agree on changes.
  4. The planner makes the changes on the Item Planning Review page.

Key capabilities

Export the review

After Generate, the results on the page can be sent to Excel for analysis.

Your own analysis

In Excel, the planner can sort, group, and add columns to answer questions the page does not ask.

Changes stay in Business Central

Decisions made in Excel are applied on the Item Planning Review page, with one-page adjustments or Update Item Planning.

A record of the review

An exported list shows what the values were before a review, which helps when a manager wants to see the changes proposed.

Details that matter on the floor

A legitimate path, not a workaround

Excel is offered as a normal way to analyze the results. The review page stays the place where changes are made.

No spreadsheet as source of truth

Because edits happen in Business Central, the item and stockkeeping unit (SKU) records stay the single record of planning values.

Who uses Excel export

Inventory managers

Share proposed changes with a manager before applying them.

Supply chain analysts

Analyze usage and settings across many items in a spreadsheet.

Purchasing managers

Review proposed order quantities by vendor.

Questions about Excel export

Can I export planning parameters to Excel from Business Central?

With Item Planning Review, yes. Send the generated results, with usage and planning values, to Excel for analysis.

Can I import the changes back from Excel?

The documented path is to make the changes on the Item Planning Review page after analyzing in Excel. Item Planning Review does not describe an import from Excel.

What is included in the export?

The results of the review as generated on the page. The exact columns are not listed here, so check the file before sharing it.

Item Planning Review app icon

Part of Item Planning Review

Optimize inventory management by streamlining reorder planning, minimizing costs, and enhancing accuracy.

Have a question about Excel export?

Send us a note and the Item Planning Review team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.

Ask a product question

Product Questions