Examples of JSON to CSV Conversion

See how different types of JSON data convert to CSV format

Example 1: Product List

E-commerce product data with prices and categories

JSON Input:

[
  {
    "id": 1,
    "name": "Wireless Headphones",
    "price": 99.99,
    "category": "Electronics",
    "inStock": true
  },
  {
    "id": 2,
    "name": "Coffee Mug",
    "price": 12.50,
    "category": "Home",
    "inStock": false
  }
]

CSV Output:

id	name	price	category	inStock
1	Wireless Headphones	99.99	Electronics	true
2	Coffee Mug	12.50	Home	false

Example 2: User Data

User profiles with contact information

JSON Input:

[
  {
    "userId": "u001",
    "name": "John Doe",
    "email": "john@example.com",
    "age": 28,
    "city": "New York"
  },
  {
    "userId": "u002",
    "name": "Jane Smith",
    "email": "jane@example.com",
    "age": 32,
    "city": "Los Angeles"
  }
]

CSV Output:

userId	name	email	age	city
u001	John Doe	john@example.com	28	New York
u002	Jane Smith	jane@example.com	32	Los Angeles

Example 3: API Response

Typical REST API response with nested data

JSON Input:

[
  {
    "id": 1,
    "title": "Sample Post",
    "author": {
      "name": "Alice Johnson",
      "email": "alice@blog.com"
    },
    "publishedAt": "2024-01-15",
    "tags": ["tech", "programming"]
  }
]

CSV Output:

id	title	author.name	author.email	publishedAt	tags
1	Sample Post	Alice Johnson	alice@blog.com	2024-01-15	tech,programming

Ready to Convert Your JSON?

Try our tool with your own JSON data