Import Opportunities

1. Feature Overview

You can import opportunities to LeadSquared through a CSV file. Here are some things you need to consider before beginning the import process –

  • You can only import records pertaining to one opportunity type (e.g., home loan opportunities, vehicle insurance opportunities, etc.).
    For an insurance company, you can import multiple vehicle insurances in one CSV file, but you cannot import vehicle insurance and health insurance in the same file.
  • You will have to manually map the fields in your CSV to the fields in the opportunity type, after you upload the file.

To know more about opportunities, please refer to Opportunity Management – Feature Guide.

Note: You can import a maximum number of 25,000 opportunities in a go.


2. Prerequisites

  • The opportunities feature must be enabled in your account. To enable it, please write to
  • Any one Opportunity Type field is mandatory.
  • The lead identifier field (such as email, phone number, prospect Id, etc.) is mandatory, based on the unique field that’s configured in the system.


3. Import Opportunities

3.1 Download the Sample CSV File

  1. From the main menu, navigate to Leads>Manage Opportunities>Opportunity Type.
  2. On the Manage Opportunity page, click the Import Opportunity button.
  3. On Import Opportunity pop-up, download the sample CSV file by clicking Sample CSV.
  4. The sample file will now be downloaded (to the downloads folder or any location you’ve configured for your browser’s downloads). View the file to understand how to structure the CSV you want to upload.

Import Opportunities_1


3.2 Upload the CSV File

  1. On the Import Opportunity wizard, either click the select a file from your computer link or directly drag and drop the CSV file into the area demarcated by the dotted line.
  2. Once the file has been uploaded, click Next.

Import Opportunities_3


3.3 Map the CSV File Columns to the Opportunity Type Fields

  1. Map the fields in the CSV file to the opportunity type fields. Choose the appropriate field in the CSV that matches the identifiers in the opportunity type fields (For example, Expected Deal Size, Status, Source Campaign, etc.).
  2. Click Next when you’re done.

Import Opportunities_4


3.4 Set Import Rules

Set import rules on how you want to handle duplicates –

  • Ignore duplicates – If you select this option, duplicate opportunity records will not be imported. This is the default option that is pre-selected.
  • Overwrite duplicates – If you select this option, the CSV file data will overwrite existing duplicate opportunity records in your LeadSquared account.*
  • Update empty fields of duplicates – With this option, only empty fields of the duplicate records in LeadSquared will be updated with the data in the  CSV file.
  • Post Duplicate Detected Activity – If you click this Checkbox checkbox, then a duplicate detected activity will be posted when a duplicate is detected. It’ll get posted on the Opportunity Details page and the Lead Details page, under the Activity History tab.

You can also set the default owner –

  • If the opportunity specified in your CSV is missing an owner, the selected user will be assigned as the opportunity owner.
  • It won’t be overridden if you’ve mentioned an opportunity owner in your CSV file (for example, that user Rajesh is the opportunity owner for the opportunity “Program”).

Click Next when you’re finished.

Import Opportunities_5

*To update existing opportunities without changing the opportunity owner –

  1. Select the Overwrite Duplicates option.
  2. Enable the  

Note that this setting will also ignore the default opportunity owner you select for the import.

opportunity import restrict owner update


3.5 Check the Status of Your Import

Your import request is now successfully queued. Click the link shown below to view the status of the import. You’ll also be notified by email once the import is complete.
You can now choose to import another file or proceed to the Manage Opportunity page.

Import Opportunities_6

Here’s an example of the email you’ll receive in your inbox. Click the link to download a summary report CSV.

Import Opportunities_7

The “Import Status” and “Import Message” columns give you details on what happened with each opportunity (in case of a failed opportunity import).

Import Opportunities_8


Any Questions?

Did you find this article helpful? Please let us know any feedback you may have in the comments section below. We’d love to hear from you and help you out!

Was this Helpful?

Notify of
Inline Feedbacks
View all comments