TechArena Community

TechArena Community (
-   Windows Software (
-   -   Importing contacts from an Excel file (

Benjycool 02-02-2010 09:27 PM

Importing contacts from an Excel file

I want to import my outlook contacts a list of email addresses i have in an Excel file, How can i do this? please let me know the step wise procedure because i haven't done it before.

Thanking you...

Nigel_123 02-02-2010 09:32 PM

Re: Importing contacts from an Excel file
Firstly it is necessary that in Excel you put in the headers (Name, email, etc etc ...) and especially that you have named the area to import. Attention no merged cells or other close contact with seizures of 2 different lines, it must file either a very simplistic containing only data. Then in File Menu, Import and export.

Solomon 02-02-2010 09:41 PM

Re: Importing contacts from an Excel file
To import contacts from a CSV file or from Excel into Outlook:
  • In File -> Import and Export
  • select the desired file.
  • Select the Outlook folder you want to import the contacts to. This will usually be your Contacts folder.
  • Click OK.
  • Now click Finish.

kattman 02-02-2010 09:45 PM

Re: Importing contacts from an Excel file
In Excel

Select ALL the import data and the row headers, click in the "Name" Excel (where the address appears pointer cell A1), type (not too strong) any name and press [Enter]. Save the file and exit Excel.

In Outlook

File Menu, Import and export, Import from another program or file, Next, Microsoft Excel, Next, Browse to select the file, Ok Choose the options you want no-duplication, Next, Choose destination folder, Next, Check the box that you named above and click the button Custom Fields so as to match your headers to Excel with the field names in Outlook.

Sam.D 02-02-2010 09:46 PM

Re: Importing contacts from an Excel file
In 99% of cases, you have a field in Excel is called "Name" and Outlook does not involve the proper scope of contacts.

By default, the Name field Excel is associated with HEADING "Name" column that contains itself the "Name" field, the latter you must use or lose contact names when importing. Drag the field Name the left column on the field Name the right hand column (not the topic that includes a [+] or [-] before !!!), once all the associations made, click OK then Finish to start importing.

All times are GMT +5.5. The time now is 10:48 PM.