How to Perform BULK Lead Conversion in Salesforce using XLS or CSV?

BULK Lead Conversion using XLS or CSV in few clicks

When a Prospect (or Lead) is converted in Sales Process, it is converted to Account, Contact and Opportunity. This process is performed manually on each Lead record by clicking “Convert” button at lead level, which is a time-consuming and a monotonous job for Salesforce developers and admins.

In order to convert 100 or 200 or 500 leads, such requests require a couple of days of effort.

Bulk Object Field Creator (BOFC) is a native app designed to help you overcome the above situation. BOFC can easily convert mass number of Leads in few simple clicks.

BOFC application can convert 500+ Lead records in just 10-15 minutes. This would help users save time, reduce manual effort and increase productivity. BOFC application has a simple user interface which is extremely self-explanatory and easy to use.

Major Features for Bulk Lead Conversion includes:

  1. User can import Leads using XLS or CSV
  2. User can choose option to either “Create new account” or “Assign lead to existing account”
  3. User can choose option to either Create or Skip opportunity creation.
  4. User can choose option to choose Lead Owner for single or multiple leads
  5. Error And Validation Support- Application effectively guides user in lead conversion and provide error description.
  6. Columns are enabled or disabled depending upon option selected

To avail this feature, kindly make sure you have installed the latest version of the application. You can upgrade your package using either of two ways:

  1. In Salesforce, go to “BOFC Home > Settings > App Version > Click to Upgrade” — or —
  2. Refer the below button to quickly upgrade your package to the latest version and explore its complete benefits:

Steps to Convert Mass number of leads using XLS in few clicks:

1. Goto BOFC Application and open “Bulk Lead Conversion” page

Bulk Lead Conversion page

2. It will open this page for Lead conversion

Bulk Lead Conversion

Import Lead IDs using XLS file: In this option, user can upload lead using a pre-formated xls or csv template. User can download template and then can upload its lead file once ready.

Import Lead IDs using XLS file

3. Click on “Download Sample Template” button to download a sample template which is acceptable by Lead Conversion page. Once your file is ready, upload the file.

4. Once the Lead File is uploaded, it will display the Leads in below table.

 Lead File is uploaded

Above image has few features (each number has its description as below):

  1. User needs to select lead rows once all the mandatory fields are filled
  2. This column display the status for lead conversion
  3. Lead columns (Lead name and Company)
  4. User can avoid creating new account and can attach lead to existing account.
  5. User can create request for new account at lead conversion
  6. Creating Opportunity is Optional. If selected, it will create opportunity at the time of lead conversion.
  7. If “New Opportunity” is checked, then Opportunity name field is enabled, otherwise it will be disabled.
  8. Pagination: Each page shows 80 lead records. User can navigate to next or previous or first or last pages using this navigation
  9. When lead is converted, lead fields are mapped to Account, Contact and Opportunity fields. In order to review or modify field mappings, click this button and it will display the Standard Lead mapping page.
  10. Once user has selected the lead rows, it can click “Convert Bulk Leads using Standard Conversion” button to convert all the selected lead rows

5. Select lead rows & verify all the details in required columns or remove error(if any).

Select lead rows & verify all the details

6. Click “Convert Bulk Leads using Standard Conversion” button to convert selected lead row records. Once clicked, it will show a status popup:

Convert Bulk Leads using Standard Conversion

In this popup, it shows stats for “how many records are to be processed, how many are converted, failed. Once the status is completed, click on Close button.

7. Once the close button is clicked, it will show “Success or Error” status message in-front of each row.

Success or Error” status messageSuccess or Error" status message

Green means – Lead row converted successfully
Red means – Lead row error out with some error message

Check out other methods to use BOFC other Lead Conversion Methods:

  1. BULK Lead Conversion directly on ALL Non-Converted Leads in Salesforce
  2. BULK Lead Conversion using Salesforce Standard Reports in few clicks?

Have a look at step by step detailed video to “Perform Mass Lead Conversion using XLS


Have you started using BOFC yet? Thousands of BOFC users have been able to save time & boost productivity using our Salesforce Metadata app. Click here to install the latest version of BOFC application in your Salesforce instance & explore its complete benefits for you.

For any queries or suggestions, you can write your comment in the comment box or for further assistance contact us at or mail us: Our BOFC Expert will help you get the best out of it.

Experience it for yourself

Bulk Object Field Creator (BOFC) is a must-have tool, designed specifically for Administrators, that simplifies many of the tedious tasks of managing a complex Salesforce environment.

This tool is available on Appexchange and Click on below button to install the
latest version of BOFC

or learn more
Notify of
Inline Feedbacks
View all comments