Skip to content
SmaftyTools

CSV to JSON

Convert CSV data to JSON online with header detection, custom delimiters and quoted-field support. Fast, free and private.

JSON output

Output will appear here

About CSV to JSON

The CSV to JSON converter transforms spreadsheet exports and other comma-separated data into JSON — either an array of objects (using the first row as keys) or an array of arrays. It handles the tricky parts of real CSV correctly: quoted fields, escaped quotes, and commas or line breaks inside values.

Numbers, booleans and nulls are detected and converted to proper JSON types instead of strings, and you can switch the delimiter to semicolons or tabs for European-style exports and TSV files. Conversion is instant and private — your data never leaves the browser.

How to Use the CSV to JSON

  1. Paste CSV data (straight from Excel, Google Sheets or a .csv file).
  2. Toggle 'First row is headers' and pick the delimiter if needed.
  3. Copy the resulting JSON from the output pane.

Features

  • RFC 4180-style parsing: quoted fields, escaped quotes, embedded newlines
  • Header row → array of objects, or raw array-of-arrays mode
  • Automatic type detection for numbers, booleans and null
  • Comma, semicolon and tab delimiters

Frequently Asked Questions

How do I convert an Excel sheet to JSON?

In Excel or Google Sheets, copy the range or export as CSV, paste it here, and copy the JSON output. Keep 'First row is headers' on if your sheet has column names.

Why are my numbers quoted as strings?

Values that aren't plain numbers (like '007' with a leading zero, or '1,000' with separators) stay as strings to avoid corrupting data. Clean numeric values convert automatically.

Is the CSV to JSON converter free?

Yes, the CSV to JSON converter is completely free with no usage limits. No signup, no account and no installation required.

Is my data safe?

Yes. All processing happens locally in your browser using JavaScript — nothing you type is uploaded or stored on our servers.