logo

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.

Upload a CSV, TSV, PSV File
*Note: If you need to select other than default option for "Expand Nested Object", "Expand Array Object", "Array Indexes As Keys", "Unwind Arrays". Leave "Select Header" to default.
Select Header

Related Tools

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"