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:

idnamepricecategoryinStock
1Wireless Headphones99.99Electronicstrue
2Coffee Mug12.50Homefalse
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:

userIdnameemailagecity
u001John Doejohn@example.com28New York
u002Jane Smithjane@example.com32Los 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:

idtitleauthor.nameauthor.emailpublishedAttags
1Sample PostAlice Johnsonalice@blog.com2024-01-15tech,programming

Ready to Convert Your JSON?

Try our tool with your own JSON data