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.

Ready in 5 Steps

  1. Install the App – Install MSGreenTec® BC2Excel from Microsoft AppSource or as an .app file in Business Central.
  2. Run the Setup Assistants – Search → "BC2Excel" – check Settings and Permissions, and register the license.
  3. Create the Example Templates – The "Create Example Templates" assistant creates ready-to-run templates for both Layout and Template mode.
  4. 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.
  5. Export – Use BC2Excel Run Export to download, send by email, or save as a document attachment – every run shows up in the Export Log.

You'll find the full documentation here.

Get to Know Us with No Obligation

To find out how Microsoft Dynamics 365 Business Central can take your business to the next level, we offer prospective customers a free consultation.

Book a Call