This article will show you how to create a CSV file for the subscriber list.
Important Note
You will want to do this in Microsoft Excel or another spreadsheet software.
Layout
Rules
- Fields must be tab or comma-delimited
- No header row in your document
- Place each record on a separate line
- All fields must be present, even if empty
- Only the SMS number may be empty
- Allow/ignore blank lines
- Ignore duplicate entries
Fields
Two options for fields: Simple or Expanded
Simple
- Allows for only 3 fields
- SMS number (Formatted: ########## or ###-###-####)
- Subscription type (email, sms, or both)
Email Address |
SMS # |
Subscription Type |
Expanded
- Allows for 10 fields
- SMS
- Subscription type
- First name
- Last name
- Address 1
- Address 2
- City
- State
- Zip
|
SMS |
Subscription Type |
First Name |
Last Name |
Address 1 |
Address 2 |
City |
State |
Zip |
Note: You should use your upload instructions to determine which type of field to include.
Instructions
- Navigate to File
- Select Save As
- Select a location to save your spreadsheet
- Change the file type to CSV
- Click Save
Feedback About the Article
Let us know what was helpful or not helpful about the article below.0 comments
Please sign in to leave a comment.