Step 1: Prepare an excel sheet with all the required columns.
|User ID||First name||Last Name||Group or role||Email address|
Step 2: Click on the option Step By Step Merge Wizard in MS word document
Step 3: Select the radio button next to Letters on the right pane and click Next
Step 4: Choose radio Button next to the Use Current Document and click on Next
Step 5: Click on Browse and chose the excel file created
Then copy below in the word document =
Step 6: Map the columns with the required fields after you copy the format from an existing exported user file
now map this fields with the corresponding excel fields. To map this put cursor on uid and click on Insert merge field as shown below. Complete this for all fileds
Once you click on ok you will get all excel fields & their value mapped. Now just select all from word document and paste into one text file.
Step 7: Login to SAP Portal User administration and go to User administartion – Import
All the users in excel got created now.