Ignite Magic Import

Ignite Magic Import is an AI-powered data import solution that transforms hours of manual data entry into minutes of guided, intelligent import within Microsoft Dynamics 365 Business Central. Designed for teams migrating legacy data, IT consultants onboarding new customers, and businesses that regularly import from spreadsheets, PDFs, or external systems, it eliminates rigid templates and manual field mapping by using AI to understand file structure and map it to the right fields automatically.

Key Capabilities

• Universal import action — adds a consistent "Magic Import" button across master data pages like Items, Customers, Vendors, and Journals for a unified import experience.
• AI-powered field mapping — analyzes your file and automatically maps columns to Business Central fields, with confidence scoring for every match.
• Multi-format support — imports PDF, Excel (.xlsx/.xls), CSV, JSON, XML, and plain text files without requiring pre-defined templates.
• Manual override and reusable templates — lets you review and adjust AI-suggested mappings, then save configurations for recurring imports.
• Data transformation and validation — built-in rules catch and fix formatting issues, with a full preview before you commit.
• Background processing with detailed error logging — runs large imports asynchronously with live progress tracking and clear, actionable error messages.

Integration & Compatibility

Magic Import works directly within Microsoft Dynamics 365 Business Central (SMB ERP) and is compatible with version 26.0 and above. It integrates as a Copilot Agent, adding the Magic Import action to supported pages across master data areas such as Items, Customers, Vendors, and Journals. The solution is deployed as a SaaS add-in within Business Central and requires an API key for AI to enable AI-powered analysis; no additional infrastructure is needed.

Who It's For

Ideal for small to midsize businesses using Business Central that regularly import data from spreadsheets, PDFs, or external systems. It particularly benefits teams migrating legacy data, IT consultants onboarding new Business Central customers, and roles responsible for data management, such as finance and operations staff, who need to reduce manual data entry and improve accuracy.