How to import contacts from Excel to Outlook

[@debbiejowen3062]

I spent hours trying to import my long contacts list from WLM to Outlook and was getting very frustrated! This tutorial was so easy to follow and I had my contacts successfully imported within minutes. Thank you so much!

[@charlesturi2180]

hi, when i go to mapping on the left handside it doesnt look like yours where i can drag and drop on to the right hand side. it looks like: name,email,cell number. so when i select it copies that whole line

[@samterracina]

Melissa - You are very easy to follow. My end goal is to create a texting group without having to build it manually. I volunteered to help someone create this group, but now I'm struggling. I created the CSV and pulled it in, but I didn't see a way to store the new group separately. It also didn't give me the option to manually map it. I'm on the desktop version of Outlook. Is it only possible on the web version of Outlook? Thanks.

[@jesseserranoll39]

I really enjoyed your laid back presentation and, being from Texas, I appreciate your accent! (finally someone I can understand who isn't mirroring video game graphics to amp up their presentation. I only wish your screen were clearer. It is very "soft" and unfocused. Otherwise perfect. Keep up the great work!

[@MelCompton]

Hello! It is in HD (1080) so I'm not sure what is unfocused. I will look into it but it might be on your side.

[@theoneandonlykeem]

Thank you so much. Figuring this out actually counts as extra credit for my grade. WOOHOO!

[@MelCompton]

This is great! They didn't say how you had to figure it out. I am so happy it helped you get extra credit!

[@dyannepauline]

This is so spot one, Melissa! Thanks for such a detailed and quick tutorial on how to import contacts!

[@robertnormandia5501]

NICE!!! This was SO easy - THANK YOU! The latest version of Outlook already has the street, city, state , email etc populated in the destination so there was no need to "click and drag" during the final steps! Can't wait to see what other Microsoft pearls you have!

[@caitlynbales]

Hi Melissa, very helpful video! I'm looking to create a Power Automated workflow to help manage the Contacts and Distribution Lists for work, but I haven't been able to find any Power Automate videos importing data from Excel into Outlook Contacts. Do you maybe have some tips for how I can get started?

[@kevindavis8607]

Thank you for this video. You saved me so much time.

[@MelCompton]

Thank you! I'm glad it helped!

[@lindajones8680]

Thank you! I loved that we wiped out, made a few mistakes, more true to life ;) good for learning!

[@shanewars89]

Thank you I knew how to import but the mapping really helped out thanks

[@MelCompton]

Thank you so much! I am glad this helped you!

[@nancybennett7336]

You are an excellent instructor!

[@ElioPerez-lv3fo]

Hi; Everything is clear and well explained, but I don't know how to import contacts because my outlook is 2021 and it is different. Could you help me with this matter ?

[@TheClaudos]

This video was so helpful and easy to follow. Thank you

[@christochiramukhathu4616]

Surely I found it helpful. Thank you and God bless you.

[@gefflynn7171]

Boom, perfect! Thanks for saving me a bunch of time.

[@starfire1609]

This was so helpful!! Thank you!

[@MelCompton]

Thank you! I so glad it helped!

[@Bayatty]

This video helped me alot thank you so much. I wanted to import gmail contact to outlook but it did't show the name and email in the contact folder. then I tried your method and it saved me 😊

[@goldensleeves]

Great video. But does this create a distribution list so I can email all those persons at once?

[@MelCompton]

Hello! No, but it can be done. I will get a tutorial out on how to do this as soon as I can.

[@ogbutterflies7039]

This is great, but I am having trouble with one thing. I have added my own custom fields to Outlook Contacts and I do not see them pop up when mapping the categories from my CSV to my Excel sheet. Is there a way to fix/ overcome this?

[@immobilieninvestmentsinden9651]

How do I make sure, the imported list is a separate list if I don't want to mix it up with my other contacts?

[@memegwesisutherland963]

Can you make an updated tutorial of this. My Outlook looks nothing like this. I can't even find the import button. I've been searching KZbin and unable to find a current tutorial for importing a contacts from an excel sheet to Outlook Contact List.

[@MelCompton]

Are you using the desktop version? If so is it the “new” Outlook experience?

[@lenasvisionyoutube]

HELP! When it comes to mapping, all the values are together. It's email;name;etc and I can only assort it to one catagory. help?

[@moklys]

The same thing happened to me :(

[@moklys]

I found solutions for this problem. Settings- Region and Language - Customize Format - List separator: should here is the sign: , I had a semicolon there ;

[@michaelangeloquiroz9050]

Wow. Thank you so much. This helped me a lot.

[@mamdouh733]

Thank it was very helpful

[@JackieTBritt]

Hi, I get through to the wizard but Map is grayed out and everything is frozen from that point on. Help please--I have Outlook 365

[@MelCompton]

Are you using 365 online?

[@JackieTBritt]

yes@@MelCompton

[@SocraticTroller]

Great job!

[@diwang6761]

Thank you very much!

[@MelCompton]

Thank you! Glad it was helpful!

[@Livelarge86]

thank you sooooooo much!

[@rogermaris1965]

very helpful, thank you

[@irmulc]

I don’t have a contacts folder to import to. Whyyyyyyy??????😤

[@Sushil-Mukul]

Gr8 😊😊😊

[@ssarguro]

My ceviche only has email addresses, no names. This doesn’t work

[@deniko74]

to whom ho has only one row at outlook's mapping window like as 'name,email,cell number etc.' Open your .csv file in Word. Do you see millions of ; instead of , (comma) ? This is the reason that I personally found. Replace all ; marks with , because outlook doesn't recognize ; mark. Save your file and try to import again. My one worked well.

[@KlaudiaChruszczyk]

Thank you very much for this video, really helpful. Great job!

[@OttoTyson-er5cv]

Wonderful thank you!