CSV to JSON Converter — Data Migration Tools

Overview

Converts CSV into a JSON array where each row becomes an object keyed by header names.

Features

Optional type inference.
Handles quoted fields.

Use cases

Feeding a CSV export into a NoSQL pipeline.
Preparing data for a JS chart.

API reference

POST /api/v1/tools/convert

Convert text between CSV, JSON, XML, YAML, and SQL by pivoting through JSON when no direct converter exists.

Returns: The converted text, the row count from the last step that reported one, and the converter chain that ran.

Parameters

Name	Type	Required	Default	Description
`input`	string	Yes	—	The text to convert, in the source format.
`autoTypes`	boolean	No	`true`	Infer number/boolean/null types when parsing CSV rather than treating every cell as a string.
`dialect`	string (mysql\|postgres\|sqlserver\|sqlite)	No	—	SQL dialect for CSV-to-SQL output. Ignored for other target formats.
`table`	string	No	`"data"`	Table name for CSV-to-SQL INSERT statements. Ignored for other target formats.
`rootElement`	string	No	`"root"`	Root XML element name for JSON-to-XML output. Ignored for other target formats.

For this tool, use from: "csv" and to: "json".

Example

curl -X POST https://data-migration-tools.com/api/v1/tools/convert \
  -H "Content-Type: application/json" \
  -d '{"from":"csv","to":"json","input":"id,name\n1,Ada\n2,Grace"}'

See the full API reference for all examples and error codes.