Loading

Fix Salesforce Data Import Error MALFORMED_ID

Udgivelsesdato: Oct 9, 2026
Beskrivelse

If there are errors during your data import, Salesforce tells you about them in the attachment included with the summary email. A common error you may encounter in the summary email is MALFORMED_ID.

This means the ID you are attempting to use in your CSV file is not formatted correctly and/or has unsupported characters.

Løsning

This article explains how to fix the MALFORMED_ID error that appears after a Salesforce data import. To fix this error, replace the incorrect ID in your CSV file with a valid record ID. You can get a valid ID from a report or from the record itself.

Fix MALFORMED_ID by Getting the ID From a Salesforce Report

  1. Click the Reports tab in the navigation bar.
  2. Click New Report.
  3. In the Search Report Types search bar, type the name of the object you are importing into.
  4. Click the search result for the object you are importing into.
  5. Click Continue.
  6. Click the Filters column and make sure All records are shown for All Time.
  7. Click the Outline column.
  8. Remove all fields from the Columns section except the record or object Name.
  9. Add the record or object ID under the Columns section.
  10. Open the error CSV file you received as an attachment in the summary email after the initial import.
  11. In the error CSV file, change the ID in the cell identified in the error message to an existing ID shown in your Salesforce report.
  12. Save the error CSV file.
  13. Perform the import again using the error CSV file.

Fix MALFORMED_ID by Getting the ID From a Salesforce Record

  1. Type the record name in the Global Search bar at the top of the screen.
  2. Click the search result for the record.
  3. In the URL bar, find the ID for the record. The URL looks similar to the following example, where the ID is 5003000000D8cuIQAA:
    • https://<YourInstanceOrMyDomainHere>.lightning.force.com/lightning/r/Case/5003000000D8cuIQAA/view?0.source=alohaHeader
  4. Open the error CSV file you received as an attachment in the summary email after the initial import.
  5. In the error CSV file, change the ID in the cell identified in the error message to the existing ID shown in your Salesforce record URL.
  6. Save the error CSV file.
  7. Perform the import again using the error CSV file.
Vidensartikelnummer

000389149

 
Indlæser
Salesforce Help | Article