---
title: Mass Converting Leads in Salesforce
description: Understand how to mass convert Salesforce leads with XL-Connector 365.
---

[Skip to content](https://knowledge.xappex.com/mass-converting-leads-in-salesforce#main-content)

English

Show submenu for translations

![Xappex-logo-with-name.png\]](https://knowledge.xappex.com/hs-fs/hubfs/Xappex-logo-with-name.png?height=40&name=Xappex-logo-with-name.png)

- [Products](https://knowledge.xappex.com/mass-converting-leads-in-salesforce#products)
- [Blog](https://knowledge.xappex.com/mass-converting-leads-in-salesforce#blog)
- [About](https://knowledge.xappex.com/mass-converting-leads-in-salesforce#about)

Open main navigation

Close main navigation

- [Products](https://knowledge.xappex.com/mass-converting-leads-in-salesforce#products)
- [Blog](https://knowledge.xappex.com/mass-converting-leads-in-salesforce#blog)
- [About](https://knowledge.xappex.com/mass-converting-leads-in-salesforce#about)
- English
  
  Show submenu for translations
- Go to xappex.com

 Go to xappex.com

 Hello. How can we help you?

- There are no suggestions because the search field is empty.

1. [Xappex Knowledge Base](https://knowledge.xappex.com/?hsLang=en)
2. [I use Microsoft Excel](https://knowledge.xappex.com/i-use-microsoft-excel?hsLang=en)
3. [I use XL-Connector 365](https://knowledge.xappex.com/i-use-microsoft-excel?hsLang=en#i-use-xl-connector-365)

# Mass Converting Leads in Salesforce

## Understand how to mass convert Salesforce leads with XL-Connector 365.

To mass-convert a list of Lead records in Salesforce from an Excel spreadsheet, you’ll need to have at least two mandatory fields pulled from Salesforce:

- Lead Id
- Lead Status (needs to be set to a status marked as ‘converted’ in Salesforce)

An example SOQL query to pull leads to convert is as follows:  
*SELECT Id, LastName, FirstName, Title, Company, Status FROM Lead WHERE IsConverted = False*

To manually convert multiple leads using XL-Connector 365, make sure that the lead status is set to one marked as ‘converted’ in Salesforce, see below:

![](https://www.xappex.com/wp-content/smush-webp/2023/04/converted_status_sf-1024x181.png.webp)

Then select them in the worksheet and click on Admin Tools -\> Convert leads:  
![](https://www.xappex.com/wp-content/smush-webp/2023/04/data-1024x466.png.webp)

The following dialog box will be displayed:

![](https://www.xappex.com/wp-content/uploads/2023/04/dialog.png)

**Lead ID column** and **Convert Statuses** column settings are mandatory and has to be selected in order to convert the leads successfully. Convert Statuses column must have values marked  as ‘converted’ in Salesforce.

Specify an **Owner ID column** setting if you want to change the owner of the Contact, Account, and Opportunity records created as the result of lead conversion.

Optionally, you can map Excel columns to fields on the Contact, Opportunity, Account, and Person Account objects to transfer data to these objects. The most common use case for these mappings is to define a Record Type for these object by passing the corresponding record type Id there.

There’s also a set of parameters you can define when converting Leads, they are all False by default, but can be set to true using the following user interface:

![](https://www.xappex.com/wp-content/uploads/2023/04/parameters.png)

- [I use Google Sheets](https://knowledge.xappex.com/i-use-google-sheets?hsLang=en)
- [I use Microsoft Excel](https://knowledge.xappex.com/i-use-microsoft-excel?hsLang=en#main-content)

    - [FAQs](https://knowledge.xappex.com/i-use-microsoft-excel?hsLang=en#faqs)
    - [I use XL-Connector](https://knowledge.xappex.com/i-use-microsoft-excel?hsLang=en#i-use-xl-connector)
    - [I use XL-Connector 365](https://knowledge.xappex.com/i-use-microsoft-excel?hsLang=en#i-use-xl-connector-365)
    - [I use Excel Merge package](https://knowledge.xappex.com/i-use-microsoft-excel?hsLang=en#i-use-excel-merge-package)
- [I use Looker Studio](https://knowledge.xappex.com/i-use-looker-studio?hsLang=en)

- [Products](https://knowledge.xappex.com/mass-converting-leads-in-salesforce#products)
- [Blog](https://knowledge.xappex.com/mass-converting-leads-in-salesforce#blog)
- [About](https://knowledge.xappex.com/mass-converting-leads-in-salesforce#about)

[![Chill listening crop-3](https://knowledge.xappex.com/hubfs/Xappex-Logo.svg "Chill listening crop-3")](https://www.xappex.com)

xappex.com Help Center

Copyright © 2026, Xappex LLC