Editing Business Central data in Excel

Edit in Excel opens the data behind a Business Central list — items, customers, journal lines, and more — as a live, editable spreadsheet rather than a static export. Changing several records at once (a batch price update, a bulk correction to a journal) is often faster in Excel's grid than clicking through one record at a time on the web page.

Where it lives

From most list pages, look for Edit in Excel in the ribbon, sometimes grouped under an Excel-related menu alongside Open in Excel or Export to Excel — those are different actions, so check you've picked the two-way one if you plan to write changes back.

Steps

1. Open the list page you want to edit — for example, the Items list, filtered to whatever subset you're changing.
2. Apply any filters first. Edit in Excel respects the current view's filters, so narrowing to the right records on the web page before opening Excel saves scrolling through everything.
3. Select Edit in Excel. Business Central generates and downloads a workbook connected back to your environment; open it in Excel when prompted.
4. Review the columns. They mirror the fields visible (or configured) on that list page — you may need to add fields to the page's view first if a column you need to edit isn't there.
5. Make your changes directly in the grid, the way you would in any spreadsheet — type over values, use Excel's fill-down for repetitive changes, paste in a column of new prices.
6. Publish the changes. Use the Publish action from the Business Central ribbon tab inside Excel. It validates each changed row against Business Central's normal rules and reports success or failure per row.
7. Fix and republish any failed rows. A failure usually means a required field is missing or a value doesn't pass validation (an invalid customer number, say) — correct it in Excel and publish again.
8. Refresh before a second editing session. If you're coming back to the same workbook later, refresh first to pull current data — otherwise you risk publishing changes on top of records someone else has since updated.

What you need

No special licence add-on is needed beyond normal access to the list page itself and Excel (desktop is the most reliable; Excel for the web has some functional limits with the add-in). Check current licensing and permission-set assignment if the Edit in Excel action is missing from a page you'd expect to see it on — it can also be a page-level configuration choice rather than a user permission issue.

Limits and gotchas

• Not every page supports it. Heavily customised or purely informational pages may not expose Edit in Excel — if it's missing where you'd expect it, that's often by design rather than a fault.
• Excel doesn't relax Business Central's rules. A field that's read-only or validated on the web page behaves the same way through Edit in Excel — you can't use the spreadsheet to bypass a restriction.
• A stale workbook can cause publish conflicts. If colleagues have changed the same records since you opened the file, refresh first rather than publishing blind.
• Bulk changes deserve a second look before publishing. Fill-down and paste are powerful and unforgiving — a wrong formula or an accidentally dragged column can change far more rows than intended before you notice.

Making bulk edits safely

The single biggest risk with Edit in Excel isn't the feature, it's the speed it gives you — a fill-down or paste that goes one row too far can change far more records than intended in seconds, and unlike a single manual edit on the web page, a bad bulk change can be hard to spot before you publish it. Before publishing anything that touches more than a handful of rows, sort or filter the sheet to spot-check a sample of the changed values against what you actually intended, and consider exporting a copy of the original data first (a static export, not Edit in Excel itself) so you have something to compare against if a batch of changes needs review afterward.

Bulk price or customer updates through Excel often follow directly from a batch of approved changes — see Approving a request in Business Central workflows if those edits started life as a request that needed sign-off, and Using dimensions on a sales document in Business Central if the columns you're editing include dimension fields.