This feature is designed to make it possible to import addresses into AOL Email on the Web from a comma-separated values (.CSV) or a tab-delimited (.TXT) file. Many email and contact database programs allow you to export contact information to these file formats, and most spreadsheet applications, such as Microsoft Excel, do so as well. Once you export the contacts from those programs, you can import them into AOL Email on the Web.
What are CSV and Tab-Delimited Files?
A CSV or tab-delimited file is simply a text file that contains information separated by commas or tabs. Each column represents a separate field and each row represents a separate contact record. The format evolved as a way to get information out of tables in spreadsheet or databases programs and into other similar programs.
A CSV or tab-delimited file does not have any unique or proprietary formatting. Typically, the first line has the field names (columns) for the actual entries or records that make up the rest of the file. Contact programs or email programs may use various field names but AOL Email on the Web automatically recognises the field names that are exported by Microsoft Outlook, Outlook Express, Yahoo, and Emailblocks Webmail. If your program uses different field names, you may have to rename them or edit the file's first line to match our requirements and allow the file to be imported. See the notes below for a list of some of the acceptable field names.
AOL Email on the Web recommends that you include at least the First Name, Last Name, and Email Address columns. It doesn't matter which order the columns are in, but the file must include the column headers on the first line, followed by one entry (record) per line, as in the samples below:
Example of CSV file:
First Name,Last Name,Email Address:
John, Doe, email@example.com
Harriet, Wong, firstname.lastname@example.org
Mary Jo, Smith, email@example.com
Example of Tab-delimited file:
First Name Last Name Company Email Address:
Johnathan Doe ABC Company firstname.lastname@example.org
Harriet Wong Company Inc. email@example.com
Mary Jo Smith Any Corp. firstname.lastname@example.org
Import Addresses from a CSV or Tab-Delimited File
Importing Addresses Using the Address Book Import Assistant
Importing Addresses Using the Built-in File Import Feature
Export Contacts from Microsoft Outlook 2002 to a CSV file
Export Contacts from Microsoft Outlook Express 6 to a CSV File
There are two ways to import addresses into your address book. One is using a free program called the Address Book Import Assistant and the other way is to use the built-in file import feature. The Address Book Import Assistant will copy all of your Microsoft Outlook and Outlook Express contacts into your AOL Address Book. The built-in import feature can import CSV or tab-delimited data files.
AOL provides an Address Book Import Assistant program that you can download and use for free to import your address book addresses from other applications to your AOL Address Book. This feature is only available when using AOL Email on the Web.
If you have already saved your address book entries from other applications to your computer in either a CSV or tab-delimited format, you can import them quickly and easily using AOL Email on the Web.
To make it easier to import your addresses from Microsoft Outlook 2002, you should export your address book and save it as a CSV or tab-delimited file.
To make it easier to import your addresses from Microsoft Outlook Express 6, you should export your address book and save it as a CSV file.