Prep to Export Contacts

Moving contact information from Excel to Outlook requires saving your spreadsheet as a .csv file. Be sure to click the worksheet within a multiple-sheet spreadsheet before getting started. You now have a copy of your spreadsheet in .cvs format; the original file has not been affected and is closed.

You should now close the .cvs file.

Importing into Outlook

Follow these directions to bring the contents of the recently created .cvs file to Outlook.

Next:

Next:  

Next:

Mapping Fields

The final step is to “map” the fields in your .cvs file to the contact fields in Outlook. Don’t hit to Finish button until after setting this up (see below). You have now imported contacts from a Microsoft Excel spreadsheet to Microsoft Outlook. Click the People icon at the bottom left to see the contacts you imported.

Obviously, you can do more than export contacts in Microsoft Excel. We recently told how you could add bullet points in the spreadsheet powerhouse and wrap text. There are also articles on filtering unique values in Excel and locking certain cells, rows, or columns. For home use, the Microsoft 365 suite is currently available in three varieties, including a Family, Personal, and Home & Student plan. The first is priced at $100 per year (or $10/month) and includes Word, Excel, PowerPoint, OneNote, and Outlook for Mac, and is useful for up to six users. The Personal version is for one person and is $70/year or $6.99 per month. The student plan is a one-time purchase of $150 and includes Word, Excel, and PowerPoint. Business users can select from Basic, Standard, and Premium plans, starting at $5 per user/month. Comment Name * Email *

Δ  Save my name and email and send me emails as new comments are made to this post.

How to Export Contacts from an Excel Worksheet to Outlook - 50How to Export Contacts from an Excel Worksheet to Outlook - 24How to Export Contacts from an Excel Worksheet to Outlook - 52How to Export Contacts from an Excel Worksheet to Outlook - 30How to Export Contacts from an Excel Worksheet to Outlook - 96How to Export Contacts from an Excel Worksheet to Outlook - 38How to Export Contacts from an Excel Worksheet to Outlook - 62How to Export Contacts from an Excel Worksheet to Outlook - 87How to Export Contacts from an Excel Worksheet to Outlook - 44