MSGreenTec® BC2Excel
Excel exports straight out of Microsoft Dynamics 365 Business Central – as a flat or grouped layout, or as a freely designed placeholder template, including format rules, formulas and email delivery.
Features
Layout Mode
Export generated directly from the source/field definition – with format rules, border presets, zebra striping, free cells and grouping for nested sources.
Template Mode
Upload your own Excel template and fill it with placeholders and repeating ranges – design stays entirely in Excel.
Placeholder Reference
Field placeholders, repeating ranges, system placeholders (company, date, user, filter) and formula placeholders for free cells.
BC2Excel Run Export
Pick a template, enter runtime filters, get warned for large exports – download, send by email, or save as an attachment.
Package Export/Import
Exchange templates, including sources, fields, styles and the template file, as a single JSON package between companies or tenants.
Permissions
Separate roles for running and configuring – users who only run exports can neither see nor change templates.
Export Log
Every export is logged – template, output type, user, duration, record count and error message.
Public API
Trigger exports from code, register your own data sources, and extend placeholders and events from your own extension.
Quickstart
Ready in 5 steps
Install the app
Install MSGreenTec® BC2Excel from Microsoft AppSource or as an .app file in Business Central.
Run the setup assistants
Search → "BC2Excel" – check Settings and Permissions, and register the license.
Create the example templates
The "Create Example Templates" assistant creates ready-to-run templates for both Layout and Template mode.
Build your own template
Import sources, fields and styles via a JSON package or build them through the AL API, then design it in Layout mode or Template mode.
Export
Use BC2Excel Run Export to download, send by email, or save as a document attachment – every run shows up in the Export Log.