Home Outlook Free Ways to Import Contacts from Excel to Outlook 2007? Complete Solution

Free Ways to Import Contacts from Excel to Outlook 2007? Complete Solution


Looking for a method to import contacts from Excel to Outlook 2007? You came to the right place; here we are going to introduce a free native solution to export contacts from MS Excel to Outlook.

Multiple users store contacts in Excel for effectively managing them but when they want to share them or to access them from a remote location! Therefore they wish to import their contacts to Outlook. As we all know that in all the Outlook versions users can easily import/export the file using Outlook default Import/Export feature. And we also aware that MS Outlook only supports .csv or .pst file format. Hence in this article, we will describe to you the whole process to import contacts from Excel to Outlook 2007 in a trouble-free manner.

Methods to Import Excel Contacts to Outlook

MS Outlook deals with the CSV file format to import or export the contacts. Therefore if you want to import contacts from Excel to Outlook 2007, you need to save the .xls or .xlsx file into CSV format then you will be able to import that CSV file into Windows Outlook. Read the upcoming section to know how to export CSV file from MS Excel.

Export CSV from MS Excel

  • Open MS Excel and browse the contacts file that need to be exported
  • Now, go to Save As option and select CSV file format
  • Browse the destination folder for the resultant file
  • Hit the OK button to complete the process

This is how one can easily export CSV files from MS Excel. Now follow the upcoming section to import the CSV file to MS Outlook.

How to Import Contacts from Excel to Outlook 2007?

  • Launch your Microsoft Outlook. Navigate the File menu >> Open & Export then choose Import/Export
  • A new Import and Export wizard will appear on your screen select Import from another program and hit the Next button
  • In the next window choose CSV(Comma Separated Values) and click the Next button
  • Hit the Browse button and specify the location for your resultant file. Enable the option do not import duplicate items and hit the Next button
  • Select the folder Contacts of your Outlook and again click on the Next button
  • Under the Next window, you will see that import action is selected. You can also map the custom fields between Outlook contacts and Excel file by clicking on Map Custom Fields
  • A new Map Custom Field will appear on your screen in this you can map the source file values to values in contacts. Enable the options as required under mapping and hit the OK button
  • Finally, click on the Finish button.

All your Excel contacts get exported soon. You can also view it now in your Outlook application in the Contacts folder

So you only need to read the throughout process very carefully to import contacts from excel to Outlook 2007 while facing any issue with your excel-like unable to access, open, error pop-ups, etc. We provide you this SysTools Excel to Outlook converter tool to import contacts from Excel to Outlook 2010. It is highly compatible with all the versions of the Excel Server.

The tool is capable to import MS Excel files directly to the MS Outlook folder while mapping attributes. The all-in-one solution designed in such a way that even non-technical guys can easily do it without any hindrance. Download the demo version of the tool from the below link.
how to migrate lotus domino to exchange server


The Import and Export feature of Outlook helps to import contacts from excel to Outlook 2007. By the above tool, one can easily export contacts from excel. This tool enables you to move a large number of contacts from Excel with details to Outlook in a trouble-free manner the tool has multiple additional features download the tool to check them out.