JSON → CSV

All tools

Flatten a JSON array of objects into CSV.

The conversion runs entirely in your browser — your data never leaves this page.

Try a sample:
Delimiter
input.json
NDJSON detected — one object per line.
output.csv 


							

								
								
Your spreadsheet will appear here

								
Paste JSON on the left, drop a .json file, or load a sample.

							


							

								
								

							


							

								
								
							

						

					

				

			

		

	


        
                    

		


					
About JSON → CSV

							
The JSON to CSV converter flattens a JSON array of objects into a spreadsheet-ready CSV file. Paste JSON, open a .json file or start from one of the samples; the result is shown both as a live table preview and as raw CSV, and updates instantly as you edit the input.

							
Nested structures are no problem: an optional flatten switch expands nested keys into dotted column names such as customer.city, and NDJSON input (one JSON object per line) is detected automatically. A single object works too — it simply becomes a one-row file.

							
The column set is the union of every key found across all objects, preserving first-seen order, so ragged records still align correctly. Pick a comma, semicolon, tab or pipe delimiter, then copy the CSV or download the .csv file — the whole conversion happens in your browser.

					
					
How to use JSON → CSV

			
    
									
  1. Paste a JSON array of objects, open a .json file, or load one of the samples.
    2. 
									
  2. Turn on “Flatten nested keys” if your objects contain nested data.
    3. 
									
  3. Pick the delimiter — comma, semicolon, tab or pipe — and the header row option.
    4. 
									
  4. Switch between the Table and Raw CSV views to check the result.
    5. 
									
  5. Copy the CSV or download it as a .csv file.
    6. 
							

		
					
Frequently asked questions

			

									

						

							
						

						

							
No. The entire json to csv conversion runs client-side in your browser. API responses or exports containing private data never leave your device.

						

					

									

						

							
						

						

							
Yes, it is completely free — no credits, no registration and no file limits.

						

					

									

						

							
						

						

							
With flattening enabled, nested keys become dotted column headers — an object like {"customer":{"city":"Paris"}} produces a customer.city column. Without flattening, nested values are serialized as JSON text inside the cell.

						

					

									

						

							
						

						

							
Yes. If the input is newline-delimited JSON — one object per line, as produced by many log pipelines and export tools — the converter detects it automatically and treats each line as a row.

						

					

									

						

							
						

						

							
The converter builds the column list from the union of all keys, in the order they first appear. Objects missing a key simply get an empty cell in that column, so nothing shifts out of alignment.

						

					

									

						

							
						

						

							
Yes. The output is standard CSV with a header row. If your locale expects semicolon-separated files, choose the semicolon delimiter before downloading and Excel will parse the columns correctly.

						

					

							


						
			


	



	
	

		

		

			Share this
							
					
				
							
					
				
							
					
				
							
					
				
							
					
				
							
					
				
							
					
				
							
					
				
							
					
				
					

	



    
	
	

				
Related Tools


					

									

						
							
							
								
									CSV → JSON
									
								
								Turn pasted CSV into a clean JSON array.
								
																			Free
																	
							
						
					

									

						
							
							
								
									JSON Formatter
									
								
								Beautify, minify and validate JSON.
								
																			Free
																	
							
						
					

									

						
							
							
								
									Spreadsheet Converter
									
								
								Convert between CSV, Excel (XLSX) and JSON.
								
																			Free
																	
							
						
					

									

						
							
							
								
									Code to Image Converter
									
								
								Turn a code snippet into a beautiful shareable image — themes, backgrounds, window chrome and more.
								
																			Free
																	
							
						
					

									

						
							
							
								
									World Date & Time Formats
									
								
								See how dates and times are written around the world — pick countries or languages and compare their formats instantly.
								
																			Free
																	
							
						
					

									

						
							
							
								
									JSON ↔ YAML
									
								
								Convert JSON to YAML and back, with validation.
								
																			Free
																	
							
						
					

							

			





		

		
Popular searches

		

							json to csv
							convert json to csv
							json csv converter
							flatten json to csv
							json array to csv
							export json as csv
					

	





		

			

				

					
					

						
Need help?

						
Found an issue with this tool? Let our team know.

					

				

				
					Report an issue
				
			

		

	





        

            

                

                    
                

                

                    

                        
Add this free tool to your own website — copy and paste the code below.