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.
- Introduction to Data Analysis Export Features
- Excel Export Methods - Right-Click and Menu Approaches
- Improved File Naming for Excel Exports
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.
Features
Every feature below: status not stated, demoed.
| Feature | At |
|---|---|
| Excel Export via Right-Click | 0:25 |
| Excel Export via Data Analysis Tab Menu | 0:43 |
| Improved Excel File Naming | 1:00 |
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
- page 25 “Customer Ledger Entries” at 1:00
Not found in BC28-30: page “data analysis”.
Quotes
- 0:05 “if you like working with the data analysis tool in business Central we have a few new goodies for you”
- 0:25 “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 “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 “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 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