--- id: video/N7RE_UVeH1c type: video title: "What's Cooking in Business Central: Wanna Export Data to Excel in Analysis Mode?" summary: 'Excel export from the data analysis tool (analysis mode) in Business Central. There are two ways to export: right-click in the data area (always possible, now easier) or the new menu on the data analysis tab. Exported workbooks are now named after the page and analysis tab instead of "export". The changes were backported to the current version and are in 2025 release wave 1, shown on customer ledger entries.' tier: official language: en tags: - data analysis - excel export - analysis mode - file naming system: reporting review: state: reviewed by: opus at: "2026-10-07T23:02:10.947Z" flags: [] generated: at: "2026-10-13T00:32:41.360Z" pipeline: 0.2.0 prompts: extract-video: 1 summarize-video: 2 input_hash: 8a7c1b0e005e21901a1825d7d39dce3ccd42b9134bfe8b82ef0e22bfc7c261df evidence: - kind: video url: https://www.youtube.com/watch?v=N7RE_UVeH1c&t=5s title: "What's Cooking in Business Central: Wanna Export Data to Excel in Analysis Mode?" date: "2025-01-30T12:27:28.000Z" commit: null t: 5 quote: if you like working with the data analysis tool in business Central we have a few new goodies for you - kind: video url: https://www.youtube.com/watch?v=N7RE_UVeH1c&t=25s title: "What's Cooking in Business Central: Wanna Export Data to Excel in Analysis Mode?" date: "2025-01-30T12:27:28.000Z" commit: null t: 25 quote: in this release wave we made it a little bit easier the first method is simply if you right click in the data area - kind: video url: https://www.youtube.com/watch?v=N7RE_UVeH1c&t=43s title: "What's Cooking in Business Central: Wanna Export Data to Excel in Analysis Mode?" date: "2025-01-30T12:27:28.000Z" commit: null t: 43 quote: the other way which is in which is new is to use the menu here on the data analysis Tab and simply choose open - kind: video url: https://www.youtube.com/watch?v=N7RE_UVeH1c&t=60s title: "What's Cooking in Business Central: Wanna Export Data to Excel in Analysis Mode?" date: "2025-01-30T12:27:28.000Z" commit: null t: 60 quote: you also get the file name of your Excel workbook uh with a name not not with the name export but with a name links: learn: [] objects: - object/page/25 features: [] topics: [] localizations: [] videos: [] posts: [] guidelines: [] video_id: N7RE_UVeH1c channel: yt-microsoft source_name: Microsoft Dynamics 365 Business Central (YouTube) url: https://www.youtube.com/watch?v=N7RE_UVeH1c published_at: "2025-01-30T12:27:28.000Z" duration_s: 90 captions: full audience: - end user - functional consultant - administrator chapters: - t: 0 title: Introduction to Data Analysis Export Features - t: 25 title: Excel Export Methods - Right-Click and Menu Approaches - t: 60 title: Improved File Naming for Excel Exports features: - name: Excel Export via Right-Click status: unclear t: 25 verified: false status_source: video - name: Excel Export via Data Analysis Tab Menu status: unclear t: 43 verified: false status_source: video - name: Improved Excel File Naming status: unclear t: 60 verified: false status_source: video objects_mentioned: - page data analysis - page customer ledger entries quotes: - t: 5 text: if you like working with the data analysis tool in business Central we have a few new goodies for you check: exact - t: 25 text: in this release wave we made it a little bit easier the first method is simply if you right click in the data area check: exact - t: 43 text: the other way which is in which is new is to use the menu here on the data analysis Tab and simply choose open check: exact - t: 60 text: you also get the file name of your Excel workbook uh with a name not not with the name export but with a name check: exact --- # What's Cooking in Business Central: Wanna Export Data to Excel in Analysis Mode? > Excel export from the data analysis tool (analysis mode) in Business Central. There are two ways to export: right-click in the data area (always possible, now easier) or the new menu on the data analysis tab. Exported workbooks are now named after the page and analysis tab instead of "export". The changes were backported to the current version and are in 2025 release wave 1, shown on customer ledger entries. [Watch on YouTube](https://www.youtube.com/watch?v=N7RE_UVeH1c) · Microsoft Dynamics 365 Business Central (YouTube) · 2025-01-30 · 1:30 · tier official · reviewed (checked by Opus) ## Overview The video is a short "What's Cooking" item on exporting data to Excel while working in the data analysis tool. It demonstrates two methods. The first is to right-click in the data area and choose the Excel export option, then open in Excel. The second, which is new, is a menu on the data analysis tab where you choose open in Excel. It also shows that the exported Excel workbook now gets a file name built from the page name and the analysis tab name, instead of just "export". The speaker notes that the changes were backported to the current version and are also available in the 2025 release wave 1. ## Key points - Right-click in the data area of the data analysis tool, choose Excel export, then open in Excel. This was always possible but is now easier. - A new menu on the data analysis tab offers an open in Excel option to export data directly. - Exported workbooks are named with the page name and the analysis tab name rather than just "export". - The speaker says these changes were backported to the current version and are also in the 2025 release wave 1. - The demo uses the customer ledger entries page in analysis mode. ## Chapters - [0:00](https://www.youtube.com/watch?v=N7RE_UVeH1c&t=0s) Introduction to Data Analysis Export Features - [0:25](https://www.youtube.com/watch?v=N7RE_UVeH1c&t=25s) Excel Export Methods - Right-Click and Menu Approaches - [1:00](https://www.youtube.com/watch?v=N7RE_UVeH1c&t=60s) Improved File Naming for Excel Exports ## Features Every feature below: status not stated, demoed. | Feature | At | |---|---| | Excel Export via Right-Click | [0:25](https://www.youtube.com/watch?v=N7RE_UVeH1c&t=25s) | | Excel Export via Data Analysis Tab Menu | [0:43](https://www.youtube.com/watch?v=N7RE_UVeH1c&t=43s) | | Improved Excel File Naming | [1:00](https://www.youtube.com/watch?v=N7RE_UVeH1c&t=60s) | ## 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. - page "data analysis" at [0:05](https://www.youtube.com/watch?v=N7RE_UVeH1c&t=5s) - [page 25 "Customer Ledger Entries"](../objects/page/25.md) at [1:00](https://www.youtube.com/watch?v=N7RE_UVeH1c&t=60s) Not found in BC28-30: page "data analysis". ## Quotes - [0:05](https://www.youtube.com/watch?v=N7RE_UVeH1c&t=5s) "if you like working with the data analysis tool in business Central we have a few new goodies for you" - [0:25](https://www.youtube.com/watch?v=N7RE_UVeH1c&t=25s) "in this release wave we made it a little bit easier the first method is simply if you right click in the data area" - [0:43](https://www.youtube.com/watch?v=N7RE_UVeH1c&t=43s) "the other way which is in which is new is to use the menu here on the data analysis Tab and simply choose open" - [1:00](https://www.youtube.com/watch?v=N7RE_UVeH1c&t=60s) "you also get the file name of your Excel workbook uh with a name not not with the name export but with a name" ## Disclaimers in the video - [0:05](https://www.youtube.com/watch?v=N7RE_UVeH1c&t=5s) preview: they're actually a bit old because they were backported to the current version but they are also available in the 2025 release Wave 1