(208) 391-7176
ALCO Tools · Files

CSV to JSON converter

Convert CSV to JSON and JSON back to CSV, with quoted fields and ragged rows handled properly.

Opening tool…

Runs in your browser. Nothing you enter is uploaded to ALCO.

Overview

About this tool.


Turn a CSV export into JSON, or an array of JSON objects back into CSV, without opening a spreadsheet. Commas inside quoted fields, escaped quotes, semicolon and tab delimiters, and rows with missing columns are all handled by a real parser rather than a split on commas, and anything that looks wrong is reported row by row instead of silently dropped. The conversion runs in your browser, so an export full of customer records or invoice data never leaves your machine.

Common questions

Using this tool.


Why did my postcode or product code lose its leading zero?

Because “Convert numbers and booleans” turned 01234 into the number 1234. Codes, postcodes and phone numbers are text that happens to be made of digits, so untick that option and every value comes through as a string.

What happens to nested JSON when I convert to CSV?

A nested object or array is written into the cell as JSON text, and the tool tells you how many values that affected. CSV is a flat format with no way to express nesting, so the alternative would be to lose the data.

My CSV uses semicolons. Will it work?

Yes. Detection is automatic and usually right, and you can force comma, semicolon, tab or pipe if a file confuses it — which happens with European exports where the decimal separator is also a comma.

Why is there a 1 MB limit?

Both the input text and the parsed result sit in your browser’s memory at once, and a larger file will make the tab stall, especially on a phone. Above a megabyte a spreadsheet application or a command-line tool is the right instrument.

Need more than a quick tool?

These are free and always will be. If one of them is solving a problem you keep having, the underlying issue is usually worth a conversation.

Interested in

Fields marked “required” must be completed. Prefer to talk? Call +1 (208) 391-7176 or book a call.