Importing CSV to Populate AD Profile

Posted on 2016-10-21
Medium Priority
Last Modified: 2016-10-27
I've started using a 3rd party program to streamline our email signatures, which pulls from the AD profile. I haven't always filled in the relevant information in the users' AD profiles and I was wondering if there was a way to export the profiles into Excel, fill out the needed items and then import it back into AD? That seems easier than going one by one through the profiles. Thanks!
Question by:itgolfer
LVL 27

Assisted Solution

skullnobrains earned 1000 total points
ID: 41854136
any free ldap browser will be able to export/import to/from various formats. most handle csv. so does excel. that should be workable but remember that excel works as a table and an ad is more like a tree. in your case it should not be too cryptic, though since you should have a reasonable number of single-valued fields to deal with.

it is quite likely that working through the users using ldap queries such as "tell me which users have this field empty" would be simpler
LVL 44

Accepted Solution

Adam Brown earned 1000 total points
ID: 41854235
AD powershell makes it pretty easy to do, but it may require some finesse to get things added back, since it requires set-aduser, which doesn't give the option to modify all AD attributes.  https://www.adamfowlerit.com/2014/08/updating-active-directory-from-a-csv/ has a short guide.
https://support.software.dell.com/download-install-detail/5024645 has the ActiveRoles powershell console, which is much better at doing things, can let you export all AD attributes to a CSV, which can then be opened and modified in Excel. It's similar to AD Powershell, but gives more capabilities with the cmdlets it has.

Otherwise, http://www.techrepublic.com/blog/data-center/simplify-admin-tasks-by-exporting-active-directory-data-with-csvde/ CSVDE is a good solution for doing what you want.

LDIFDE is a more capable version of CSVDE: https://msdn.microsoft.com/en-us/library/bb727091.aspx

Author Closing Comment

ID: 41862840
Thanks for the suggestions!

Featured Post

Easily manage email signatures in Office 365

Managing email signatures in Office 365 can be a challenging task if you don't have the right tool. CodeTwo Email Signatures for Office 365 will help you implement a unified email signature look, no matter what email client is used by users. Test it for free!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

If there is anything erroneous with Exchange Database, it causes a significant effect on email communication till the user remounts the database. Further, database crash directly affects Outlook users due to which they are unable to access their ema…
Seizing the Operation Master Roles in Windows Server 2016 in case of FSMO holder failure.
This video demonstrates how to sync Microsoft Exchange Public Folders with smartphones using CodeTwo Exchange Sync and Exchange ActiveSync. To learn more about CodeTwo Exchange Sync and download the free trial, go to: http://www.codetwo.com/excha…
This video tutorial shows you the steps to go through to set up what I believe to be the best email app on the android platform to read Exchange mail.  Get the app on your phone: The first step is to make sure you have the Samsung Email app on your …
Suggested Courses

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question