We help IT Professionals succeed at work.

Pasting outlook contacts in excel

90 Views
Last Modified: 2018-09-25
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?
Comment
Watch Question

CERTIFIED EXPERT

Commented:
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.

Author

Commented:
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.
CERTIFIED EXPERT

Commented:
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.
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
@BillDL - Bill I don't see Categories as an option. Any idea?
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

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

This was a great help
CERTIFIED EXPERT

Commented:
Thank you Rezwan, and thank you N8iveIT for the supporting screenshots
CERTIFIED EXPERT

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

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.