Guide: convert CSV and JSON for spreadsheets and APIs
Excel/Sheets exports arrive as CSV with `,` or `;` delimiters and a header row. REST APIs expect JSON object arrays — spreadsheet hacks do not scale for pipelines.
Processing is local: paste non-sensitive or anonymized samples. Delimiter, quoting, and escapes are honored; empty rows may be skipped per options.
Use for DB seeds, test fixtures, or marketing exports. Validate types in the JSON viewer before posting to your backend.
Step by step
- Paste CSV or JSON — Include a header row in CSV. JSON should be an object array (or single object per tool rules).
- Set delimiter and header — Pick `,`, `;`, or tab — common in EU CSV. Toggle first row as column names.
- Fix problematic rows — Quoted multiline fields should parse; correct any rejected lines.
- Export to destination — Copy JSON for `fetch` POST or CSV for Excel — chunk very large datasets.