> For the complete documentation index, see [llms.txt](https://knowledgebase.offer18.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://knowledgebase.offer18.com/network/tools/import-data/import-affiliates.md).

# Import Affiliates

1. **Go to Tools » Import Data**

![](/files/5TaKXSHVkQnhNpoDjf8g)

2\. **Select Affiliate Import Template (CSV file)**

![](/files/PAUufdbfODp23KFeyoQj)

Once the File gets uploaded Affiliate data will be displayed in table format. Users must match all column headings as per the data sorted CSV sheet.\
(Remove 1st heading row after mapping column)

***

#### Important **fields in the CSV to import Affiliates**

1. First Name, Last Name 
2. Country
3. Company Name
4. Email ( **Mandatory** )
5. Currency
6. Address
7. Phone
8. Website
9. Status ( approved, pending, rejected )

Download the Affiliate Import template file from here and sort your Affiliate data as per the template headings.

{% file src="/files/eMg0zaziTY3OxpUkOYXR" %}
Download Affiliate Import Template
{% endfile %}