Automated JSON unnester
Pricing
$2.00/month + usage
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.
0.0 (0)
Pricing
$2.00/month + usage
1
Monthly users
1
Runs succeeded
97%
Last modified
4 months ago
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!
Pricing
Pricing model
RentalTo use this Actor, you have to pay a monthly rental fee to the developer. The rent is subtracted from your prepaid usage every month after the free trial period. You also pay for the Apify platform usage.
Free trial
30 minutes
Price
$2.00
