import pandas as pd from io import BytesIO excel_ = BytesIO(response.body) df = pd.read_excel(excel_) records = df.to_dict('records')