How to export email addresses from Excel using Powershell

Asked By 10 points N/A Posted on -
qa-featured

I have a very long list of names, first names, last names and middle names in Excel, but I only care about those that have email accounts. If I could loop through the excel sheet and get the email and OU then export it to the excel sheet, that would really be great. Can I do this in Powershell? How do I actually go about doing it? Thanks!

SHARE
Answered By 0 points N/A #199827

How to export email addresses from Excel using Powershell

qa-featured

Hello,

 

Powershell is not necessarily the best tool for this task. It is not designed with this use in mind, or frankly any practical use. I suggest scripting in Python. There are fully developed python libs and other tools specifically for this purpose. You can quickly create what you need. There is a wealth of information online including documentation, sample code, and assorted guides for various tasks. Utilizing a search engine should yield all the information very quickly.

Login/Register to Answer

Related Questions