Export of Office Outlook contacts to GMail

To import your Microsoft Office Outlook contacts to GMail or Google Apps, you need to export them first to a CSV file.

• In Outlook, go to the "File" tab in the ribbon menu, and click "Options" in the left sidebar.
• In the Outlook Options dialog, click on "Advanced" in the sidebar, and click the "Export" button. 
• In the first step of the Import and Export wizard, select "Export to a file", and click "Next".
• In the second step, select "Comma Separated Values (Windows)", and click "Next".
• In the third step, select your Contacts folder that you want to export (normally "Contacts"), and click "Next".
• In the fourth step, enter or select the filename, e.g. "contacts.csv".
• Click "Finish" to start the export.

When you import this file in GMail, and you are a member of a Windows Active Directory domain, the e-mail addresses are not imported.  Instead, the e-mail address field in GMail contains the "distinguished name" of your contact as known to your ActiveDirectory.  E.g. "cn=jsmith,ou=promotions,ou=marketing,dc=noam,dc=reskit,dc=com".
The real e-mail address is however included in the CSV file, as part of the column "E-mail Display Name", which contains the full name and the regular e-mail address between parentheses, but this column isn't used by the GMail import.

You could replace all E-Mail Addresses in the file using an Excel formula, or manually in a text-editor.
Or you can simply use this FxGqlC command to replace all e-mail address columns with the e-mail address taken from the display name:

select replaceregex($line, '\"/o=.*?\",\"EX\",(\".*?\((.*?)\)\")', '"$2","EX",$1') into [contacts2.csv] from [contacts.csv]

The same method can be used to replace national telephone numbers into an international format:
select replaceregex($line, '\+?(32\d{8,9})', '+$1') into [meucci3.csv] from [meucci2.csv]

You need to adopt the regular expression to a format appropriate for your contacts.

Import the resulting file in GMail, and that's it.