S
S
shledon2022-01-13 18:46:55
Active Directory
shledon, 2022-01-13 18:46:55

How to import users from .xlsx file to AD Users and Computers?

From the .xlsx file, only users need to be imported into the users department, what are the ways? I saw only scripts but could not figure out how they work, if the script is the only way, help me understand how it works.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexey Dmitriev, 2022-01-13
@shledon

Powershell will help you.
Import-CSV will help you import the csv file,
the New-ADUser cmdlet will help you create users,
and ForEach will help you run the entire list from the file line by line.
If you're trying to figure it out, ask specific questions.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question