Bulk Data Import for Microsoft Dynamics 365 Business Central
A data migration usually means loading customers, vendors, items, and open entries into many tables, and building a separate template for each table slows the work down. Import Export PowerTool imports data into effectively any Business Central table from a plain text file, and one file can carry many tables at once. This is a completely free app from Insight Works for Business Central.
The same Import Export PowerTool page that runs exports also runs imports, so a file exported from one company or environment can be loaded into another.
How Bulk data import works in Import Export PowerTool
- Prepare a text file with a table ID line, a row of field names, and the data rows for each table you want to load.
- Mark with an asterisk the fields that should run Business Central validation, usually the fields a person would type by hand.
- Open Import Export PowerTool in Business Central and set the Operation to Import.
- Choose the import options: inserts, updates, two-step insert, validation, quote handling, text encoding, and how to treat missing fields.
- Run the import and review the completion message, then check the loaded records in Business Central.

Key capabilities
Many tables in one file
Each table in the file starts with a line that names its table ID, followed by a row of field names and the data rows. A single import can load several related tables in one pass.
Fields you choose
The file carries only the fields you want to load. Columns can be added or removed in the file without first defining them anywhere in Business Central.
Insert, update, or both
The Allow Record Inserts and Allow Record Updates switches decide whether the import creates new records, changes existing ones, or does both. See Insert and Update Control.
Validation where it matters
Prefix a field name with an asterisk in the file and Import Export PowerTool runs Business Central's own validation for that field, so defaults and related fields fill in the way they would during manual entry. See Field Validation.
Trigger and file handling options
Options control whether OnInsert and OnModify trigger logic runs, whether stray quote characters added by spreadsheet programs are removed, and which text encoding the file uses.
Legacy data with extra columns
Fields and tables that do not exist in the target environment can be prompted for or skipped, so a file from an older system can still load its core data. See Missing Fields and Tables.
A clear result
When the import finishes, a message reports how many records were imported.
See Bulk data import on screen
Real screens from Import Export PowerTool, shown with demo data.
Details that matter on the floor
Business Central logic still applies
Imported records pass through Business Central table and field validation. A file that breaks business rules stops with an error rather than forcing bad data in.
Check the line endings
Text files need correct line terminators to import properly. A text editor that shows non-printing characters makes a problem file easy to spot.
Permissions stay in force
An import can only write to tables the user already has permission to change in Business Central.
Who uses Bulk data import
Business Central consultants
Load master data and open balances during new implementations and upgrades.
Data migration specialists
Move data from legacy systems, between companies, or from a sandbox to production.
Developers
Load test data quickly into development and sandbox environments.
Questions about Bulk data import
Can Business Central import data into any table?
With Import Export PowerTool, yes, for effectively any table the user has permission to change. The import still runs through Business Central table and field validation, so the data has to meet the same rules as manual entry.
Do I need one file per table?
No. One plain text file can hold many tables, each introduced by its table ID, followed by the field names and the data rows.
What file format does the import use?
Plain text. Excel is not required, although a file can be prepared in a spreadsheet and saved as text. See No Excel Dependency.
Does Import Export PowerTool replace Microsoft's cloud migration tools?
No. Import Export PowerTool is a data migration and data management tool, not an integration tool, and it does not replace Microsoft's cloud migration tooling. It can be used alongside it.
Is there a licensing cost?
Import Export PowerTool is free on Business Central online, and each user needs a Business Central license. Licensing depends on your setup; see the licensing FAQ.
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 import?
Send us a note and the Import Export PowerTool team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.
