Skip to content
Import Export PowerTool app icon

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+

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 ↓
Illustrative image: a forklift carries a bale of recovered cardboard across a recycling yard.

Customer story

VIPA Hellas

VIPA Hellas, a recycling and recovered materials company in Athens, Greece, replaced manual data handling with structured, validated imports and exports in Business Central using Import Export PowerTool.

Read the case study →

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 Export PowerTool videos

3 videos on setting up and using Import Export PowerTool, in the order most people need them.

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.

Ask a product question

Product Questions