MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


Take me to MyPage
I'm not curious

IT Career Development Platform

IT Career Development, Progression, Coaching, Jobs | MyTechLogy
You are here: Home / IT Blogs / IT Blog View

Export Excel Spreadsheet to Outlook Contacts with Easy Solutions

Published on 17 March 18
0
0
Export Excel Spreadsheet to Outlook Contacts Without any Hassle

Microsoft Excel is commonly used for saving the records, contacts, calculations in a properly organized manner but data stored in Excel spreadsheets are only available on the system. If a user wants to access those data from any remote location through Outlook application then it is not accessible. If people want to access their Excel contacts in their Outlook account profile then one must have to export Excel spreadsheet to Outlook account.


This page describes the most appropriate and easiest method to export Excel file to Outlook contacts. If you are aware of the Excel features then you can perform the method easily and if not, then another suitable method is also available.

Approaches to Export Excel Spreadsheet to Outlook Contacts

It is one of the easiest methods for adding Excel Spreadsheet to MS Outlook. This procedure can be easily performed on any version of Microsoft Office. Also, Outlook application must be installed into the system in which Microsoft Excel is present. In this situation, this method will work. Now, let’s get started, there are following three important steps:


  1. Save the Excel data into .csv file format in a proper way.

  2. Importing contacts of Excel to Outlook application, using Import feature.

  3. Strictly, MAP all the Excel contacts field with Outlook Contacts field.

Step 1: Conversion of Excel data into .csv Format:

  1. Open the Microsoft Excel on the system.
  2. Then open your workbook. Click on File tab, a drop-down menu will appear.
  3. Go to Save As option, a new dialog box will appear. Choose the desired location and the type of the file and save the file in CSV format.
  4. After the completion of the third step, a message will appear that convey this Some features in your workbook might be lost if you save it as CSV (Comma delimited). This refers only to limitations of the CSV file and can be ignored.
  5. Click Yes to save the file as CSV format. After that your .xls/.xlsx file will be close.
  6. Now, close your CSV file.
1
Step 2: Import CSV file to Microsoft Outlook:

  1. Open MS Outlook account in the system.
  2. Click on File tab, a drop-down menu will open. There is an option Open & Export, click on that.
  3. A box will appear, Select Import from another program or file and then click Next.
  4. A new dialog box will appear and for Import a File, Select Comma Separated Values and click Next.
  5. Click on the browse, then select that CSV file that you wants to import into MS Outlook. Some radio buttons also appear in the box, if you want to export the Excel contacts and import them into Outlook then always select the first option.
  6. Navigate the location of CSV file in Outlook contacts and then click Next.
  7. A checkbox will appear of the name Your File Name.csv into folder: Contacts.. Tick the checkbox and do not click on Finish button.
To export Excel spreadsheet to Outlook contacts, there are three steps to be followed. Two steps are already discussed above, first is to save Excel data into .csv format file, second is to import contacts of Excel to Outlook application and the third is discussed in the next section.
Step 3: MAP Excel fields to Outlook fields:

  1. After Selecting the checkbox, you have to click on Map Custom Fields....button. A new dialog box will appear.
  2. This dialog box contains the fields of CSV file such as Name, Contact etc. in a From Column and Outlook fields in the To Column. Now, this is a user responsibility to map the same field of CSV file with Outlook Field.
  3. Once mapping procedure is over, click on Finish button.
  4. Contacts from Excel Spreadsheet are successfully added to MS Outlook.
Limitation of the Direct Method:

  • The direct method has certain limitations:
  • It cannot support multiple files to Export into Outlook contacts.
  • After the file conversion of .xls/.xlsx into CSV. A user can no longer preview that file again.
  • It cannot exclude the duplicate contacts.
  • If the mapping is not done properly, then it will disorganize all the fields.
  • Have to face multiple options, that will create confusion while performing the method.
Experts Choice to Export Excel Spreadsheet to Outlook Contacts
If a user has less data then the direct method can be applicable but moving on the big organization that has large storage and wants to convert or transfers Excel spreadsheet to Microsoft Outlook contacts, without wasting any time on that, then this dynamic Excel to Outlook Converter tool is for you. The application can smoothly Export the data from the Excel to Outlook. Also, providing several features that cannot be given by the direct method such as Export number of files into Outlook, configure the Excel file directly in the Outlook, proper Mapping is performed by the tool, excluded all the duplicate contacts during the conversion. There is only one requirement of this tool, that Outlook must be installed on the same machine where Microsoft Excel is present.
Conclusion

The following methods for Export Excel Spreadsheet to Outlook contacts depend upon the user data size. If a user wants to export small data of Excel to Outlook, then the direct method can be run easily. If the export data is available in bulk then a user can go for the tool to export the data.
This blog is listed under Data & Information Management Community

Related Posts:

Microsoft Outlook

 
Post a Comment

Please notify me the replies via email.

Important:
  • We hope the conversations that take place on MyTechLogy.com will be constructive and thought-provoking.
  • To ensure the quality of the discussion, our moderators may review/edit the comments for clarity and relevance.
  • Comments that are promotional, mean-spirited, or off-topic may be deleted per the moderators' judgment.
You may also be interested in

IT Skills for your Career Progression
Tips to improve MySQL performance
Are you new to MyTechLogy?
Click here to learn more
 
Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top