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


01sep10:00 am10:30 amEnsuring Quality and Compliance for Batch Manufacturers in Life Sciences

01sep12:00 pm12:30 pmIs it Worth It to Move to the Cloud? A Look at Considerations for Current Agribusinesses Using Dynamics GP

01sep2:00 pm2:45 pmWhat’s New in Dynamics 365 Finance and Supply Chain

09sep11:00 am12:00 pmConfab Live with Stoneridge – Data Strategy and Reporting – Mining Decision Making Insights

15sep10:00 am11:00 amSolving the Biggest Challenges in Agribusiness Through Innovation and Technology

22sep12:00 am12:30 pmSimplifying Payroll and HR Management with ADP Workforce Now

22sep10:00 am10:30 amStreamlining Batch Manufacturing with Technology

22sep2:00 pm2:30 pmProcess Automation for Microsoft Dynamics D365 for Business Central, Finance and Operations and GP

23sep11:00 am12:00 pmConfab LIVE with Stoneridge - Riding the Wave 2 Release – Key Features Coming to Dynamics 365 this October

29sep10:00 am11:00 amTop Five Reasons Why NOW is the Right Time to Move from Salesforce to Dynamics 365 Customer Engagement

29sep12:00 pm12:45 pmUnderstanding Job Costing and Tax Management in Business Central

29sep2:00 pm3:00 pmDigitalizing Horticulture & Agriculture - How to Sell Plants Online and Simplify Business Management

30sep12:00 pm4:00 pmSecurity and Permissions Training for D365 Business Central or Dynamics NAV


06oct10:00 am10:30 amPreview of D365 Business Central Fall Release Features and Functionality

06oct12:00 pm12:30 pmInsider's Guide to New Features Available in the Fall Release of D365 Finance and Supply Chain

07oct11:00 am12:00 pmConfab LIVE with Stoneridge - Dataverse and Dynamics in Review – Let’s Get Technical

21oct11:00 am12:00 pmConfab LIVE with Stoneridge - Dataverse and Dynamics in Review – Let’s Get Functional

26oct(oct 26)9:00 am28(oct 28)5:00 pmStoneridge Connect Leadership and Community Conference

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!