Import Export PowerTool for Microsoft Dynamics 365 Business Central
100% Free App
Load and fix Business Central data in bulk
Import, export, update, and delete Business Central data in bulk, for data migration and ongoing data management.
Import Export PowerTool moves data into, out of, and around Microsoft Dynamics 365 Business Central with bulk import, export, update, and delete operations on effectively any table. This is a completely free app from Insight Works for Business Central. It is built for consultants, integrators, and developers handling data migration and cleanup, and it works within each user's existing Business Central permissions.
- Business Central online
- No user limit
- Rating on Microsoft Marketplace
- 5.0
- Installs
- 5,000+
Import Export PowerTool resources
How Import Export PowerTool helps
Data migration
Load legacy data in one file, then rerun only what failed
Data migration often stalls on the import step. Every rerun after a fix costs time, and large loads spread across many files are hard to keep straight.
Import Export PowerTool reads and writes plain text files that can carry many tables in one file, with no Excel dependency. Existing RapidStart configuration package definitions can be reused as export templates, and imports can commit per table so an error in a later table does not force a full reimport.
See all Import Export PowerTool features ↓Update and delete
Fix bad records directly, with a preview first
A broken reservation entry, or a wrong value across hundreds of records, usually means asking a developer for an extension or exporting, editing, and reimporting the data. Both take longer than the fix itself.
The Update and Delete operations apply a value to, or remove, a filtered set of records, including fields Business Central marks non-editable and protected tables with no page of their own. A preview shows which records a filter will affect, and an enhanced confirmation option makes the user confirm before a destructive operation runs.
See all Import Export PowerTool features ↓Access control
Decide who can reach protected tables
A tool that can delete ledger entries is useful to a consultant and risky in the wrong hands. Administrators need to control access before the tool is in wide use.
Two permission sets separate managers, who can change setup, from users, who cannot. The setup page controls update and delete access, access to protected tables, and the option to disable the change log, and the app never grants more than a user's existing Business Central table permissions.
See all Import Export PowerTool features ↓Opening inventory
Load opening inventory with lot and serial numbers
Opening inventory for tracked items needs a lot or serial number on every line, which is slow to prepare by hand. Notes and links from the old system are often lost along the way.
Import Export PowerTool creates lot and serial number entries automatically on item journal imports. Record links and record notes can be exported and imported too, so notes from a legacy system carry across.
See all Import Export PowerTool features ↓Import Export PowerTool screenshots
Real screens from Import Export PowerTool in Business Central, shown with demo data.
Import Export PowerTool features
22 features in 4 groups. Each one has its own page with screens, steps, and answers to common questions.
Import
- Bulk importImport data into effectively any table from plain text files.
- Insert and update controlChoose whether an import can insert records, update existing records, or both.
- Field validationValidate selected fields with Business Central business logic by marking them in the file.
- Two-step insertInsert the primary key first, then the remaining fields, for tables that need it.
- Lot and serial number insertionCreate lot and serial number entries automatically on item journal imports.
- Missing fields and tablesPrompt for, or skip, fields and tables that do not exist in the target environment.
- Disable change logTurn off the change log during an import to avoid thousands of log entries.
- Per-table commitCommit imports per table so an error in a later table does not require a full reimport.
- DimensionsImport and export shortcut, non-shortcut, and default dimensions.
Export
- Bulk exportExport many tables to one text file using table IDs and standard filters.
- Configuration package reuseUse existing RapidStart configuration package definitions as export templates.
- Record links and notesExport and import record links and record notes.
- No Excel dependencyWork with plain text files that any text editor can open.
Update and delete
- Update recordsApply a value to a field across a filtered set of records.
- Delete recordsRemove a filtered set of records in one operation.
- PreviewPreview the records a filter will affect before you run an operation.
- Protected tablesWork with system-protected tables, including fields marked non-editable.
- Change log cleanupDelete change log entries when protected table access is enabled.
Control and extension
- Permission setsControl access through separate manager and user permission sets.
- Enhanced confirmationRequire users to confirm before an update or delete runs.
- Batch configurationsStore configurations as batches for repeatable tasks.
- Published eventsExtend the app through published events, for example to run scheduled imports.
Import Export PowerTool videos
3 videos on setting up and using Import Export PowerTool, in the order most people need them.

5 min
Set up Import Export PowerTool
For administrators who have just installed the app and want to control who can import, update, and delete data.

25 min
Import items, item journals, and sales history with Import Export PowerTool
For partners and administrators who need to bring opening balances, serial numbers, and history into Business Central from another system.

21 min
Create sample sales orders in Excel and import them with Import Export PowerTool
For consultants and partners who want a large set of realistic test or demo orders in Business Central without entering them by hand.
Will it fit your setup?
Can Import Export PowerTool insert records into ledger entry tables?
Yes. It can write to protected ledger tables such as item ledger entries and customer ledger entries, and general ledger entries are supported in the latest release. Journal entries have always been supported.
Requirements and licensing
Free, with no user limit
Import Export PowerTool is free on Business Central online (cloud), with no Insight Works license or subscription and no limit on users.
Business Central license
Each user needs a Business Central full user or Team Member license, on the Essentials or Premium tier. Access to the app itself is controlled by its permission sets rather than by license tier.
Business Central online
The free app runs on Business Central online (cloud).
Permissions
A manager permission set can change setup and a user permission set cannot. The app works within each user's existing Business Central table permissions.
Other Insight Works apps
No other Insight Works app is required.
PRICE
Free
Free on Business Central online (cloud), with no Insight Works license or subscription.
App details and prerequisites
- Business Central
- Business Central online
- Insight Works license
- Free, no user limit
- Business Central license
- Full user or Team Member license (Essentials or Premium tier)
- Languages
- English
- Availability
- All countries where Business Central is available
What customers say about Import Export PowerTool
“Extremely helpful for data migration activities. Thanks for sharing with the [Business Central] community!”
Roger FriederichMicrosoft Marketplace review “Very useful. Import Export PowerTool is faster and more flexible than configuration packages.”
Juan Ramon SánchezMicrosoft Marketplace review “Import Export PowerTool is a must-have if you are exporting or importing data into Business Central. The sheer speed of this extension makes a huge difference. Imports that used to take minutes or even hours are now done in seconds.”
Brian StoutMicrosoft Marketplace review
Case studies
Questions about Import Export PowerTool?
Ready to plan a rollout? Contact your Microsoft Partner. For product questions, send us a note and the Import Export PowerTool team will reply by email.








