Microsoft Excel is the best program to store your address book contact details. Its layout has been designed in such a manner that you can process your data in different ways: Combine multiple contacts in one, merge different files with emails. Once you have shaped your data in the desired manner, you can import contacts to Outlook from Excel. One can easily move contacts into Outlook address book by following two simple steps:
Step1: Firstly, open your Excel worksheet and import the required contacts into it.
Step2: Now, go to the File menu and scroll down towards Save As option. Select CSV as a saving format.
Step3: Excel will show the following message: The selected file type does not contain workbooks that contain multiple sheets. Just click on the OK tab.
Step4: Once you Save it another message displays on the screen as shown in the screenshot: Some features in your workbook might be lost if you save it as CSV (Comma delimited). Ignore this notification and hit on Yes. Close your newly created CSV file.
Done with the Excel process. Now you can easily import Excel data into Outlook contacts
Step1: Open MS Outlook and on the top of the screen, Go to File menu.
Step2: Now, select Open & Export and thereafter Import/ Export.
Step3: Pick Import from another program or file option and hit on the Next tab.
Step4: Select Comma Separated values and press on the Next button.
Step5: Now, in the Import A File dialogue box, browse your CSV contacts file and double-click on the particular file for selection.
Step6: There will be three options by which you can manage your duplicate contacts: Replace duplicates with items imported, Allow duplicates to be created, Do not import duplicate items.
Step7: Now, click on Next and enable the checkbox of the Import “Mycontacts.csv” option. Hit on the Finish tab and MS Outlook starts to import contacts.
Step8: You can see your contacts at the bottom of the Outlook screen, choose People icon as shown in the screenshot.
That’s it! This manual solution will work for all versions of Outlook. There are so many users who want to import CSV contacts to PST format. However, they got stuck when they want to achieve the same. In such scenarios, a reliable automated solution works best. In the coming section of the blog, we will describe such a utility that will enable you to bulk import contacts to Outlook PST.
If you want to import a list of contacts into Outlook PST and VCF format, you can easily do this using CSV Contacts converter utility. With this wizard, you can easily upload single as well as multiple contacts into Outlook PST format. It has been specifically designed to convert CSV contacts files to PST (Personal Storage Table) and VCF (Virtual Contacts File). It is quite helpful to import contacts to Outlook application. This wizard creates a Unicode PST file that is compatible with all the latest and earlier versions of Outlook. In this way, you can transfer contacts into Outlook address book of 2016, 2019, 2013 and prior versions. It provides the facility to combine various CSV files data to a single PST file. For an illustration, if you select 100 CSV files then it will create single 100 PST files. Later, you can take this PST file and import it into MS Outlook. The batch conversion feature of this software will help you to move contacts to Outlook 2016, 2013, 2010, 2019 address book in bulk. This saves a lot of user’s time and effort.
Ques1: How to import an excel file into Outlook contacts of 2007 editions?
Ans: You can follow the above guidelines described in the article to add contacts into Outlook from excel.
Ques2: Can I import CSV contacts to Outlook 2019?
Ans: Yes, you can easily transfer CSV contacts into an excel spreadsheet and thereafter import contacts to Outlook.
Ques3: I have used this method to import contacts to Outlook from Excel spreadsheets. But, I don’t know where can I find contacts in Outlook?
Ans: Once you open the Outlook application, go to the bottom. It will show four options: Mail, calendars, People, and File. Click on the People icon to see your imported contacts to Outlook.
I regularly maintain my excel spreadsheet to manage my business and personal contact information. Recently, I started using MS Outlook for meeting my communication deals with my clients. Actually, I I was looking to know how do I import contacts to my Outlook account. I am a regular follower of Bitrecover software and once I came to know about this CSV file to Outlook conversion utility, I purchased it. I can affirm this product will resolve all your worries related to importing contacts to Outlook from CSV format.
This blog covered up all the points that are necessary to import contacts to Outlook. The standard solution for importing contacts into MS Outlook is very easy. One can easily do it without seeking any sort of technical assistance from anyone. If you still have any technical queries related to this, you can contact to our technical supoort team.