plotiq

CSV to JSON

Paste a CSV or drop a .csv file and Plotiq outputs clean JSON live — array-of-objects or object-of-arrays shapes, pretty-print on or off, leading-zero IDs preserved.

Perfect for seeding a database, mocking an API, or feeding an LLM.

1. Paste or upload your CSV

Drop a .csv file or paste CSV text. Plotiq auto-detects the separator and parses live.

2. Pick array or object output

Array-of-objects is the default. Object-of-arrays gives you column-oriented JSON for pandas or Arrow.

3. Copy or download the JSON

Copy to clipboard for a quick paste, or download a .json file for a downstream pipeline.

Which JSON output shape should I pick?

Array-of-objects is the default — every row becomes one JSON object keyed by the header. Object-of-arrays is column-oriented and helpful when feeding pandas, Arrow, or column stores.

Does the converter preserve leading-zero IDs like "007"?

Yes. Numeric-looking strings that start with a zero stay strings in the JSON output, so IDs, phone numbers, and ZIP codes never silently become integers.

How does the CSV parser handle commas inside quoted fields?

The parser is RFC 4180 compliant — "Smith, John" keeps the comma, "He said ""hi""" unescapes correctly, embedded newlines survive the round-trip.

Can I pretty-print the JSON output?

Yes — toggle Pretty in the options row. Off produces minimal single-line JSON; on formats with 2-space indentation for human readability.