CSV to JSON Converter

Turn CSV or spreadsheet data into a JSON array, with quoted fields handled properly.

How to Use CSV to JSON Converter

  1. Paste your CSV. Export from Excel or Sheets as CSV first if needed.
  2. Choose the delimiter (comma, semicolon or tab) and the output shape: Array of Objects or Array of Arrays.
  3. Untick 'First row is Header' if your data has no header row.
  4. Click Convert CSV to JSON, then Copy or Download the JSON.

Handles real-world CSV

The parser follows the usual CSV rules: values in double quotes can contain the delimiter, line breaks and doubled quotes ("" for a literal quote), so addresses and long descriptions come through intact. Blank lines are skipped. Semicolon is common in European Excel exports, and tab is what you get when you copy cells straight out of a spreadsheet.

Empty header cells get names like column_3, and repeated header names get a number added (name, name_2) so no column overwrites another.

Numbers, booleans and text

Values that are plainly numbers, like 42 or 3.5, become JSON numbers, and true or false become booleans. Anything that would change if turned into a number stays as text: ZIP or PIN codes with leading zeros such as 02134, phone numbers, IDs too long for JavaScript numbers, and values like 3.50. That keeps your data exactly as it was.

Key Features & Practical Use Cases

  • Turning a spreadsheet export into JSON for an app, API or database seed.
  • Converting a contact or product list into JSON for a website.
  • Preparing test data for code from data kept in Excel or Google Sheets.

Frequently Asked Questions

Can I open my Excel file directly?

Not an .xlsx file. In Excel or Google Sheets, save or download it as CSV first, then paste it here.

Why is a number in quotes in my JSON?

Values like 02134 or 3.50 are kept as text so leading zeros and formatting aren't lost.

My data uses semicolons. Will it work?

Yes. Choose Semicolon as the delimiter.

Is my data uploaded?

No. Everything is converted in your browser.

About OneClickly

OneClickly is a set of 119 free tools for PDFs, images, text, everyday math and code. They run in your browser, so the files and text you work with stay on your device.

Related Tools

  • HTML Formatter - Indent messy HTML so it is easy to read, or minify it to a single line.
  • SQL Formatter - Format and beautify SQL queries across multiple database dialects.
  • JSON Formatter & Validator - Format, validate, prettify, and parse raw JSON data.
  • JSON to CSV Converter - Convert a JSON array into CSV you can open in Excel or Google Sheets.
  • CSS Minifier - Remove comments and spaces from CSS to make the file smaller.
  • JavaScript Minifier - Minify JavaScript with terser: removes whitespace and comments and shortens local names.