Data Import & Mass Record Loader
High-speed mass data import tool supporting Insert, Update, Upsert, and Delete via Bulk API 2.0 or REST API with auto field mapping and failure download.
⚡ 1. Overview & Architecture
High-speed mass data import tool supporting Insert, Update, Upsert, and Delete via Bulk API 2.0 or REST API with auto field mapping and failure download.
🧭 2. Step-by-Step Workflow
Follow these steps to get maximum velocity with Data Import:
Choose SObject & Action
Select target object and action (Insert, Update, Upsert, Delete).
Upload CSV File
Drag-and-drop or browse your CSV data file.
Confirm Field Mapping
Verify or tweak column-to-field mappings.
Execute Import
Click Import Data and monitor batch completion in real time.
🛠️ 3. Key Capabilities & Superpowers
Bulk API 2.0 & REST Engine
Process up to 100,000+ records asynchronously with auto-batching or use REST API for real-time validation.
Smart CSV Column Mapping
Auto-detects standard and custom Salesforce field names from CSV headers.
External ID Upsert
Upsert records matching on any standard or custom external ID field.
Error CSV Export
Instantly download a CSV containing only failed rows with detailed error messages.
💡 4. Pro Tips & Keyboard Shortcuts
- Use Upsert with an External ID to avoid creating duplicate records during data synchronizations.
- Download the error CSV, fix the flagged rows, and upload it again to complete the import.
Explore More SF Lens Pro Guides
Discover how other integrated studio tools can accelerate your Salesforce development and administrative workflows.