The workshop · The text and data corner
The text and data cornerCSV to JSON, and back
The fact almost nobody mentions: “the CSV format” is not a standard. Its reference document is marked “informational” and says itself that there are considerable differences among implementations. That is why this tool MEASURES the separator instead of assuming it, and shows you what it found.
Pasted CSV or JSON
Your text never leaves your device
This tool works entirely inside your browser. What you type or paste here is sent nowhere, and nothing is kept once the tab is closed.
Checkable in ten seconds, without taking our word for it:
- Open your browser's inspector: the F12 key (or Ctrl+Shift+I, or Cmd+Option+I on a Mac).
- Go to the “Network” tab, then clear the list.
- Type or paste some text on this page and run the tool. The list stays empty: no request goes out.
- To go further: cut your connection and do it again. The tool still works.
This absence of requests is also checked BY MACHINE before every release: a lock drives a real browser, processes a real file, and refuses to publish if a single byte goes out.
Going further
The direction is deduced from the text. JSON has to be an array of objects to give a two dimensional table: that is the shape almost every export produces.
VerifyThe proof, step by stepThe network inspector check, explained one gesture at a time, with screenshots.
The cornerThe text and data cornerThe other tools in this corner of the workshop.
UnderstandHow this is builtThe formats actually handled, browser by browser, and what we ruled out.