CSV to JSON
Turn CSV headers and cells into an array of objects for an API workflow.
Understand the input and result
sku,qty
A17,2
B24,5[
{
"sku": "A17",
"qty": "2"
},
{
"sku": "B24",
"qty": "5"
}
]Reading the result
Headers become object keys and the two data rows become two objects. Cells are read as strings, so qty ‘2’ is not the number 2.
Common mistakes
Duplicate headers and rows with mismatched column counts are errors. Numeric conversion, booleans and per-column schemas are not inferred.
Examples were checked against this tool's processing behavior. Review whether the meaning and format fit your own input.
CSV to JSON guide
How to use it
- Paste the input on the left or use Open file to load a UTF-8 text file. Provide the content to process, without unrelated logs, HTTP headers or explanations. For comparison, enter one JSON document in each input area.
- Choose the action and options in the middle and press Run. If an error appears, correct the original input and try again. You can edit input and options during processing; a result from an older input will not be applied to your new input.
- The original stays on the left and the result appears on the right. Use Copy or Download to take it to your next task. Editing input or options clears the previous result. Reset clears both areas while keeping your options. Structure views allow tree entries to be expanded and collapsed.
How it works and what to keep in mind
XML output uses a root wrapper and item elements for arrays. Values read from XML are strings, with @_/#text for attributes/text. CSV uses record arrays with headers; nested values become JSON strings in cells. Cells read from CSV remain strings. RSS converts its XML structure to JSON without remapping to a separate feed schema. Cross-format conversion does not guarantee lossless round trips.
Input and results are processed in your browser without being uploaded or saved. Open file accepts UTF-8 text files up to 2 MB. These tools handle syntax and data representation; they do not guarantee business-rule validity, security or production readiness. Language and theme changes preserve your current input and options, but reloading clears work data.
Use the header buttons to switch languages or light and dark modes instantly. Switching keeps your input, results and running state. Your language and theme choices also apply on later visits and when you navigate to another page.