# Bulk Import File Format

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

To correctly format the CSV file for bulk importing affiliate accounts into your program, click on **bulk import** in the **All Affiliates** section of the **Affiliates** tab in the GoAffPro admin panel.

![Affiliates > All Affiliates  > Click on bulk import](https://1200686697-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LdPzLtyP46oY7cyXnkw%2F-MCjlXuR91idCtdtfF7Q%2F-MCjyKf-yUxvCvcup29D%2FAnnotation%202020-07-21%20113310.png?alt=media\&token=04a7b358-678a-42ac-9c94-9de24f257e2f)

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-MCjlXuR91idCtdtfF7Q%2F-MCjyxQDUVpCAVhPd0KL%2FAnnotation%202020-07-21%20113459.png?alt=media\&token=c1e68e63-3343-4d2e-b16b-587a19b3a045)

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-MCk4dQsolzSDvOhJoGu%2F-MCkC8_Dmi9o48WPYfQP%2FAnnotation%202020-07-21%20123747.png?alt=media\&token=a8d7fb3b-99f5-4947-8fcc-82fee62cc40f)

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

![Fill in the affiliate information](https://1200686697-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LdPzLtyP46oY7cyXnkw%2F-MCk4dQsolzSDvOhJoGu%2F-MCkD1rLSyK5OzmzKw6C%2FAnnotation%202020-07-21%20124250.png?alt=media\&token=c79a5611-5e58-48a6-9b09-90a4adc0397d)

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-MCjlXuR91idCtdtfF7Q%2F-MCk02lBTyWa_a2YDotz%2FAnnotation%202020-07-21%20113459.png?alt=media\&token=2e7274b2-f30e-488c-a765-8ea5d650ab30)

Now, click on **Start Importing** to begin the importing process.

![Click on Start Importing](https://1200686697-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LdPzLtyP46oY7cyXnkw%2F-MCk4dQsolzSDvOhJoGu%2F-MCkE3PiI9uh1pGJnFVm%2FAnnotation%202020-07-21%20124635.png?alt=media\&token=ac779657-ca8a-48fa-be84-e42f69fea647)

After the import process is completed, you can check the import status of each affiliate in the status column.

![Check the import status](https://1200686697-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LdPzLtyP46oY7cyXnkw%2F-MCk4dQsolzSDvOhJoGu%2F-MCkEN1Lc3hSxNFCx0j_%2Fimage.png?alt=media\&token=c73517bb-4f00-4047-b1bc-45d82d30de29)

The newly imported affiliate accounts will now appear in the All Affiliates section of the Affiliates tab. 

![](https://1200686697-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LdPzLtyP46oY7cyXnkw%2F-MCk4dQsolzSDvOhJoGu%2F-MCkDjQ2RAKVPeyzp5mY%2Fimage.png?alt=media\&token=630dd2e3-977d-417e-a316-5b261e0a8ffb)