Automated JSON unnester Unnest and download any JSON effortlessly with this powerful Apify actor. Handle complex nested structures, expand lists into rows, and customize your output 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, view the JSON file and export to a file type of your desire from the Key-value store. ## Example Input JSON: json { "id": 1, "name": "John Doe", "emails": ["john@example.com", "jdoe@example.com"], "address": { "street": "123 Main St", "city": "Anytown" } } 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 unnesting it automatically, ready for analysis and reporting. Try the Automated JSON unnester actor today! ```