Skip to content
HandfulTools

CSV to JSON Converter

Turn a spreadsheet export into JSON for an API, a web app or a database import. The header row becomes object keys and numbers and true/false values become real JSON types.

Runs in your browser

Loading…

How to use

  1. Paste CSV (or TSV) on the left.
  2. Check the delimiter and header options.
  3. Copy the JSON.

How it works

Parsing follows RFC 4180: fields in double quotes may contain commas, line breaks and doubled quotes (""). The delimiter — comma, semicolon, tab or pipe — is detected from the first lines. Values that look like numbers are converted unless they have leading zeros (postcodes, phone numbers), which stay strings.

Empty cells become null. Duplicate column names get a numeric suffix so no data is lost.

Examples

Product list
name,price → [{"name":"Mug","price":12.5}]

Common uses

  • Preparing data for APIs and apps
  • Importing spreadsheets into databases
  • Test fixtures

Privacy & security

This tool runs entirely in your browser. Your files and text are never uploaded to our servers — processing happens on your device and results are created locally. How each tool handles files

Frequently asked questions

Why are French CSV files separated by semicolons?

In locales that use a comma as decimal separator, Excel uses ; between columns. Auto-detection handles it.

Can it handle large files?

Yes, several megabytes are processed instantly in the browser.

Last updated: