Common Salesforce Data Import Blocks We Resolve
Salesforce CRM enforces strict system validation rules during data ingestion. Here is how CleanMyCSV repairs your batch files:
1. Strict ISO 8601 Date & Datetime Formatting
Salesforce rejects date fields that do not conform strictly to ISO standard (YYYY-MM-DD). Text dates like "12/05/2024" or Excel serial numbers trigger immediate batch rejections. CleanMyCSV standardizes all date columns with locale-aware day/month parsing.
2. 15 and 18-Character Salesforce Record ID Safeguard
Salesforce relies on unique 15-character (case-sensitive) or 18-character (case-insensitive) Record IDs (e.g. 00100000003ABCQAAS). Excel often truncates or alters letter case in these IDs. Our Anti-ID safeguard isolates technical keys to prevent corruption.
3. Phone Normalization & Lead Personalization
Formatting phone numbers into international E.164 standards ensures seamless integration with CTI phone systems (Salesforce CTI / RingCentral). CleanMyCSV cleans proper names, fixes capitalization, and restores missing ZIP code zeros.
4. Semicolon Delimiter & UTF-8 Encoding Fix
Data Loader requires comma-delimited (,) CSV files with UTF-8 BOM encoding. European Excel exports with semicolons (;) dump all attributes into a single column. CleanMyCSV handles delimiter conversion and encoding in one click.