asked on

Pasting outlook contacts in excel

I am trying to copy and paste outlook contacts to excel. some of the contacts have mailing addresses and when pasting to excel the address, does not go under the address column and it is being appeared right under Full Name column. So, is there anyway that I can make excel to paste the address under the correct column?

BillDL

Probably the easiest way would be to export the Outlook contacts to a *.CSV file (comma-separated values). Open the *.csv file in Excel, format and move the columns around as required, and save as an Excel file.

In a CSV file each of the fields like first name, last name, address 1, address 2, etc, are separated by commas. if there is no value in a particular field you just get two commas together. Excel knows how to handle this and will create an empty cell under that column.

Rezwan Senobarian

ASKER

We have over 200 Categorize in outlook and I only need some of those not all. I don't think there is a way to only export the category that I need.

BillDL

I do not have Outlook on the computer that I am currently using and it has been a number of years since I last exported Outlook contacts to CSV format, but from memory I felt sure that you were presented with a "wizard" sequence of steps where you could choose which fields you wanted to include in your output file. There is no mention of it here:
https://support.office.com/en-us/article/export-contacts-from-outlook-10f09abd-643c-4495-bb80-543714eca73f
so perhaps I am mistaken.

ASKER CERTIFIED SOLUTION

BillDL

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Rezwan Senobarian

ASKER

@BillDL - Bill I don't see Categories as an option. Any idea?

SOLUTION