Avatar of Rezwan Senobarian
Rezwan Senobarian
Flag for United States of America 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?
Microsoft OfficeOutlookMicrosoft Excel

Avatar of undefined
Last Comment
N8iveIT

8/22/2022 - Mon
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.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
ASKER CERTIFIED SOLUTION
BillDL

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Rezwan Senobarian

ASKER
@BillDL - Bill I don't see Categories as an option. Any idea?
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Rezwan Senobarian

ASKER
YOU SAVED SO many hours of our time./ Many Many Thanks.

This was a great help
BillDL

Thank you Rezwan, and thank you N8iveIT for the supporting screenshots
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
N8iveIT

Thank-you both as well; didn't mean to jump in but thought I would test and post a screenshot to look at.