I have exported data from production in .csv file, now I'm trying to import data to sandbox and I'm running into issue where RecordType.Id is not same as in the sandbox.

How should you go after correcting this? is there any tool to use? some says use vlookup to map and some says copy the production recordtype.id and update the same to sandbox recordtype.id.

Any suggestions?

select Id from RecordType where Name = 'Canada' and SobjectType = 'employee__c' limit 1

1 Answer 1


You cannot update RecordType.Id in any Sandbox to match that to Production. It’s the Id field and is not updatable as any other System (Id) fields.

You will need to replace the RecordType.Id to match that with Sandbox. As for tools, you can use VLOOKUP in Excel to do so. If you are using an ETL tool, the tool can transform the values for you.

If you can use SFDX CLI along with Bulk API, you can actually utilize the Record Type Name only to load data without the need of specifying any Id. Refer to this answer from sfdcfox for implementation details.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .