# Uploading Fans {% embed url="" %} ## How to Upload Fan Emails/Numbers to ForeverFan In this guide, we will walk you through how to properly upload fan emails and phone numbers to your ForeverFan account. {% hint style="info" %} Please ensure you adhere to the necessary legal frameworks, such as GDPR, CAN-SPAM, and COPPA, when collecting and uploading fan data. Learn more about compliance below. {% endhint %} {% content-ref url="uploading-fans/compliance-information" %} [compliance-information](https://help.foreverfanmusic.com/fanbase-management/uploading-fans/compliance-information) {% endcontent-ref %} Uploading fans to your account allows you to manage your audience directly on our platform. Follow the steps below to prepare and upload your CSV file. Please read all instructions carefully to ensure a smooth process. **Note: Fan uploads are not reversible.** *** ### Step 1: Prepare Your CSV File {% hint style="info" %} **THIS IS VERY IMPORTANT: YOU CAN ONLY UPLOAD A FILE ENDING IN .CSV** \ \ **We recommend using Google Sheets or Excel to set this up!** {% endhint %} Your CSV file should contain **at least one contact method for each fan — either an email address or phone number.** Any rows missing both will be ignored. We support the following columns in your upload file: #### Required Columns | Column | Description | Required? | | ---------- | ------------------- | ------------------------------------ | | **email** | Fan’s email address | Required if phone number is missing | | **number** | Fan’s phone number | Required if email address is missing | At least **one of email or phone number** must be present for each fan. *** #### Optional Columns | Column | Description | | ------------- | ------------------------------------------------------------------------------------------------------------------------------------------- | | **name** | Fan’s full name | | **city** | Fan’s city | | **region** | Fan’s state or province | | **country** | Fan’s country | | **latitude** | Fan’s latitude | | **longitude** | Fan’s longitude | | **tags** | A list of tags, separated by commas (e.g., "VIP,Superfan,Preorder"). Tags should not contain spaces unless they are part of the tag itself. | #### Notes on Location Data * You can either provide a **city and country,** or **latitude/longitude** to result in fan tagged with location. * If you provide **latitude and longitude**, we will prioritize them and overwrite the city/region/country you enter. * If you provide **city and country,** you do not need to provide latitude/longitude. * If location data is incomplete or invalid, the fan’s location will not be saved. *** #### Important: Deduplication Process We will **automatically deduplicate fans based on email address and phone number.** * If a fan with the same **email or phone number** already exists in your account, **we will not create a new fan record.** * Instead, any **new data (such as name, location, tags)** will be **added to the existing fan record.** *** #### Step 2: Upload Your CSV File 1. Navigate to the **Audience** section of your dashboard. 2. Click **Upload Fans**. 3. Select your prepared CSV file. 4. Confirm and upload. *** #### Step 3: Review and Confirm Once uploaded, your data will be processed. Please note: * **Uploads cannot be undone.** Double-check your file before uploading. * Invalid rows (missing required contact information) will be skipped. * If duplicate emails or phone numbers exist, they will **merge into the existing fan record**. *** #### Step 4: Ensure Compliance All uploaded fan data must comply with our platform’s data and privacy policies. By uploading, you confirm that you have the necessary consent and legal rights to store and contact these fans. *** ### Sample CSV File For your reference, you can **download a sample CSV file here**. This sample contains 10 example fans and demonstrates the correct formatting and column structure. {% file src="" %} *** ### Frequently Asked Questions (FAQ) #### What happens if I upload a fan who already exists? If a fan with the **same email address or phone number** already exists, we will **merge** any new data into the existing fan record instead of creating a duplicate. If there is new data that doesn't match (ex. a new location) we will **overwrite** with the new data. #### Can I undo an upload? **No.** Uploads cannot be reversed. Please double-check your file before uploading. #### Do I have to include all columns? No. Only **email or phone number** is required. All other fields are optional but recommended for better audience management. #### What happens if my location data is incomplete? If you provide **only part of a location** (for example, just a city and country), we will attempt to fill in the missing data using a geocoding service. Incomplete or invalid locations may be skipped. #### Can I upload tags? Yes, you can. Tags should be provided in the `tags` column as **a comma-separated list** (e.g., `VIP,Superfan,Preorder`). Tags will automatically be added to the fan profile. #### Is there a limit to how many fans I can upload at once? Without reaching out to our team, you cannot upload more than 500 fans. For increased limits, please contact us at . *** ### Compliance Reminder By uploading fans, you certify that you have collected and are handling this data in accordance with all applicable laws and regulations. You are responsible for ensuring that your fan data is compliant.