> 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**

![](https://295230641-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F41f2EboJipeUA6flsLGK%2Fuploads%2FdIIeZRPTbsYnBceNuNEW%2Ffac910c03582ef3d98f286eb82b5d0b1%20111.gif?alt=media\&token=3196c8dc-f075-4a9e-80b8-322634ac9ae0)

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

![](https://295230641-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F41f2EboJipeUA6flsLGK%2Fuploads%2FG03gD4khJ1oUr4vY1yJJ%2F9b19b566b71ed3f95b58d383be3fb91b%20222.gif?alt=media\&token=ea1be1f0-92ac-4549-bced-45ef8c87254c)

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 (**Mandatory**)
2. Last Name 
3. Country Code ([Supported codes](/universal/common-values.md#countries): IN, US, GB, etc.)
4. Company Name
5. Email (**Mandatory**)
6. Currency ([Supported currency codes](/universal/common-values.md#currency): USD, INR, GBP, etc.)
7. Address
8. Mobile
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/gHi0Sk5TqEzPp7AqYsWg" %}