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?
Rezwan SenobarianAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

BillDLCommented:
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.
0
Rezwan SenobarianAuthor 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.
0
BillDLCommented:
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.
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

BillDLCommented:
Yes, it is possible to choose the  fields.  Perhaps this will help:
https://www.contactgenie.info/understanding-outlook-contact-exporting/
The video is on YouTube:
https://www.youtube.com/watch?v=WNVjdCP5bUU
The important step is at 3:04
You tick the box and then click the "Map Custom Fields" button.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Rezwan SenobarianAuthor Commented:
@BillDL - Bill I don't see Categories as an option. Any idea?
0
N8iveITCommented:
Since BillDL doesn't have Outlook available, this is to support what he said ... it is on mine ...

Outlook, Import / Export, To File, Map Custom Fields (Outlook 2016 Client)
I would Export everything, turn the CSV into a table, manipulate it how you need it to be, filter out what you don't need then copy the final table into a new sheet and you have the spreadsheet (or at least the basic format) you need.
1
Rezwan SenobarianAuthor Commented:
YOU SAVED SO many hours of our time./ Many Many Thanks.

This was a great help
0
BillDLCommented:
Thank you Rezwan, and thank you N8iveIT for the supporting screenshots
1
N8iveITCommented:
Thank-you both as well; didn't mean to jump in but thought I would test and post a screenshot to look at.
1
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.