How to loop through rows and columns and enter data into SAP

Hi ,
I need to automate an excel containing 3 columns with 100 rows . The first column contains plant names (ex. AST5,AST6) nd second column contains storage locations to be created for each plant (ex.0001,0002,… etc) how do I create only storage locations for a single plant and continue to loop for next Plant
AST5 0001 NEW
AST5 0002 NEW
AST5 0003 NEW
AST6 0001 NEW
AST6 0002 NEW