How are quoted fields handled?

Fields enclosed in double quotes are parsed correctly, even if they contain the delimiter character, newlines, or other special characters. Escaped quotes (two consecutive double quotes inside a quoted field) are also handled properly.

CSV/JSON Converter | QuickUtil.dev

How It Works

⚡

Instant Conversion

Paste CSV or JSON data and convert with a single click. The output updates immediately with properly formatted results. All processing happens locally in your browser.

🔄

Bidirectional

Convert CSV to JSON or JSON to CSV. Switch between formats freely. The tool automatically collects all unique keys from JSON objects to build CSV headers.

⚙

Configurable Delimiters

Choose from comma, semicolon, tab, or pipe delimiters. Handle European-style CSVs (semicolon-separated) and tab-separated value files with ease.

📊

Data Preview

See your parsed data in a formatted table with column headers, row counts, and field statistics. Verify your data looks correct before downloading or copying.

Understanding CSV and JSON Formats

CSV (Comma-Separated Values) and JSON (JavaScript Object Notation) are two of the most widely used data interchange formats. CSV is a plain-text format where each line represents a record and fields are separated by a delimiter (typically a comma). JSON is a lightweight, human-readable format that represents structured data as key-value pairs and arrays.

When to Convert CSV to JSON

CSV files are commonly exported from spreadsheets, databases, and reporting tools. Converting CSV to JSON is useful when you need to consume tabular data in web applications, APIs, or NoSQL databases that expect JSON input. JSON provides richer structure with named fields, nested objects, and typed values (numbers, booleans, nulls) that CSV cannot natively represent.

When to Convert JSON to CSV

JSON data from APIs, configuration files, or databases sometimes needs to be imported into spreadsheet applications like Excel or Google Sheets, or into relational databases. Converting JSON to CSV flattens the data into a tabular format that these tools can readily process.

Handling Edge Cases

Quoted fields: Fields containing commas, newlines, or the delimiter character must be enclosed in double quotes per RFC 4180.
Escaped quotes: A literal double quote inside a quoted field is represented as two consecutive double quotes ("").
Mixed delimiters: European locales often use semicolons instead of commas because commas are used as decimal separators.
Headerless files: Some CSV exports omit the header row. Disabling the header option generates automatic column names.
Type coercion: This tool automatically detects numbers, booleans, and null values in CSV fields and converts them to their proper JSON types.

Frequently Asked Questions

How does CSV to JSON conversion work? ▼

The converter parses each row of CSV data using the specified delimiter. The first row is treated as column headers (when the "First row is header" option is enabled), and each subsequent row becomes a JSON object with header names as keys and row values as values. The result is an array of JSON objects. Fields are automatically typed -- numbers become JSON numbers, "true"/"false" become booleans, and "null" becomes null.

What delimiters are supported? ▼

The tool supports four delimiters: comma (,), semicolon (;), tab, and pipe (|). Select the appropriate delimiter from the dropdown before converting. The default delimiter is comma. Semicolons are common in European CSV files where commas serve as decimal separators. Tab-separated values (TSV) are frequently used in scientific and database exports.

How are quoted fields and escaped quotes handled? ▼

Fields enclosed in double quotes are parsed correctly, even if they contain the delimiter character, newlines, or other special characters. For example, a field like "Smith, John" will be parsed as the single value Smith, John. Escaped quotes (two consecutive double quotes inside a quoted field, like "He said ""hello""") are also handled properly and converted to a single double quote in the output.

Can I convert JSON back to CSV? ▼

Yes. Paste a JSON array of objects into the input area and click "JSON to CSV". The tool collects all unique keys from all objects in the array to form the CSV header row, then outputs each object as a CSV row. Fields that contain the delimiter character, double quotes, or newlines are automatically escaped with proper quoting. You can also convert a single JSON object, which will produce a CSV with one data row.

What happens if my CSV has no header row? ▼

Uncheck the "First row is header" option. When disabled, the tool generates automatic column names (column1, column2, column3, etc.) and treats every row -- including the first -- as data. This is useful for headerless CSV files, raw data exports, or machine-generated data where columns are identified by position rather than name.

Is my data safe when using this tool? ▼

Yes. This CSV to JSON converter runs entirely in your browser using JavaScript. No data is sent to any server, stored, or logged. All conversion and parsing happens locally on your device. You can verify this by disconnecting from the internet and confirming the tool still works. This makes it safe to use with sensitive data, internal reports, or confidential records.

CSV to JSON Converter