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
- Open Import Export PowerTool and set the Operation to Export.
- Enter a table ID filter, or choose a configuration package.
- Choose whether to include record links and record notes.
- Run the export and review the completion message.
- 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.
Related Import Export PowerTool features
All Import Export PowerTool features →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.
