CSV parse (options) API

Parses CSV into records with full options: custom delimiter, quote char, header on/off, skip-rows, trim, and type coercion (RFC4180 quoting with embedded commas/quotes/newlines). Answers 'How do I parse CSV with a custom delimiter and quoting?', 'How do I coerce CSV cells to typed values?'.

Price$0.02per request

MethodPOST

Route/v1/data-transform/csv-parse

StatusLive

MIME typeapplication/json

Rate limit120/minute

Cache0s public

data-transformcsvparsedelimiterrfc4180tabularwrangle

API URLhttps://x402.hexl.dev/v1/data-transform/csv-parse

Integration docs

Example request

{
  "csv": "name,age\n\"Doe, J\",36\nAda,28",
  "coerce": true
}

Example response

{
  "records": [
    {
      "name": "Doe, J",
      "age": 36
    },
    {
      "name": "Ada",
      "age": 28
    }
  ],
  "rowCount": 2,
  "columns": [
    "name",
    "age"
  ]
}

Input schema

{
  "type": "object",
  "required": [
    "csv"
  ],
  "properties": {
    "csv": {
      "type": "string",
      "examples": [
        "name,age\n\"Doe, J\",36\nAda,28"
      ]
    },
    "coerce": {
      "type": "boolean",
      "examples": [
        true
      ]
    }
  }
}

Output schema

{
  "type": "object",
  "additionalProperties": true
}