Skip to content
Import Export PowerTool app iconImport Export PowerToolExport

Bulk Data Export for Microsoft Dynamics 365 Business Central

Getting data out of Business Central for a migration, a copy to another company, or analysis often means exporting table after table. Import Export PowerTool exports any number of tables to a single text file, using table IDs and standard Business Central filter syntax. This is a completely free app from Insight Works for Business Central.

How Bulk Data Export works in Import Export PowerTool

  1. Open Import Export PowerTool and set the Operation to Export.
  2. Enter a table ID filter, or choose a configuration package.
  3. Choose whether to include record links and record notes.
  4. Run the export and review the completion message.
  5. Open the text file in a text editor, or import it into another company or environment.

Key capabilities

Tables by ID

Enter a table ID filter, such as a range or a list of IDs, using the filter syntax people already use in Business Central.

All fields

A table ID export includes every field in the tables you select, ready to edit or import elsewhere.

From a configuration package

Point at an existing configuration package to export only the tables and fields it defines. See Configuration Package Reuse.

Notes and links too

Record links and record notes can be exported across a filtered range of tables. See Record Links and Notes.

Ready to import

The export file uses the same format that Import Export PowerTool imports, so data can move from a sandbox to production or from one company to another.

See Bulk Data Export on screen

Real screens from Import Export PowerTool, shown with demo data.

Details that matter on the floor

One file to manage

Many tables in one text file are easier to review, edit, and hand over than a separate file or sheet for each table.

Permissions apply

A user can only export data from tables they already have permission to read in Business Central.

Who uses Bulk Data Export

Business Central consultants

Copy setup and master data between companies and environments.

Business analysts

Export data for detailed analysis outside Business Central.

Developers

Pull realistic data into development and test environments.

Questions about Bulk Data Export

How do I export many Business Central tables at once?

With Import Export PowerTool, set the Operation to Export and enter a table ID filter. All the selected tables export to one text file.

Can I export only some fields?

Yes, by exporting from a configuration package that defines the tables and fields you want. A table ID export includes all fields.

Can the export file be imported into another company?

Yes. The export uses the same text format that Import Export PowerTool imports.

Import Export PowerTool app icon

Part of Import Export PowerTool

Import, export, update, and delete Business Central data in bulk, for data migration and ongoing data management.

Have a question about Bulk Data Export?

Send us a note and the Import Export PowerTool team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.

Ask a product question

Product Questions