๐Ÿ”„ CSVโ‡”JSON Converter

Convert CSV data into a JSON array, or a JSON array into CSV. Useful for turning spreadsheet data into a format your API or program can work with, or the reverse โ€” turning JSON data into something you can open in a spreadsheet app.

How to use

  1. Choose the direction: "CSV โ†’ JSON" or "JSON โ†’ CSV".
  2. Paste the data you want to convert (for CSV, the first row is treated as the header row).
  3. The converted result appears automatically below. Use the "Copy" button to copy it.

FAQ

Does this handle CSV fields with commas wrapped in double quotes?

Yes โ€” a field like "Tokyo, Shibuya" wrapped in double quotes is correctly treated as a single value, not split on the comma inside it.

For JSON โ†’ CSV, what happens if objects have different keys?

The header row is built from the union of all keys across every object, and any object missing a given key gets an empty cell for it.

What should I do if the conversion fails?

For JSON โ†’ CSV, the input needs to be a valid JSON array of objects โ€” check for syntax errors in your input.