Convert JSON to CSV

Need help APIs
1

I’m trying to convert JSON to CSV

[
{
“name”: “Harry Potter”,
“city”: “London”
},
{
“name”: “Don Quixote”,
“city”: “Madrid”
},
{
“name”: “Joan of Arc”,
“city”: “Paris”
},
{
“name”: “Rosa Park”,
“city”: “Alabama”
}
]
this is response from my API,

Can someone help me please.

2

Any success?

3

On the internet, there are a couple of methods available to convert JSON to CSV, but it was really confusing to find which technique to use to convert JSON files. So, I mentioned the technique to convert JSON files to CSV format.

Steps to Convert JSON to CSV Using Excel (Manual Method)

Copy the JSON data

Copy everything starting from [ to ] from your API response.

Example:


[

{"name": "Harry Potter", "city": "London"},

{"name": "Don Quixote", "city": "Madrid"},

{"name": "Joan of Arc", "city": "Paris"},

{"name": "Rosa Parks", "city": "Alabama"}

]

Save it as a .json file

  • Open Notepad (or any text editor).

  • Paste your JSON data.

  • Save it as data.json (make sure the extension is .json, not .txt).

Open Excel

  • Go to the Data tab.

  • Click Get Data → From File → From JSON.

  • Browse and select your data.json file.

Load the data

  • Excel will open the Power Query Editor.

  • You’ll see a “List” or “Record” view — click the expand button (↔) next to it to reveal columns (name, city).

Load to sheet

  • Once the data looks correct, click Close & Load.

  • The data will appear in an Excel sheet with proper columns.

Save as CSV

  • Go to File → Save As → Browse.

  • Under “Save as type,” select CSV (Comma-delimited) (*.csv).

  • Save the file.

After converting, you can easily access the CSV in Excel. But, this method may be risky and damage your formatting. So, if you have a batch of JSON files and want to convert them into CSV format, you can use a trusted tool like JSON Converter by Softaken for 100% security. Rather than using an Online converter.

4

The 1T - CSV Creator plugin converts JSON to CSV. You may be able to use that to achieve what you need - 1T - CSV Creator Plugin | Bubble

5

Check out 1T - CSV Creator 3.0 - #450 by mccjon