The contact information you have in your Outlook account can be useful in many other areas.
But you might want to consider manually copying and pasting that data, or re-entering it when you want to use it there.
Luckily, there’s a faster way to do this by exporting your Outlook contacts to a CSV file, which you can then open in applications like Microsoft Excel or Google Sheets.
How to View Outlook Contact Information in an Excel Spreadsheet
- Open Outlook.
- Click the “File” tab.
- Select the “Open and Export” option.
- Select Import/Export.
- Select Export to File and click Next.
- Select comma-separated values and click Next.
- Select “Contacts” and click “Next”.
- Choose a name and location for the file, then click OK.
- Click “Next.
- Click Done.
Our guide continues below with more information on how to export Outlook contacts to Excel, including images of these steps.
The information you have saved for your contacts in Microsoft Outlook 2013 can be useful for a number of different reasons.
In addition to storing information about how to contact friends, family, colleagues, or clients, it also makes certain tasks easier, such as building mailing lists.
But if you just want to back up this information to prevent it from being lost, or if you need to view all your contact information in one file to combine email addresses or phone numbers, being able to put this information into a spreadsheet that Excel can read is very healthy.
Luckily, you can export all your contacts from Outlook 2013 to a CSV file that can be viewed in Microsoft Excel.
Google Calendar information can also be viewed in Excel. You can learn more in our tutorial on exporting Google Calendar to Excel.
Export Outlook Contacts to .csv File (Illustrated Guide)
During the process of exporting Outlook 2013 contacts to a .csv format file, you will be given the option to alternatively export them to a .pst file.
This is not useful for viewing contacts in Excel, but can be useful if you need to copy contacts from Outlook on one computer to Outlook on another computer.
But since we are focusing on exporting Outlook contacts to a file format that can be read by Microsoft Excel, follow these steps.
Step 1: Launch Microsoft Outlook 2013.
Step 2: Click the “File” tab in the top left corner of the window.
Step 3: Click “Open and Export” in the column on the left side of the window.
Step 4: Click the Import/Export button.
Step 5: Select the option to export to a file, then click the “Next” button.
Step 6: Select the Comma Separated Values option, then click the Next button.
Step 7: Select the “Contacts” option under “Personal Folders”, then click the “Next” button.
Step 8: Click the “Browse” button, enter a name for the exported file in the “File Name” field, select a folder for the exported file, then click the “OK” button.
Step 9: Click the “Next” button.
Step 10: Click Finish.
Now that you know how to export Outlook contacts to a CSV file, you can back up this file or use it in other applications that support CSV import.
Need to buy gift cards for someone but are looking for an option that’s a little more personal than the regular ones you’ll find in stores?
amazon gift cards can be embellished with your own images and can be created in several different denominations. You can even create video gift cards.
#export #Outlook #contacts #Excel
❤ XOXO ❤