CSV ↔ JSON Converter

Convert spreadsheet-style records to JSON and back, with quoted-field support and spreadsheet-safe export.

Convert locally in your browser. No files or records are uploaded.

Conversion direction Source data Spreadsheet-safe CSV: prefix formula-like cells with an apostrophe

Converted data

Move a table between CSV and JSON

CSV stores rows and columns as text. JSON gives each record named fields, making it useful for application imports and small data exchanges. This tool converts a flat table; it does not infer a database schema or silently guess data types.

CSV to JSON: keep identifiers intact

The first row supplies property names. Every later row must have the same number of fields. Values stay strings: a product code “0012” remains “0012”, and a date such as “03/04/2026” is not interpreted as either March 4 or April 3. Empty cells become empty strings. Headers must be non-empty and unique, so duplicate names cannot silently overwrite a column.

Comma-separated CSV supports double-quoted fields, commas inside those fields, doubled quotation marks, and line breaks inside a quoted field. For example, "Smith, Jo","Said ""hello""" contains two fields, not three. Semicolon and tab delimiters are not supported here; export comma-separated CSV from your spreadsheet first.

JSON to CSV: a flat set of records

Paste a non-empty array of objects, such as [{"item":"Notebook","quantity":3}]. The converter uses the union of all property names, in first-seen order. Missing properties and null values become empty cells. Booleans and numbers become text in the CSV. Nested objects or arrays are rejected rather than losing their structure.

Opening the export in a spreadsheet

Some spreadsheets execute cells beginning with characters such as =, +, -, or @ as formulas. Spreadsheet-safe mode prefixes those fields with an apostrophe, including headers. That changes the exported data, so leave it checked for spreadsheet use and disable it only for a trusted import that requires exact text. CSV quoting alone does not prevent formula execution.

Before importing

Check one row containing a leading-zero code, a comma, a quotation mark, and an empty value. Review the destination application’s date and number settings. This tool accepts up to 100,000 characters, making it suitable for small records rather than large datasets. See the conversion workflow guide for a validation checklist.