# Correctly Format Bulk Import Connections File

To bulk import customer-affiliate connections into your program, you will be required to upload a correctly formatted CSV file. 

To correctly format the CSV file for bulk importing customer-affiliate connections into your program, click on **bulk import** in the **Connections** tab of the GoAffPro admin panel.

![Connections > Click on bulk import](https://1200686697-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LdPzLtyP46oY7cyXnkw%2F-MOb6-abHN5yJWcFCKd8%2F-MObDb_Omsx-CsKhdHkQ%2FScreenshot%202020-12-15%20215639.png?alt=media\&token=234cadd9-cfa9-46ee-ae66-e9b6bfebe41a)

Here, click on the **Sample CSV file** to download the file.

![Click on the Sample CSV file](https://1200686697-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LdPzLtyP46oY7cyXnkw%2F-MOb6-abHN5yJWcFCKd8%2F-MObE6zfyh9bO0_XKW2e%2FScreenshot%202020-12-15%20215839.png?alt=media\&token=eca97150-1609-4cfa-af82-031a6887dc30)

Now, open the CSV file.

{% hint style="info" %}
The CSV file can be opened in programs such as Microsoft Excel or Google Sheets.
{% endhint %}

![Open the CSV file](https://1200686697-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LdPzLtyP46oY7cyXnkw%2F-MOb6-abHN5yJWcFCKd8%2F-MObFAVGQIl5W355FaSk%2Fimage.png?alt=media\&token=9d15fcc3-8d53-4ed7-af79-10b3d02ba353)

After this, fill in the connection information according to the columns provided in the sample file.

![Fill in the connection information](https://1200686697-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LdPzLtyP46oY7cyXnkw%2F-MOb6-abHN5yJWcFCKd8%2F-MObEc_hffCSxTdGmA2h%2Fimage.png?alt=media\&token=89489889-ff72-429d-89b2-0a9f46cb8e5c)

Finally, click on **Browse** and upload your CSV file.

![Click on Browse](https://1200686697-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LdPzLtyP46oY7cyXnkw%2F-MOb6-abHN5yJWcFCKd8%2F-MObFd7zaC2QZktV9jbs%2FScreenshot%202020-12-15%20220514.png?alt=media\&token=6e75e5b9-495d-4156-9231-0e3bbc24753f)

Now, click on **Bulk Import** to begin the importing process.

![Click on Bulk Import](https://1200686697-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LdPzLtyP46oY7cyXnkw%2F-MOb6-abHN5yJWcFCKd8%2F-MObG5GruhdHa_YCtZOR%2FScreenshot%202020-12-15%20220718.png?alt=media\&token=8b538ef6-2f40-4e6f-9047-bc0886ae83dc)

After the import process is completed, you will get a confirmation message saying that the connections have been added.

![Connections added](https://1200686697-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LdPzLtyP46oY7cyXnkw%2F-MOb6-abHN5yJWcFCKd8%2F-MObGeLslMnBGe9MHv_p%2Fimage.png?alt=media\&token=0b6a2449-8feb-4bf2-a05a-f8c6e83c9b82)

The newly imported customer-affiliate connections will now appear in the Connections tab.

![](https://1200686697-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LdPzLtyP46oY7cyXnkw%2F-MOb6-abHN5yJWcFCKd8%2F-MObGkX29sUZk6WFeA7y%2Fimage.png?alt=media\&token=55c797e0-6544-4175-aa63-fbc14891e571)