Convert JSON format to CSV format for MS Excel [closed]

by

I’m not sure what you’re doing, but this will go from JSON to CSV using JavaScript. This is using the open source JSON library, so just download JSON.js into the same folder you saved the code below into, and it will parse the static JSON value in json3 into CSV and prompt you to download/open in Excel.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <title>JSON to CSV</title>
    <script src="https://stackoverflow.com/questions/4130849/scripts/json.js" type="text/javascript"></script>
    <script type="text/javascript">
    var json3 = { "d": "[{\"Id\":1,\"UserName\":\"Sam Smith\"},{\"Id\":2,\"UserName\":\"Fred Frankly\"},{\"Id\":1,\"UserName\":\"Zachary Zupers\"}]" }

    DownloadJSON2CSV(json3.d);

    function DownloadJSON2CSV(objArray)
    {
        var array = typeof objArray != 'object' ? JSON.parse(objArray) : objArray;

        var str="";

        for (var i = 0; i < array.length; i++) {
            var line="";

            for (var index in array[i]) {
                line += array[i][index] + ',';
            }

            // Here is an example where you would wrap the values in double quotes
            // for (var index in array[i]) {
            //    line += '"' + array[i][index] + '",';
            // }

            line.slice(0,line.Length-1); 

            str += line + '\r\n';
        }
        window.open( "data:text/csv;charset=utf-8," + escape(str))
    }

    </script>

</head>
<body>
    <h1>This page does nothing....</h1>
</body>
</html>

More Related Contents:

  1. Kotlin Json Parser
  2. Is there a streaming API for JSON? [closed]
  3. How to make HTTP Post request with JSON body in Swift
  4. JSON and escaping characters
  5. Converting Go struct to JSON
  6. AngularJS $http-post – convert binary to excel file and download
  7. Build a JSON string with Bash variables
  8. uncaught syntaxerror unexpected token U JSON
  9. Retrieving JSON Object Literal from HttpServletRequest
  10. Unhandled Exception: InternalLinkedHashMap’ is not a subtype of type ‘List
  11. How to Deserialize a list of objects from json in flutter
  12. Postgres: How to convert a json string to text?
  13. Jackson JsonTypeInfo.As.EXTERNAL_PROPERTY doesn’t work as expected
  14. How to use Newtonsoft.Json as default in Asp.net Core Web Api?
  15. Post a json body with swagger
  16. Convert a JSON array to a bash array of strings
  17. How to parse json and read in vb.net
  18. Spring REST service: retrieving JSON from Request
  19. iteration a json object on Ngfor in angular 2
  20. Angular2 Ansychronous bootstrapping with external json configuration file
  21. How to exclude properties from Swift Codable?
  22. Only allow properties that are declared in JSON schema
  23. How can I use JSON on the web page from a source with neither CORS nor JSONP? [closed]
  24. Split a JSON file into separate files
  25. How to parse JSON from the Invoke-WebRequest in PowerShell?
  26. AngularJS Intercept all $http JSON responses
  27. How to escape single quotes into double quotes into single quotes
  28. How to convert a JSON file to an SQLite database
  29. Any when decoding JSON with Codable?
  30. Using VBA and VBA-JSON to access JSON data from WordPress API

Leave a Comment