How to Import Emails From OUTLOOK to EXCEL & why you want to do that!

[@LeilaGharani]

Stay up to date with the latest by signing up to my FREE XelPlus Weekly newsletter: www.xelplus.com/newsletter/

[@OmarAlvi]

pls make us the video for Gmail, as we are desperately trying it and it is not working for us. Moreover now MFA2 is everywhere. How to handle it. pls make a new video as lot of things have changed since this video.

[@user-mma173]

Exchange ≠ Outlook This will not work on local data such as Personal Folders and Archives.

[@utkarshthakur3049]

Ma'am firstly I would like to tell you that I am a huge fan of yours. Your videos really helped me in getting tremendous growth in my career. I just have 2 doubts from one of your videos. In my Excel 365 version I am unable to find Microsoft Exchange in Get Data Option Under Data Ribbon, nor does Get Data File PDF File is showing in my Excel 365 version. I have also updated it in case, but I am still unable to find both these options. Please help me to figure out these errors, and I'll be really helpful to you. Thank you so much. 🙏

[@danielsequeira6142]

the same with me. i don't find that option on excel 365 from a company account business

[@jeroenvanbroekhoven7325]

@@danielsequeira6142 Same here Daniel & Utkarsh... It would have been a great help to track offers etc. but I don't have the option either :- (

[@robertosfsouza2043]

Leila? Amazing lesson! Please do not give up to bring us wonderful excel lessons in finance and engineering. I am sure many many will love these subjects.

[@LeilaGharani]

No worries, more to come :)

[@blasebom7489]

what version of Excel is this please ? I do not have these import possibilities at the menu

[@kets0985]

​@@LeilaGharani Can you please help me if there is any way to extract email information along with attachment names from shared mailbox using web outlook from Chrome browser.

[@kets0985]

​​@Leila Gharani Can you please help me if there is any way to extract email information along with attachment names from shared mailbox using web outlook from Chrome browser

[@AhmadAli-ht6hy]

FYI- the import from Microsoft Exchange Online - feature is only available with an Enterprise License, not a Business Standard User License. :)

[@savedbythekingofkings]

You are correct. This is so frustrating. So many times when i am trying to follow something like this step two the button that is supposed to be there is not. Really puts me off Microsoft.

[@t.cneilson38]

What is power automate? For me, this keeps saying that this can't find my credentials. So another way to do this would be nice

[@monty2ish]

I was delighted to watch this video, to know this is possible. unfortunately I cant find the data import with a Business Standard User License. Has anyone tried the power automate mentioned by Laura B in the comment below? Is there a way around this?

[@questionresearch8721]

Thank you. 🙂

[@dolphinloh7018]

Hi, how to check the License is under which one for my case?

[@janemisc6378]

Wow! I didnt know about this until I watched this video. Your content is very insightful! Thank you so much! Avid subscriber here. God bless and more power to you!

[@paulspray8363]

What do I think? I think you rule! This is a solution to a problem that literally came across my desk today.

[@ellisz5972]

Hmm ... except that my Excel is missing the "From Exchange" option to import. :-(

[@kevinoleary3479]

it appears this feature is only available with entrrprise accounts. Leila, do you have a work-around for business accounts?

[@Amal757]

I found it in Data ->New Query

[@DerlykLandersi]

@@Amal757 which ?

[@realpulsecoin]

This can become a great project manager overview. And so on. You for me Leihla 👏

[@ramasubbukamatchi3026]

hi, i don't have the option, Source from Microsoft exchange , how can i get it ,i am using office 365.

[@alanmonaghan9194]

Same here and I have the latest 365 insider version, but Microsoft Exchange option doesn't exist. I tried this on Power BI but I got a connection error. :-(

[@Mindwiper]

I dont even have the option to get data from Microsoft exchange. Can someone help?

[@Mindwiper]

Ok I found the solution. There isnt :/ It seems this option is only for Microsoft 365 Enterprise

[@ramganeshmaiya6598]

Is this available in all office packs madam? I couldn't find microsoft exchange in Office business version. Is there any way to activate this?

[@aziquaderi]

Hello Leila, I cannot find Microsoft Exchange in the drop down menu from Other Sources. How and where do I get it? Please advise.

[@Monduras]

I found mine in the new query drop down

[@aziquaderi]

@@Monduras can you please show me?

[@Monduras]

@@aziquaderi do you use discord? My id is Mond#5273

[@mrheshamkamal]

Hey Leila, this is not available in Excel 365 Home.

[@danielmain3975]

I love this functionality! Quick question ... can this functionality also pull in daily scheduled emails that contain spreadsheets? If this is possible I'd like to dynamically analyze the spreadsheets. Just looking to see what's possible. Keep up the great work!

[@Kate98755]

mind blown....am implementing this today

[@fjbekkering]

Man, this is great. Finally a fast search functionality for my emails

[@qiranwang]

Can't you search directly from your mailbox?

[@thejonny0208]

The company I am working for they try to save money every time… a specialty on tools and employees :( but they still expect efficiency lol… I hope you guys working for better companies ;)

[@chewbacca5986]

Fabulous! Need to do this for a shared mailbox, I hope it works the same! Thank you!!

[@vaibhavthakkar9127]

Hey! Were you able to do this on shared mailbox ? I am unable to

[@clarkgibson1031]

Thank you for this. I received an error when I tried this in PQ. "DataSource.Error: The requested failed. The remote server returned an error:(407) Proxy Authentication Required." How do I resolve this?

[@cdyard1]

I love Power Query and learning more about it is a joy. Thanks again.

[@JudeBarak]

Hi Leila, Thanks for another great way of using Excel. I am using office 365 with exchange - but I don't see the option to get data from exchange. Is it just an insider option? a specific build?

[@maxknoblock]

You might need to more expensive subscription

[@Ahommel]

Such a great video! I used this to create a call log - but found that recurring events only show once. Everything else works fantastic - thank you for this content! Would love a Pt 2 to this that walks through solving for recurring events. Appreciate all the content you create and thank you again!

[@Montage1NordConnectDE]

Hi, The video is great. But I do not have this option and I am using Microsoft 365. Does anyone knows if I should configurate something first?

[@rfcarty]

So what if you dont have the MS Exchange Server option in Data Source? Is there another way to query emails as such?

[@narayanamurthy6573]

Even I'm facing that right now. Please put it over here if any such other query exists?

[@khalidseada3498]

Likewise. Help please

[@aaronhale3903]

I have Microsoft 365 and On my Excel/Data Tab/ Get Data/ From Other Sources it does not list "From Microsoft Exchange". Any Ideas?

[@FourSeasonsStringQuartet]

Great "how to". Unfortunately not working on Mac running office 365 for mac

[@vedbulland5033]

Leila, a great lesson. I tried importing emails from outlook, but however when i tried the query from other sources, i couldnt find microsoft exchange. How do i proceed if i cant see that option.

[@jonathandavidson2042]

Hi Leila, great video as always!! Question for you- what would you do if your company automatically archives your emails after 90 days and you don't want to lose the data in excel once it comes in. Is there a way to backup the incoming data to a new worksheet? Thanks for your thoughts and keep up the great videos! Best, Jon

[@GixxerGR]

Just looking for a function that automaticly reply to all my e-mails in a better way than I would.

[@matthewv4170]

You can use power automated to flag emails and send replies and put it in your Tasks

[@JonathanExcels]

PQ is awesome. I believe you can also select all those emails in Outlook and drag n drop into a blank spreadsheet for a one-off analysis.

[@exploranza]

Is it possible?

[@skomwulski]

Is there a way to include importing attachments, do the preview of that attachment is visible in that "email excel"?

[@mpugliano]

I think you look amazing only rivaled by your communication skills.

[@johncrow5072]

i think I missed the answer to the second question 'Why' would you want to do this?

[@yonariasgedom2301]

Hey Leila, is it possible to open attachments such as pdf document in excel (once you import the emails to excel)?

[@exploranza]

I don't think it happens. The emails are imported as text, but not with attachments. Correct me if I am wrong!

[@glensimon3011]

This looks awesome, but I dont have the 'From Microsoft Exchange' option. I'm using O365???

[@yaashjut76]

Hi Leila, another wonderful lesson that really helps.

[@utkarshthakur3049]

I am unable to find Microsoft Exchange in Other Sources Tab. Is there any particular reason that I can't choose/find Microsoft Exchange in the Get Data tab.

[@utkarshthakur3049]

Please help someone 🙏

[@davidirish1928]

Great tutorial. Thanks. The emails I'm trying to bring in have tables in the body. How can I bring them in as tables? I can't seem to work out how to do that. Appreciate your input.

[@s.y.daniel2137]

Gonna be a major life saver to organise my work to do! A dynamic and clear-cut list! On the other hand i still dont know the way to export the address book....

[@qiranwang]

Why not just use the task reminder function in Outlook? Why export the tasks to Excel first?

[@javiercabello3573]

This would be an awesome time saver for me ! But How come my Microsoft Excel 365 doesn't have this feature when I click "Get Data - From Other sources"?? Anyone?

[@javiercabello3573]

Ms. Leila Do I need to have a Microsoft 365 for Business?

[@manjuiyer8983]

Loved this tip. Is there a way to download excel attachments from outlook to a specific folder automatically? Thank you.

[@SharathAcharyaputtur]

Within this query you have an option to save the attachments

[@poshpantspaddy]

@@SharathAcharyaputtur What are the additional steps required to save the attachments?

[@RobTiff0818]

Apparently this feature isn't available for M365 Business Premium accounts. It requires an enterprise level account. Not sure why, but the "From Microsoft Exchange" option doesn't exist for me.

[@Michael-mx5bn]

Have you tried to open 365 on a browser , copying the URL and pasting the URL as a file location?

[@akashneeramkelewan1697]

Love the quick tips, they are very useful. Please keep them coming. Thanks Leila

[@michelangekouassi7349]

Hey Leila Thanks for this great video as usual. Really appreciate. However, I couldn't connect my email address when it comes to load tables (mail, people, tasks...). Any idea about this issue? Ps: I use Microsoft O365 Enterprise

[@extrafant03]

The same problem

[@saibaba270]

Leila is it also possible to track the status of each email whether those are replied or not

[@exploranza]

I don't think it happens automatically because once imported the data is in Excel and it doesn't change automatically. Correct me if I am wrong!

[@misterwill3625]

🤯You just blew my mind. Excellent explanation👏🏾I never thought of Outlook as a source file to excel😊I can think of several cases to use this. Now I’m wondering if the excel table can capture responses to those emails to ensure all were addressed🤔

[@nbdcbn]

I feel like I love you, You've taught me so much.. so fast... and your voice is golden.

[@davidadam2551]

What versions of outlook and excel does this work with?

[@jomorley4225]

Love this idea. What happens when you delete the emails from Outlook?

[@damrupunjabi684]

Ya, I also have this query.

[@jorisboris7921]

try it out. then you have the answer.

[@robertw236]

Can you do this with shared emails? To be more specific, I mean I would like to bring in calendar tasks from outlook in to excel from a shared calendar.

[@srinjayc9510]

Never knew I could do so much with excel! I show off the excel skills I learn from your vids and your udemy course, at work! You’re a hero!!

[@prayagpanicker3241]

Hey Leila, the option "get data" is not available in excel, I am using excel in browser, can you please help??

[@AndoSydney]

Love the idea Leila, however I do not have access to Microsoft Exchange in the 'Get Data' list in Excel... any suggestions as to how to access this option?

[@KristinBakerWi]

@Leila Gharani I am in the same boat! Would LOVE to know the workaround for this! (Office 365 - family, not business account)

[@SergeLetunovskiy]

Subscribed. Bell activated‼️. Top notch content. 💪🏻💪🏻👏🏻👏🏻👏🏻👍🏻👍🏻

[@LeilaGharani]

Welcome aboard, Serge!

[@davidingham2216]

Interesting idea. I feel I want to use that but not sure what for. :)

[@LeilaGharani]

😁

[@KacperKonarczak]

Awesoem function :) can I import attachements from mail? I did something similar for the HR team to make it easier for them to sign up employees for internal training but unfortunately I couldn't download anything from Outlook. It was only with the help of PQ from a network drive that I made the records merge.

[@chrism9037]

I’ve never thought of this, great idea Leila!

[@LeilaGharani]

Thank you! 😊

[@KristinBakerWi]

@@LeilaGharani I am trying to do this with our Office 365 family version and I am unable - is this only available in business or do you have a workaround if in excel: data - external sources - Outlook is not an option?

[@anirbanbhowmik8692]

@@KristinBakerWi i have office 365 buisness from my organization but still unable to do it.

[@KristinBakerWi]

@@anirbanbhowmik8692 dang - i was scouring the internet like crazy last night.. in your organization - you might be able to use PowerAutomate and create a flow from outlook to excel. I've used it for my organization with forms and auto-populating into excel and it's super awesome (but only in business or school accts) :) Good luck!

[@woonyoung91]

I don't have this one office 365 biz 64bit as well. Seems to be greyed out. Any solutions?

[@sirtaco2003]

WHAT VERSION OF MICROSFT 365 DOES THIS WORK ON?

[@gintomino4136]

This is excellent! Very useful to record my daily output at work! Thank you!

[@721rima]

Hi Leila, thanks for the tutorial video. Can you share how to connect to outlook using Office 365 running on Mac please?

[@IvanCortinas_ES]

This is a brutal advance Leila. Thank you!!!

[@exploranza]

Indeed!

[@georgedimakopoulos]

I have the Office 365 and I don't have the option "From Microsoft Exchange"... 😥

[@z00h]

"While you're down there" Yes please!

[@monaarab4372]

That is wonderful! More videos about outlook organization & time saving, etc. please.

[@cooloox]

This is such a useful tutorial and so well demonstrated. Thanks Leila. 🙂

[@fidemaster9663]

Hi Leila , how can i make pivot table refresh imadiatly when the source data just changed , without hitting refresh

[@rufatahadov251]

I guess the max u can do is to to have some kinda vba event code. Otherwise u have to press refresh button unless idk sth.

[@emmanuelonuoha3642]

When I want to get some complex office task done, I always refer to the Leila way, which to me has become the easiest way. Thanks.

[@MrLe09]

Hi Leila, Thank you so much for this video. Is there a way to import any user-defined field in Outlook?

[@williamjones1078]

I love this lesson. I was wondering how you would pull the data from a word doc that is copied into the body of the email. Example: The word doc has name, serial number, date, resolution, service detail as headers. The person would fill this form out and then cut and paste it into the body of an email and send. I see the data but it does not show up in its own column in excel.

[@przemel931]

Hello all, this lesson is amazing! One thing I can not find is that how to filter the emails what are flagged in to do list. Any idea is there some attribute what is named differently or maybe to do list is somewhere else (in tasks list they are not show up as well, unless I put reminders- but I do not need reminder, I just want this items flagged)

[@girishpadia6449]

I love your presentation skills. What happens if I delete a row from Excel and hit refresh? Mail will be retained or deleted from mailbox?

[@arunfurtado469]

Your channel is now my favorite. Really useful. Thank you so much for sharing your knowledge. God bless you

[@opensupport4801]

WoW thanks for the value knowledge. Also interested to know how to attach email EML file in excel sheet

[@enricomendiola9952]

Great excel lesson Leila! What if I'm using office 365 for business and microsoft exchange is not availabe what are the alternatives? Do you have any videos related to this? Thank you.

[@dnautu7835]

I have the same issue.

[@enricomendiola9952]

Thank you Leila.

[@EMoscosoCam]

What about importing data from an Attachment sent as an Excel file? Or if the message Body has an Internet link to a downloadable CSV file? Thanks a lot!

[@mmitchum3826]

I would like to see this too.... I receive excel files on a weekly basis via email. Would love to be able to automatically pull the data from those weekly excel files into a single file and do analysis/updates comparing the week over week data.

[@nikhilshahu830]

Maim please please hindi me vidoes upload kre

[@mfmendes1208]

Excellent tip! This helps a lot to manage my inbox and make a proper follow up!

[@davidmosedale4586]

Can you still do this, as I am unable to find outlook in the data import in excel.

[@brianxyz]

You need to use Microsoft Exchange Server as the data source.

[@omotossso]

There's no option for Microsoft Exchange on my machine

[@GpD79]

Leila, your content is always top shelf! Thank you for sharing your expertise with us. Is there a way we can link an excel file to an Outlook calendar to keep track of events? For example, let's say you have a Microsoft Form to keep track of when people are moving in or moving out. Can the form entry automatically link to Outlook calendar and create an appointment for the respective day?

[@franklingeorge361]

Hey Leila, how will you manage if you have more than 1 200 000 rows on Excel (so more than 1200000 mails) with this méthod ?

[@javierpena5146]

Great tool. For sure I am going to try it. But, question. Can you also import Excel data to Outlook emails that you need to send? I use a template in excel to create data I need to send just changing customer name, equimpment serial and job to be done. But I copy a paste this information on the emails. Can I import them some way? Thani you Leila.

[@mrCetus]

I love this functionality! Quick question ... can this functionality also pull in daily scheduled emails that contain spreadsheets? If this is possible I'd like to dynamically analyze the spreadsheets. Just looking to see what's possible. Keep up the great work!

[@tinshatoy5925]

Wonderful Mam... Thanks a lot for all your help. Really appreciate your efforts

[@BryanJenks]

could also add a little VBA code to refresh the connection on a timed interval, or every time you give the worksheet focus you refresh it. Did that on all my pivot tables, every time I updated the source data tables and navigated to the pivot table tabs it would refresh the pivot table data

[@LeilaGharani]

Great tip! Thanks Bryan!

[@smartvisa717]

Hi I deleted my Microsoft 365 app in Windows 10.how I can reinstall it thanks

[@BROOKLYNGROUP-k5c]

Hi Leila, Very nice video, Just a quick question, I have around 64K emails and while downloading it just timed out. Is there any way that the download starts from a specific date? Please let me know.

[@wijnandvaneekelen2418]

Hello Leila, thank you for all your videos,tips etc. It helps me a lot working with and understanding Outlook and Excel mostly. Question: about this video, I was not able to setup the mailconnection via microsoft exchange! Error message: in Dutch: Details: Exchange: Kan geen verbinding maken met Microsoft Exchange Autodiscover Service. Controleer of Autodiscover Service correct is ingesteld en of uw referenties geldig zijn

[@ravinandasana2517]

I am not able to see Get data option in office365 Excel

[@apraghavendra]

Hello Leila, I'm regular watcher of all your Excel ways of working. I've a request. In the same context of this video, i would like to import emails from a Generic Mail Box (GMB). This will not have password. When i tried this, i got error Message "We Couldn't authenticate with the credentials provided", as i've provided only email id but not password. How can this be tackled? Any idea?

[@MickPsyphon]

Okay! Someone's messing with my head, because I was JUST thinking about how to do exactly this!!!! Way cool! 😋👍 Awesome!!! 🙃

[@LeilaGharani]

Thanks! 😁

[@mywifetheartist]

Great informaition but when I open get data and other sources I don't see microsoft exchange??

[@adeelahmed949]

Hi Leila, apparantly this only works if you have an Office 365 Business account or Enterprise Account. The option for getting data from Microsft Exchange isn't available for Office 365 Home Premium. Could I request a workaround tutorial for users such as me as its a really useful feature.

[@omotossso]

Wow.. i keep wowing.... I can share this tip and be a local hero to my team 😂😂😂😂 Absolutely, this tip is what we all need but we never knew microsoft was working to make this an easy one for us... Thanks Leilah for sharing this wonderful tip

[@LeilaGharani]

My pleasure :)

[@evilgenius747]

Details: "Exchange: We were unable to contact the Microsoft Exchange Autodiscover Service. Please make sure the Autodiscover Service is properly set up and your credential is valid." :(

[@shahameedali1222]

If you are looking for Microsoft Exchange option under Get Data, but you do not see this option in your Excel application because there are some features in Get Data which are available only to Microsoft 365 Apps for Enterprise subscription and Microsoft Exchange is one of them. This option is not available in Microsoft 365 Home, Personal, Business, Business Premium.

[@mikewill34]

This is interesting, but WILL suffer from the human failing where people simply reply all and don't change the subject when they should. I told Microsoft at TechEd 2009 that threaded emails / conversation mode will never work 100% whilst humans send emails.

[@TheHellis]

Very interesting! I have something similar created with VBA in outlook but now my outlook is more or less broken so the VBA has to be manually run. This seems like a good alternative. Can it handle the attachments/pictures also? Meaning save them to a folder?

[@1994Jeroen]

Hi Leila, I love your videos, they are very helpfull! I wonder, regarding the connection with all microsoft apps. The power query imports data. Is it also possible to export data to, for example, your callendar from the sheet if you change the data? Kind regards, Jeroen