json-to-csv Convert JSON array of objects to CSV
Examples
Convert a JSON array to CSV
Usage
"[{"name":"Alice","role":"admin"},{"name":"Bob","role":"edito..." | json-to-csvExport marketing analytics JSON to CSV for a spreadsheet
Usage
"[{"campaign":"Summer","clicks":4200,"spend":"$340"},{"campai..." | json-to-csvConvert a user list JSON to CSV for HR reporting
Usage
"[{"name":"Alice","dept":"Engineering","start":"2023-01"},{"n..." | json-to-csvView source
(input)=>{
try {
const data = JSON.parse(input);
if (!Array.isArray(data) || data.length === 0) return "Error: expected non-empty JSON array";
const headers = [
...new Set(data.flatMap(Object.keys))
];
const esc = (v)=>{
const s = String(v ?? "");
return /[,"\n]/.test(s) ? `"${s.replace(/"/g, '""')}"` : s;
};
return [
headers.map(esc).join(","),
...data.map((row)=>headers.map((h)=>esc(row[h])).join(","))
].join("\n");
} catch (e) {
return `Error: ${e.message}`;
}
}