CSV to JSON Converter
AvailableConvert CSV to JSON or JSON to CSV, with type detection and protection against spreadsheet formulas.
Use the tool
Everything runs in your browser. Your text is not uploaded or stored.
About this tool
Turn a CSV table into JSON, or a JSON array of objects into CSV. Quotes, commas inside values and line breaks inside quotes are handled, and commas, semicolons and tabs are detected as separators.
How it works
- The first CSV row becomes the keys. Every other row becomes one object.
- By default every value stays text. You can ask for numbers and true / false to be detected; values with leading zeros such as 007 stay text.
- For JSON to CSV, the columns are all keys found in the objects, and nested values are written as JSON text.
Common questions
What are spreadsheet formulas in CSV output?
A value that starts with = + - or @ can run as a formula when the file is opened in a spreadsheet. By default we add a leading apostrophe to defuse it. Choose to keep values exactly if you need the raw data.
Why did my number lose its leading zero?
It did not, unless you chose type detection and the value is a plain number. Codes such as 007 are kept as text so they are not changed.
Your text is processed in your browser and is never uploaded.
Related tools
JSON Formatter & Validator
AvailableFormat, minify, sort and check JSON, with the line and column of any error.
Developer Tools
Base64 Encoder & Decoder
AvailableEncode text to Base64 or decode it back, with standard and URL-safe alphabets and full Unicode support.
Developer Tools
URL Encoder & Decoder
AvailablePercent-encode a value or a whole URL, or decode one, and find broken sequences.
Developer Tools
UUID Generator
AvailableGenerate random version 4 UUIDs in bulk, in lowercase, uppercase or without hyphens.
Developer Tools