Step-by-Step Guide to Import Leads into Salesforce

Jason Gong
June 22, 2024

Go to the Leads tab, then Tools, and click Import Leads.

By the way, we're Bardeen, we build a free AI Agent for doing repetitive tasks.

If you import leads often, check out Bardeen's AI for sales. It automates lead import tasks, saving you hours.

How to Import Leads into Salesforce

Importing leads into Salesforce is a critical task for managing your sales pipeline and ensuring your sales team has all the necessary information to engage with potential customers effectively. This guide covers various methods to import leads, including using CSV files, Salesforce Lightning, and integrating leads from LinkedIn and Excel.

Automate your Salesforce lead management with Bardeen. Download now and streamline your process.

Import Leads into Salesforce

To import leads into Salesforce, navigate to the Leads tab, scroll to the Tools panel, and click the Import Leads link. Then, launch the wizard, select 'Leads' and 'Add new records', specify any additional information like lead source or assignment rule, and upload your data file. After mapping fields and confirming the data, start the import. Once complete, the new leads will appear on the Leads tab.

Salesforce Import Leads CSV

For importing leads from a CSV file, prepare your file by ensuring data accuracy, removing duplicates, and matching column headers to Salesforce field names. Save the file as a CSV and use the Data Import Wizard in Salesforce to upload the file, map fields, and import the leads.

Import Leads into Salesforce Lightning

In Salesforce Lightning, use the Data Import Wizard accessible from the Setup menu. Choose 'Leads' as the data type, specify the import details, upload your CSV file, map the fields accordingly, and proceed with the import.

Import Leads from LinkedIn to Salesforce

For LinkedIn leads, use the LinkedIn Sales Navigator Lead Creation feature. Admins must enable this in Sales Navigator settings, and users need to authenticate with Salesforce. Leads can then be created in Salesforce directly from Sales Navigator Lead Pages or Lists.

Discover how to automate sales for SDRs and Sales Ops teams with Bardeen's Salesforce integration workflow automation guide.

How to Import Leads into Salesforce from Excel

To import leads from an Excel spreadsheet, first save the Excel file as a CSV. Ensure the data is clean and the column headers match Salesforce field names. Then, use the Data Import Wizard in Salesforce to upload the CSV file, map the fields, and import the leads.

Mass Import Leads Salesforce

For mass importing leads, the Data Import Wizard is the most efficient tool. It allows for the import of large numbers of records at once. Prepare your CSV file with all the leads, ensuring data integrity and correct formatting, then follow the standard import process.

Data Import Wizard

Salesforce Data Import Wizard

The Salesforce Data Import Wizard provides a user-friendly interface for importing leads, among other records. Access it via the Setup menu, select the type of data to import, upload your file, and follow the prompts to map fields and execute the import.

Import Leads Permission Salesforce

Ensure you have the necessary permissions to import leads. Typically, you need the 'Import Leads' permission, which can be granted by your Salesforce administrator.

Import Sales Navigator Leads into Salesforce

To import leads from LinkedIn Sales Navigator, enable the Lead Creation feature in Sales Navigator Admin settings. Users must authenticate with Salesforce, and leads can then be added directly from Sales Navigator to Salesforce.

Automate Salesforce Leads with Bardeen Enhancements

While importing leads into Salesforce manually is a foundational skill in managing your sales pipeline, leveraging automation can significantly enhance your efficiency and ensure you capture a wider array of potential leads. By using Bardeen, you can automate various tasks related to Salesforce lead management, from creation to enrichment, directly from LinkedIn profiles, email interactions, and more.

Embrace the power of automation with Bardeen and ensure no lead slips through the cracks:

  1. Create a Salesforce lead from a LinkedIn profile: This playbook transforms LinkedIn profiles into Salesforce leads in just a few clicks, ideal for quickly capturing valuable leads from your LinkedIn network.
  2. Enrich and update a Salesforce lead's record with new information: Automatically update Salesforce leads with fresh data from LinkedIn, ensuring your leads' information is always current and actionable.
  3. Create a Salesforce lead from a LinkedIn post: Leverage LinkedIn posts to discover and create new Salesforce leads, perfect for tapping into the rich, professional insights shared on LinkedIn.

By automating these essential tasks, you can significantly reduce manual data entry, improve lead quality, and accelerate your sales cycle. Get started by downloading the Bardeen app at

Automate Salesforce Lead Import

Bardeen's AI Agent automates lead import and saves you hours.

Get Bardeen free

Related frequently asked questions

Convert Numbers to Text in Google Sheets: A Guide

Learn to convert numbers to text in Google Sheets using TO_TEXT and TEXT functions, and text to numbers with VALUE, including bulk conversions.

Read more
Sales Automation in CRM: The Ultimate Guide for 2024

Master sales automation in CRM with our comprehensive guide. Learn key features, benefits, and strategies to transform your sales process in 2024.

Read more
Sales Demo: 15 Tips to Boost Closing Rates

Learn what a sales demo is and discover 15 top tips to increase your closing rates effectively in 2024.

Read more
Setup Salesforce Authenticator on New Phone: A Step-by-Step Guide

Learn how to add Salesforce Authenticator to a new phone with a step-by-step guide, ensuring secure Salesforce access via two-factor authentication.

Read more
Step-by-Step Guide to Remove Clearbit (2024)

Learn how to remove or uninstall Clearbit from Gmail, Outlook, Safari, and more with our step-by-step guide. Includes disabling browser extensions and CRM integrations.

Read more
Master Pipedrive in 2024: A Comprehensive Step-by-Step Guide

Learn how to set up and optimize Pipedrive for your sales needs with our detailed, step-by-step guide. Master contact management and automation.

Read more
how does bardeen work?

Your proactive teammate — doing the busywork to save you time

Integrate your apps and websites

Use data and events in one app to automate another. Bardeen supports an increasing library of powerful integrations.

Perform tasks & actions

Bardeen completes tasks in apps and websites you use for work, so you don't have to - filling forms, sending messages, or even crafting detailed reports.

Combine it all to create workflows

Workflows are a series of actions triggered by you or a change in a connected app. They automate repetitive tasks you normally perform manually - saving you time.

get bardeen

Don't just connect your apps, automate them.

200,000+ users and counting use Bardeen to eliminate repetitive tasks

Effortless setup
AI powered workflows
Free to use
Reading time
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
By clicking “Accept”, you agree to the storing of cookies. View our Privacy Policy for more information.