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.

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.

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

Convert JSON to CSV

Need help APIs

mccjon November 18, 2025, 1:22pm 5

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

Topic		Replies	Views
CSV to JSON converter plugin by Zeroqode :file_folder: Plugins	0	385	January 25, 2024
[New Plugin]: XLSX \| CSV to JSON Showcase	0	120	April 5, 2024
Convert into json from csv returned from an api Questions	0	79	July 3, 2024
🎊[New Plugin] - Convert CSV to JSON File Plugins	2	756	September 13, 2022
CSV into JSON format using OpenAI or Gemini APIs	1	351	April 29, 2024

Convert JSON to CSV

Related topics