Nested JSON Fields

When importing data from a JSON file, you may encounter nested fields—fields that are not at the top level of the JSON structure. Simple Tables makes it easy to detect and extract these nested fields as additional columns.

After uploading a JSON file, if nested fields are detected, you'll see a banner indicating that more fields are available. You can add them by opening the Columns tab and clicking New column.

Simply reference the nested field using a dot-separated path. For example, for this JSON object:

{
  "user": {
    "name": "Alice",
    "email": "alice@example.com"
  },
  "order": {
    "id": 123,
    "total": 99.99
  }
}

You can create columns with paths like user.name or order.total.

Use case: Customer profile extraction

Use case: Customer profile extraction
avatar

Customer Insights Team

Shinkansen Systems — CRM Analytics

Context and goal:
The CRM team manages a customer.json file that contains user profiles, where contact details and customer status are stored within nested objects.

Solution:
They use user.name, user.email, and status.level as new columns to extract relevant fields. These columns are then combined with calculated columns to classify users.

Impact:
The team avoids writing custom scripts or flattening the data manually. Nested fields are handled seamlessly, reducing preparation time and improving visibility.

Nested field support is especially useful for product catalogs, customer profiles, or any hierarchical data stored in structured JSON.