CSV to JSON Converter

Convert CSV data into a clean JSON array of objects. Handles quoted fields, custom delimiters, and automatic type inference.

Note: The first row of your CSV is treated as the header row (keys for the JSON objects). If your CSV does not have headers, the tool will generate generic keys like column1, column2, etc.

Paste Your CSV Data

Delimiter

Type Inference

JSON Indentation

JSON Output

What is a CSV to JSON Converter?

A CSV to JSON converter is a tool that transforms Comma-Separated Values (CSV) data into JavaScript Object Notation (JSON). CSV is the universal format for spreadsheets and tabular data, while JSON is the standard format for web APIs and modern applications. Converting between the two is a fundamental data preparation task for developers, data analysts, and anyone who needs to move data between a spreadsheet and a web service.

The core challenge of this conversion is structural. CSV is inherently flat: it consists of rows and columns, with no concept of nesting or hierarchy. JSON, on the other hand, is hierarchical and can represent complex nested objects and arrays. A CSV to JSON converter must make intelligent decisions about how to map the flat tabular data into a structured JSON array of objects. The most common approach is to treat the first row of the CSV as the header (the keys) and each subsequent row as an object, with the values from each column mapped to the corresponding key.

Why Convert CSV to JSON?

You convert CSV to JSON for one primary reason: to feed data into an application or API. Here are the most common scenarios:

API Payloads: When you need to send tabular data to a REST API, it almost always expects JSON. If your data is in a CSV export from Excel or Google Sheets, you must convert it to JSON first.
Database Seeding: When setting up a new database, you often need to insert initial data (seed data). If the data is provided as a CSV, converting it to JSON makes it easy to write a script that inserts the records using a MongoDB, Firebase, or similar document-based database.
Mock Data for Testing: Front-end developers often need realistic mock data to build UI components. A CSV file of sample data can be quickly converted to JSON and used as a static fixture in tests or a development environment.
Data Migration: When migrating from a legacy system that exports CSV to a modern application that consumes JSON, a converter bridges the gap without writing custom parsing code.

The Core Challenge: Quoted Fields and Delimiters

A naive CSV parser that simply splits on commas will fail on real-world data. The most common issue is quoted fields. If a value contains a comma (e.g., "New York, NY"), it must be wrapped in double quotes so the parser does not treat the comma as a column separator. A robust converter must correctly identify quoted fields and handle escaped double quotes inside them (which are represented as "").

Another challenge is custom delimiters. While comma is the most common, some regions use semicolons (common in European locales where the comma is used as a decimal separator), and some systems use tabs (TSV) or pipes. This tool supports all four delimiters, ensuring it works with data from any source.

Understanding Type Inference

CSV stores all data as text. A value of 30 in a CSV file is the string "30", not the number 30. JSON, however, distinguishes between strings, numbers, booleans, and null. A good converter should infer the correct type:

Numbers: Values that match a numeric pattern (e.g., 30, 3.14, -5) are converted to JSON numbers.
Booleans: Values like true, false, yes, and no (case-insensitive) can be converted to JSON booleans.
Strings: Everything else remains a string.

This tool performs type inference by default, but you can disable it if you need all values to remain as strings (for example, if you have a numeric ID that must not be treated as a number).

Common CSV to JSON Conversion Pitfalls

Missing Headers: If your CSV does not have a header row, the tool will generate generic keys (column1, column2). Always ensure your first row contains meaningful column names.
Empty Cells: Empty cells become null or empty strings, depending on the context. This tool converts empty cells to empty strings to preserve the structure of the object.
Heterogeneous Rows: If some rows have more or fewer columns than the header row, the extra columns are ignored or missing values are left empty. This tool handles ragged rows gracefully by filling missing values with empty strings.
Large Files: Browsers have memory limits. For very large CSV files (e.g., >50MB), a command-line tool like csvtojson or Papa Parse in Node.js is more appropriate.

How to Use This Tool

Paste Your CSV: Insert your CSV data into the input textarea. Ensure the first row contains column headers.
Select Delimiter: Choose the correct delimiter for your data (comma, semicolon, tab, or pipe).
Configure Options: Choose whether to enable type inference (for numbers and booleans) and select your preferred JSON indentation.
Convert: Click "Convert to JSON". The tool will parse the CSV, build the JSON array, and display the result.
Copy or Download: Use the "Copy JSON" button to transfer the output to your clipboard.

Frequently Asked Questions

Is my CSV data sent to a server?

No. This tool runs entirely in your browser using client-side JavaScript. Your CSV data never leaves your device and is not logged or stored anywhere. It is 100% private and safe for sensitive data.

How does the tool handle quoted fields with commas?

The tool uses a proper CSV parser that correctly identifies quoted fields. If a value is wrapped in double quotes (e.g., "New York, NY"), the comma inside the quotes is treated as part of the value, not as a column separator. Escaped quotes inside a quoted field (represented as "") are also handled correctly.

What happens if my CSV does not have a header row?

The tool treats the first row as the header row. If your CSV does not have headers, the first row of data will be used as the keys, which will produce incorrect results. You should add a header row to your CSV before converting, or the tool will generate generic keys like column1, column2, etc.

How does type inference work?

When type inference is enabled, the tool checks each value: if it looks like a number (e.g., 30, 3.14), it becomes a JSON number. If it is true, false, yes, or no (case-insensitive), it becomes a JSON boolean. Everything else remains a string. You can disable this feature if you need all values to be strings.

Can I use a semicolon or tab as a delimiter?

Yes. Use the "Delimiter" dropdown to select comma, semicolon, tab, or pipe. This is useful for data from European locales (where comma is often the decimal separator and semicolon is used in CSV) or for tab-separated values (TSV) from clipboard data.

What happens to empty cells in the CSV?

Empty cells are converted to empty strings ("") in the JSON output. This preserves the structure of the object, ensuring that every key is present in every object, even if the value is empty.

Does this tool support nested JSON structures?

No. CSV is inherently flat, and this tool produces a flat JSON array of objects. It does not attempt to create nested objects from column names (e.g., address.city). If you need nested JSON, you would need a more advanced converter that supports dot-notation headers.

What is the maximum CSV size I can convert?

The limit depends on your browser's memory. Most modern browsers can handle CSV files of several megabytes without issue. For very large files (e.g., >50MB), a command-line tool like csvtojson (which has over 1.4 million weekly npm downloads) is more appropriate.

Can I convert JSON back to CSV?

This tool is specifically for CSV to JSON. If you need the reverse direction, you can use the JSON to CSV Converter tool on this site, which is designed for that exact purpose.

Why is my JSON output minified?

Use the "JSON Indentation" dropdown to choose between 2 spaces, 4 spaces, or minified (no spaces). Minified output is useful for reducing file size when sending data over a network.

Does this tool handle UTF-8 characters and emojis?

Yes. The tool operates on JavaScript strings, which are UTF-16 encoded, so it can handle Unicode characters, including emojis, accented letters, and non-Latin scripts. Your data is preserved correctly.

What happens if a row has more columns than the header?

The tool will ignore the extra columns beyond the header row. For example, if the header has 3 columns and a data row has 4 values, the 4th value is discarded. This prevents the JSON structure from breaking due to ragged rows.

What happens if a row has fewer columns than the header?

The tool fills the missing values with empty strings. For example, if the header has 3 columns and a data row has only 2 values, the 3rd key will have an empty string value. This ensures every object has the same structure.

Can I use this tool on my phone?

Yes. The interface is fully responsive and works on mobile browsers. However, for large CSV files, a desktop browser is recommended for better performance.

Is this tool free to use?

Yes. It is completely free, requires no sign-up, and has no usage limits. All processing is local, so there are no server costs.

Does this tool work offline?

After the page loads, the tool works offline because all parsing runs in your browser. You can disconnect from the internet and continue converting.

What is the difference between CSV and TSV?

CSV uses a comma as the delimiter, while TSV (Tab-Separated Values) uses a tab. Both are flat text formats for tabular data. This tool supports both, so you can convert either format to JSON.

Why does my number lose its leading zeros?

If type inference is enabled, a value like 007 is converted to the number 7, losing the leading zeros. If you need to preserve leading zeros (e.g., for zip codes or product IDs), disable type inference so all values remain as strings.

Can I convert a CSV file directly from my computer?

This tool accepts pasted text. You can open your CSV file in a text editor (or Excel/Google Sheets), copy the contents, and paste them into the input textarea.

What library does this tool use under the hood?

This tool uses a custom, lightweight CSV parser written in vanilla JavaScript. It implements the core RFC 4180 rules for quoted fields and delimiters, ensuring compatibility with standard CSV files from Excel, Google Sheets, and other tools.

What is the JSON output structure?

The output is a JSON array of objects. Each object represents one row of the CSV, with keys derived from the header row and values from the corresponding cells. For example: [{"name":"John","age":30},{"name":"Jane","age":25}].