# CRM - Importing Opportunities with Defined Win Dates

SprintHub allows you to import opportunities in a practical and organized way, including with already defined win dates. This feature is ideal for keeping your CRM always updated with the correct negotiation history.

#### Choosing the Pipeline

Before starting the import, go to the CRM settings and select the sales pipeline where you want to import the opportunities. Each pipeline has specific stages and, therefore, this step is essential to ensure that the data is imported correctly.

<figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXcio77N5KydMAborctIZK1iA9s5rHHmTx7FomWUzCVFo8hoX5Rx7zCZPAp2wtIA7USNKeanfaaawR2KNRmxMSUWa2V4VzYkHRzmh77LItcD06TZX1-JeeliUe4m9RbaJrlz1XgB?key=cPrm8jfvxM_wrSa2_WdE4UX1" alt=""><figcaption></figcaption></figure>

#### Starting the Import

When you click on "Import Opportunities," two file options will be available:

* CSV
* XLSX

Choose the format of your spreadsheet file to continue with the import.

#### Important Notes for Mapping

<figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXePu-W7OP14vASuxhnMOekUSH1CnqZZxzqVEivTv0K5Q08UPcjsIiyyI-kN0MgGKFtPflv3N7N4FtR5zJxnN4JIoTlkh5QSoeRKvOTuuxmbRswBL4aarMZ8usXxy6soBOqo2Q9j7A?key=cPrm8jfvxM_wrSa2_WdE4UX1" alt=""><figcaption></figcaption></figure>

Check out an example spreadsheet. Pay attention to empty rows; they must be removed because they interfere with the mapping.

<figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXcA1umTksaCnZkCjZ2vz3z9WjzR4MjAojCAu22bqPp7K9l0tvQIgNBVi_d9ryGdAMZ6WOzCo5Jn1iOAf3ookyF3bb1YriWa16jPJ7nj7YltdiG3te-wb88njEib7yX5FBeGRrvr-A?key=cPrm8jfvxM_wrSa2_WdE4UX1" alt=""><figcaption></figcaption></figure>

{% hint style="warning" %}
Your spreadsheet must include the title column; without it, the mapping cannot be performed.
{% endhint %}

To see the Stage and User IDs, click on "View IDs," which will be displayed as shown in the image below:<br>

<figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXdRYNnZkauNUmcOaQtT7-I6Uv3SiC5msndhYAwt9wsqhcp65uAQTnDZKhXVVrZHkw-f-9fKJyrFSEvH-ru1Ho8DZ-AKcjVpAuZ2VOj7WLLfNcqDsLmrv_HK9nTt7sMwI1UQTegOKQ?key=cPrm8jfvxM_wrSa2_WdE4UX1" alt=""><figcaption></figcaption></figure>

#### Mapping the fields

<figure><img src="https://lh7-rt.googleusercontent.com/docsz/AD_4nXcQi3GvFS7oT8DyXOh245OkXv4AJw9fPymPvlr9J7w0XBd_3xYJgoGpLXwtiwpt94lvnZfEiVBAD8_6nqngmnxOLCUUvkbNilpGjN8gvaQ-mhsIoWt1Iq-SCcn1JO5-0-2FoSMnZQ?key=cPrm8jfvxM_wrSa2_WdE4UX1" alt=""><figcaption></figcaption></figure>

\
Attention to the Date Format

When importing opportunities with defined dates, it is essential to verify:<br>

* What date format is used (for example: DD/MM/YYYY, YYYY-MM-DD, etc.).

<figure><img src="https://684109703-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F9FzUKkagBNy5uQ7AtGNa%2Fuploads%2FrM8wJHjWNCQgScaKl2e3%2Fimage.png?alt=media&#x26;token=f64e237f-a8ca-49d7-9830-a406008f77f9" alt=""><figcaption></figcaption></figure>

{% hint style="warning" %}
Incorrect date mapping can affect the import of your data.
{% endhint %}

#### Finishing the Import

After reviewing the mapping of all fields:

1. Make sure the data is correct.
2. Click "Import".<br>

Done! Your opportunities will be inserted into the CRM with complete information, including the win dates correctly associated.

<br>