Automated JSON unnester
No credit card required
Automated JSON unnester
No credit card required
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.
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
-
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.
-
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
.).
-
Run the Actor:
- Click the Start button to begin the conversion process.
-
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:
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 unnesting it automatically, ready for analysis and reporting. Try the Automated JSON unnester actor today!
PacoActor Metrics
1 monthly user
-
1 star
>99% runs succeeded
Created in Nov 2024
Modified 2 days ago
