---
id: video/6zj34hjbpGU
type: video
title: How Business Central Integrates with Microsoft Excel (2025)
summary: "Business Central's Excel integration: exporting list page data, opening or editing it in Excel (web or Windows app), building pivot tables and charts on data that can be refreshed, and publishing bulk edits back through the Excel add-in pane. Demoed in a 3-minute walkthrough using customer ledger entries and the customer list."
tier: official
language: en
tags:
  - excel integration
  - data export
  - pivot tables
  - data analysis
  - edit in excel
  - publish changes
  - excel addin
  - financial data
system: reporting
review:
  state: reviewed
  by: opus
  at: "2026-10-07T22:56:32.778Z"
  flags: []
generated:
  at: "2026-10-13T00:32:41.360Z"
  pipeline: 0.2.0
  prompts:
    extract-video: 1
    summarize-video: 2
  input_hash: 7412680ef6474658b88f483a366257d4f16b9c662b45c95f889143d3757a39c0
evidence:
  - kind: video
    url: https://www.youtube.com/watch?v=6zj34hjbpGU&t=0s
    title: How Business Central Integrates with Microsoft Excel (2025)
    date: "2025-05-22T16:10:08.000Z"
    commit: null
    t: 0
    quote: Business Central makes analyzing and working with your financial data simple with integration to Microsoft Excel. You can easily export data from a list
  - kind: video
    url: https://www.youtube.com/watch?v=6zj34hjbpGU&t=16s
    title: How Business Central Integrates with Microsoft Excel (2025)
    date: "2025-05-22T16:10:08.000Z"
    commit: null
    t: 16
    quote: You can also edit your data in Excel and then publish it back to Business Central
  - kind: video
    url: https://www.youtube.com/watch?v=6zj34hjbpGU&t=31s
    title: How Business Central Integrates with Microsoft Excel (2025)
    date: "2025-05-22T16:10:08.000Z"
    commit: null
    t: 31
    quote: On list pages, you have the option to either open or edit in Excel
  - kind: video
    url: https://www.youtube.com/watch?v=6zj34hjbpGU&t=90s
    title: How Business Central Integrates with Microsoft Excel (2025)
    date: "2025-05-22T16:10:08.000Z"
    commit: null
    t: 90
    quote: Analyzing the data in Excel enables powerful reporting abilities, all of which can be refreshed through the data connection
  - kind: video
    url: https://www.youtube.com/watch?v=6zj34hjbpGU&t=113s
    title: How Business Central Integrates with Microsoft Excel (2025)
    date: "2025-05-22T16:10:08.000Z"
    commit: null
    t: 113
    quote: This could take a while if you had to update the field one by one on each customer card. With edit in Excel, we
  - kind: video
    url: https://www.youtube.com/watch?v=6zj34hjbpGU&t=124s
    title: How Business Central Integrates with Microsoft Excel (2025)
    date: "2025-05-22T16:10:08.000Z"
    commit: null
    t: 124
    quote: When Excel opens, the Excel addin pane displays. Here we can refresh, filter, and publish our data
links:
  learn: []
  objects:
    - object/page/22
    - object/page/21
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
video_id: 6zj34hjbpGU
channel: yt-microsoft
source_name: Microsoft Dynamics 365 Business Central (YouTube)
url: https://www.youtube.com/watch?v=6zj34hjbpGU
published_at: "2025-05-22T16:10:08.000Z"
duration_s: 177
captions: full
audience:
  - end user
  - functional consultant
  - administrator
chapters:
  - t: 0
    title: Overview of Excel integration capabilities
  - t: 31
    title: Opening and accessing data in Excel
  - t: 57
    title: Creating pivot tables and charts for analysis
  - t: 90
    title: Updating records in Excel and the addin pane
  - t: 124
    title: Publishing changes back to Business Central
features:
  - name: Export data to Excel
    status: unclear
    t: 0
    verified: false
    status_source: video
  - name: Open or Edit in Excel option
    status: unclear
    t: 31
    verified: false
    status_source: video
  - name: Pivot table creation
    status: unclear
    t: 57
    verified: false
    status_source: video
  - name: Pivot chart visualization
    status: unclear
    t: 78
    verified: false
    status_source: video
  - name: Data connection refresh
    status: unclear
    t: 90
    verified: false
    status_source: video
  - name: Bulk update in Excel
    status: unclear
    t: 101
    verified: false
    status_source: video
  - name: Excel addin pane
    status: unclear
    t: 124
    verified: false
    status_source: video
objects_mentioned:
  - table Customer Ledger Entries
  - page Customer List
  - page Customer Card
quotes:
  - t: 0
    text: Business Central makes analyzing and working with your financial data simple with integration to Microsoft Excel. You can easily export data from a list
    check: exact
  - t: 16
    text: You can also edit your data in Excel and then publish it back to Business Central
    check: exact
  - t: 31
    text: On list pages, you have the option to either open or edit in Excel
    check: exact
  - t: 90
    text: Analyzing the data in Excel enables powerful reporting abilities, all of which can be refreshed through the data connection
    check: exact
  - t: 113
    text: This could take a while if you had to update the field one by one on each customer card. With edit in Excel, we
    check: exact
  - t: 124
    text: When Excel opens, the Excel addin pane displays. Here we can refresh, filter, and publish our data
    check: exact
---

# How Business Central Integrates with Microsoft Excel (2025)

> Business Central's Excel integration: exporting list page data, opening or editing it in Excel (web or Windows app), building pivot tables and charts on data that can be refreshed, and publishing bulk edits back through the Excel add-in pane. Demoed in a 3-minute walkthrough using customer ledger entries and the customer list.

[Watch on YouTube](https://www.youtube.com/watch?v=6zj34hjbpGU) · Microsoft Dynamics 365 Business Central (YouTube) · 2025-05-22 · 2:57 · tier official · reviewed (checked by Opus)

## Overview

The video shows how Business Central works with Excel for analysis and for editing data. On list pages, a user can open data in Excel to view it or edit it in Excel to change it. Both Excel for the web and the Excel app for Windows are supported.

The demo builds a pivot table of quarterly sales by customer and adds a pivot chart from Excel's Insert tab. These reports stay connected to Business Central and can be refreshed. It then edits several records in Excel and publishes the changes back, which it contrasts with updating each customer card one by one. The Excel add-in pane provides the refresh, filter and publish controls.

## Key points

- List pages offer both an open in Excel option (viewing) and an edit in Excel option (making changes).
- Both Excel for the web and the Excel app for Windows are supported.
- Pivot tables and pivot charts are built from the Insert tab in Excel, for example quarterly sales by customer.
- Reports and charts created in Excel keep a data connection to Business Central and can be refreshed.
- In edit mode, the Excel add-in pane has controls to refresh, filter and publish data.
- Editing many records in Excel and publishing them back replaces updating each customer card individually.
- Objects mentioned: Customer Ledger Entries table, Customer List page, Customer Card page.

## Chapters

- [0:00](https://www.youtube.com/watch?v=6zj34hjbpGU&t=0s) Overview of Excel integration capabilities
- [0:31](https://www.youtube.com/watch?v=6zj34hjbpGU&t=31s) Opening and accessing data in Excel
- [0:57](https://www.youtube.com/watch?v=6zj34hjbpGU&t=57s) Creating pivot tables and charts for analysis
- [1:30](https://www.youtube.com/watch?v=6zj34hjbpGU&t=90s) Updating records in Excel and the addin pane
- [2:04](https://www.youtube.com/watch?v=6zj34hjbpGU&t=124s) Publishing changes back to Business Central

## Features

Every feature below: status not stated, demoed.

| Feature | At |
|---|---|
| Export data to Excel | [0:00](https://www.youtube.com/watch?v=6zj34hjbpGU&t=0s) |
| Open or Edit in Excel option | [0:31](https://www.youtube.com/watch?v=6zj34hjbpGU&t=31s) |
| Pivot table creation | [0:57](https://www.youtube.com/watch?v=6zj34hjbpGU&t=57s) |
| Pivot chart visualization | [1:18](https://www.youtube.com/watch?v=6zj34hjbpGU&t=78s) |
| Data connection refresh | [1:30](https://www.youtube.com/watch?v=6zj34hjbpGU&t=90s) |
| Bulk update in Excel | [1:41](https://www.youtube.com/watch?v=6zj34hjbpGU&t=101s) |
| Excel addin pane | [2:04](https://www.youtube.com/watch?v=6zj34hjbpGU&t=124s) |

## AL objects mentioned

As heard in the captions. A name that matches one object page by exact type and name links to it; the others stay as named.

- table "Customer Ledger Entries" at [0:16](https://www.youtube.com/watch?v=6zj34hjbpGU&t=16s)
- [page 22 "Customer List"](../objects/page/22.md) at [1:41](https://www.youtube.com/watch?v=6zj34hjbpGU&t=101s)
- [page 21 "Customer Card"](../objects/page/21.md) at [2:26](https://www.youtube.com/watch?v=6zj34hjbpGU&t=146s)

Not found in BC28-30: table "Customer Ledger Entries".

## Quotes

- [0:00](https://www.youtube.com/watch?v=6zj34hjbpGU&t=0s) "Business Central makes analyzing and working with your financial data simple with integration to Microsoft Excel. You can easily export data from a list"
- [0:16](https://www.youtube.com/watch?v=6zj34hjbpGU&t=16s) "You can also edit your data in Excel and then publish it back to Business Central"
- [0:31](https://www.youtube.com/watch?v=6zj34hjbpGU&t=31s) "On list pages, you have the option to either open or edit in Excel"
- [1:30](https://www.youtube.com/watch?v=6zj34hjbpGU&t=90s) "Analyzing the data in Excel enables powerful reporting abilities, all of which can be refreshed through the data connection"
- [1:53](https://www.youtube.com/watch?v=6zj34hjbpGU&t=113s) "This could take a while if you had to update the field one by one on each customer card. With edit in Excel, we"
- [2:04](https://www.youtube.com/watch?v=6zj34hjbpGU&t=124s) "When Excel opens, the Excel addin pane displays. Here we can refresh, filter, and publish our data"