Import Data Into Business Central: Excel, Configuration Packages or a Free PowerTool

There are three practical ways to import data into Business Central: Edit in Excel, Configuration Packages, and the free Import Export PowerTool. This article compares them on volume, validation, related tables, rollback behavior and skill required, then explains what to do when an import fails partway and how to move data between companies.