How do I import leads and info from excel spreadsheet - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Dawn SiegmundDawn Siegmund 

How do I import leads and info from excel spreadsheet

Matthew LambMatthew Lamb
Here's some great info on getting started with uploading data:

Steve MolisSteve Molis
 Here are the requirements and steps for using the Lead Import Wizard ->  

Using the Lead Import Wizard

  1. Prepare your list of names according to the specifications described in Field Mapping for Importing Leads.
  2. Click the Manage Members drop-down button and select Add Members - Import File on the detail page of the campaign you want to update.
  3. Click Import Leads.
  4. Click Browse and choose your import file.
  5. Select a lead source.
  6. Select an assignment rule to assign the leads.
  7. Optionally choose to use assignment rule settings to notify the new record owners.
  8. Select the default member status for leads with blank or invalid statuses.
  9. Select the character encoding of your import file. Most users do not need to change the default setting.
  10. Optionally choose to trigger workflow rules for new and updated records.
  11. Optionally choose to trigger workflow rules for new campaign members. This is only available if you activated the New Campaign Member Creation Behavior.
  12. Click Next.
  13. Map the Salesforce fields to the fields in your import file, then click Next.
  14. Map the Salesforce campaign member status field and any campaign member custom fields to your import file, then click Next. This is only available if you have campaign member custom fields and you activated the New Campaign Member Creation Behavior.
  15. Click Import Now!
Jamie CooperJamie Cooper

SimpleImport is an application on the Salesforce AppExchange that allows Excel files to be easily imported - all from within Salesforce, so no software needs to be downloaded.

SimpleImport will also automatically understand which columns are associated with each part of the object. For example a 'Country' column within the spreadsheet will automatically be associated with the Country field within Salesforce, saving you time. With its clean and simple user interface SimpleImport is the best option for importing files.

Visit the AppExchange listing for SimpleImport here

Hope this helps,

Josh TurpinJosh Turpin
It is important to know you have to go to Setup>Administration Setup>Data Management>Import Leads to get to the import wizzard.  The stock answer provided is not very useful if you don't know where to start!  I am a noob but this simple function should be obvious to anyone in the help section and it is not.  Or you can click on your leads tab and scroll the the very bottom where it says Import Leads.  The only issue I have is that it seems to upload everything to Contacts instead of Leads
Steve MolisSteve Molis
The original question and answers were posted well over a year ago and reflected the information available at the time.  

Since then the Import Help has been updated =>
Importing Data 
Importing Data Quick Start 
[Quick Starts]

Keep in mind that this is a customer forum made of SFDC users, admin, developers, etc.  We don't work for Salesforce, and it's not our job to go through the thousands of previous posts and update them. 
Steve MolisSteve Molis
Also if you click on the links that Matt originially posted they do bring you to step-by-step instructions for accessing the Lead Import Wizard =>
Josh TurpinJosh Turpin
Thanks and I do understand.  One thing may help me.  How do you upload to leads and not accounts.  When I used the Import Leads Wizzard it still put them into contacts.  I am not ready for these leads to be put into contacts yet.  Any advice is appreciated.
Steve MolisSteve Molis
Hi Josh,

Which edition of SFDC are you using?  Can you posyt a screenshot of the Import Wizard that you're selecting and where you are seeing these imported Leads as "Contacts"?
Josh TurpinJosh Turpin
I am using professional edition. Screenshot below.  I just used this and it imported them to contacts not to leads.Screenshot
Alexander TarasevichAlexander Tarasevich
Now you can import/export any object to/from your Excel spreadsheet using CRM Enabler (
Johan YuJohan Yu
@Alexander, have been using your product for couple of weeks, it is great and safe time.
Godemir GrgićGodemir Grgić
If you want to import a CSV file with leads to Salesforce on a daily basis, the best option is to use 3rd parties like or Skyvia Salesforce DataLoader.