Exporting Contacts to a file

If you were previously using an email client other than Outlook, Entourage, Outlook Express, Windows Mail, or Eudora, and you want to transfer your list of Contacts (saved email addresses) to your Nexus account, you will need to export the contacts to a file, and then import them to Nexus using Outlook or Entourage (Outlook is available on the IT Services Help Centre computers).

Most email clients (including some web-based clients such as Hotmail and Gmail) have an export function to allow you to save your contacts to a file, so if your program is not listed here then please refer to your email client's help files.

1. Exporting Thunderbird (version 2.0) Address Book

Export Thunderbird address book
Figure 1. Export Thunderbird address book

Open your Thunderbird address book and then click [Tools/Export...] (see Figure 1, Export Thunderbird address book).

Choose a name, type, and location for the file
Figure 2. Choose a name, type, and location for the file

The next screen allows you to choose a location to save your exported contacts (in the example, My Documents has been selected - see Figure 2, Choose a name, type, and location for the file), enter a name for the file, and select a file type. The default file type is LDIF, but this is not supported by Microsoft Outlook 2007, so choose Comma Separated instead. Make a note of the name and location that you have chosen so that you can find the file later! Then click Save to complete the export.

2. Exporting Eudora (version 7) Address book

Export Eudora 7 address book
Figure 3. Export Eudora 7 address book

Open your Eudora 7 address book and then click [File/Save As...] (see Figure 3, Export Eudora 7 address book).

Choose a name, type, and location for the file
Figure 4. Choose a name, type, and location for the file

The next screen allows you to choose a location to save your exported contacts (in the example, My Documents has been selected - see Figure 4, Choose a name, type, and location for the file), enter a name for the file, and select a file type. The default file type is HTML, but this is not supported by Microsoft Outlook 2007, so choose CSV Files instead. Make a note of the name and location that you have chosen so that you can find the file later! Then click Save to complete the export.

3. Exporting Mac Address book

The built-in Mac address book does not have a method to export your contacts list in a transferrable format. You can export individual contacts in VCard format, but if you want to transfer your whole address book you will need to download a third party tool such as MacUpdate's Address Book Exporter.

4. Exporting Pegasus Address book

Open Pegasus and go to your address book. Click on one of your contacts and then press <Ctrl-A> to select all your contacts.

Export Pegasus Address book
Figure 5. Export Pegasus Address book

Choose [Addressbook/Export to tab-delimited file...].

Choose filename and location
Figure 6. Choose filename and location

Select a location and filename for your addressbook, using the filename extension ".txt", like in the image above (Figure 6, Choose filename and location). Then click the Save button to complete the export.

You will now need to edit the exported file slightly so that other programs will recognise it. Open the file in a spreadsheet program such as Microsoft Excel or OpenOffice Calc. To open the file you will need to start the spreadsheet program, choose [File/Open], and then tell it to look for files of any type (Files of Type: All files (*.*) in Excel). The following instructions are based on Microsoft Excel, but the same principles are applicable to other spreadsheet programs such as OpenOffice Calc.

Text Import Wizard
Figure 7. Text Import Wizard

When you open the file, you will see the "Text Import Wizard". Choose file type Delimited and click Next.

Text Import Wizard 2
Figure 8. Text Import Wizard 2

Choose Delimiters: Tab and click Next.

Text Import Wizard 3
Figure 9. Text Import Wizard 3

Click Finish to open the file.

Now delete the contents of the first line, which contains the text * Pegasus Mail Addressbook and the date and time of the export. Instead, enter the column headings: Name, E-mail, Keywords, Department, Primary Phone, Business Fax, Home Address, Other Address, Notes. If you use these exact labels then Outlook should import all your data. Otherwise, you may lose some of the information stored in Pegasus.

Converted file
Figure 10. Converted file

Once you have finished, the file should look something like Figure 10, Converted file. Now you need to save it as a comma-separated values file. Choose [File/Save As...] and select a location for the file.

Save As dialog
Figure 11. Save As dialog

Set the file type to be CSV (comma delimited) (*.csv) and choose a suitable name, then click Save. You will probably see an error now, just click on OK to ignore it.

The file that you just saved can now be imported to your Nexus account, via Outlook or Entourage.

 

Service area: 

Written by IT Services. Latest revision 5 September 2014