Skip to content
POST /api/v1/csv-to-json

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.

string required
advanced options
boolean
string

Auto-detected if not specified

X-Sandbox-Remaining: - get an api key

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.
response awaiting request sending
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.

cookies

We use analytics cookies to see how the site gets used. Nothing loads until you accept. Privacy policy