If you want to do this with just python, you probably want to first read your Excel file with pandas ( ). When you have all the data read in, you need to use individual data changing commands (psspy.busdata3, branchdata3, etc.) to input it to your case.