Convert CSV to JSON

Paste CSV or drop in a file and get tidy JSON straight away. Comma, semicolon, tab and pipe separators are spotted automatically, and your data never leaves the browser.

Converted on your device. Your data never leaves your browser.

Turning CSV into JSON

  1. 1

    Paste the CSV into the input box, drop a .csv file onto it, or press Open file.

  2. 2

    Check the options: the separator is detected for you, the first row becomes the JSON keys, and numbers and booleans get proper types.

  3. 3

    Copy the JSON, or press Download .json to save it.

What makes this CSV to JSON converter handy

Copes with messy CSV

Quoted fields, escaped quotes, commas and line breaks inside cells, and Excel's byte-order mark are all read correctly.

Sensible types

Numbers, true/false and blank cells become real JSON values, while IDs and ZIP codes with leading zeros stay as text.

Any separator

Commas, semicolons (common in European Excel exports), tabs and pipes are all detected automatically.

Private and instant

Conversion happens in your browser as you type – your data is never uploaded.

What people use the CSV to JSON converter for

Bring spreadsheets into apps

Get rows from Excel or Google Sheets into JSON for code and APIs.

Make test fixtures

Build sample data for front-end and back-end development.

Power charts and dashboards

Lots of charting libraries expect JSON arrays.

Tidy up exports

Turn CSV exports from CRMs and shops into structured JSON.

Also searched for as: CSV to JSON converter, spreadsheet to JSON, Excel to JSON and CSV parser online.

Related searches

  • convert excel csv to json online
  • csv to json array of objects
  • csv to json with headers
  • convert google sheets csv to json
  • csv to json for api testing
  • large csv to json converter no upload
  • convert large csv to json online

Quick data conversions in the browser

Switch between CSV, JSON and YAML, or turn images into Base64, without installing anything. Everything is processed in your browser, so exports, customer data and API keys stay on your machine rather than going to someone else's server.

Questions & answers

How can I get an Excel sheet into JSON?

In Excel or Google Sheets choose File → Save As (or Download) → CSV, then drop that CSV in above and download the JSON.

What is "First row is header" for?

With it on, the first row provides the keys and each remaining row becomes an object such as {"name": "Ada"}. Switch it off to get an array of arrays instead.

Why are some numbers left as text?

Values with leading zeros, like ZIP codes or an ID of 007, and integers too big for JSON numbers stay as strings so nothing gets lost. Turn off "Detect numbers & booleans" to keep everything as text.

Does it work with big CSV files?

Yes – hundreds of thousands of rows convert in a second or two. With very large files the on-screen preview is trimmed, but the download always has the complete JSON.

Do my files get uploaded anywhere?

Never. The work is done by JavaScript running in your own browser, on your own device. Nothing is sent to a server or kept anywhere, which makes it safe for personal photos and sensitive data – and it carries on working even on a patchy connection.

You might also need

CSV ⇄ JSONBoth directions, one toolJSON to CSVJSON as a spreadsheetJSON to YAMLJSON as readable YAMLYAML to JSONYAML configs as JSONImage to Base64Data URIs for your codeBase64 to ImageTurn Base64 back into a fileHEIC to JPGiPhone photos that open everywhereHEIC to PNGiPhone photos, no further lossWebP to JPGWeb images your apps can openWebP to PNGWebP to PNG, transparency keptPNG to JPGMuch smaller screenshotsJPG to PNGEdit without more quality lossPNG to WebPLighter images, still transparentJPG to WebPQuicker photos for websitesSVG to PNGCrisp PNGs at up to 8× sizeImage ConverterAny image to WebP, PNG or JPGMetadata RemoverWipe GPS and EXIF from photosJPG to PDFPhotos into a single PDFPNG to PDFScreenshots and scans as a PDFReorder PDF PagesRearrange, rotate, delete pagesZip FilesBundle files into a ZIPUnzip FilesSee inside and extract ZIPsExtract TAR.GZUnpack .tar.gz, .tgz, .tar, .gzTAR.GZ to ZIPArchives that open on WindowsAudio TrimmerCut audio on a waveformWord CounterWords, characters, reading timeText Diff CheckerSpot changes between two textsImage to Text (OCR)Copy text out of picturesBase64 Encoder / DecoderEncode and decode Base64Code MinifierShrink or tidy CSS, HTML, JSRegex TesterTest patterns with live matches

Guides for this tool

See every guide →