demo:
import pandas as pd def trans(): df = pd.read_json("result.json", lines=True) df.to_excel("result.xlsx")