CSV to JSON Converter
Paste CSV data to convert it into a JSON array of objects. The first row is used as object keys by default. Supports commas, semicolons, tabs, and pipes as delimiters. Quoted fields with commas inside are handled correctly.
advanced options
Auto-detected if not specified
returns
- data.records
- Array of row objects keyed by column name.
- data.columns
- Column names from the header row.
- data.rows
- Number of records parsed.
Fill in the fields and send a request. The response lands here.
Run it from your code
A temporary key takes one request and lasts seven days at 20 calls a day. Register and it becomes 75 a day, still free.
$ curl -sX POST "https://apixies.io/api/v1/csv-to-json" \ -H "X-API-Key: $APIXIES_KEY" \ -H "Content-Type: application/json" \ -d '{"csv":"..."}' | jq '.data.records'
questions
How are column headers cleaned?
Headers are trimmed, lowercased, and spaces are replaced with underscores. "Full Name" becomes "full_name". If there are no headers, columns are named column_1, column_2, etc.
What happens with quoted fields?
Fields wrapped in double quotes are handled correctly, even if they contain commas or newlines. This follows the RFC 4180 CSV standard.