CSV to JSON converter (and JSON to CSV)
Paste CSV or open a spreadsheet export to get clean JSON for an API or app, or turn a JSON array back into a CSV that opens in Excel or Google Sheets.
Runs in your browser. Your files and data stay on your device and are never uploaded to EpiFive.
How to use it
- Choose CSV to JSON or JSON to CSV.
- Open a file or paste your data. The result appears straight away.
- For CSV, check the delimiter, whether the first row holds column names, and whether numbers and true/false should be typed.
- Copy the result, download it as a .json or .csv file, or tap Convert back to check the round trip.
Example
The CSV name,age / Asha,31 becomes [{"name": "Asha", "age": 31}] as an array of objects, or [["name", "age"], ["Asha", 31]] as an array of arrays.
Related tools
- JSON formatter: Format, validate and minify JSON, with the line and column of any error.
- YAML to JSON converter: Convert YAML to JSON and JSON to YAML, with line and column for errors and multi-document support.
- Text diff checker: Compare two texts side by side or inline, with changed words highlighted and options to ignore whitespace and case.
- Base64 encode and decode: Encode or decode Base64 text (UTF-8 safe) and convert files to and from Base64.
Questions people ask
Does it handle commas and line breaks inside values?
Yes. It follows the CSV standard (RFC 4180): a value in double quotes can contain commas, line breaks and quotes written as two double quotes (""). Windows (CRLF) and Unix line endings and the byte order mark Excel adds are handled too.
My CSV uses semicolons. Will it work?
Yes. Excel in many European locales saves CSV with semicolons, and exports from databases often use tabs or pipes. The delimiter is detected automatically, or you can pick comma, semicolon, tab or pipe yourself.
Why do some numbers stay as text?
With typing on, plain numbers become JSON numbers and true, false and null become their JSON values. Values with leading zeros (PIN codes, employee IDs such as 007) and numbers longer than 15 digits (phone or account numbers) stay text, because converting them would change or round them.
How are nested JSON objects turned into CSV?
Nested objects become columns with dot-separated names, so {"address": {"city": "Pune"}} gives an address.city column. Arrays are written as JSON text in one cell. Tick “Nest dotted columns” when converting back to rebuild the nested objects.
Will Excel open the CSV correctly?
Yes. The downloaded CSV uses Windows line endings and, by default, a UTF-8 byte order mark so Excel shows Hindi, other Indian scripts, ₹ and accented letters correctly instead of garbled characters.
Is my data uploaded?
No. Files are read and converted in your browser, so customer lists and exports never leave your device or reach EpiFive.