|Help > Importing Contacts - Troubleshooting|
Ninety percent of CSV files that cannot be imported into the Web Mail Address Book are not properly formatted. Even if a file has the .csv file extension, it may not be in the correct format for Web Mail. The file has to be exported as an Outlook CSV file to work with Web Mail.
If you are using Microsoft Outlook, here are the steps for exporting an Outlook CSV file:
You can check whether your CSV file is properly formatted by opening the file using Microsoft Excel. If there is no bold "header" at the top of each column, the file is not properly formatted. A correctly formatted file will look like this:
Note the header at the top of each column (Title, First Name, Last Name, etc.). The Web Mail Address Book import tool uses those headers to recognize the data in each column and import the data into the correct fields in the Address Book. (For a list of column headers that Web Mail supports, see the bottom of this page). Here are some tips for ensuring that files exported from Outlook and other email programs and services are properly formatted:
Outlook: When exporting from Outlook, be sure to choose the "Comma Separated Values (Windows)" option when you are prompted to choose a file type.
Yahoo! Mail: When exporting your contacts from Yahoo! Mail, be sure to choose the "Microsoft Outlook" export option.
Mozilla Thunderbird: Choose the "Comma Separated (*.csv)" option when exporting your contacts. (Note: Thunderbird 2.0 and later supports the correct headers. CSV files exported from older versions of Thunderbird omit the headers and cannot be imported into Web Mail).
Another tip: If you have a CSV file that is improperly formatted, you can import that file into Outlook or Outlook Express and then export it from there as a Windows CSV file. The resulting file should work in Web Mail.
The Web Mail Address Book currently supports a maximum of 2,500 contacts. However, when importing a CSV file with more than a 1,000 contacts during peak business hours, the import process sometimes causes the server to time out.
If your CSV file contains more than 1,000 contacts, please try to import it later in the day or early in the morning to avoid peak business hours. Another option is to break up a large file into two or more smaller files and import the files separately.
After importing your contacts into Web Mail, you may notice that email addresses in your Web Mail Address Book look something like this:
The example above is a Microsoft Exchange-formatted email address.
To make sure that your Address Book data is in the correct format, open your CSV file before you import it into Web Mail and verify that all the columns contain information as you want it to appear in your Web Mail Address Book. You will need to edit any improperly formatted entries manually before trying to import the file into Web Mail.
Here are the Outlook CSV column headers that the Web Mail Address Book supports:
E-mail 2 Address
E-mail 3 Address
Business Street 2
Business Street 3
Business Postal Code
Home Street 2
Home Street 3
Home Postal Code
Other Street 2
Other Street 3
Other Postal Code
Business Phone 2
Company Main Phone
Home Phone 2
Address PO Box
Personal Web Page