TokenPad
Format

CSV to JSON Converter

Turn a spreadsheet export into records an API or a dataset can use.

Your input

41 characters4 lines0 tokensor drop a file

CSV to JSONExact
0Token change
Token change0no change
Input tokens0what you pasted
Output tokens0what you would send
Token cost of this result
Output tokens0
As input$0.00
× 100K requests$0.00

Everything on this page runs in your browser. Nothing you paste is transmitted, because there is no server here to transmit it to.

Result
 

The usual starting point

Evaluation sets, labelled examples and fine-tuning candidates almost always begin life in a spreadsheet, because that is where the people who label data work. Getting them into JSON is the first step of every pipeline built on top of that.

This handles the parts that hand-rolled splitting gets wrong: quoted fields containing the delimiter, escaped quotes inside quoted fields, and blank trailing lines.

Type coercion, and when to switch it off

CSV has no types — everything is text. The converter infers numbers, booleans and nulls, which is what you want most of the time.

Switch it off when identifiers could be misread as numbers. A postcode, an order reference or a version string can lose leading zeros or become a float, and that corruption is silent and permanent.

From records to a dataset

JSON records are rarely the final destination. For fine-tuning you need JSONL with a messages array per line — build that with the chat messages tool, then check it with the JSONL validator before uploading.

Frequently asked questions

Why did my ID column turn into a number?
Type coercion. Switch it off, or quote the column in the source. Leading zeros are lost permanently once a value becomes a number, so check identifier columns specifically.
My rows are misaligned. What happened?
Almost certainly an unquoted delimiter inside a field. Export from your spreadsheet with proper quoting, or switch to tab-delimited, where the problem is far rarer.

More format tools