JSON to CSV Converter

Convert any JSON data into a CSV file effortlessly with this powerful Apify actor. Handle complex nested structures and expand lists into rows with ease.

Features

• Handles Nested Structures: Flattens nested JSON objects and arrays into a CSV format.
• Expand Lists into Rows: Option to expand lists so that each item becomes a separate row.
• Multiple Input Methods: Provide JSON data via URL or by pasting the JSON text directly.
• Customizable Output: Define custom separators for nested keys.

Benefits

• Ease of Use: Convert complex JSON data without writing any code.
• Flexibility: Suitable for any JSON structure, no matter how deeply nested.
• Efficiency: Quickly transform data for analysis, reporting, or integration with other tools.

How to Use

1. Input Your JSON Data:

   • JSON File URL: Enter the URL of your JSON file.
   • Paste JSON Text: Copy and paste your JSON content into the provided text area.

2. Customize Options (optional):

   • Expand Lists into Rows: Check this option to expand lists into multiple rows.
   • Key Separator: Set a custom separator for nested keys (default is .).

3. Run the Actor:

   • Click the Start button to begin the conversion process.

4. Retrieve Your CSV File:

   • After the run completes, download the CSV file from the Key-value store. Or export it to another format as per desire.

Example

Input JSON:

1{
2  "id": 1,
3  "name": "John Doe",
4  "emails": ["john@example.com", "jdoe@example.com"],
5  "address": {
6    "street": "123 Main St",
7    "city": "Anytown"
8  }
9}

Output CSV:

id	name	emails[0]	emails[1]	address.street	address.city
1	John Doe	john@example.com	jdoe@example.com	123 Main St	Anytown

Support

For any questions or issues, please open an issue in the GitHub repository or contact support.

---

Unlock the full potential of your JSON data by converting it into a CSV format that's ready for analysis and reporting. Try the JSON to CSV Converter actor today!