Sample JSON File

An array of 60 customer records with a nested address object, a tags array and a boolean field — the shape you hit when flattening API responses into a table.

Download the sample file

JSON · 60 records · 16.0 KB · synthetic data, free for any use

Download JSON sample

Preview

[
  {
    "id": 1,
    "name": "Paul Bennett",
    "email": "[email protected]",
    "address": {
      "city": "Shanghai",
      "country": "China"
    },
    "orders": 5,
    "lifetime_value": 4050.99,
    "tags": [
      "newsletter"
    ],
    "active": true
  },
  {
    "id": 2,
    "name": "Nina Cohen",
    "email": "[email protected]",
    "address": {
      "city": "São Paulo",
      "country": "Brazil"
    },
    "orders": 34,
    "lifetime_value": 881.99,
    "tags": [
      "trial",
      "beta"
    ],
    "active": true
  },
  {
    "id": 3,
    "name": "Tomás Silva",
    "email": "[email protected]",
    "address": {
      "city": "São Paulo",
      "country": "Brazil"
    },
    "orders": 40,
    "lifetime_value": 790.67,
    "tags": [
      "vip"
    ],
    "active": true
  }
]

Columns

Column	Type	Description
`id`	number	Record id 1–60
`name`	string	Full name
`email`	string	@example.com address
`address`	object	Nested { city, country }
`orders`	number	Lifetime order count
`lifetime_value`	number	LTV in USD
`tags`	array of strings	0–3 tags per record
`active`	boolean	true / false

What makes this file useful

address is a nested object and tags is an array — the two fields that force a converter to make a flattening decision (dot keys, JSON string, or exploded rows).
Some tags arrays are empty, which is the edge case that breaks naive "join by comma" code.
The file is a top-level JSON array, not newline-delimited JSON — use the NDJSON sample tooling if you need JSONL.

Use cases

Test a JSON-to-CSV converter and see how it flattens address and tags
Mock an API response in a front-end test
Practise JSONPath / dot-notation extraction
Compare nested vs flattened representations

Open it in a tool

Load this sample — or your own file — into a real tool. Everything runs client-side.

CSV to JSON NDJSON to CSV YAML to CSV XML to CSV Schema Detect

Related guides

More sample datasets

Sample TSV FileA tab-separated version of a simple customer table — 100 rows — for testing a TSV parser, a TSV-to-CSV convers…Sample Customers CSV FileA CRM-style contact list with international names, valid-looking emails and phone numbers, cities and customer…Sample CSV File With HeadersA deliberately clean CSV with a proper header row and 100 well-formed data rows — no missing values, no stray …Sample Products CSV FileA product catalog with prices, costs, stock levels, SKUs and ratings — enough structure to compute margins, fl…

Browse all sample CSV files →

Frequently asked questions

Is this valid JSON?

Yes. It is a pretty-printed top-level array of objects and parses in any standard JSON library.

How do I turn it into a CSV?

Use the JSON to CSV tool. You will be asked how to handle the nested address and the tags array.

Is there a JSONL / NDJSON version?

Not directly, but the NDJSON to CSV tool documents the format, and you can convert this array to JSONL with one line of code.

Turn this into a saved workflow

Create a free account to save the steps from this guide as a reusable workflow and re-run it on any file, from any device.

Follow HowToCSV on Google

Add us as a preferred source on Google Search so our latest CSV guides and tutorials surface more often in your Top stories.

Add HowToCSV as a preferred source

Sample JSON File — Free Download