Need step by step directions for importing an Excel spreadsheet (with 8 columns that contain info such as name, title, cell phone, home phone, etc.) into Outlook 2007 contact list

Need step by step directions for importing an Excel spreadsheet (with 8 columns that contain info such as name, title, cell phone, home phone, etc.) into Outlook 2007 contact list so that the data is imported into the correct Outlook 2007 fields.

Please give me a step by step list on how to do this.
IT GuyNetwork EngineerAsked:
Who is Participating?
 
jfromanskiCommented:
Open your Outlook, From File menu select Import and Export, select Export to file, select Microsoft Excel format, enter filename, eg. export.xls, Finish. Open this .xls file in Excel, delete it's contens leaving only field names intact, open your Execel spreadsheet and copy/paste colums to export.xls. Save export.xls and back in outlook File/Import and export, then import yor data.
0
 
IT GuyNetwork EngineerAuthor Commented:
jfromanski,

You provided me with the Export process.

What I am trying to do is to IMPORT an existing Excel spreadsheet into my Outlook 2007 contacts.

This Excel spreadsheet contains 8 columns that contain info such as name, title, cell phone, home phone, etc. I need to be able to import this data into the Outlook 2007 contact list so that the data is imported into the correct corresponding Outlook 2007 fields (name, title, cell phone, home phone, etc).
0
 
MYCUCommented:
The link I provided tells you how to do that. You need to select to map custom fields so that the fields in your excel spreadsheet get added to the correct fields in the Outlook Contact.
0
 
jfromanskiCommented:
Export process was for prepare "good" Excel template, without field mapping. Having this template paste your data into right columns, then import them.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.