How to export email addresses from Excel using Powershell

Asked By ayannahana 10 points N/A Posted on - 07/01/2014

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!

• Status: Open
• Question Views: 620
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Server Software

Answered By Nortan gabriel 5 points N/A #199827

How to export email addresses from Excel using Powershell

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.

About Nortan gabriel

Questions
0

Answers
157

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 01/29/2015
• Question Category: Server Software