Skip to content

Developer tools

JSON to CSV Converter (and CSV to JSON)

Turn API responses into spreadsheets, or spreadsheets into JSON. Nested objects become columns like author.name; quotes and line breaks are handled correctly.


            
        

    



    


    

        

                            

                    
How to use the JSON to CSV Converter (and CSV to JSON)

                    
    
                                                    
  1. 
                                1
                                
    Choose JSON → CSV or CSV → JSON, then paste your data or open a file.
    
                            
    2. 
                                                    
  2. 
                                2
                                
    Pick the delimiter (use semicolon for Excel in many European locales) and whether the first row is a header.
    
                            
    3. 
                                                    
  3. 
                                3
                                
    Copy the result or download it. CSV downloads open directly in Excel with the right encoding.
    
                            
    4. 
                                            

                

            
                            

                    
Frequently asked questions

                    

                                                    

                                
                                    How are nested objects converted?
                                    
                                
                                
They become dot-separated columns, e.g. {"author": {"name": "Dasun"}} becomes an author.name column. Arrays are written as JSON text in one cell.

                            

                                                    

                                
                                    Why do accents look wrong in Excel?
                                    
                                
                                
Excel needs a UTF-8 marker to read accents and emoji correctly; downloaded CSV files include it.

                            

                                                    

                                
                                    Is my data sent anywhere?
                                    
                                
                                
No. The conversion happens in your browser.

                            

                                            

                

            
            
            
                                


        
    


            

            
            

                                    
                                    
                                    
                            

        

            

    
    
    
    

    

    

                                                
Popular tags

                

                                            
                            #API
                        
                                            
                            #awk
                        
                                            
                            #Database
                        
                                            
                            #DevOps
                        
                                            
                            #Eloquent
                        
                                            
                            #Laravel
                        
                                            
                            #Linux
                        
                                            
                            #MySQL
                        
                                            
                            #Performance
                        
                                            
                            #PHP
                        
                                    

                        
Type to search. Press Enter for all results.

            




    
        

            
                
            
            
Get new articles in your inbox

            
Practical tutorials and deep dives, about once a week. No spam, unsubscribe anytime.


            

                

            
        

            
            

                
                
            

                
        

            

            


            

                
                Privacy policy
            

            
        

        
        
    
        
        

            

                
Add DEV Talk to your Home Screen

                
            

            
    
                
  1. 1
                    Tap the Share button 
 in Safari's toolbar.
    2. 
                
  2. 2
                    Scroll down and tap Add to Home Screen.
    3. 
                
  3. 3
                    Tap Add. Open it from the Home Screen to read like an app and to turn on notifications with the bell.
    4. 
            

            
        

    
    

        

            

                We use cookies to improve your experience and analyze traffic. By continuing, you agree to our
                Privacy Policy.