You're really not providing enough info to go on for anyone but to speed up
and simplify the process - this is how your Excel sheet "should" look:

- 1 row = 1 contact
- 1 column = 1 field of information (i.e. name, address, email etc - each
column only has one item in it)
- first row represents the "header row" - i.e. each entry in the column
represents the column's (field's) name
    (i.e. column A1 = PersonName, A2 = CompanyName etc etc - field names
depend on what you have in the column)
- you create ONE Excel "named range" that  covers the header row and ALL
data rows

Save your file. Import from Outlook making sure you map the fields
individually and you should be on your way :-).

Karl

PS - Not familiar with "Excel named ranges"? You can further simplify your
life by just saving this worksheet in a CSV format and import the .CSV file
instead as long as it follows all the row/column rules.

Here's what worked for me -

Open your excel file.
The first row should contain header titles. Copy this row
and paste it as Row 3, after the first contact in Row 2.

Import the excel file to Outlook, and when you get to the
mapping bit, use the data in the bogus row 3 to map to the
correct outlook fields.
Now finish the import.
You will have a new contact that contains the bogus data
and you can delete that.

Hope this helps, ian