xxxxxxxxxx
Data(Top bar)>>Get Data >> From File>> From JSON
Select File>>Import
(You can do changes now)
To Table>>(optional: Choose options)>>Ok
>>Choose the required columns and check use original name as prefix(if needed)>>Ok
>>close & load
https://www.howtogeek.com/775651/how-to-convert-a-json-file-to-microsoft-excel/
xxxxxxxxxx
import pandas as pd
# Assuming the JSON data is stored in a file called 'data.json'
json_file = 'data.json'
# Load the JSON data into a pandas DataFrame
data_frame = pd.read_json(json_file)
# Convert the DataFrame to an Excel file
excel_file = 'data.xlsx'
data_frame.to_excel(excel_file, index=False)
xxxxxxxxxx
import pandas as pd
# Replace 'path_to_excel_file' with the actual path to your Excel file
data_frame = pd.read_excel('path_to_excel_file.xlsx')
# Convert the data frame to JSON and specify the orientation as 'records'
json_data = data_frame.to_json(orient='records')
print(json_data)