How to Convert CSV to JSON — Complete Guide

The fastest way to convert CSV to JSON is to use a free online tool. This guide covers all methods — from drag-and-drop converters to JavaScript and Python code examples.

Published: May 27, 2025 Updated: May 27, 2026 5 min read

What is CSV to JSON Conversion?

Converting CSV to JSON means transforming tabular data (rows and columns) into a structured JSON format (objects and arrays). CSV files use plain text with delimiters to separate values. JSON uses key-value pairs and arrays that are natively understood by JavaScript, APIs, and most modern programming languages.

For example, this CSV:

Name,Age,City John,28,New York Jane,32,London

Becomes this JSON array:

[ { "Name": "John", "Age": 28, "City": "New York" }, { "Name": "Jane", "Age": 32, "City": "London" } ]

Method 1: Free Online Converter (Fastest)

The quickest way to convert CSV to JSON with no code required:

1

Open the Converter

Go to convertcsv2json.getinfotoyou.com. No account or download needed.

2

Input Your CSV Data

Either drag and drop a .csv file into the upload zone, click to browse for a file, or paste CSV text directly into the input textarea.

3

Configure Settings (Optional)

The tool auto-detects your delimiter. You can also set output format (array, object, or nested), enable number/boolean parsing, and toggle pretty-print.

4

Get Your JSON Output

The JSON output appears instantly. Click Copy to copy to clipboard or Download to save a .json file.

All processing happens in your browser — your CSV data is never uploaded to any server. Try it now →

Method 2: Convert CSV to JSON in JavaScript

For developers who need to convert CSV to JSON programmatically in JavaScript or Node.js:

function csvToJson(csv) { const lines = csv.trim().split('\n'); const headers = lines[0].split(',').map(h => h.trim()); return lines.slice(1).map(line => { const values = line.split(','); return headers.reduce((obj, header, i) => { obj[header] = values[i]?.trim() || ''; return obj; }, {}); }); } // Usage const csv = `Name,Age,City John,28,New York Jane,32,London`; console.log(JSON.stringify(csvToJson(csv), null, 2));

Method 3: Convert CSV to JSON in Python

Python's built-in csv and json modules make this straightforward:

import csv import json def csv_to_json(csv_filepath, json_filepath): data = [] with open(csv_filepath, 'r', encoding='utf-8') as f: reader = csv.DictReader(f) for row in reader: data.append(dict(row)) with open(json_filepath, 'w', encoding='utf-8') as f: json.dump(data, f, indent=2) # Usage csv_to_json('data.csv', 'data.json')

Method 4: Convert Excel to JSON

Excel files (.xlsx) cannot be converted directly, but the process is simple:

  1. Open your Excel file in Microsoft Excel or Google Sheets
  2. Go to File → Save As (Excel) or File → Download → CSV (Google Sheets)
  3. Choose CSV (Comma delimited) format
  4. Upload the saved CSV to our CSV to JSON converter

JSON Output Formats Explained

Our converter supports three output formats:

Array of Objects (most common)

Each CSV row becomes a JSON object in an array. Best for APIs and databases.

[ { "Name": "John", "Age": 28 }, { "Name": "Jane", "Age": 32 } ]

Object with Keys

Uses a specified field as the key. Good for lookup tables.

{ "John": { "Name": "John", "Age": 28 }, "Jane": { "Name": "Jane", "Age": 32 } }

Tips for Better CSV to JSON Conversion

  • Use the first row as headers — our converter uses the first row as JSON keys automatically
  • Enable Parse Numbers — converts numeric strings like "28" to actual numbers
  • Auto-detect delimiter — works for comma, semicolon, tab, and pipe separated files
  • Enable Trim Whitespace — removes extra spaces from field values
  • Use Pretty Print — formats JSON with indentation for readability

Ready to Convert?

Use our free online tool — no signup, no upload to servers, instant results.

Convert CSV to JSON Free →