How to Use Excel in Microsoft Dynamics 365 Business Central

by | Updated January 7, 2021 | Dynamics 365 Business Central

Thanks to Microsoft Excel’s popularity and long-standing presence in the office, the spreadsheet tool has a large, loyal following. If you’ve been working with Excel for many years, you’ll be happy to know that Microsoft Dynamics offers a variety of ways to use it in combination with Business Central.

Microsoft Dynamics 365 Business Central users can connect Excel into Business Central for flexible, familiar data editing and reporting. Let’s explore the different options for using Excel with Business Central.

How Excel Can Be Used in Business Central

Excel is used in Business Central for:

  • Reporting purposes
  • Importing data
  • Copying and pasting data directly into your Business Central environment
  • Editing data directly before publishing it to Business Central

If you love Excel, you’ll love Business Central. The following illustration shows the item list in Business Central. It visually explains the three main concepts of using Excel with regard to your items in Business Central.

1. Open Excel in Business Central

The “Open in Excel” option sends the Business Central page to Excel for further analysis. It’s important to note that this is one-way. Therefore, use this feature only when you don’t plan to make changes and publish them back into Business Central. The option to open your data in Excel is available from any Business Central journal, list, or worksheet. Simply open the page you’re interested in, and click “Open in Excel.” From here, you’ll have the option to open the resulting Excel workbook immediately or save it to your computer.

This is a great feature for Business Central users who are used to build reports in Excel and prefer its interface for their data analysis.

2. Edit Business Central Data in Excel

The “Edit in Excel” option, like the “Open in Excel” option, creates an Excel file with the data on the Business Central page. Additionally, you now have the option to make changes to the data in Excel and send it back to Business Central. On our eLearning portal, you can find a training video on how to edit in Excel, based on the customer master data as an example.

Microsoft also has a short video on how to work with Excel in Business Central. The “Edit in Excel” feature is great for making mass updates to your data or for analyzing transactional data.

3. Refresh Excel Data in Business Central

You have the option to refresh Excel data in Business Central, too. The Excel file that you created by using the “Edit in Excel” feature can be saved with its link to the data source in Business Central. This way, it can be used to refresh the data at any point in time.

Other options that let you work seamlessly with Business Central and Excel include:

  • Default Excel reports directly from your role center
  • Copy and paste from Business Central to Excel and back (ideal for journals)
  • Budgeting in Excel
  • Financial reporting and consolidating in Excel
  • Create a query in Business Central using Web services
  • Querying your Business Central data from within Excel using “Get Data From Odata feed”

Related Posts


Submit a Comment

Your email address will not be published. Required fields are marked *

Upcoming Events


02jun2:00 pm2:30 pmBusiness Intelligence for Batch Manufacturers

16jun10:00 am10:30 amHow AP automation can speed up month-end close in D365 Finance

17jun11:00 am12:00 pmConfab Live with Stoneridge – Real Time Marketing Strategies for Success

23jun10:00 am10:30 amThe Modern Manufacturer: Cost Accounting in D365

30jun10:00 am10:30 amAP Automation Checklist for a 2022 Rebound

30jun2:00 pm2:30 pmAchieving Success: How Technology Is Helping Nonprofits Thrive


01jul11:00 am12:00 pmConfab Live with Stoneridge – Dataverse Virtual Entities

14jul12:00 pm12:30 pmBeyond Reporting - What Business Intelligence Can Do For Your Agribusiness

15jul11:00 am12:00 pmConfab Live with Stoneridge – Integration Strategies for End User Success

21jul10:00 am10:30 amThe Modern Manufacturer: Manufacturing Software in the Real World

21jul12:00 pm1:00 pmIs it Worth it to Upgrade to Dynamics 365 Finance and Supply Chain Management? - Everything AX Users Need to Consider

About Stoneridge
Stoneridge Software is a unique Microsoft Gold Partner, with emphasis on partner. With specialties in Microsoft Dynamics 365, Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP and Microsoft Dynamics CRM, we focus on attracting the most knowledgeable experts in the field to our team, and prioritize delivering stellar solutions with maximum impact for your business. At Stoneridge, we are deeply committed to your results. Each engagement is met with a dedicated team, ready to provide thorough, tailored, and expert service. Based in Minnesota, we intentionally “step into your shoes,” wherever you are. We focus on what you care about, and develop trusting, long-term relationships with our clients.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!