Welcome to our new blog series, “What’s Cooking in Business Central.” Here, we’ll share the latest updates, tips, and best practices to help you get the most out of Microsoft Dynamics 365 Business Central. Whether you’re new to the platform or have been using it for a while, this series will keep you informed and help you work smarter.
Stay tuned for exciting and useful advice!
Today, we’ll discuss some simple but useful updates to the 2025 Release Wave 1 Excel export features. These changes make it quicker and easier to work with your data, so let’s dive in and take a look!
If you’re a business central user who frequently works with data analysis tools, you’re in for a treat! The latest updates in Business Central include new features for exporting data to Excel. These updates are part of the 2025 Release Wave 1. While these features were initially available in test versions, they’ve now been made live in the current version, making working with your data even easier and more efficient.
What’s New in Excel Export?
Exporting data to Excel is not a new concept in Business Central—users have been able to do it for quite some time. However, the new improvements in this release wave streamline the process and add a few user-friendly touches to enhance your experience.
1. Right-click and Export to Excel
In this update, exporting data to Excel is as simple as right-clicking in the data area. Here’s how:
Step 1: Right-click in the data area
That’s it! With just a few clicks, you’ll have your Excel data ready for further analysis or manipulation
2. New “Open in Excel” Button on the Data Analysis Tab
The second method of exporting to Excel is brand-new features designed to make your workflow even smoother. You no longer need to right-click—simply use the “Open in Excel” button on the Data Analysis tab in the menu.
This button provides a more direct and intuitive export process, saving you time when you need to get your data into and Excel file quickly.
3. File Naming for Easier Organisation
One of the standout features of this update is the improved file name convention. Previously, Excel exports defaulted to generic names like “Export,” but with the new update, you get a much more informative file name.
When you export data using either method, your Excel file will automatically take the name of the page you are (e.g. “Customer Ledger Entries”) along with the name of your analysis tab. This improvement helps you stay organised, especially when working with multiple datasets.
Why Does This Matter?
The new features in Business Central’s 2025 Release Wave 1 save time, enhance your organisation, and ultimately improve your productivity. With more intuitive and streamlined processes for exporting data to Excel, you can focus more on analysis and decision-making rather than spending time on repetitive tasks.
Whether you’re managing customer data, sales records, or any other form of business information, these improvements make it easier to transfer that data into Excel, where you manipulate, analyse and present it as needed.
Final Thoughts
The latest Excel export updates in Business Central’s 2025 Release Wave 1 are all about making data export easier, faster, and more user-friendly. Whether you’re exporting through the right-click or the new button on the Data Analysis Tab, you’ll experience a smoother and more efficient workflow. Plus, with the latest file naming conventions, organising your exported data has never been easier!
