Export Email Contacts to CSV file

• Select Tools > Address Book from the menu.
• Now choose File > Save As… from the menu.
• Make sure CSV Files (*.csv) is selected under 'File type'.
• Type "Contacts" under 'File name'
• Click Save.
• Try importing the Contacts.csv file into your email program or service right away. If the import fails:
  • Open the Contacts.csv file in a spreadsheet program (such as Microsoft Excel, Apple iWork Numbers, OpenOffice.org Calc, or Google Spreadsheets).
  • Try:
    • Cleaning up any errors you see.
    • Adding column headers your email program or contact manager may expect.
    • Removing the Eudora nickname (typically the first column).
    • Re-arranging columns to confirm to the standard your email program expects.

Gmail: To export your Gmail Contacts list into a CSV file -

• Sign into 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.
• Copy the list to the Windows Clipboard (right-click your mouse and copy; or hold down the 'Control + C' keys).
• Open a spreadsheet program that supports comma separated values (such as Microsoft Excel, Apple iWork Numbers, OpenOffice.org Calc, or Google Spreadsheets).
• Open a blank spreadsheet and select its first cell (in Excel, select cell A1 which is the top square on the left side)
• Paste the Contacts list (without formatting) from the Windows Clipboard into the blank spreadsheet (either right-click your mouse and Paste; or hold down the 'Control + V' keys - do not use 'Paste Special').
• Choose 'Save as' from the 'File' menu, and select the type 'CSV (Comma delimited).' Note where you saved the file.

• Sign into 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.

IncrediMail: To export your IncrediMail address book to a CSV file -

• Select Tools > 'Address Book...' from the menu.
• Select File > Export... from the address book's menu.
• Go to the folder where you want to export your address book.
• Accept the standard "IncrediMail Contacts (csv)" file name, or enter a custom file name for the copy.
• Click Save.

Following are the general steps to export from Office Outlook or Outlook Express to a CSV file -

    From Office Outlook:

• In Office Outlook, select File > 'Import and Export...' from the menu.
• Highlight "Export to a file".
• Click Next.
• Select 'Comma Separated Values (Windows)'.
• Click Next .
• Highlight the Contacts folder.
• Click Next.
• Use the Browse... button to specify a location for the exported contacts.
• Enter a file name (such "Outlook.csv" or "ol-contacts.csv") for the e-mail contacts file.  
• Click Next.

    From Outlook Express:

• In Outlook Express, select File > Export > 'Address Book' from the top menu .
• Select "Text File (Comma Separated Values)".
• Click on Export.
• Save the exported address book with a meaningful name to a USB drive or something similar.
• Click the Next button.
• Select the fields you want to include in the exported Outlook Express address book.
• Finally, click the Finish button.

▲ Back to the top of this web page

To return to CTI's menu of Help and Tutorials, click here  or use the back arrow at the top of your Internet browser. To go directly to CTI's menu of Error Fixes, click here.