Importing contact from excel

Posted on 2005-03-15
Medium Priority
Last Modified: 2010-04-08

why doesn't stuff from microsoft just work?

I've followed the various help files to try to import to a contacts folder the rows from an excel sheet.

I've named the ranges in excel and Outlook presents the same names in the custom mapping dialog.

To keep things simple i'm starting with just 2 columns: Name & Company. Outlook insists on creating 2 contacts for each instead of one with both fields filled in.
Question by:juststeve
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 76

Expert Comment

by:David Lee
ID: 13551093
Hi juststeve,
> why doesn't stuff from microsoft just work?

'Cause it's stuff from Microsoft!  Sorry, I couldn't resist making that comment.

LVL 21

Accepted Solution

traval earned 1000 total points
ID: 13560459
Sure, it's fun to blame everything on Microsoft, and I'm sure it would be much easier to map customized fields while importing a spreadsheet into a contact database from a UNIX command prompt, but the fact is that the import wizard is slick as sh*t, so make sure you are following these steps and it should work fine:

I created an XL file containing this data (including the column headings):

bob                   smith              acme                    bob@acme.com
bill                    jones              emca                    bill@emca.com

I highlighted these 12 cells, named the range and saved the file to my desktop.  I opened Outlook and created a new contact folder, then clicked FILE->IMPORT&EXPORT->IMPORT FROM ANOTHER PROGRAM OR FILE->MICROSOFT EXCEL

I browsed to the file and chose "Allow duplicates to be created", verified the current folder is where I wanted the data to go,

I clicked on MAP CUSTOM FIELDS and mapped it like this:

IN XL                                   IN OUTLOOK

FIRST NAME          ->           FIRST NAME
LAST NAME           ->           LAST NAME
COMPANY NAME    ->           COMPANY
EMAIL                  ->           E-MAIL ADDRESS

Click on OK->FINISH and voila, two brand new contacts with name, company, and email address just like I wanted.  This is in Outlook 2003 but I don't see anything that would be significantly different in earlier versions.

Are these the exact steps you are using?

Author Comment

ID: 13563970
Probably cuz i don't have my name field isn't split to first & last.

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This article will help to fix the below error for MS Exchange server 2010 I. Out Of office not working II. Certificate error "name on the security certificate is invalid or does not match the name of the site" III. Make Internal URLs and External…
Many of my clients call in with monstrous Gmail overloading issues with Outlook. A quick tip is to turn off the All Mail and Important folders from synching. Here is a quick video I made to show you how to turn off these and other folders in Gmail s…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question