Skip to content

How to export Outlook 2013 contacts to Excel

How to export Outlook 2013 contacts to Excel

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

  1. Open Outlook.
  2. Click the “File” tab.
  3. Select the “Open and Export” option.
  4. Select Import/Export.
  5. Select Export to File and click Next.
  6. Select comma-separated values ​​and click Next.
  7. Select “Contacts” and click “Next”.
  8. Choose a name and location for the file, then click OK.
  9. Click “Next.
  10. 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.

click the Open and Export button

Step 4: Click the Import/Export button.

select the

Step 5: Select the option to export to a file, then click the “Next” button.

select export to file

Step 6: Select the Comma Separated Values ​​option, then click the Next button.

export Outlook 2013 contacts as csv file

Step 7: Select the “Contacts” option under “Personal Folders”, then click the “Next” button.

select contacts folder

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.

enter a name for the exported file

Step 9: Click the “Next” button.

Step 10: Click Finish.

create contacts CSV file

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 ❤

Leave a Reply

Your email address will not be published. Required fields are marked *