Can Tableau Read JSON Data?

Thinking about analyzing data from a web API or a NoSQL database in Tableau? You've likely run into the JSON format, and your first question is probably, "Can Tableau even handle this?" The answer is a resounding yes. This article will show you exactly how to connect Tableau to your JSON data, walk you through the process of understanding its structure, and give you practical solutions for the common hiccups you might encounter along the way.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What is JSON and Why Is It Everywhere?

Before jumping into Tableau, let's quickly cover what JSON is. JSON stands for JavaScript Object Notation. It's a lightweight, text-based format for structuring and sending data. Think of it as a universal language for apps and servers to communicate.

You'll find JSON being used in several common scenarios:

• APIs: When you request information from services like Twitter, a weather app, or Google Analytics, the data they send back is almost always formatted as JSON.
• Configuration Files: Many modern applications use JSON files to store settings and configurations because they are easy for both humans and machines to read and modify.
• NoSQL Databases: Databases like MongoDB and CouchDB store data in a JSON-like format, making it flexible and well-suited for web-scale applications.

The core of JSON's structure is its use of key-value pairs (like a dictionary) and arrays (lists). This allows for nested, hierarchical data, which is powerful but can be tricky to work with in traditional table-based tools like Tableau. For example, a single customer record could contain an array of all their past orders, and each order could contain an array of the products included in that purchase.

The Direct Answer: Yes, Tableau Reads JSON

As of Tableau version 10.1, you can connect directly to local JSON files. This was a major update that unlocked a huge amount of data for analysis, especially from web-based sources. You don't need a special plugin or expensive third-party tool to get started. Tableau's built-in connector can handle the task right out of the box.

You can connect to a .json file saved on your computer, a network drive, or even pull it down through a Web Data Connector for live API data. The process itself is straightforward, but the key is understanding how Tableau translates the nested structure of JSON into the flat, tabular structure it needs to create visualizations.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

How to Connect Tableau to a JSON File: Step-by-Step

Let's get practical. Here is the exact process to connect your JSON data source to Tableau Desktop.

1. Open the "Connect" Pane

Launch Tableau Desktop. On the start page, you'll see the "Connect" pane on the left side of the screen. This is where you select your data source. Under the heading "To a File," look for JSON File.

Quick Tip: If you don't see it listed immediately, click on "More..." at the bottom of the list. This opens up a complete list of file-based connectors, where you'll find the JSON File option.

2. Select Your JSON File

After clicking on "JSON File," a familiar file dialog box will open. Navigate to the location of your saved JSON file, select it, and click "Open."

3. Choose Your Schema Levels (The Important Part!)

Once you select the file, Tableau won't immediately show you a table of data. Instead, a pop-up window titled Select Schema Levels appears. This is the single most important step in the process and is where many new users get stuck.

Because JSON data can be nested (think of Russian dolls), Tableau needs you to tell it which level or levels of the data you want to transform into rows and columns. It scans your file and presents you with the structure it finds. You need to select the objects and arrays that contain the core information for your analysis.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Making Sense of "Select Schema Levels"

Let's break down this step with a relatable example. Imagine you have a JSON file containing information about store orders. The structure might look something like this:

{
  "records": {
    "orders": [
      {
        "order_id": "ORD-101",
        "customer": {
          "name": "Jane Doe",
          "location": "New York"
        },
        "items": [
          { "product_id": "PROD-A", "quantity": 1, "price": 25.00 },
          { "product_id": "PROD-B", "quantity": 2, "price": 10.00 }
        ]
      },
      {
        "order_id": "ORD-102",
        "customer": {
          "name": "John Smith",
          "location": "London"
        },
        "items": [
          { "product_id": "PROD-C", "quantity": 5, "price": 5.00 }
        ]
      }
    ]
  }
}

When you connect this file, the Select Schema Levels dialog box might show you the following levels:

• records
• orders
• customer
• items

What should you select? It depends on what you want to analyze. What should one row represent in your final data table?

• If you want to analyze orders: Select the orders level. This will generate a table where each row represents an entire order. However, the details inside customer and items would be grouped together in complex fields that you'd need to "un-nest."
• If you want to analyze individual products sold: This is a more common goal. Select both orders and items. By selecting both, particularly the parent (orders) and the child array (items), you're telling Tableau to "flatten" the structure. It will create a new row for each item within each order.

If you choose to flatten by selecting both orders and items, the resulting table in Tableau's Data Source pane would look like this, which is a perfect format for analysis:

This "flattening" step is how Tableau turns complex, hierarchical data into a clean, structured table ready for you to build charts and dashboards.

Common Challenges (and How to Fix Them)

Connecting to JSON data isn't always a one-click process. Here are some of the most common issues you'll run into and how you can work around them.

Challenge 1: The JSON is Way Too Complex

The problem: Your JSON file has dozens of nested levels, and the "Select Schema Levels" dialog is an overwhelming, confusing mess.

The solution: Don't try to parse it directly in Tableau Desktop. Your best bet is to pre-process the data first.

• Tableau Prep Builder: If you have access to the full Tableau suite, Tableau Prep is the ideal tool for this job. It's designed specifically for cleaning and reshaping complex data. You can connect to your JSON file in Prep, visually flatten the structure, remove unnecessary fields, and then output a clean .hyper (Tableau Extract) file to use in Tableau Desktop.
• Scripting: If you're comfortable with a little bit of code, a simple Python script using the pandas library can flatten even the most complicated JSON file into a perfect CSV. This gives you complete control over how the final table is structured.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Challenge 2: Your File is Absolutely Enormous

The problem: You have a JSON file that is gigabytes in size. Tableau is very slow or even crashes when trying to process it.

The solution: For massive datasets, don't rely on a flat file connection. The most robust and performant long-term solution is to load the data into a database.

• Use a scripting language (like Python or Node.js) to parse the large JSON file and load its contents into a dedicated database like PostgreSQL, MySQL, or a cloud data warehouse like Google BigQuery or Snowflake.
• Once the data is in a proper database, you can connect Tableau to that source. Database connections are optimized for performance and will handle large amounts of data far better than a direct file connection. You'll also be able to run queries faster and take advantage of live connections or efficiently scheduled extracts.

Challenge 3: Inconsistent Data Structures

The problem: In some of your JSON objects, a certain key-value pair exists, but in others, it's missing. For instance, some customers have a phone_number and others don't.

The solution: This one is actually an easy fix! Tableau handles this situation surprisingly well. When it generates the table, it will create a column for phone_number. For any row where a value wasn't present, Tableau will simply fill it in with a NULL value. You can then handle these nulls directly in your calculated fields or filters within Tableau as needed.

Final Thoughts

So, can Tableau read JSON data? Absolutely. Its built-in connector does a great job of turning structured, nested JSON into the clean, tabular format required for data visualization. The key is to properly navigate the "Select Schema Levels" step and know when to reach for a pre-processing tool like Tableau Prep or a simple script for more complex files.

Many of these steps—connecting to APIs, managing data pipelines, and structuring responses—often become a manual bottleneck, taking you away from actual analysis. At Graphed, we've automated this entire process. We handle connecting directly to sources like Google Analytics, Shopify, and Salesforce at the API level, so you never have to see or parse a single line of JSON. You can simply ask a question in plain English, like "Show me my sales by product from Shopify this quarter," and we instantly generate the interactive chart without you ever having to think about schema levels or data cleansing.