JSONをCSVに書き出す

# JSONをExcelで開く
import json
import csv

with open('test.json', 'r', encoding='utf-8') as fp:
    data = json.load(fp)

# newline=''なしだと1行空く
with open('test.csv', 'w', encoding='cp932', newline='') as fp:
    writer = csv.writer(fp)
    writer.writerow(['title', 'url', 'file'])
    for row in data:
        writer.writerow([row['title'], row['url'], row['file']])