20+ Free JSON Datasets for Testing (Shopify, Jira, Stripe, & More)

Finding good JSON test data is surprisingly hard. Most "sample" generators create flat, unrealistic data that doesn't test your application's ability to handle deeply nested objects, arrays of objects, or large file sizes.

To help developers and data analysts, we've compiled a collection of realistic, complex JSON datasets that you can download for free. These aren't just random strings—they mirror the actual structure of popular API exports.

[!TIP] You can drag and drop any of these files directly into JsonExport to instantly view them as an Excel or CSV file.

🛍️ E-Commerce Datasets

1. Shopify Orders Export (Complex)

This dataset mimics a full Shopify order export, including nested line items, customer details, shipping addresses, and tax lines. Perfect for testing "Order to Row" flattening logic.

• Structure: Deeply nested (Orders -> Line Items -> Tax Lines)

• Complexity: High

• Size: ~85 MB

• Records: 100,000+ orders

• Records: 100,000+ orders

Download shopify_orders.json | View in Excel

2. Stripe Payments (simulated)

Simulated Stripe API objects including charges, refunds, and customer metadata.

• Structure: Nested metadata and payment method details
• Complexity: Medium
• Size: ~5 MB

Download test-5mb.json

---

🛠️ Project Management & DevOps

3. Jira Issues Export

A complex export simulating Jira issues, including comments, worklogs, history, and custom fields. This is notoriously difficult to parse because of the variable custom fields and arrays within arrays.

• Structure: Issues -> Fields -> Worklogs -> Authors

• Complexity: Very High

• Size: ~40 MB

• Size: ~40 MB

Download jira_issues.json | View in Excel

4. MongoDB Logs

Raw server logs in JSON format, typical of what you'd export from MongoDB or ELK stack. Great for testing performance with massive numbers of keys.

• Structure: Flat but wide (hundreds of potential keys)
• Complexity: Low (but high volume)
• Size: ~38 MB

Download mongodb_logs.json

---

🏋️ Large File Testing

Need to stress-test your parser? We have generated standardized files of various sizes.

Note: Most online converters crash with files over 10MB. JsonExport handles files up to 100MB+ primarily because it runs 100% in your browser—no server upload required.

---

License

These datasets are generated programmatically and are free for any use (commercial or personal). No attribution required, though a link back to JsonExport.com is always appreciated!

Want to convert these to Excel?

You don't need Python or Power Query.

1. Download a file above.
2. Go to the converter.
3. Drop the file.
4. Click Export to Excel.

It's that simple. Happy coding!