csv-to-json Convert CSV to JSON array
Examples
Convert a CSV export to JSON array
Usage
"name,email,role
Alice,[email protected],admin
Bob,[email protected],editor" | csv-to-jsonConvert a marketing spreadsheet export to JSON for an API
Usage
"campaign,clicks,conversions
Summer Sale,4200,310
Back to Sch..." | csv-to-jsonConvert an HR employee list to JSON for a web dashboard
Usage
"name,department,start_date
Alice,Engineering,2023-01-15
Bob,..." | csv-to-jsonView source
(input)=>{
const lines = input.trim().split("\n");
if (lines.length < 2) return "[]";
const headers = lines[0].split(",").map((h)=>h.trim().replace(/^"|"$/g, ""));
const rows = lines.slice(1).map((line)=>{
const values = line.split(",").map((v)=>v.trim().replace(/^"|"$/g, ""));
return Object.fromEntries(headers.map((h, i)=>[
h,
values[i] || ""
]));
});
return JSON.stringify(rows, null, 2);
}