Skip to content
utilnest

CSV to JSON converter

Turn spreadsheet exports into JSON for your code, and JSON from an API back into a spreadsheet.

  • Works in your browser
  • No sign-up
  • Free to use

How to use CSV to JSON converter

  1. 1

    Choose CSV to JSON or JSON to CSV.

  2. 2

    Paste your data or choose a file. The separator is detected for you, or pick it yourself.

  3. 3

    Pick the options you want, then copy the result or download it as a .json or .csv file.

What this tool does

This converter moves data between the two formats people use most: CSV, which spreadsheets export, and JSON, which web apps and APIs use. Use it to load a spreadsheet into an app, inspect API data in Excel, or prepare test data.

Features

  • CSV to JSON as an array of objects (column names as keys) or an array of arrays.
  • Type detection for numbers, true/false and null, keeping leading zeros as text.
  • JSON to CSV with nested objects flattened into dotted column names and a wrapper like {"items": [...]} unwrapped.
  • Any separator: comma, semicolon, tab or pipe, detected automatically.
  • Pretty or minified JSON, and a one-click swap to convert back.

Limits

  • JSON to CSV expects a list of objects or arrays. Deeply nested lists inside objects stay as JSON text in one cell.
  • The first row is used as column names unless you turn that option off.

Where your data is processed

This tool works in your browser: your data is converted on your own device, so it isn't sent to our server for this tool. Some other tools on UtiloNest do use our server, and their pages say so.

Frequently asked questions

Does it handle commas and line breaks inside values?

Yes. Values in double quotes may contain the separator, line breaks and quotes written twice (""), as in the CSV standard. Files from Excel, Google Sheets and databases work as they are.

What does "turn numbers and true/false into real values" do?

Cells like 42, 3.5, true, false and null become JSON numbers, booleans and null instead of text. Numbers with leading zeros, such as phone numbers or postcodes like 01234, stay text so nothing is lost.

How are nested JSON objects turned into CSV?

Nested objects become columns joined with dots, so {"address": {"city": "Lahore"}} becomes a column called address.city. Lists stay as JSON text in a single cell. Objects with different keys are combined into one set of columns.

Is there a size limit?

Files of tens of megabytes work in a modern browser. Very large outputs are shown cut short on the page, but the download always contains everything.

Is my data uploaded?

No. The conversion runs in your browser, so your file never leaves your device.

Was this tool helpful?