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. Go to the Columns tab and click New column to add them.

Reference nested fields using a dot-separated path. Example JSON:


{
  "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

Customer Insights Team

Shinkansen Systems — CRM Analytics

Context and goal:
The CRM team manages a customer.json file with profiles where contact details and status live in nested objects.

Solution:
They add columns like user.name, user.email, and status.level, then combine them with calculated columns to classify users.

Impact:
No custom scripts or manual flattening. Nested fields are handled seamlessly, reducing prep time and improving visibility.

Tip
Use dot paths for arrays too, e.g. items.0.price for the first element’s price.

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

Want to try it in your site? InstallSimple Tables for Confluence from the Atlassian Marketplace.