Fix Salesforce MALFORMED_ID errors before import
Salesforce record IDs have a strict shape. A wrong length, unsupported character or ID mapped to the wrong field can stop an Update or produce MALFORMED_ID errors.
What Salesforce IDs look like
Salesforce documents record IDs as 15-character case-sensitive or 18-character case-insensitive identifiers. Values mapped to ID fields need to be valid Salesforce IDs for that operation.
What ReadyRows checks
ReadyRows recognizes ID-like headers and validates non-empty ID values as 15- or 18-character alphanumeric Salesforce IDs. For Update, a missing or malformed primary Id is treated as blocking.
What ReadyRows cannot verify
A correctly shaped ID can still point to the wrong object, a nonexistent record or a record the importing user cannot access. Those checks require Salesforce account context.
Official reference
Salesforce documents the relevant import rule in its MALFORMED_ID troubleshooting article.
Check the file before you re-import it
ReadyRows scans the file locally in your browser, highlights platform-specific import risks and separates rows that need attention from rows that are ready to export.
Open the free Salesforce fixerReadyRows is an independent tool and is not affiliated with Salesforce. Import rules can change; confirm account-specific behavior in the platform's official documentation.