convert .json file to .csv

I have the following .json file:

data:	
    0:	
        area_code	"1A40"
        blacklist	0
        cost_center	"Payments "
        country	"Colombia"
        created_date	"Thu, 03 Jul 2014 12:57:02 GMT"
        .
        .
        .
    1:
        area_code	"1A42"
        blacklist	0
        cost_center	"Payments "
        country	"Colombia"
        created_date	"Thu, 03 Jul 2014 12:57:02 GMT"
        .
        .
        .
    2:{...}
    .
    .
    .
    1000:{...}

next url: "eyJzdGFydElu...="

I am using the following code to convert my .json file to csv :

import pandas as pd
df = pd.read_json('Data.json')['data']
df.to_csv('file.csv')

when I open the file from google sheet it brings me this way:

What I'm needing is for the information to be listed in the sheet without repeating the headers for each cell

Maybe you could tell me how I can list it like this?

You can try:

import json
import pandas as pd

with open('data.json', 'r') as f_in:
    df = pd.DataFrame(json.load(f_in)['data'])

print(df)

#to save to CSV:
#df.to_csv('file.csv')

Prints:

  area_code  blacklist cost_center   country                   created_date
0      1A40          0   Payments   Colombia  Thu, 03 Jul 2014 12:57:02 GMT
1      1A42          0   Payments   Colombia  Thu, 03 Jul 2014 12:57:02 GMT

Contents of data.json file:

{
    "data": [
        {
            "area_code": "1A40",
            "blacklist": 0,
            "cost_center": "Payments ",
            "country": "Colombia",
            "created_date": "Thu, 03 Jul 2014 12:57:02 GMT"
        },
        {
            "area_code": "1A42",
            "blacklist": 0,
            "cost_center": "Payments ",
            "country": "Colombia",
            "created_date": "Thu, 03 Jul 2014 12:57:02 GMT"
        }
    ]
}

You have to expand the dicts in the list. you can do this:

import pandas as pd
df = pd.read_json('Data.json')['data'].apply(pd.Series)
df.to_csv('file.csv')