> For the complete documentation index, see [llms.txt](https://help.3sigmacrm.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.3sigmacrm.com/welcome/adding-or-importing-leads/bulk-import-leads-csv.md).

# Bulk import leads(CSV)

Importing leads in bulk is straightforward using our CSV feature. Follow these steps for a smooth import process:

**Simple 4-Step Import Process:**

1. **📥 Download Template**: Start by downloading our CSV template from the system. This ensures your data is organized correctly and meets our format requirements.
2. **📝 Fill in the Template**: Enter your lead information into the template. The mandatory fields are **Name** and **Phone**.
3. **🛠️ Map Your Columns**: During the upload process, match your CSV columns to the lead fields in the system.
   * **Example**: If your CSV has a column named “Mobile Number,” map it to the “Phone” field in the system.
4. **📤 Upload and Wait**: Upload the mapped file and let the system handle the rest. The processing occurs in the background, and you'll receive a summary notification once the upload is complete.

**Data and Formatting Guidelines:**

* **Phone Number**:
  * Must be formatted correctly. For Indian numbers:
    * Include the country code (+91) without any spaces or special characters (e.g., +919876543210).
    * Alternatively, use the 10-digit format without the leading zero (e.g., 9876543210).
    * Avoid spaces, parentheses, or dashes.
  * The column for phone numbers should be formatted as 'Number' in Excel to avoid any issues during the upload process.
* **Name**:
  * This is a required field and can include both first and last names.
* **Email**:
  * Optional. Ensure it follows a proper email format (e.g., <name@example.com>).
* **Number Format Fields**:
  * For any fields involving numbers like "Amount" or "Zip Code," ensure these are also formatted as 'Number' in Excel.

> **Important**: If your lead duplication settings are disabled, the system will automatically prevent any duplicate leads from being added.

By adhering to these steps and guidelines, you can avoid common issues and ensure that your leads are imported correctly every time.

## Importing on the Web App 💻

1. Open **Leads** and pick the lead list you want to import into. New leads are added to the list that is open.
2. Click **Add lead → Import from a file**.
3. **Upload file**: first time? Click **Get sample file**. It already has your own lead fields as columns. You can upload **.csv**, **.xls** or **.xlsx** (only the first sheet is read).
4. **Match columns**: for each CRM field, pick the matching column in your file, or choose **Don't import**. Use **Keep all** to also bring in other columns from your file.
5. **Check data**: review your leads before importing.
   * Super admins can choose what to do **If a lead is already in your CRM**: **Skip them** (default), **Update them** or **Add them again**. This choice applies to this import only.
6. Click **Import leads**. Your leads are added in the background.

## Importing on the Mobile App 📱

1. On the **Leads** tab, long-press **+** and tap **Import CSV file**.
2. Tap **Download Template** to save the template to your phone's Downloads, fill it in, then tap **Upload File**.
3. Pick your **.csv** file and match each **CRM field** to a **File field**. **Name** and **Phone** must be matched.
4. Tap **Upload file**. You can import up to 20,000 leads in one file.

## Importing Leads with Notes, Tasks and Activities (Admins) 📦

Moving from another CRM (like HubSpot, Salesforce or Zoho) or from offline spreadsheets? Bring the full history with your leads.

1. On the web app, go to **Settings → Import leads**.
2. Click **Download template**. It is an Excel file with 4 sheets: **Leads**, **Notes**, **Tasks** and **Activities**, with sample rows.
3. Fill in your data and upload the **.xlsx** file.
4. Click **Import now**.
5. Check the results: **Leads added**, **Notes added**, **Tasks added**, **Activities added**, **Duplicates in file**, **Already in CRM** and **Failed rows**.

## Updating Many Leads from a File (Admins) ✏️

To change many existing leads at once (for example status or custom fields):

1. On the web app, go to **Settings → Update leads**.
2. Download the template to see the columns you can change. It uses the same format as lead import, and every row needs the lead's ID.
3. Upload your file and click **Update leads**.
4. Check the results: **Leads changed**, **Not found** and **Same lead twice in file**.

## **Special Fields Guidelines**

🔹 **Assign To:**

* **Use:** Assigns the lead to a specific team member.
* **Formatting:** Use **"Assign To"** as the column name exactly as it is.
* **Input:** Enter the **phone number** of the employee (without the country code, e.g., **9876543210**).
* **Important:** The number must belong to an existing user in 3Sigma CRM.

🔹 **Status:**

* **Use:** Defines the current stage of the lead (e.g., "New," "In Progress," "Closed").
* **Formatting:** The status **must match** the predefined statuses in 3Sigma CRM.
* **Important:** If no value is provided, the system will **default to your CRM’s default status**.

🔹 **Label:**

* **Use:** Categorizes leads for easy filtering and management.
* **Formatting:** Labels must **exactly match** existing labels in 3Sigma CRM, including spelling and case.
* **Important:** If a label does not exist, it will not be assigned.

🔹 **Source:**

* **Use:** Identifies where the lead came from (e.g., "Facebook," "Google Ads," "Website").
* **Formatting:** The source name must be **spelled exactly** as it appears in 3Sigma CRM.
* **Important:** If the source is missing, you must create it first on the mobile app: tap **+** on the Leads screen, then **+ New Source** under **Lead Source**.

{% embed url="<https://youtube.com/shorts/QFxjUyRFSzo>" %}

{% embed url="<https://youtu.be/sDG2-pu6rD8>" %}
