---
id: topic/dev-itpro/integration/integrating-business-central-with-office
type: topic
title: Integrating Business Central with Office apps and Microsoft 365
summary: "Integration of Business Central with Office apps and Microsoft 365: Excel, OneDrive, Teams, Word and the Outlook add-in. It answers questions about editing and reporting in Excel, sharing documents, Teams cards and tabs, Word layouts and templates, and deploying the Outlook add-in."
tier: official
language: en
system: integration
review:
  state: reviewed
  by: opus
  at: "2026-10-07T05:21:05.533Z"
  flags: []
generated:
  at: "2026-10-08T00:04:31.553Z"
  pipeline: 0.2.0
  prompts:
    hub-topic: 1
  input_hash: fd3ad344a1025cc03f884400385aa0775a3914c557ba51559459f983b4e25b85
evidence:
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/dev-itpro/developer/devenv-develop-for-teams-tab-content
    title: Add and remove recommended content for Business Central tabs
    date: "2023-12-22"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/across-onedrive-overview
    title: Business Central and OneDrive for Business Integration
    date: "2025-10-17"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/dev-itpro/developer/devenv-edit-in-excel-lists
    title: Controlling Edit in Excel on list pages
    date: "2024-05-02"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/dev-itpro/developer/devenv-develop-for-teams-tabs
    title: Create Business Central tabs for Teams
    date: "2023-12-28"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/dev-itpro/developer/devenv-develop-for-teams
    title: Developing for Microsoft Teams Integration
    date: "2022-11-23"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/dev-itpro/developer/devenv-develop-for-teams-cards
    title: Developing for Microsoft Teams Using Metadata
    date: "2021-04-01"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/dev-itpro/developer/devenv-extending-document-sharing-onedrive
    title: Extending Document Sharing and OneDrive for Business
    date: "2021-10-01"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/dev-itpro/developer/devenv-dev-faq-teams
    title: Frequently asked questions about Microsoft Teams integration with Business Central
    date: "2022-11-23"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/dev-itpro/developer/devenv-develop-for-teams-check-session
    title: Get session and environment information relevant to Teams development
    date: "2023-12-19"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/admin-outlook
    title: Get the Business Central Add-in for Outlook
    date: "2026-03-10"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/dev-itpro/developer/m365-integration-overview
    title: Integrating with Office apps and Microsoft 365
    date: "2024-07-23"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/ui-how-add-fields-word-report-layout
    title: Map Data Fields in Word Layouts
    date: "2026-09-09"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/across-import-data-configuration-packages
    title: Use Excel to import data
    date: "2026-06-17"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/ui-mail-merge
    title: Using Word templates for bulk communications
    date: "2024-11-13"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/across-work-with-excel
    title: Viewing and editing in Excel from Business Central
    date: "2026-01-26"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/ui-excel-report-layouts
    title: Working with Excel layouts
    date: "2024-09-09"
    commit: null
    t: null
    quote: null
links:
  learn:
    - https://learn.microsoft.com/dynamics365/business-central/admin-outlook
    - https://learn.microsoft.com/dynamics365/business-central/dev-itpro/developer/m365-integration-overview
  objects:
    - object/page/1480
    - object/page/1831
    - object/page/1832
    - object/page/9650
    - object/page/9652
  features: []
  topics:
    - topic/dev-itpro/integration
    - topic/dev-itpro/integration/integrating-business-central-with-office/integrating-with-microsoft-excel
    - topic/dev-itpro/integration/integrating-business-central-with-office/integrating-with-microsoft-onedrive
    - topic/dev-itpro/integration/integrating-business-central-with-office/integrating-with-microsoft-teams
    - topic/dev-itpro/integration/integrating-business-central-with-office/integrating-with-microsoft-word
  localizations: []
  videos: []
  posts: []
  guidelines: []
  changes:
    - change/bcapps/8051
    - change/bcapps/8318
learn_toc_path:
  - Integration
  - Integrating Business Central with Office apps and Microsoft 365
toc_file: dev-itpro/TOC.md
parent: topic/dev-itpro/integration
children:
  - topic/dev-itpro/integration/integrating-business-central-with-office/integrating-with-microsoft-excel
  - topic/dev-itpro/integration/integrating-business-central-with-office/integrating-with-microsoft-onedrive
  - topic/dev-itpro/integration/integrating-business-central-with-office/integrating-with-microsoft-teams
  - topic/dev-itpro/integration/integrating-business-central-with-office/integrating-with-microsoft-word
coverage:
  learn: 16
  code: 5
  video: 0
  blog: 0
  guideline: 0
bc_forms:
  - 1480
  - 1831
  - 1832
  - 9650
  - 9652
member_hash: d98ae0c47255f3855b2ac4e7287e4df94986fc9661dc88cd16860d8e9e01802c
narrative: generated
---

# Integrating Business Central with Office apps and Microsoft 365

> Integration of Business Central with Office apps and Microsoft 365: Excel, OneDrive, Teams, Word and the Outlook add-in. It answers questions about editing and reporting in Excel, sharing documents, Teams cards and tabs, Word layouts and templates, and deploying the Outlook add-in.

Path: [Integration](../integration.md) > Integrating Business Central with Office apps and Microsoft 365 · tier official · system integration · narrative reviewed (checked by Opus)

## Overview

This area covers how Business Central connects to Microsoft 365 tools. The landing page lists the capabilities: Excel, OneDrive, Outlook, SharePoint, Teams, Word and Microsoft Graph, used for data management and document processing.

The pages split by product. Four subtopics cover Excel, OneDrive, Teams and Word. The Outlook add-in has its own page, which describes how to get and deploy it. Start with the overview page to find the right product, then go to that subtopic.

Excel and Word pages cover both users and report authors (Edit in Excel, report layouts, XML mapping, Word templates). The Teams pages are aimed at AL developers. The OneDrive pages cover setup, daily use and extending the Document Sharing module.

## Key points

- Excel: Open in Excel and Edit in Excel, permission sets that control Edit in Excel, importing data through Excel or configuration packages, and Excel report layouts.
- OneDrive: open, share and save documents such as reports and Excel workbooks in OneDrive for Business; developers can extend the Document Sharing module.
- Teams: for AL developers; covers Teams cards, card details and tabs, customizing cards with the Brick field group and AL events, and detecting Teams sessions.
- Teams FAQs address link unfurling, stage view, licensing and permissions.
- Word: map report data fields into Word layouts with the XML Mapping pane, and use Word templates to merge entity data into bulk communications for customers, vendors and contacts.
- Outlook add-in: can be deployed centrally by Microsoft 365 admins or installed individually by users.
- The Outlook add-in provides contact insights and document view in emails and appointments, and supports creating business documents.

## Subtopics

- [Integrating with Microsoft Excel](integrating-business-central-with-office/integrating-with-microsoft-excel.md) (4 pages)
- [Integrating with Microsoft Onedrive](integrating-business-central-with-office/integrating-with-microsoft-onedrive.md) (2 pages)
- [Integrating with Microsoft Teams](integrating-business-central-with-office/integrating-with-microsoft-teams.md) (6 pages)
- [Integrating with Microsoft Word](integrating-business-central-with-office/integrating-with-microsoft-word.md) (2 pages)

## More Learn pages

- [Get the Business Central Add-in for Outlook](https://learn.microsoft.com/dynamics365/business-central/admin-outlook): Learn how to install the Business Central add-in for Outlook for your organization or for your own use.
- [Integrating with Office apps and Microsoft 365](https://learn.microsoft.com/dynamics365/business-central/dev-itpro/developer/m365-integration-overview): Learn how to integrate Business Central with Office apps and Microsoft 365.

## Videos, posts and code changes

Linked by a Haiku matcher with a grounding quote from the item's summary (link/topics.ts); machine-generated.

- [#8051 [Edit in Excel] Expose ExternalizeODataObjectName and add Page Control Field publisher](../../../changes/bcapps/8051.md) (code change): "Edit in Excel codeunit now exposes a public procedure for OData object name conversion"
- [#8318 SharePoint Graph Module - extend functionality with additional methods](../../../changes/bcapps/8318.md) (code change): "SharePoint Graph module gains update and rename operations for drive items"

## Business Central pages and reports

The pages, reports and queries this hub's Learn pages name (ms.search.form, API reference), joined to the code by exact object id (data/index/docs-objects.json); a page shows the table it runs on.

- [Page 1831 "Outlook Centralized Deployment"](../../../objects/page/1831.md) · captioned "Outlook Add-in Centralized Deployment" · on [Table 1610 "Office Add-in"](../../../objects/table/1610.md)
- [Page 1832 "Outlook Individual Deployment"](../../../objects/page/1832.md) · captioned "Get the Outlook Add-in"
- [Page 1480 "Excel Centralized Depl. Wizard"](../../../objects/page/1480.md) · captioned "Excel Add-in Centralized Deployment" · on [Table 1480 "Edit in Excel Settings"](../../../objects/table/1480.md) · via [Integrating with Microsoft Excel](integrating-business-central-with-office/integrating-with-microsoft-excel.md)
- [Page 9650 "Custom Report Layouts"](../../../objects/page/9650.md) · on [Table 9650 "Custom Report Layout"](../../../objects/table/9650.md) · via [Integrating with Microsoft Excel](integrating-business-central-with-office/integrating-with-microsoft-excel.md)
- [Page 9652 "Report Layout Selection"](../../../objects/page/9652.md) · on [Table 9651 "Report Layout Selection"](../../../objects/table/9651.md) · via [Integrating with Microsoft Excel](integrating-business-central-with-office/integrating-with-microsoft-excel.md)

Source: Microsoft Learn (CC BY 4.0). Descriptions are Learn's own.