---
title: "Importing Opportunities from a file"
slug: "importing-opportunities-from-a-file"
description: "There are several ways to get your Lead data into Close. The first and most commonly used is Close's Lead Importer. Navigate to the Lead Importer by clicking your name in the upper right of Close, then choose Import Leads & Data. Using the Lead Importer, you can import (and update) Leads from a ..."
updated: 2025-12-02T07:46:51Z
published: 2025-12-02T07:46:51Z
---

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

# Importing Opportunities from a file

You can import Opportunities from a file following the steps below.

## Go to the Importer

You can do the following to bring your Leads into Close from a file:

- Upload via CSV by browsing that file on your computer
- Dragging and dropping a file onto the Lead Importer’s landing page
- Copy and paste directly from your spreadsheet

![](https://cdn.document360.io/b5cf4edd-8d9e-4649-a50a-2d7591eba26b/Images/Documentation/3.a.png)

## Format your import file

- Make sure the first row in your spreadsheet is a header row (e.g., a row containing column names).
  - It has to contain one column that identifies the Lead, for example `Lead Name`, `Email` or `Phone`. This is how Close will identify the Lead to which the Opportunity belongs.
  - It has to contain the Opportunity infromation in separate columns. You have to fill out at least one column to create a new Opportunity. The columns can be: `Status`, `Date Created`, `Date Won`, `Value`, `Value period`, `Confidence`, `Note` and `User`
- Make sure you have valid data in these fields:
  - `Status`: It should match any of the Opportunity statuses you have in your [pipeline](/v1/docs/opportunity-statuses).
  - `Date Created`: By default, if you don’t import this field, the Opportunity creation date will be the day of the import. You can import custom creation dates for [reporting](/v1/docs/opportunity-funnels-report) purposes.
  - `Date Won`: This is the estimated close date of the Opportunity, or if it’s already in a “Won” status, it’s the close date. You can use this format to import dates: `yyyy-mm-dd`
  - `Value`: This has to be a number.
  - `Value period`: The options are: `One-time`, `Monthly` or `Annua`. If not imported, it will default to one time.
  - `Confidence`: This is a percentage of how likely it is that the Opportunity will be won.
  - `Note`: You can enter any note.
  - `User`: The user you want the Oportunity to be assigned to. If not imported, the Opportunity, by default, will be assigned to the importing user. Use the user’s name or email address.

## Assign Fields

After you finish uploading your data, you must assign each column from your spreadsheet to a field in Close. In some cases, Close will recognize your column name and do the work for you. You'll also see a few preview rows from your spreadsheet so you can know what's in each column.

To assign the data from your spreadsheet to the right place in Close, use the dropdown under `This column will be assigned to`. The field will turn from blue to green once you've matched a spreadsheet column to a field in Close. If you don’t want to import a column from your spreadsheet, check the `Skip` option at the top right of the field box. Click `Next` to move on to the next page.

You also have the option to `Skip All Unassigned Columns` at the bottom of the screen.

When you assign fields, Close will automatically scan for errors and allow you to review and fix the errors directly in the importer.

![](https://cdn.document360.io/b5cf4edd-8d9e-4649-a50a-2d7591eba26b/Images/Documentation/3.c.png)

## Assign Opportunities to an existing Lead

In your import file, you have added a column to identify the lead. Make sure to use that infromation to “Check if the Lead already exist.” This will ensure that the Opportuity will be created on the correct Lead.

If you only want to import Opportunities and nothing else, choose “skip the Lead” if it does not already exist.

![](https://cdn.document360.io/b5cf4edd-8d9e-4649-a50a-2d7591eba26b/Images/Documentation/CleanShot 2025-02-12 at 16.57.35.png)

Customize your import like this to import Opportunities