- How to import contacts into outlook 2013 from excel how to#
- How to import contacts into outlook 2013 from excel full#
Step 2: Click the File tab at the top-left corner of the window. But since we are focused on exporting the Outlook contacts to a file format that can be read by Microsoft Excel, follow the steps below. Instead, you must first convert it to a CSV file and import contacts from CSV to. Step 1: Save Distribution List as Text file Step 2: Open the saved Text file in Microsoft Excel Step 3: Save Excel file as CSV file Step 4: Import CSV file. I also selected 'Do not enter duplicates' and then mapped out the entries. In the Import a File box, browse to your. Choose Comma Separated Values, and then choose Next. This starts the wizard Choose Import from another program or file, and then choose Next.
How to import contacts into outlook 2013 from excel full#
This is not beneficial for the purpose of viewing your contacts in Excel, but can be helpful if you need to copy contacts from Outlook on one computer to Outlook on another computer. However, the software does not accept full Excel workbooks with many pages. I've imported several times with different results and finally figured out the 'name the range' rule and to save the Excel worksheet in the 97-2003 format. At the top of your Outlook ribbon, choose File. Use a comma separated values file (CSV) to import your contacts into. csv file format, you will be given the option to alternatively export them to a. Outlook has an Import/Export wizard that makes it easy to import contacts from a CSV file. csv Fileĭuring the process of exporting your Outlook 2013 contacts to the. csv file that you can view in Microsoft Excel. Fortunately you can export all of your contacts from Outlook 2013 to a.
How to import contacts into outlook 2013 from excel how to#
Aside form storing information about how to get in touch with friends, family, coworkers or clients, it also makes it easier to perform certain tasks, like making distributions lists.īut whether you simply want to create a backup of this information to prevent it from being lost, or you need to view all of your contact information in one file to combine email addresses or phone numbers, the ability to put that information in a spreadsheet that Excel can read is very helpful. The information that you have stored for your contacts in Microsoft Outlook 2013 can be useful for a number of different reasons.