---
id: topic/business-central/integrate-with-other-applications/microsoft-office-apps-and-microsoft-365
type: topic
title: Microsoft Office apps and Microsoft 365
summary: "Integration of Business Central with Microsoft Office apps and Microsoft 365: Excel, OneDrive, Outlook, Teams and Word. It answers how-to, setup and administration questions about exchanging data, sharing files and records, email and contacts, and report or document layouts."
tier: official
language: en
review:
  state: reviewed
  by: opus
  at: "2026-10-07T02:16:41.871Z"
  flags: []
generated:
  at: "2026-10-08T00:04:31.553Z"
  pipeline: 0.2.0
  prompts:
    hub-topic: 1
  input_hash: 9f1c66d639be14d787139c8f01a775b52404dbeea8ec8abdff90bfc96dd602e8
evidence:
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/teams-access-with-m365-license
    title: Access Data in Teams without Business Central License
    date: "2023-02-07"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/across-teams-tab
    title: Add Business Central tab in Microsoft Teams
    date: "2025-10-21"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/across-teams-overview
    title: Business Central and Microsoft Teams Integration
    date: "2025-10-21"
    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/across-teams-settings
    title: Changing company and other settings in Teams
    date: "2025-10-21"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/admin-onedrive-integration-onpremises
    title: Configuring OneDrive integration with Business Central on-premises
    date: "2024-09-01"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/ui-design-word-layouts-business-central-add-in
    title: Design Word Layouts with the Business Central Add-in
    date: "2026-09-09"
    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/across-install-app-for-teams
    title: Install the Business Central app in Microsoft Teams
    date: "2025-10-16"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/m365-integration-overview
    title: Integrating with Office apps and Microsoft 365
    date: "2026-06-19"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/admin-teams-integration
    title: Managing Microsoft Teams Integration with Business Central| Microsoft Docs
    date: "2025-01-06"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/admin-onedrive-integration
    title: Managing OneDrive Integration with Business Central
    date: "2024-06-13"
    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/admin-onedrive-faq
    title: OneDrive in Business Central FAQ
    date: "2025-01-28"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/across-share-onedrive
    title: Opening Business Central Files in OneDrive
    date: "2025-10-21"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/save-business-contacts-to-outlook
    title: Save Business Contacts to Microsoft Outlook
    date: "2026-03-13"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/across-search-contacts-teams
    title: Searching for contacts from Microsoft Teams
    date: "2025-10-20"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/dev-itpro/administration/configuring-excel-addin
    title: Setting up the Excel Add-In for Editing Data
    date: "2024-09-18"
    commit: null
    t: null
    quote: null
  - kind: learn
    url: https://learn.microsoft.com/dynamics365/business-central/across-working-with-teams
    title: Sharing Business Central records in Microsoft Teams
    date: "2025-10-23"
    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/admin-no-outlook
    title: Using Business Central without Outlook
    date: "2023-12-11"
    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/m365-integration-overview
  objects:
    - object/page/1480
    - object/page/1831
    - object/page/1832
    - object/page/2718
    - object/page/9553
    - object/page/9650
    - object/page/9652
    - object/page/9660
    - object/page/9666
  features: []
  topics:
    - topic/business-central/integrate-with-other-applications
    - topic/business-central/integrate-with-other-applications/microsoft-office-apps-and-microsoft-365/microsoft-excel
    - topic/business-central/integrate-with-other-applications/microsoft-office-apps-and-microsoft-365/microsoft-onedrive
    - topic/business-central/integrate-with-other-applications/microsoft-office-apps-and-microsoft-365/microsoft-outlook
    - topic/business-central/integrate-with-other-applications/microsoft-office-apps-and-microsoft-365/microsoft-teams
    - topic/business-central/integrate-with-other-applications/microsoft-office-apps-and-microsoft-365/microsoft-word
  localizations: []
  videos: []
  posts: []
  guidelines: []
learn_toc_path:
  - Integrate with other applications
  - Microsoft Office apps and Microsoft 365
toc_file: business-central/TOC.md
parent: topic/business-central/integrate-with-other-applications
children:
  - topic/business-central/integrate-with-other-applications/microsoft-office-apps-and-microsoft-365/microsoft-excel
  - topic/business-central/integrate-with-other-applications/microsoft-office-apps-and-microsoft-365/microsoft-onedrive
  - topic/business-central/integrate-with-other-applications/microsoft-office-apps-and-microsoft-365/microsoft-outlook
  - topic/business-central/integrate-with-other-applications/microsoft-office-apps-and-microsoft-365/microsoft-teams
  - topic/business-central/integrate-with-other-applications/microsoft-office-apps-and-microsoft-365/microsoft-word
coverage:
  learn: 24
  code: 9
  video: 0
  blog: 0
  guideline: 0
bc_forms:
  - 1480
  - 1831
  - 1832
  - 2718
  - 9553
  - 9650
  - 9652
  - 9660
  - 9666
member_hash: 88aa9829e9139b478da110d5b21bd9d8d55751c9b0039b25816320366e1be77a
narrative: generated
---

# Microsoft Office apps and Microsoft 365

> Integration of Business Central with Microsoft Office apps and Microsoft 365: Excel, OneDrive, Outlook, Teams and Word. It answers how-to, setup and administration questions about exchanging data, sharing files and records, email and contacts, and report or document layouts.

Path: [Integrate with other applications](../integrate-with-other-applications.md) > Microsoft Office apps and Microsoft 365 · tier official · system none · narrative reviewed (checked by Opus)

## Overview

This area covers how Business Central works with the Microsoft 365 apps people already use. An introductory page gives the overall picture: Excel export and import, OneDrive document storage, Outlook email and contact management, Teams sharing, and Word document templates.

Each app has its own subtopic. Excel covers viewing and editing data in Excel, the Excel add-in setup for on-premises, importing data from Excel or configuration packages, and Excel report layouts. OneDrive covers opening, sharing and saving files, plus admin setup for online and on-premises. Outlook covers deploying the add-in, saving contacts to Outlook and Teams, and email setup without Outlook. Teams covers installing the app, searching contacts, sharing records as cards, adding tabs, company settings, and administrator tasks such as licensing and deployment. Word covers report layouts, the XML Mapping pane, and Word templates for bulk communications.

Start with the introductory page to find the right app, then open that app's subtopic. Administrators should look at the setup and deployment pages in the Excel, OneDrive, Outlook and Teams subtopics.

## Key points

- Excel: view and edit Business Central data in Excel, import data from Excel or configuration packages, and build Excel report layouts.
- Excel add-in setup is documented for on-premises deployments.
- OneDrive: open and share files in OneDrive for Business and save Excel workbooks and report files, with admin setup for online and on-premises.
- Outlook: deploy the Outlook add-in, save Business Central contacts to Outlook and Teams, and set up email when Outlook is not used.
- Teams: install the Business Central app, search contacts, share records and page links as interactive cards, add Business Central tabs, and change company settings.
- Teams administrator management covers licensing and deployment.
- Word: design report layouts with the Business Central add-in and map data fields in the XML Mapping pane.
- Word templates support bulk communications with customers, vendors and contacts.

## Subtopics

- [Microsoft Excel](microsoft-office-apps-and-microsoft-365/microsoft-excel.md) (4 pages)
- [Microsoft OneDrive](microsoft-office-apps-and-microsoft-365/microsoft-onedrive.md) (5 pages)
- [Microsoft Outlook](microsoft-office-apps-and-microsoft-365/microsoft-outlook.md) (3 pages)
- [Microsoft Teams](microsoft-office-apps-and-microsoft-365/microsoft-teams.md) (8 pages)
- [Microsoft Word](microsoft-office-apps-and-microsoft-365/microsoft-word.md) (3 pages)

## More Learn pages

- [Integrating with Office apps and Microsoft 365](https://learn.microsoft.com/dynamics365/business-central/m365-integration-overview): Learn how to integrate Business Central with Office apps and Microsoft 365.

## 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 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 [Microsoft Excel](microsoft-office-apps-and-microsoft-365/microsoft-excel.md)
- [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) · via [Microsoft Outlook](microsoft-office-apps-and-microsoft-365/microsoft-outlook.md)
- [Page 1832 "Outlook Individual Deployment"](../../../objects/page/1832.md) · captioned "Get the Outlook Add-in" · via [Microsoft Outlook](microsoft-office-apps-and-microsoft-365/microsoft-outlook.md)
- [Page 2718 "Page Summary Settings"](../../../objects/page/2718.md) · captioned "Card Settings" · via [Microsoft Teams](microsoft-office-apps-and-microsoft-365/microsoft-teams.md)
- [Page 9553 "Document Service Setup"](../../../objects/page/9553.md) · captioned "OneDrive Setup" · via [Microsoft OneDrive](microsoft-office-apps-and-microsoft-365/microsoft-onedrive.md)
- [Page 9650 "Custom Report Layouts"](../../../objects/page/9650.md) · on [Table 9650 "Custom Report Layout"](../../../objects/table/9650.md) · via [Microsoft Excel](microsoft-office-apps-and-microsoft-365/microsoft-excel.md)
- [Page 9652 "Report Layout Selection"](../../../objects/page/9652.md) · on [Table 9651 "Report Layout Selection"](../../../objects/table/9651.md) · via [Microsoft Excel](microsoft-office-apps-and-microsoft-365/microsoft-excel.md)
- [Page 9660 "Report Layouts"](../../../objects/page/9660.md) · via [Microsoft Word](microsoft-office-apps-and-microsoft-365/microsoft-word.md)
- [Page 9666 "Report Theme and Header/Footer"](../../../objects/page/9666.md) · captioned "Manage themes and header-footer layouts" · via [Microsoft Word](microsoft-office-apps-and-microsoft-365/microsoft-word.md)

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