Import data from CSV files or migrate from 20+ competing CRMs with auto-detection and field mapping
Import 8 different entity types from CSV, Excel, JSON, or ZIP files.
Migrate from 20+ competing CRMs with auto-detection and optimized field mapping.
Complete field mappings, value transformations, and auto-detection for:
Field mappings and detection without value transformations:
Listed for recognition with fuzzy field matching:
Two paths to import: Magic Import (auto-detect everything) or manual CRM selection.
The import page offers two ways to start:
Drag and drop your file. The system automatically detects which CRM it came from, identifies the entity type, and maps all fields. You go straight to the review screen.
Click your current CRM from the grid. This applies CRM-specific field mappings and value transformations for the most accurate import.
Upload a CSV, Excel (.xlsx/.xls), JSON, or ZIP file. Multiple files can be uploaded at once. ZIP files are automatically extracted. Maximum file size is 10MB.
The system auto-maps columns to Laureo fields using preset mappings (for known CRMs), synonym matching, and fuzzy matching. Green dots indicate high-confidence matches, yellow for medium confidence, and red for unmapped fields. Adjust any mapping using the dropdown.
Select how to handle duplicate records: Skip (keep existing), Update (overwrite with imported data), or Create New(import as separate records).
Click Import to start. Large imports process in the background — you can safely navigate away and will be notified when complete. Check progress in the Import History tab.
Supported formats and specifications.
How duplicates are identified during import.
Track past imports and undo if needed.
The Import History tab shows all past imports with their status, record counts, and source CRM. Completed imports can be rolled back within 24 hours — this deletes created records and restores updated records to their pre-import state. Rolling back requires typing “UNDO” to confirm, as any manual changes made after the import will be lost.
Pre-import data quality check.
Before importing, the system runs a health assessment on your data. This shows a readiness score (green/yellow/red) based on completeness, data quality, duplicate risk, and relationship integrity. Recommendations are provided to fix issues before importing.
Common issues and solutions.