Support Center/Artist Knowledge Base/Managing Fans

Importing Your Mailing List

Topspin Artist Support
posted this on December 06, 2011 02:32 pm

How do I import Fans into Topspin?

To import fan email addresses into your Topspin account manually, just download Topspin's CSV Import template from your Fans tab.

1.) Start by clicking the "Import Fans" button in your account. 

1.jpg

2.) Click "Import via CSV"

2.jpg

3.) Download the Topspin CSV Template by clicking the "Get the Topspin CSV Template" download link

3.jpg

CSV stands for "Comma Separated Value". It's a spreadsheet format supported by most email software applications, and can be edited and saved in any standard spreadsheet editor like Excel. When you download the Topspin CSV Template, open it and paste your email addresses into the spreadsheet. Important: Make sure you don't alter the header row included in the Topspin CSV Template. This will prevent a proper import. 

4.jpg

 

How do I import my fans' geographic information?

If your current mailing list contains geographic data for individual fans, you can import this data into Topspin along with your fans' email addresses.

1. The "Geo" columns in the Topspin CSV template are 'export-only' columns (they aren't used for importing info, just exporting it)

2. To associate your fan email addresses with specific cities and countries, apply your city/province/country data to either "Billing" or "Shipping" columns: (Billing City, Billing State/Province, Billing Country) and/or (Shipping City, Shipping State/Province, Shipping Country)

3. Remember to use proper ISO codes for "Country" info. For instance, when you enter country information, don't type 'United States'. Make sure you use the standard, two-digit ISO code for the country. In the case of the United States, this would be "US". A comprehensive list of official ISO codes can be found in the 'Import Fans'>'Import via CSV' section of your fans tab.

Screen_Shot_2011-12-12_at_1.24.00_PM.png

4. About 24 hours after your import, you should be able to query and filter your fans by geographic location.