Skip to main content
Partner Stories

Free RapidStart Alternative for Microsoft Dynamics 365 Business Central: Import Export PowerTool vs Configuration Packages

Listen to the podcast

Import Export PowerTool is a free RapidStart alternative for Microsoft Dynamics 365 Business Central that imports, exports, updates, and deletes data across effectively any table. This is a completely free app from Insight Works for Business Central. It moves data faster than RapidStart configuration packages and keeps many tables in one plain text file.

Import Export PowerTool is a Business Central extension published on Microsoft Marketplace, and the add-on consultants, integrators, and developers use when a data load is too big or too awkward for configuration packages.

Why Do RapidStart Configuration Packages Slow Down Business Central Data Migration?

Configuration packages slow down large migrations because they were built to reuse setup data, not to move high volumes of records. Microsoft describes them as a way to reuse setup data from one company when configuring another. That works well for setup tables, but it strains under thousands of items, contacts, or ledger records.

The structure adds friction too. A configuration package produces a separate Excel sheet for every table, and each field has to be defined in the package before it can be imported. A consultant loading data from a legacy system often has custom fields that do not exist in Business Central, and the package has no simple way to skip them.

Partners notice. One reseller described configuration packages as something that “sometimes can be problematic” when loading or cleaning data during a deployment. When a migration sits on the critical path of a go-live, a slow or fragile load becomes a scheduling problem.

What Does Import Export PowerTool Do in Business Central?

Import Export PowerTool gives consultants four operations on one setup page: Export, Import, Update, and Delete. Each operation works against standard Business Central tables, using the table ID and Business Central filter syntax to pick exactly which records are affected.

Export writes any number of tables to a single text file. A consultant can also point Import Export PowerTool at an existing RapidStart configuration package and export the tables and fields it defines, so earlier package work is reused rather than rebuilt.

Import reads that file back in, with separate switches for whether new records can be inserted and existing records updated. The same file can load new data or refresh what is already there. Fields and tables that do not exist in the target environment can be skipped, which makes legacy imports with custom fields practical.

Update and Delete apply a change across a filtered set of records. A preview shows exactly which records a filter will touch before anything is committed, and an optional confirmation step asks the user to type a confirmation before a destructive operation runs.

How Does Import Export PowerTool Compare to RapidStart Configuration Packages?

Import Export PowerTool is faster than configuration packages for bulk loads and handles several jobs that configuration packages do not. The table compares the two on the points where they differ.

CapabilityImport Export PowerToolRapidStart configuration packages
CostFreeIncluded with Business Central
File formatOne plain text file for many tablesA separate Excel sheet per table
Adding fieldsAdd or remove fields freely in the fileFields must be defined in the package first
Speed on bulk loadsFaster on large imports and exportsSlower on large imports and exports
Record links and notesImports record links and record notesNot supported
Lot and serial numbersCreates lot and serial entries on item journal importsNot supported
Reusing existing packagesUses a configuration package as an export templateBuilt in

One reviewer on the Import Export PowerTool product page, Michael Inga, reported importing more than 20,000 inventory items in under a minute. The same load had taken over an hour with configuration packages.

Which Business Central Data Migration Tasks Does It Handle Best?

Import Export PowerTool fits the migration jobs that are repetitive, high volume, or hard to reach through the Business Central user interface. Four jobs stand out.

Opening inventory loads come first. Item journal imports automatically create lot and serial number entries, which is the intended path for loading starting stock with tracking already in place.

Moving data between environments is next. Consultants export from a sandbox and import into production, or copy data between companies, using the same text file both ways. Dimensions, including shortcut, non-shortcut, and default dimensions, can be imported and exported as well.

Carrying over notes and links matters on legacy migrations. Import Export PowerTool exports and imports record links and record notes across a filtered range of tables, so the history attached to customers, vendors, and items comes along.

Large multi-table files no longer need a full restart after an error. Imports can be committed per table, so a failure in a later table does not undo the tables that already loaded.

Can Import Export PowerTool Fix Bad Data Without a Developer?

Yes, within the user’s existing permissions. Import Export PowerTool can reach protected tables, such as item ledger entries and customer ledger entries, including fields Business Central marks as read-only. That lets a consultant correct a bad reservation entry or a similar broken record directly.

Without the tool, the same fix usually means asking a developer to write an extension, or exporting the data, changing it, and importing it again. With Import Export PowerTool, the consultant filters to the affected records, previews them, and applies the update.

The same capability helps with upgrades. A knowledge base article documents a case where leftover data in a Business Central system table blocks an environment upgrade, and the Import Export PowerTool Delete operation is one of the documented fixes.

Is Import Export PowerTool Safe to Use on Production Data?

It is safe in the right hands, and it is built for people who understand Business Central data. Import Export PowerTool respects each user’s existing Business Central table permissions, so it cannot delete anything that user could not already delete.

Two permission sets control access. A manager set can edit the setup page, where access to protected tables and the option to disable the change log are granted. A user set cannot change those settings.

Care still matters. Deleting ledger entries that other records depend on, such as entries with related value or general ledger entries, will leave data in a bad state. Business Central validation also still applies to imported records, so a file that breaks business logic fails rather than forcing its way in.

“It’s basically a data migration tool. It’s not an integration tool, and it’s not going to replace the cloud migration tool from Microsoft.”

Mark Hamblin, Senior Solution Advisor at Insight Works

Frequently Asked Questions

Is Import Export PowerTool free?

Yes. Import Export PowerTool is free with no user limit, and it works with Essential, Premium, and Team Member licenses. Access is controlled by permission sets rather than license tier.

Is Import Export PowerTool an app, an extension, or an add-on?

All three terms are correct. Import Export PowerTool is a Business Central app, published as an extension on Microsoft Marketplace, and partners often call it an add-on.

Does Import Export PowerTool replace Microsoft’s cloud migration tool?

No. Import Export PowerTool is a data migration and manipulation tool, not an integration tool, and it does not replace Microsoft’s cloud migration tooling. It can work alongside it.

Can Import Export PowerTool run imports on a schedule?

Not on its own. Import Export PowerTool publishes events and callable functions, so a partner can build a small extension that runs scheduled imports.

Does Import Export PowerTool need Excel?

No. The file format is plain text, so a text editor is enough. Files saved from Excel also work.

Which Business Central deployments does it support?

Import Export PowerTool is available for Business Central online, in every country where Business Central is offered.

Start Your Next Business Central Data Migration with Import Export PowerTool

Import Export PowerTool gives consultants a faster, more flexible way to load, update, and clean Business Central data than configuration packages alone. Install it from the Import Export PowerTool app page, and find setup steps, import and export walkthroughs, and the published events reference in the Import Export PowerTool knowledge base.

For a walkthrough of moving data between sandboxes, production, and companies, read The Secret to Effortless Data Migration in Business Central.