Skip to main content
Already have a fan list? Fanhaven makes it easy to import existing data into your fan database. And when you need to use fan data in external tools, export gives you a clean download.

​
Importing fans

​
Preparing your data

Before importing, make sure your data is in a CSV file with the following columns:
ColumnRequiredNotes
PhoneYesThe primary identifier. Include country code (e.g., +1 for US)
First NameRecommendedFan’s first name
Last NameRecommendedFan’s last name
EmailOptionalEmail address
Phone number is the primary identifier in Fanhaven. Records without a valid phone number cannot be imported.

​
Running the import

1
Go to Fans
2
Navigate to the Fan Database page.
3
Click “Import”
4
Select your CSV file and upload it.
5
Map columns
6
Fanhaven will attempt to auto-detect your columns. Verify the mapping is correct — phone, name, email, etc.
7
Review duplicates
8
The import tool detects existing fans (matched by phone number) and lets you choose how to handle them:
9
  • Skip — Don’t update existing records
  • Merge — Update existing records with new data (won’t overwrite existing data with blanks)
    • 10
    Confirm and import
    11
    Review the summary (new fans to add, duplicates found, invalid records) and confirm.

    ​
    Post-import

    After importing, Fanhaven automatically:
    • Validates emails — Checks that imported email addresses are deliverable
    • Validates phones — Verifies phone numbers are valid
    • Enriches profiles — Adds geographic and demographic data where available

    ​
    Exporting fans

    ​
    Full export

    Export your entire fan database as a CSV file. Go to Fans and click Export. The download includes all fan fields.

    ​
    Segment export

    Export only fans in a specific segment:
    1. Navigate to the segment you want to export
    2. Click Export on the segment view
    3. Download the filtered CSV

    ​
    Use cases for exports

    Use caseWhat to export
    Email platform syncFans with email consent for your email service provider
    Ad audiencesPhone/email lists for custom audiences on Meta, TikTok, etc.
    ReportingFan data for external analytics or presentations
    BackupPeriodic full exports as a data backup
    Fanhaven respects consent preferences. When exporting for marketing purposes, always filter to fans who have opted in to the relevant channel (email or SMS).