JSON to CSV, TSV, PSV Converter
Converts JSON data or a file into CSV, TSV, or PSV data or downloads as a CSV, TSV, or PSV file. Select the specific field and various other options for conversion.
Related Tools
-
RGB to HEX color convert and color picker Convert RGB color to HEX color and vice versa. Pick a color with color picker from the screen or choose from the color palette and convert it to RGB or HEX color.
-
QR Code Generator - Create a QR Code from URL, Text, Email, WiFi, Phone, SMS, and Location Generate a QR Code from URL, Text, Email, WiFi, Phone, SMS, and Location. Download the QR code in PNG, JPG, WebP, and SVG format.
-
QR Code Scanner - Scan the QR code from an image, screenshot, data URI, camera, or webcam for free Scan the QR code from an image, screenshot, data URI, camera, or webcam for free - unlimited use without the need for any app.
-
CSV, TSV or PSV to JSON Converter Converts CSV, TSV, or PSV data or a file into JSON data or downloads as a JSON file. Add custom header fields if they are not in the file, or select the specific field after conversion.
JSON to CSV, TSV or PSV Converter
Converts JSON data or a file into CSV, TSV, or PSV data and downloads as a CSV, TSV, or PSV file. Select the specific field and various other options for conversion.
What is a JSON to CSV, TSV, or PSV converter?
A JSON to CSV, TSV, or PSV converter is a tool that helps to convert JSON to CSV, TSV, or PSV. You can choose the fields you want in the "Select Header" option and various other options. Once converted, you can copy or download it as a CSV, TSV, or PSV file.
What is a CSV file?
CSV stands for comma-separated values. A CSV file is a plain text file that stores data in a tabular format. In CSV, values are separated by a comma or a semicolon. The file has a file extension of ".csv"
What is a TSV file?
TSV stands for tab-separated values. A TSV file is a plain text file that stores data in a tabular format. In TSV, values are separated by a tab. The file has a file extension of ".tsv"
What is a PSV file?
PSV stands for pipe-separated values. A PSV file is a plain text file that stores data in a tabular format. In PSV, values are separated by a pipe. The file has a file extension of ".psv"
Can I add a specific value if the field doesn't have value?
Yes, you can add any value like "n/a" or "-" or anything. Just add value in "Empty field value".
Can I download the CSV, TSV, or PSV without header fields?
Yes, you can download the file or copy data without header fields. Just toggle "Remove Header" to "Yes" before conversion.
Can I select specific fields in CSV, TSV, or PSV?
Yes, you can select a specific field as your requirement and copy the CSV, TSV, or PSV data or download it into a CSV, TSV, or PSV file.
What is "Prevent CSV Injection"?
If you select "Prevent CSV Injection" to "Yes". It will remove these characters: equals(=), plus(+), minus(-), at(@), tab, and carriage return.
What is "Expand Nested Object"?
"Expand Nested Object" if selected to "Yes". It will expand the object list into a new column.
Eg: [ { "iPhone": {"old": "14", "new": "15"} }]
They will expand the header to "iPhone.old" and "iPhone.new"
What is an "Expand Array Object"?
"Expand Array Object" if selected "Yes". It will expand into the header as each child's keys.
Eg: [ { "iPhone": [{"old": "14"}, {"new": "15"}] }]
This will expand as iPhone.0.old and iPhone.1.new
What is "Array Indexes As Keys"?
If "Array Indexes As Keys" is selected as "Yes". Keys with the array will be expanded like "key.0", and "key.1".
Eg: [ { "name": "MacBook", "models": ["air", "pro"] } ]
The header will be "name", "models.0", and "models.1".
What is "Unwind Arrays"?
If "Unwind Arrays" is selected as "Yes". Keys with the array will be new rows for each value in the array.
Eg: [ { "name": "MacBook", "models": ["air", "pro"] } ]
This will create 3 rows of data in CSV, TSV, or PSV.
"name", "models"
"MacBook", "air"
"MacBook", "pro"