Home/HighLevel/Features/Opportunities & Pipelines/How to import Opportunities with a CSV file in HighLevel

CRM and Pipelines

How to import Opportunities with a CSV file in HighLevel

In short

Opportunity CSV import lets you add new deals or modify existing ones in bulk. Each row must link to a contact via Contact ID and include required fields like Opportunity Name and Pipeline. You can also map stages, values, statuses, and custom fields.

AreaOpportunities & Pipelines · Getting Started with Opportunities
Used forReal estate brokerage, SaaS startup, Dental practice
Setup steps20 steps in 8 tasks
Last updatedNovember 16, 2026

01Who this is for

  • Sales managers who need to populate many deals quickly without opening each record.
  • Data migration specialists moving deal information from another CRM into HighLevel.
  • Small business owners who want to update pipeline stages or values across many opportunities at once.

02Opportunities CSV import, explained

The feature reads a CSV file and either creates fresh Opportunity records or updates existing ones. It works only for Opportunities that belong to contacts already stored in HighLevel, unless you also import contacts in the same file.

During the import you select the record type, upload the file, map each column to a HighLevel field, set how empty values are treated, and then launch the process. The import runs in the background and results appear in Bulk Actions where you can see successes and failures.

03How businesses use importing opportunities using a CSV file

  • Real estate brokerage. The brokerage prepares a CSV with listings as Opportunities, includes Contact IDs of agents, and maps columns to Pipeline and Stage. The import creates a deal for each listing in the correct sales pipeline.
  • SaaS startup. The startup exports its lead list with deal values and statuses, adds Contact IDs, and runs an Opportunities only import to update the Opportunity Value and Status for existing deals.
  • Dental practice. The practice adds a CSV that contains new treatment plans as Opportunities, includes patient Contact IDs, and maps custom fields for procedure type. The import adds those plans to the appropriate pipeline.

04The numbers and rules that matter

  • CSV file size must be under the currently documented 30 MB limit.

05Before you start

  • Save the data as a CSV file.
  • Keep the file under the 30 MB size limit.
  • Create the pipelines that will receive the Opportunities.
  • Create the stages within those pipelines if you will import stage information.
  • Create any custom Opportunity fields you plan to map.
  • Ensure every Opportunities only row contains a valid Contact ID.
  • Include Opportunity ID when you intend to update an existing record.
  • Review the CSV for blank or incorrect values.
  • Test the import with a small sample file before processing a large dataset.

06How to set up and use importing opportunities using a CSV file in HighLevel

Start the import

  1. Navigate to Opportunities in your HighLevel subaccount.
  2. Click the Import button that appears in the Opportunities view.
  3. Select either Opportunities or Contacts + Opportunities as the import type.

Choose import behavior

  1. Select whether the rows will create new Opportunities or update existing ones based on the presence of Opportunity IDs.
  2. If updating, verify that each row includes the correct Opportunity ID.

Upload the CSV file

  1. Drag and drop or browse to select your CSV file in the import window.
  2. Confirm that the file uploads without error.
  3. Acknowledge any initial warnings that the importer displays.

Configure empty value behavior

  1. Enable the Don’t update Empty Values option if you want blank cells to leave existing values unchanged during an update import.

Map CSV columns to HighLevel fields

  1. Map the required columns: Contact ID, Opportunity Name, and Pipeline.
  2. Map optional columns such as Pipeline Stage, Opportunity ID, Opportunity Value, Status, and any custom Opportunity fields.
  3. When prompted, choose the option to not import data for any columns you leave unmapped.

Review and start the import

  1. Verify that all required fields are correctly mapped.
  2. Check that the empty value setting matches your intention.
  3. Review any warnings shown by the importer.
  4. Click the Start Import button to begin processing the rows.

Review import results

  1. Go to Bulk Actions after the import finishes.
  2. Open Show Stats to see successes and failures.
  3. If there are errors, download the error log, correct the rows, and re import only the corrected records.

Important warning

  1. Completed imports cannot be undone with a single click; always test with a small sample first.

07What it looks like in HighLevel

08Settings that matter

  • Don’t update Empty Values. Controls whether blank cells in the CSV overwrite existing Opportunity data during an update import.
  • Import behavior. Determines if the CSV rows create new Opportunities or update existing ones based on the presence of Opportunity IDs.
  • Don’t import data for unmapped columns. Specifies that any CSV column left unmapped will be ignored rather than creating a field with empty data.

09Things to know before you rely on it

  • CSV files must be 30 MB or smaller.
  • A completed import cannot be undone with a single click; test with a small sample first.
  • Pipeline and stage values in the CSV must match existing pipelines and stages; the import will not create them automatically.

10If something goes wrong

  • Opportunity is not linked to the correct contact. Check that the CSV contains the correct Contact ID and that the column is mapped to Contact ID.
  • A new Opportunity was created instead of updating the existing one. Ensure the row includes the correct Opportunity ID and that the column is mapped to Opportunity ID.
  • Pipeline value is rejected. Confirm the Pipeline name in the CSV matches an existing HighLevel pipeline; create the pipeline beforehand if needed.
  • Opportunity appears in the wrong stage. Verify that the Pipeline Stage value in the CSV corresponds to a stage that exists within the selected pipeline.
  • Existing data was replaced by blank values. Enable the Don’t update Empty Values setting when running an update import.
  • Custom field missing during mapping. Create the custom field for the Opportunity object before starting the import and map the CSV column to that field.

11How it connects to the rest of HighLevel

Michael's take

Michael Reimer
Michael ReimerFounder of CRM Pros, HighLevel Commander and Certified Admin

People often think they can drop a giant spreadsheet into the importer and let HighLevel magically create everything, but the system won’t build pipelines, stages or Custom Fields for you. If those pieces aren’t set up first, the import will fail or place deals in the wrong spot.

I would begin with building the exact pipelines and stages I need, then create any custom opportunity fields. After that I run a tiny test file with just a couple of rows to verify the mapping and the empty value settings. Once the test passes, I expand to the full dataset with confidence.

Get More InformationOpens on HighLevelPublished November 2, 2026 · Updated November 16, 2026

Common questions

Common questions about importing opportunities using a CSV file.

Can I import Opportunities without importing Contacts?

Yes. When the contacts already exist in HighLevel, you can run an Opportunities only import that requires only Contact ID, Opportunity Name, and Pipeline.

Is Contact ID required for an Opportunities only import?

Yes. The import needs a valid Contact ID so each Opportunity can be linked to an existing contact.

How do I update an existing Opportunity instead of creating a new one?

Include the existing Opportunity ID in the CSV and map that column to Opportunity ID. Without the correct ID, HighLevel may create a new record.

Do my Pipelines and Stages need to exist before importing?

Yes. Create the required pipelines and any stages you plan to use before starting the import; the CSV will not create them automatically.

What happens to existing values when my update CSV contains blank cells?

If you enable the Don’t update Empty Values option, blank cells will leave the current HighLevel values unchanged.

Can I import Opportunity custom fields?

Yes. Create the custom fields for the Opportunity object first, then map the corresponding CSV columns during the field mapping step.

Next step

Pick the features that matter. Then get the plan that unlocks them.

Explore the features you want, start with the five at the top, and upgrade through my link when you are ready. The bonuses and the team come with it.

The features directory explains every HighLevel feature in plain English. Browse it to see what the platform can do.

Back to the FeaturesSee the full details
⌃

Site preview

Explore the next page

This destination is reserved in the page inventory and is not built yet.