CSV to JSON Converter

What this tool does

A spreadsheet export looks simple until a product description contains a comma, a customer address contains a newline, and someone used semicolons as the delimiter because their locale expects them. Splitting on every comma silently corrupts all three. This converter parses CSV, TSV and semicolon-delimited data properly, respecting quoted fields and embedded separators, and returns clean JSON that can be pasted into a test fixture, an API request body or a NoSQL import. Auto-detect guesses the delimiter from the first rows, and you can override it when the guess is wrong. It is a common first step when moving data between a finance export and a small script, or when you want to inspect exactly how a column was interpreted before loading it into a database.

How to use it in three steps

1. Paste the CSV, TSV or semicolon-delimited data, including its header row if there is one. Do not remove quotes; they are what keeps commas inside fields intact.
2. Leave the delimiter on Auto-detect, or set it explicitly if the first rows are ambiguous and the guessed output looks wrong.
3. Press Convert, then copy the JSON. Check one record containing a comma or a line break to confirm the parser kept it as a single field. Keep the header row in the paste, since those names become the JSON keys your script will read.

Questions people ask

Why did my output come out as one giant field?

The delimiter was probably guessed incorrectly. A European export often uses semicolons even though the file is named .csv; set the delimiter manually and convert again.

How are empty cells represented?

Empty values become empty strings in the resulting objects so the column structure stays consistent across rows. If your target schema needs null instead, transform that field after importing.

Can it handle a very large export?

It runs in your browser, so the limit is your device's memory and how much JSON you can comfortably read on screen. For a file with hundreds of thousands of rows, a command-line tool will be faster and easier to verify.

Why do numbers come through as strings?

The converter preserves the original field text rather than guessing types, because a value such as 0012 must stay exactly that in an identifier or a postcode. Convert selected fields to numbers in your own code where the schema calls for it.

Privacy: Delimited rows are parsed and turned into JSON inside your browser tab, so customer lists, financial exports and internal records never leave your device or reach a server.