Skip to content

CSV to JSON

Convert a CSV export into clean, typed JSON.

Quick Tool Overview

CSV to JSON converts a spreadsheet export into a JSON array of objects, using the header row for keys. The parser is a proper one, so quoted fields containing commas and embedded line breaks are read correctly instead of splitting into the wrong columns.

What it does
Converts CSV rows into a JSON array of objects
You give it
Pasted CSV text or a dropped .csv file
You get back
Clean JSON, with optional type conversion
Best for
Seeding APIs, importing exports and preparing test data
Converters Free, unlimited use No sign-up Runs in your browser

About the CSV to JSON

Paste a CSV export — or drop the file in — and get a JSON array of objects using the header row for keys. The parser is a proper one, so quoted fields containing commas and embedded line breaks are read correctly instead of splitting into the wrong columns.

Type conversion is optional and off by default. With it enabled, numeric strings become numbers and true/false become booleans, which is usually what you want when feeding an API. Leave it off when your data contains identifiers such as postcodes or phone numbers with leading zeros that must stay strings.

Key features of the CSV to JSON

A real CSV parser

Quoted fields containing commas and embedded line breaks are handled correctly rather than split on every comma.

Header row becomes keys

The first row is used for object keys, so the JSON is immediately usable.

Optional type conversion

Turn numeric strings into numbers and true/false into booleans when you are feeding an API.

Leading zeros protected

Type conversion is off by default, which keeps postcodes and phone numbers as strings instead of mangling them.

Paste or drop a file

Work from the clipboard or drag the export straight in — either way it is parsed locally.

How to use the CSV to JSON

  1. 1

    Paste or drop your CSV

    Provide comma, semicolon or tab separated data, with or without a header row.

  2. 2

    Set the options

    Confirm the delimiter, say whether the first row is a header, and choose whether to convert types.

  3. 3

    Copy the JSON

    Take the formatted JSON array, or download it as a .json file.

Frequently asked questions

Turn the header option off and each row becomes an array of values instead of an object with named keys.

Reviews of the CSV to JSON

What people who use the CSV to JSON think of it. Reviews come from visitors and are posted as written.

No ratings yet

Yours would be the first.

  • 5 0 reviews rated 5 stars
  • 4 0 reviews rated 4 stars
  • 3 0 reviews rated 3 stars
  • 2 0 reviews rated 2 stars
  • 1 0 reviews rated 1 star

Write a review

Used this tool? Your rating helps the next person decide.

Your rating

Plain text only — links, email addresses and HTML are not accepted. Your name and review are shown publicly; nothing else is collected. See the privacy policy.

0 reviews

Newest first

No reviews yet

Be the first to rate the CSV to JSON. It takes half a minute and no account.

Write the first review

More converters