When uploading your Subscribers the file needs to be in a .CSV file. More specifically, a Comma Separated Values (.csv) file.
Row one of your file must contain all of these headers exactly spelled out like this example:
Phone
First Name
Last Name
Email
Address
City
State
Zip
Company Name
Tags
Birthdate
As you can see from the above example, in row 1 of your .CSV file, there are 10 required column headers that must be listed (columns A-J). The only column header that is not required to include is Column K - "Birth Date".
The only required column to fill in with data is the Phone Number column. Other columns can be left blank or filled in.
For example, if you only want to include Phone, First Name, and Last Name data, that is perfectly fine. Put that data in the rows that map to columns A, B, and C. But you still need to have columns D-J, row 1 labeled with the appropriate headers. Email, Address, City, State, Zip, Company Name, Tags. But just leave the data for those columns blank.
Here are the Phone Number formats we accept:
(310) 555-5555 or 310-555-5555 or 3105555555 or 1310-555-5555
Another issue we most commonly see is the file not being properly formatted, due to line endings of each row. Different computer operating systems are using different "invisible characters" when it comes to ending a row in a .CSV file. This is especially common with MAC Apple computer users.
The way to fix this is to copy the contents of your file, paste it into a new workbook, re-save the file as a Comma Separated Values (.csv) file with a new file name, and save it to your desktop. Then try uploading the new document.
For all your uploads, below is an image of the only approved .CSV format:
Comma Separated Values (.csv)
Do not save your .CSV file with any of the following:
Macintosh Comma Separated (.csv)
MS-DOS Comma Separated (.csv)
CSV UTF-8 (Comma delimited) (.csv)