Affiliate records can be exported from the Export/Import tab of the AffiliateWP » Tools page. This export option will generate a CSV file of all affiliates that match the status value specified.
This export tool allows you to generate an itemized CSV of all affiliate records with each affiliate having its own line in the CSV.