Import any data file in minutes, not hours
Drop an Excel, CSV, or PDF onto Business Central and watch AI map your fields automatically. No templates. No manual setup. No errors.
The problem with data imports today
- Every import needs a pre-formatted template that must match Business Central exactly
- A single wrong column header breaks the entire file
- Non-technical staff cannot import data without IT support
- Different data types require different import tools
- Errors are hard to trace and slow to fix
What Magic Import does instead
- Accepts any file format without conversion or reformatting
- AI detects your column structure and maps fields automatically
- Any team member can run an import without specialist knowledge
- One tool handles all master tables including Items, Customers, and Vendors
- Errors are logged per record with clear reasons and a one-click retry
How It Works
Three steps from file to Business Central
Upload your file
Open Magic Import inside Business Central and drop your file. Excel, CSV, PDF, JSON, and XML all work without any preparation.
AI analyses and maps
The AI reads your file in seconds, identifies the structure, and maps each column to the correct Business Central field. You see a confidence score for every mapping.
Review, confirm, and import
Preview your mapped data. Override any mapping. Then confirm and watch the import run with a live progress bar showing exactly what is happening.
Features
Everything your team needs
Any File Format
Upload Excel, CSV, PDF, JSON, or XML files without converting or reformatting anything first.
Automatic Field Mapping
AI reads your file and maps every column to the correct Business Central field with a confidence score. No manual matching needed.
Review Before You Commit
See a full preview of your mapped data before anything is imported. Adjust mappings and validate records in advance.
Background Processing
Large imports run in the background with a live progress bar. Your team can keep working while data loads.
Reusable Templates
Save a field mapping as a template. Next time you import the same file type, your saved mappings apply instantly.
Clear Error Reporting
Each failed record is logged with a plain-English reason. Review, fix your source data, and retry without re-importing everything.
Who It Helps
Built for your whole team
Finance Director
Stop waiting days for data migration jobs to finish. Get clean, validated data into Business Central the same morning.
Operations Manager
Import supplier price lists, stock updates, and customer files without raising an IT request or learning import templates.
IT Manager
Give your team the ability to handle their own data imports safely. Reduce support tickets and speed up business processes.
Questions about Magic Import
See Magic Import working with your data
Book a free demo and we will show you exactly how Magic Import handles your file types and your Business Central setup.
Book a Free Demo