JSON to CSV Converter

All dev 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 to CSV Converter

							
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 to CSV Converter

			
    
									
  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 to JSON Converter
                            
        

                    

                        
                
                    
                                    
                JSON Formatter
                            
        

                    

                        
                
                    
                                    
                Spreadsheet Converter
                            
        

                    

                        
                
                    
                                    
                Code to Image Converter
                            
        

                    

                        
                
                    
                                    
                World Date & Time Formats
                            
        

                    

                        
                
                    
                                    
                JSON ↔ YAML
                            
        

                    

                        
                
                    
                                    
                Base64 Encode / Decode
                            
        

                    

                        
                
                    
                                    
                Image to Base64 Converter
                            
        

                    

                        
                
                    
                                    
                URL Encode / Decode
                            
        

                    

                        
                
                    
                                    
                SQL Formatter & Beautifier
                            
        

                    

                        
                
                    
                                    
                XML Formatter & Beautifier
                            
        

                    

                        
                
                    
                                    
                HTML Entity Encoder & Decoder
                            
        

                    

                        
                
                    
                                    
                JSON to Code Generator
                            
        

                    

                        
                
                    
                                    
                Slugify: URL Slug Generator
                            
        

                    

                        
                
                    
                                    
                String Escape & Unescape
                            
        

                    

                        
                
                    
                                    
                HTML to Markdown Converter
                            
        

                    

                        
                
                    
                                    
                Archive Converter
                            
        

                    

                        
                
                    
                                    
                Font Converter
                            
        

                    

                        
                
                    
                                    
                HTML to JSX Converter
                            
        

                    

                        
                
                    
                                    
                URL Parser & Query Builder
                            
        

    

			





		

		
Popular searches

		

							json to csv
							convert json to csv
							json csv converter
							flatten json to csv
							json array to csv
							export json as csv
							json → 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.