JSON to CSV Converter

Convert JSON files to CSV format with customizable delimiter options. Supports both array of objects and array of arrays JSON structures.

How It Works

1

Upload JSON File

Select your JSON file or paste JSON data directly. The tool automatically detects whether your JSON is an array of objects or array of arrays.

2

Configure CSV Options

Choose your preferred CSV delimiter (comma, semicolon, tab, or pipe) and review how your JSON data will be structured as CSV.

3

Download CSV

Preview the converted CSV data and download the file. Your JSON data is now ready for use in spreadsheet applications or databases.

Frequently Asked Questions

What JSON structures can I convert?

The tool supports array of objects (where each object becomes a CSV row with properties as columns) and array of arrays (where each sub-array becomes a row). Complex nested objects are automatically flattened.

How are nested JSON objects handled?

Nested objects are flattened using dot notation. For example, a JSON object like {user: {name: 'John', age: 30}} becomes columns 'user.name' and 'user.age' in the CSV.

Can I choose different CSV delimiters?

Yes, you can choose from comma (,), semicolon (;), tab, or pipe (|) delimiters to ensure compatibility with your target system or regional CSV standards.

How are different data types converted?

Numbers and strings are preserved as-is, booleans become 'true'/'false', null values become empty cells, and dates are converted to ISO string format.

What happens with missing properties in objects?

If objects in your JSON array have different properties, missing properties are filled with empty values in the CSV to maintain consistent column structure.

Is there a file size limit?

The tool can process JSON files up to 50MB. For larger files, consider splitting your JSON data into smaller chunks before conversion.