Google Apps Home‎ > ‎Migration‎ > ‎

Entourage Contacts Import

Entourage exports contacts as tab-delimited files, which when imported into Google Contacts will correctly map the name and first e-mail address in the correct fields but then copies everything else into the Notes fields. For proper mapping the file needs to be converted to CSV as instructed in steps 1 and 2 of this page:http://www.entourage.mvps.org/import_export/csv.html

When the CSV file is created then follow these steps:
  • On the Contacts page click Import to bring up the Import page.
  • Click the Browse button and select your exported file.
  • Click the Import button.
  • The Import page displays "imported all xx contacts". Click the OK button to create your new contacts.

Import/Export CSV File

CSV stands for Comma Separated Values, sometimes also called Comma Delimited. A CSV file is a specially formatted plain text file which stores spreadsheet or basic database-style information in a very simple format, with one record on each line, and each field within that record separated by a comma.

Export

Usually, questions concerning CSV files are from switchers making the move from PC to Mac. Often Entourage users need to create a CSV file for downloading or uploading their contacts for web mail like Gmail and Yahoo, or for using on a PC.

1. Export your Entourage contacts as a tab delimited file. Excel can import a tab delimited file.

File Export



Select "Contacts to a list (tab-delimited text)"



2. Import your file into Microsoft Excel.

Open your spreadsheet document and go to the File pull-down menu, then choose Save As....
Change the "Save as type" or "Format" field to read: "CSV (Comma delimited)".
Enter a name for the document and click Save.
To check the validity of your CSV file, open the new file from a plain-text reading program such TextEdit. Check to make sure there are no extra commas, other than between fields. Depending on what program you're going to use the CSV file with, you may need to also remove any extra quotation marks or other formatting which Excel may have inserted.
Comments