JSON to CSV
HTML
<script src="https://github.com/douglascrockford/JSON-js/raw/master/json2.js"></script>
<script src="http://assets.ngin.com.s3.amazonaws.com/site_files/startribune/js/school_finder_object.js"></script>
<h1>
JSON</h1>
<pre id="json"></pre>
<h1>
CSV</h1>
<pre id="csv"></pre>
<button id="download_1">Download CSV</button>
JavaScript
// JSON to CSV Converter
function ConvertToCSV(objArray) {
var array = typeof objArray != 'object' ? JSON.parse(objArray) : objArray;
var a=Object.keys(array[0])
var str = '';
for (var i = 0; i < array.length; i++) {
var line = '';
for (var index in array[i]) {
if (line != '') line += ','
line += array[i][index];
}
str += line + '\r\n';
}
return a + str;
}
// Example
$(document).ready(function () {
// Create Object
//var items = [
// { name: "Item 1", color: "Green", size: "X-Large" },
// { name: "Item 2", color: "Green", size: "X-Large" },
// { name: "Item 3", color: "Green", size: "X-Large" }];
// Convert Object to JSON
// change items // var jsonObject = JSON.stringify(items);
var jsonObject = JSON.stringify(schoolFinder);
// Display JSON
$('#json').text(jsonObject);
// Convert JSON to CSV & Display CSV
$('#csv').text(ConvertToCSV(jsonObject));
$("#download_1").click(function () {
var downloadLink = document.createElement("a");
var blob = new Blob(["\ufeff", ConvertToCSV(jsonObject)]);
var url = URL.createObjectURL(blob);
downloadLink.href = url;
downloadLink.download = "data.csv";
document.body.appendChild(downloadLink);
downloadLink.click();
document.body.removeChild(downloadLink);
});
});