MDC Import - Automate Excel imports into Business Central
Get rid of manual entry
From Excel to Business Central – completely automatically
MDC Import is an automation app for Microsoft Dynamics 365 Business Central that eliminates manual data entry from Excel files. It automatically collects files from external systems, validates them, maps data to the correct Business Central tables, and imports records based on predefined rules.
While many organizations still rely on employees to manually transfer spreadsheet data into Business Central, MDC Import automates the entire process from file delivery to data processing, validation, logging, and archiving.
Whether you receive payroll files, travel expense reports, HR updates, journal entries, or other operational data, MDC Import ensures the information is imported consistently, securely, and with full traceability.
The Challenge of Excel-Based Data Imports
Many organizations spend significant time handling recurring imports from external systems, including:
- Payroll files
- Travel and expense systems
- HR and employee data updates
- General journal imports
- Vendor and customer data maintenance
- Operational data from third-party systems
- Recurring spreadsheet-based integrations
Manual import processes are often time-consuming, error-prone, and difficult to audit. Even when import routines exist, many organizations struggle with inconsistent file formats, missing approvals, limited traceability, and a lack of automation.
MDC Import provides a secure and repeatable framework for automated Excel-based integrations. Files are automatically collected, validated, processed, and logged without requiring manual intervention.
From simple imports to complex multi-system integrations, MDC Import helps organizations improve efficiency while maintaining full control of their data.
Ready to Eliminate Manual Excel Imports?
MDC Import automates the movement of data from Excel files into Microsoft Dynamics 365 Business Central.
Try the app free for 30 days.
MDC Import
Automate Excel Imports to Business Central
Import data from external systems directly into Microsoft Dynamics 365 Business Central. Automate the entire process with validation, mapping, approval flow and full traceability.
Automate Excel imports into Business Central
Read more about MDC Import. Download our free whitepaper.
Key Features
Automated Excel Data Imports
Import data from Excel files without manual processing:
- Scheduled imports
- Automatic file collection
- Recurring integrations
- Hands-off processing
- Multiple source systems supported
Data Stream Configuration
Create dedicated import streams for each external system:
- Worksheet configuration
- Starting row configuration
- SFTP folder setup
- Target table selection
- Independent stream management
Once configured, each stream handles incoming files automatically.
Flexible Column Mapping
Map Excel columns directly to Business Central fields:
- Create records
- Update records
- Delete records
- Constant values
- Table-specific mapping
Configure imports to match your business processes without modifying source files.
Value Translation
Translate incoming values automatically during import:
- Source-to-BC value conversion
- Code translations
- Text translations
- Lookup mappings
- Reusable translation rules
Maintain source system formats while ensuring compatibility with Business Central.
Workbook Validation and Safeguards
Protect Business Central from invalid or manipulated files:
- Password protection detection
- Formula detection
- Sheet protection validation
- Workbook structure validation
- Automatic rejection of invalid files
Files that fail validation are moved to an error location without affecting production data.
Approval Sheet Validation
Ensure every import has been reviewed and approved:
- Mandatory approval sheet
- Approver information
- Approval timestamp
- Last-row verification
- Import authorization controls
Imports are stopped automatically if approval information is missing or incomplete.
SFTP and Azure Storage Automation
Automate the complete file transfer process:
- SFTP integration
- Azure Function App automation
- Azure Blob Storage support
- Archive file management
- Error file handling
Files move automatically through the import process without manual handling.
Job Queue Integration
Run imports automatically in the background:
- Scheduled execution
- Automated polling
- Continuous processing
- Error isolation
- Unattended operation
Failed imports never stop subsequent files from being processed.
Full Audit Trail
Track every step of every import:
- Import logs
- Processing history
- Error tracking
- Transaction details
- Cell-level traceability
Drill down from file level to individual records, rows, and field values.
Record Protection
Prevent manual changes to imported data:
- Edit restrictions
- Delete restrictions
- Source-specific rules
- Table-specific controls
- Data integrity protection
Protect business-critical data from unauthorized modifications.
Test Mode
Validate integrations before going live:
- Safe testing environment
- Production-like processing
- Import validation
- Mapping verification
- Easy cleanup of test data
Test imports thoroughly before enabling automated production runs.
FAQ
MDC Import is an app for Microsoft Dynamics 365 Business Central that automates the import of Excel files from external systems into Business Central.
MDC Import is designed for Excel-based integrations and supports automated processing of approved Excel workbooks.
Yes. MDC Import uses Business Central Job Queues, Azure Functions, Azure Blob Storage, and SFTP automation to process files without manual intervention.
Yes. MDC Import includes flexible column-to-field mapping that allows you to configure how incoming data is written to Business Central.
The file is automatically rejected, moved to an error location, and logged with detailed error information. Other files continue processing normally.
Yes. MDC Import validates a dedicated approval sheet and stores complete audit information for each processed file.
MDC Import is designed for organizations that regularly receive Excel-based data from payroll systems, HR platforms, expense management solutions, financial systems, and other external applications that need to integrate with Microsoft Dynamics 365 Business Central.
Yes, you can try the app for free for 30 days and see how it improves your everyday life. Download the app here
We offer a range of support resources, including user guides, tutorials, and a dedicated support team, to help you get started and maximize your experience with the app.
For assistance, please reach out to our support team at support@mdcnordic.com call us at +45 53 56 53 53.
Yes! If you are interested in a demo of the app, contact us directly here: support@mdcnordic.com or call us at +45 53 56 53 53.
Prices
- Includes all app features
- Support is not included and will be billed separately.
Price
- Includes all app features
- Includes 2 hours of support per month*
All prices are per account and exclude VAT.
Get more out of Business Central
Want to see a demo of Data Studio?
Reach out to us today!
