Software

Ask something
Question Locked

Import Outlook contacts into Entourage

0 helpful
2 replies

by proteus55

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi all,

I'm trying to import contacts from Outlook 2007 into Entourage.
The contacts were exported to a .csv file and moved to the Mac machine via flash drive.
When I import from text file in Entourage, there's at least double the amount of actual contacts, most of which are blank.

For example:
The csv file contains 290 entries.
When imported into Entourage, 560 entries are imports.
The remaining 270 entries are blank.

Any workaround for this issue. Seems to happen frequently.

2 replies

by thumbsup2

It sounds as if there are multiple blank records being exported wich create at least one cell with a hidden space in it.

To fix it, open the CSV file with Excel, then sort the data. This will bring all blank lines to the top where you can delete them. After that is done, be sure to select the rows below the data, right click and choose clear contents. Hidden spaces will create blank lines in the CSV file.

Once you have "cleaned" the blank cells, use File/Save As to resave the file in CSV format. You may need to give it a new file name. You can then open that new CSV file with NotePad or any simple text editor (NOT Wordpad) to make sure there are no lines with nothing but commas in them. Those would be blank records again when imported to Entourage, so delete any you find and save the file. Then do your copy and import to Entourage.

This discussion is closed to new replies.