Searching for the solution to import Excel file into Outlook? MS Excel file act as a Standard spreadsheet which is used to store Excel documents. A spreadsheet is different than CSV File format. A CSV File format store user information in the text file and each value is separated by the comma with each other.
It only stores only the data but no format related stored in it and easily opened in a text editor. Whereas Excel file holds information in both context and any formatting such as formulas, condition, macro details and save in .xls and .xlsx file format, But CSV File file format can help to import excel file into Outlook 2013/2010/2007 editions.
Thus, in this article, we will discuss a complete solution to let users understand how to import Excel file into Outlook Contact list.
Reason Why to Import Excel File into Outlook Contacts List
In different organization, user information stored in different file formats according to work hierarchy. Sometimes these contacts list of employees, customer, client a user should be converted in popular email client Outlook to send emails or any other purposes, which is stored in the Excel file or it can be used for saving purposes for late use.
Manual Steps to Import Excel file data into Outlook
Before moving the data of excel spreadsheet into a Microsoft Outlook client, a user needs to convert the data into CSV format. Outlook application offers an option to import data into configured Outlook account using the Import /Export Wizard. As various Outlook versions available, follow all the steps to Import Excel file into Outlook 2016/2013/2010/2007 contacts.
Save Excel file into Comma Separated Value Sheet
First, you have to convert the spreadsheet file into .csv format. As Both file formats are different, but still excel file converted into .csv format.
- Open Worksheet File.
- Check all details properly >> Now click on File menu >> Save as option.
- Browse the Location to save the file in the configured system.
- Select (*.csv) file format >> Click on Save option.
Now Your Excel sheet converted into .csv format
Different Outlook version used by people, So here we try to discuss, import method for each Version. Option to import excel file into Outlook contacts list in different Outlook edition varies to another.
Import Converted CSV File Into Outlook
As Outlook 2016/2013 are more user-friendly compare to Outlook 2010 & old versions. Some steps to find the option and to import excel file into Outlook 2016 contacts changes. These are minor changes, you can view the instruction to import excel spreadsheet in Outlook 2016.
- Open Outlook 2016.
- Select Open & Export option & click.
- Import/Export[Import or Export files settings] option.
- In Import/Export wizard, Select “Import from another Program or file”. Click Next.
- Select Comma Separated Values option.
- Browse location of CSV File in the configured system.
- Select “Do not import duplicate items” to avoid duplicates. Click Next.
- Now select the Destination Folder[Contacts], In which you want to import Excel data file. Click Next.
- Now In next “Import a File” dialogue box.
- To Map Field, use “Map Custom Fields” option and to change Destination folder, select option “Change Destination” option.
- Click OK. At last click Finish.
- View the Imported Contacts data of Excel spreadsheet in Outlook Contact.
Professional Solution to Convert XLS Files to Outlook
The above solution we explained are capable to import Excel file into Outlook. But the manual solution contains some drawbacks like, manual solution is time-consuming, you should have a basic technical knowledge to proceed with the manual solution. So, we bring up with Excel to Outlook Converter.
For Mac Users
This software provides some attractive features to enhance the working of tool. This software is capable to convert multiple XLS files, allows contact details to convert into Outlook with maintaining details order.
Steps to Convert Excel Files to Outlook Using Software
- First, Install & Open the tool into your device.
- Next, click on Browse button to select the files, need to be extract.
- After selecting files, you get the preview of selected files.
- Then, select PST option to convert into PST file.
- After this, you will get 3 options for conversion, you can select as per your need.
- Click on Browse button to provide the destination for converted files.
- At last, click on Export button to start conversion process.
Now, your selected files which you need to export into Outlook are completely exported.
Conclusion
In this technical write-up, we have discussed multiple solution to resolve the query how to import Excel file into Outlook. we compare both, the manual and the automated solution for the exact solution. We found out the automated solution is much better than the manual solution, the reasons are mentioned above. So, as per our suggestion go with the automated solution.
