Importing Person Accounts into with the Data Loader

Here is a challenge you may face - importing account data into Person Accounts in If you are using the Data Loader that you downloaded from or the Lexi Loader for the Mac, then use these techniques to upload your data into Salesforce and have the import process create Person Accounts for you.

The key to this process is telling the data loader what kind of Record Type you want for the account. In your import CSV, ensure that you have a column for "Record Type". Then you'll add the record type ID for Person Accounts in your system. This is a little tricky. Here is how you do it:

Navigate to the Person Account record type via the following path:

Setup/App Setup/Customize/Accounts/Person Accounts/Record Types

Then on the Person Account description page, look at the URL, the first ID found in the URL is the Person Account ID.  See the next image:

Just paste that ID into the Record Type column that you created in your CSV import file. Then when you upload your data into with the data loader you'll be able to create Person Accounts.

Another thing to remember. Don't import into the Account Name field (labeled Name). Instead, import into the LastName and FirstName field instead.

A couple of snags you might run into.

- First, Person Accounts must be enabled in your instance of Salesforce. This is something that you must have Tech Support do for you.

- Second, the person to whom you are assigning the new account must be able to use Person Accounts. This is a profile setting. Navigate to the user profiles via the following path:

Setup/Administrative Setup/Manage Users/Profiles/Select desired profile

In the profile management page, find this link:

Click Edit. On the resulting page, ensure Person Accounts are selected.

If you have any trouble or need some help with importing, or Salesforce in general, feel free to contact us through our website -


Rishi Arora said...
This comment has been removed by a blog administrator.
naveen reddy said...

Very useful information on importing record types and names into accounts.Thank you for the stuff.

Recently I came across a dataloader i.e AutoRABIT Dataloader( which has some additional features along with SF Dataloader.

It has features like Automated Dataloading,metadata deployments, test automation etc..


akhilapriya404 said...

This is one awesome blog article. Much thanks again salesforce Online Training

saraan seo said...

Hey, I think your website might be having browser compatibility issues. When I look at your blog site in Opera, it looks fine but when opening in Internet Explorer, it has some overlapping. I just wanted to give you a quick heads up! Other then that, terrific blog!Criminology Justice test bank solutions manual

Riti said...

That solves the issue:)

Riti said...
This comment has been removed by the author.