import pandas as pd from tracking.models import Transaction excel = pd.read_excel('shipmentTracking.xlsx', sheet_name='Sheet1') col1 = excel['ShipmentID'].tolist() col2 = excel['PreDONo'].tolist() col3 = excel['Delivery Order No'].tolist() col4 = excel['Net Weight Qty'].tolist() col5 = excel['Weight Out Date'].tolist() #print(col1[0],col2[0],col3[0],col4[0],col5[0]) for a, b, c, d, e in zip(col1, col2, col3, col4, col5): new = Transaction() new.shipment_id = a new.pre_do_no = b new.delivery_order_no = c new.net_weight_qty = d new.weight_out_date = e new.save() print('success')