> ## Documentation Index
> Fetch the complete documentation index at: https://octanist.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Update and export leads

> Bulk update the status, value and loss reason of existing leads from a CSV or Excel file, and export leads with the columns you choose.

Use these tabs when you keep deal outcomes in a spreadsheet, or want your leads in another tool. To add new leads from a file, see [Manual import](https://octanist.com/docs/incoming-integrations/import.md).

## Update leads from a file

Go to **Settings > Update Leads**. The update has five steps: **Upload**, **Configure**, **Map**, **Preview** and **Update**.

### 1. Upload

Upload a CSV or Excel file with one row per lead.

### 2. Configure

Choose how the status is set:

| Option | Use when |
| - | - |
| Apply same status to all leads | Every lead in the file gets the same status: **Won**, **Lost**, **Qualified**, **Open**, or **No status change**. With **Lost** you can add a loss reason. |
| Read status from spreadsheet column | Each row has its own status in a column (open, qualified, won or lost). |

You can also update lead values by including a value column. This works with both options.

### 3. Map

Match your columns to lead fields. Map at least one identifier so Octanist can find the lead:

| Identifier | Notes |
| - | - |
| Lead ID | The Octanist lead ID. |
| External lead ID | Your own record ID, such as an order or CRM ID. |
| Email | The lead's email address. |
| Phone | The lead's phone number. |

Then map the fields to update: **Value**, **Status** and **Loss Reason**.

### 4. Preview

Check the data before you update. Rows without any identifier are skipped, and the preview tells you how many. Negative values are rejected.

### 5. Update

Octanist updates the leads and shows how many were updated, not found, or failed. Click the download button to get a CSV report with each row's result.

> [!TIP]
>
> To keep leads in sync automatically instead of uploading files, connect your CRM or use the API. See [Lead updates](https://octanist.com/docs/settings/lead-updates.md).

## Export leads

Go to **Settings > Export Leads**.

1. Under **Export Format**, choose Excel (best for spreadsheet apps) or CSV (universal compatibility).
2. Under **Date Range**, optionally pick a start and end date. This filters leads by creation date.
3. Under **Columns to Export**, choose the fields. Use **All** or **None**, or **Reset** to go back to the default selection.
4. Click **Export XLSX** or **Export CSV** to download the file.

Fields are grouped:

| Group | Fields |
| - | - |
| Core Fields | External lead ID, Name, Email, Phone, Website, Page Path, Custom Data |
| Status & Value | Status, Value, Note, Loss Reason, Source |
| Dates | Created At, Updated At, Qualified At, Expires At |
| UTM Parameters | UTM Source, UTM Medium, UTM Campaign |
| Click IDs | The click ID of each supported ad platform, such as GCLID |
| Google Ads Attribution | Customer ID, click date, campaign, ad group, ad, device, network, click type and slot |
| Consent Flags | Ad Storage, Ad User Data, Analytics Storage and Ad Personalization consent |

An exported External lead ID can be imported again without changing it.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.