Exporting contacts from other mail providers

Learn how to export the address book from other webmail services -- choose your provider from the list below.

Yahoo!
To import your Yahoo! Mail address book, save your file as a Yahoo! CSV. Instructions are available in the Yahoo! Address Book help section at: http://help.yahoo.com/help/us/ab/impexp/
Hotmail
For Internet Explorer:
  1. Sign in to your Hotmail account.
  2. Click the 'Contacts' tab.
  3. Click 'Print view.'
  4. Align the cursor with the first letter of the 'Name' column.
  5. Highlight your contacts by holding down the cursor and dragging it down the list.
  6. Hold down the 'Control + c' keys to copy the list.
  7. Open Microsoft Excel (or a similar spreadsheet program that supports comma separated values).
  8. Select cell A1 in Excel (the top square on the left side).
  9. Hold down the 'Control + v' keys to paste (don't use 'Paste Special').
  10. Choose 'Save as' from the 'File' menu, and select the type 'CSV (Comma delimited).' Make a note of where you saved the file.
For Firefox:
  1. Sign in to your Hotmail account.
  2. Click the 'Contacts' tab.
  3. Click 'Print view.'
  4. Align the cursor with the first letter of the 'Name' column.
  5. Highlight your contacts by holding down the cursor and dragging it down the list.
  6. Hold down the 'Control + c' keys to copy the list.
  7. Open Microsoft Excel (or a similar spreadsheet program that supports comma separated values).
  8. Select cell A1 in Excel (the top square on the left side).
  9. Right click in cell A1 and select 'Paste Special.'
  10. Select 'Text,' and click 'OK.'
  11. Choose 'Save as' from the 'File' menu, and select the type 'CSV (Comma delimited).' Make a note of where you saved the file.
Hotmail Live
  • Sign in to your Hotmail account.
  • Click the Contacts list on the bottom left of the page.
  • Click the Manage drop-down menu at the top of the Contacts list and select Export.
  • On the page that appears, click the Export Contacts button.
  • When you're prompted to open or save the file, click Save.
  • Select a location to save the file, and click Save.
Microsoft Outlook and Outlook Express:
Here are some general directions to follow, though instructions may vary by version. For more detailed instructions, open 'Help' in Outlook or Outlook Express and type 'export' in the search box. Look for topics that include 'export wizard,' 'export information,' 'exporting contacts' or 'exporting address book contacts' in the title.
From Outlook:
  • Select File > Import/Export > Export from the main menu
  • Choose Comma Separated Values (Windows) > Select "Contacts" > Save exported file

From Outlook Express:
  • Select File > Export > Address Book from the main menu.
  • Select Text File (Comma Separated Values).
  • Click Export.
orkut
Log in to orkut, then click 'Friends' along the top navigation. Next, click 'Download your contacts' on the bottom of the page to save your contacts as a CSV file.
AOL
AOL doesn't have the functionality to export your address book, so you'll have to create a custom CSV file if you use this service.
Others
Refer to your service or client help section for information on how to export your address book. If you have trouble uploading a file in to Gmail, you may need to open the file in Excel, alter the columns and/or headers, and then save the file as .csv.

Learn how to export a CSV file from Gmail.