Free · No upload · Works in your browser

CSV to JSON Converter: Convert CSV to JSON Free Online

Paste CSV or open a .csv file and get clean JSON with numbers, true/false and empty values handled the way you want. It runs in your browser, so your data is never uploaded.

    100% private: files are processed by your browser. Nothing is uploaded to GrowthPi or anyone else.

    How to use the CSV to JSON Converter

    1. 1

      Paste CSV into the left box, or open a .csv or .tsv file.

    2. 2

      Check the delimiter, header and type options.

    3. 3

      Pick the JSON shape and formatting.

    4. 4

      Copy the JSON or download it as a .json file.

    Why convert CSV to JSON?

    Spreadsheets are how people keep data; JSON is how software uses it. You need JSON to seed a database, feed a website or app, send data to an API, configure a no-code tool, build a static site from a product list, or hand test data to a developer. Converting CSV to JSON turns each spreadsheet row into an object, with the header row as the keys.

    A row like this:

    name,city,zip,active
    Ava Johnson,Boston,02134,true

    becomes:

    [
      { "name": "Ava Johnson", "city": "Boston", "zip": "02134", "active": true }
    ]

    Notice that true became a real boolean while the zip code kept its leading zero as text. That is the kind of detail that breaks imports when it goes wrong.

    Options explained

    OptionWhat it doesWhen to use it
    Array of objects[{"name": "Ava"}, …]APIs, JavaScript, most databases (default)
    Array of arrays[["name"], ["Ava"]]Charts, compact data, keeping column order
    JSON LinesOne object per lineLogs, BigQuery, data pipelines, large files
    Detect numbers & true/false42 and true instead of "42" and "true"When the receiving app expects real types
    Empty cells"", null, or leave the key outMatch what your database or API expects
    Nest dot keysaddress.city becomes {"address": {"city": …}}Rebuilding nested JSON, for example after JSON to CSV
    FormatPretty with 2 or 4 spaces, tabs, or minifiedPretty to read; minified for the smallest file

    Type detection stays careful: numbers with leading zeros (zip codes, IDs), numbers longer than 15 digits, and values like 1,200 or $5 stay as text so nothing is silently changed. Duplicate column names get a suffix (email, email_2) so no data is lost, and blank header cells are named column1, column2 and so on.

    CSV parsing that handles real-world files

    Exports from Excel, Google Sheets and business apps are messier than textbook CSV. The converter handles:

    • Commas, quotes and line breaks inside quoted fields, such as "Garcia, Mia" or multi-line addresses
    • Comma, semicolon, tab and pipe delimiters, detected automatically
    • UTF-8, UTF-16 and old Windows-encoded files, so names like José and Zoë stay correct
    • Windows (CRLF), Mac and Linux line endings, plus blank lines at the end

    The preview table under the converter shows exactly how your rows were split, so you can spot a wrong delimiter before using the JSON.

    Common CSV to JSON problems and fixes

    Everything is in one key. The delimiter is wrong. If detection picked comma but your file uses semicolons (common in European exports), choose the delimiter yourself and check the preview table.

    Keys look like "column1". Your file has no header row, or "First row is the header" is unticked. Add a header line such as name,email,city to get meaningful keys.

    Strange characters such as é in names. That happens when a file is read with the wrong encoding. This tool detects UTF-8, UTF-16 and Windows text automatically; if you pasted from another program and still see them, the text was already damaged there, so open the original file instead.

    An app rejects the numbers. Some systems want every value as a string. Untick "Detect numbers & true/false" and every value stays text exactly as it was in the CSV.

    The JSON is too big to read. Choose JSON Lines or Minified. Minified JSON is noticeably smaller than pretty-printed JSON because it drops the indentation and line breaks.

    From Excel or Google Sheets to JSON

    In Google Sheets, use File > Download > Comma-separated values. In Excel, use Save As > CSV UTF-8, or convert the workbook with our Excel to CSV tool, which exports every sheet at once. Then paste or open the CSV here. You can also copy cells straight from a spreadsheet and paste them: copied cells are tab-separated, and the automatic delimiter detection picks that up.

    Checking the JSON before you use it

    The output is always valid JSON produced by your browser's own JSON engine, so brackets, commas and quotes are guaranteed to be correct. What is worth checking is the content: look at the first record in the output to confirm the keys are the names you expect, scan the preview table for a column that is shifted (a sign of an unquoted comma in the source file), and compare the row count in the status line with the number of rows in your spreadsheet, not counting the header. If a value must stay text, such as a phone number with a plus sign, it already will, because only plain numbers are converted.

    Going the other way? JSON to CSV flattens nested JSON into a spreadsheet. CSV to Excel makes a formatted .xlsx. Building a site from your data? See how to build a small business website, and make clean URL slugs for product names with the slug generator.

    Private and offline-friendly

    Contact lists, price sheets and customer exports stay on your device. The CSV is parsed and converted by JavaScript in your browser, with no upload to GrowthPi or anyone else, no sign-up and no row limit beyond your device's memory.

    Last updated November 6, 2026.

    CSV to JSON Converter FAQ

    How do I convert CSV to JSON?

    Paste the CSV into the box above or open a .csv file. The JSON appears instantly; copy it or click Download JSON. Nothing is uploaded.

    How do I convert CSV to a JSON array of objects?

    Keep Output on Array of objects and First row is the header ticked. Each row becomes an object whose keys are the header names.

    How do I keep numbers as numbers in JSON?

    Leave Detect numbers & true/false ticked. Plain numbers become JSON numbers, while zip codes with leading zeros and very long IDs stay as text.

    Can I convert Excel to JSON?

    Yes. Save or convert the Excel sheet to CSV first (our Excel to CSV tool does every sheet at once), or copy the cells and paste them here.

    How do I create nested JSON from CSV?

    Name your columns with dots, like address.city and address.state, and tick Nest dot keys. They become nested objects in the JSON.

    What is JSON Lines?

    JSON Lines (.jsonl) puts one JSON object on each line instead of one big array. It is popular for logs and large data imports because it can be read line by line.