Sign in

Gmail Help


Hide

Use Google Apps for work? Learn more about Mail in the Google Apps Learning Center.

Exporting contacts from other mail providers

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

Yahoo! - Hotmail - Hotmail Live - Outlook and Outlook Express - orkut - AOL - Others ]

  • Hotmail: Here's one way to export your contacts from Hotmail to Gmail:
      Using Internet Explorer:
    • Sign in to your Hotmail account.
    • Click the 'Contacts' tab.
    • Click 'Print view.'
    • Align the cursor with the first letter of the 'Name' column.
    • Highlight your contacts by holding down the cursor and dragging it down the list.
    • Hold down the 'Control + c' keys to copy the list.
    • Open Microsoft Excel (or a similar spreadsheet program that supports comma separated values).
    • Select cell A1 in Excel (the top square on the left side).
    • Hold down the 'Control + v' keys to paste (don't use 'Paste Special').
    • Choose 'Save as' from the 'File' menu, and select the type 'CSV (Comma delimited).' Make a note of where you saved the file.

      Using Mozilla or Firefox:
    • Sign in to your Hotmail account.
    • Click the 'Contacts' tab.
    • Click 'Print view.'
    • Align the cursor with the first letter of the 'Name' column.
    • Highlight your contacts by holding down the cursor and dragging it down the list.
    • Hold down the 'Control + c' keys to copy the list.
    • Open Microsoft Excel (or a similar spreadsheet program that supports comma separated values).
    • Select cell A1 in Excel (the top square on the left side).
    • Right click in cell A1 and select 'Paste Special.'
    • Select 'Text,' and click 'OK.'
    • 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.

Think you can write a better article? Click this link to visit Knol and try your hand at editing this entry. We're using Knol in the Help Center so you can update articles and share community-edited information with others.

updated 4/21/2009

Was this information helpful?

Known issues with Gmail

Review our Known Issues page for a list of known bugs, suggested workarounds and recent fixes.

Help resources

Use Google to clean up your life

Learn how Google can help you simplify your life: Use Google to clean up your life.

Tell us how we're doing: Please answer a few questions about your experience to help us improve our Help Center.