Importing excel data into Outlook contacts

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Amateur - 13 Dec 2005 16:01 GMT

I copied a Word table into Excel and then tried to import the data into
Outlook contacts. The column containing zip codes imported as a duplicate of
the column just before it, e.g. the state column. I changed the cell format
in excel to text and general and that didn't help. I moved the column but it
still imports as a duplicate of the column just before it. Any ideas?

Reply to this Message

Karl Timmermans - 13 Dec 2005 21:09 GMT

Are there any hidden columns anywhere? If you save your worksheet in CSV
format - is the info duplicated? If not, then either import the CSV file
into Outlook or open the CSV file in Excel and save it - then import from
the new worksheet. If it is duplicated when saving to CSV, open up again in
Excel and delete the extra column.

Karl
__________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0
"Power contact importers for MS Outlook '2000/2003"
http://www.contactgenie.com

>I copied a Word table into Excel and then tried to import the data into
> Outlook contacts. The column containing zip codes imported as a duplicate
[quoted text clipped - 4 lines]
> it
> still imports as a duplicate of the column just before it. Any ideas?

Reply to this Message

Amateur - 14 Dec 2005 03:56 GMT

Thank you so much. I didn't find any hidden files but saving it as a .csv
file did the trick. It imported beautifully. Thanks!

> Are there any hidden columns anywhere? If you save your worksheet in CSV
> format - is the info duplicated? If not, then either import the CSV file
[quoted text clipped - 17 lines]
> > it
> > still imports as a duplicate of the column just before it. Any ideas?

Reply to this Message