CSV โ†” JSON Converter

Turn a CSV file into a JSON array, or an array of JSON objects into CSV. Choose the delimiter, say whether the first row is a header and see a preview table before you download. Quoted cells, embedded commas and line breaks are handled according to RFC 4180. Everything runs in your browser and nothing is uploaded.

Processed locally in your browser. Your data is not uploaded to our servers.

Direction

Your text stays in this page: it is never uploaded or sent to analytics.

SettingsDefault settings

Numbers with leading zeros, or with more than 15 digits, stay text so that nothing is changed.

Result

    Examples

    The same data as CSV and as JSON:

    CSVJSON
    name,age Ana,30[{"name":"Ana","age":"30"}]
    city "Madrid, ES"[{"city":"Madrid, ES"}]
    a;b 1;2[{"a":"1","b":"2"}]

    Formula & Methodology

    The CSV reader follows RFC 4180: cells are separated by the delimiter, a cell in double quotes may contain delimiters and line breaks, and a doubled quote inside it means one quote. JSON is read with a strict parser and numbers are copied as written. JSON to CSV uses the union of all object keys as columns, in the order they first appear.

    Nothing is guessed silently: the delimiter that was detected is shown, and any repair (extra or missing cells, repeated names) is reported as a warning.

    Notes and limitations

    • CSV has no types, so every cell is text unless you turn on type conversion. Conversion only changes cells that cannot lose information (no leading zeros, at most 15 digits).
    • Nested objects and arrays have no CSV equivalent. They are written as JSON text in a single cell; flatten them first if you need separate columns.
    • A null and an empty string both become an empty cell when writing CSV, so they cannot be told apart again.
    • Spreadsheet programs may run cells that begin with = + - or @ as formulas. The protection option prefixes such text cells with an apostrophe; it changes the data, so it is off by default.
    • Texts up to 10,000,000 characters are accepted. The preview shows the first 20 rows and 12 columns; the output contains everything.

    How to Use

    1. Choose CSV to JSON or JSON to CSV.
    2. Paste your text. The delimiter is detected for CSV, or you can choose it.
    3. Set the options: header row, trimming, type conversion and the JSON layout (or line endings for CSV).
    4. Check the preview table and any warnings.
    5. Copy the result or download it as a file.

    Frequently Asked Questions

    Is my data uploaded?

    No. The conversion runs in your browser and nothing you paste is sent to ToolQuarter, analytics or any other service.

    How are commas and line breaks inside cells handled?

    If a cell is wrapped in double quotes it can contain delimiters and line breaks, and two double quotes inside it stand for one. The tool reads these cells correctly and writes them again when converting JSON to CSV.

    Why are my numbers strings in the JSON?

    CSV stores only text. Turn on โ€œConvert numbers and true/false to JSON typesโ€ to get numbers. Values with leading zeros (such as postcodes) or very long digit strings are kept as text on purpose.

    What happens with nested JSON?

    CSV is flat, so nested objects and arrays are written as compact JSON text inside one cell, and a warning says so. Flatten the data first if you need one column per field.

    Which delimiters are supported?

    Comma, semicolon, tab and pipe, with automatic detection when reading. Semicolons are common in European spreadsheets because the comma is their decimal mark.

    Last updated: