What Are the Different Tableau Files?

Working with an application like Tableau means you will quickly find it saves files with all sorts of different extensions. At first glance, the alphabet soup of .twb, .twbx, .tds, and .hyper can feel a little confusing, but each file type serves a distinct and important purpose. Understanding the difference is key to working efficiently, sharing your dashboards correctly, and managing your data like a pro.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

This guide will break down the most common Tableau file formats you'll encounter. We'll cover what each one does, what it contains, and the best time to use it.

Tableau Workbooks: Where Your Visualizations Live

Workbooks are the most central files in your Tableau journey. They are where you build your charts, dashboards, and stories. The key difference between the two workbook types comes down to one simple question: is the data included?

1. Tableau Workbook (.twb)

A Tableau Workbook (.twb) file is the primary file you create when working in Tableau. Think of it as a blueprint or a recipe for your visualizations. It's a structured XML file that holds all your instructions for how to build your dashboards.

• What it contains: All of your worksheets, dashboards, and story points. It includes all the formatting decisions you’ve made, such as colors, fonts, and chart sizing. It also contains your calculated fields, groups, sets, and information about the data connection (like the database server address and credentials).
• What it doesn't contain: The actual data itself.

Because the .twb file doesn't have the data packaged with it, it's quite small and lightweight. It simply points to a data source, whether that's a server-based database like SQL Server, a cloud service like Google Analytics, or a local Excel file.

When to use a .twb file:

• When you’re connected to a live, massive, or constantly updating database. The workbook will pull fresh data every time it's opened.
• When multiple people are all working from the same centralized data source.
• When you want to share the structure of a dashboard without sharing the sensitive underlying data that populates it.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

2. Tableau Packaged Workbook (.twbx)

A Tableau Packaged Workbook (.twbx) is an all-in-one file. If the .twb is the recipe, the .twbx is the entire meal kit delivered to your door - it includes the recipe and all the pre-measured ingredients. It's essentially a zip file that bundles the .twb workbook with a copy of all the local data used.

• What it contains: Everything a .twb file has, plus copies of any local data sources. This could be a data extract (.hyper), an Excel file, a CSV, a text file, and even custom assets like background images or custom geocoding.

The .twbx is the standard for sharing work with others who do not have access to your live data connection. When someone opens a .twbx file, they see exactly what you see because all the necessary components are bundled together inside it.

When to use a .twbx file:

• When you need to share a workbook with a colleague, client, or stakeholder who doesn't have access to the original live data source.
• When you want to present your work and need a self-contained file that's guaranteed to open without connection errors.
• When submitting a support ticket to Tableau, as they'll need all the data and assets to reproduce your issue.
• This is the most common format for sharing your analysis.

Data Source Files: Your Data Connection's Shortcut

Data source files help you save, manage, and standardize your connections. Instead of connecting to and cleaning up the same database for every new workbook, you can do it once and save the connection for future use.

3. Tableau Data Source (.tds)

A Tableau Data Source (.tds) file is like a bookmark or a shortcut to your data source. It doesn't contain the actual data but stores all the information about how to connect to it and how you've prepared it.

• What it contains: The connection information (like a server name, database, and authentication type). It also saves any modifications you've made to the data pane, such as creating hierarchies, changing default properties (like a number format to currency), renaming fields, or creating calculated fields.

Saving a .tds file can save your team incredible amounts of time and enforce consistency. For example, if your company has a standard way to calculate "Gross Margin" or a defined hierarchy for "Product Categories," you can set it up once in the data source, save it as a .tds file, and share it. Now, everyone who connects using that .tds file starts with the same clean, standardized data model.

When to use a .tds file:

• To give your team a standardized and pre-configured starting point for new analyses on a shared data source.
• To save complex connection details or custom metadata changes so you don't have to re-do them for every new workbook.

4. Tableau Packaged Data Source (.tdsx)

Following the same logic as .twb vs. .twbx, a Tableau Packaged Data Source (.tdsx) is the all-in-one version of a .tds. It bundles the .tds file with a copy of the data itself.

• What it contains: All the connection info, metadata, and customizations of a .tds file, plus a local copy of the data. This data is usually in the form of a .hyper file (a data extract).

This is useful when you want to share a pre-configured data source with someone who doesn’t have access to the live database, allowing them to perform their own analysis offline using a static snapshot of the data.

When to use a .tdsx file:

• When you want to provide a teammate with both a standardized data connection and an offline copy of the data for them to work with.
• For sending a snapshot of your data model and data to Tableau support.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Data Extracts: Snapshots for Speed and Portability

Sometimes connecting live to a data source isn't practical. It might be too slow, you might not have constant network access, or you may want to reduce the analytic load on your company's production database. This is when extracts come into play.

5. Tableau Hyper Data Extract (.hyper)

A Tableau Hyper Data Extract (.hyper) is a highly compressed and optimized snapshot of your data. When you choose to "Extract" your data in Tableau, it queries the original data source once, pulls all the data, and stores it in this file format right on your local machine.

The .hyper format uses Tableau's newer in-memory data engine, providing blazingly fast query performance, even on hundreds of millions of rows of data.

Quick Note: If you've used older versions of Tableau, you may be familiar with the Tableau Data Extract (.tde) file type. Since Tableau 10.5, .tde files have been replaced by the more powerful .hyper format. If you open an older workbook with a .tde, Tableau will automatically convert it for you.

When to use a .hyper extract:

• To significantly speed up dashboard performance when working with slow databases or complex queries.
• When you need to work offline or are disconnected from the network.
• To reduce database usage (queries per second) on transactional databases that support your live business applications.
• When your raw data is spread across multiple sources and you want to join and blend it into a single, optimized data source.

Remember, a .hyper extract is an integral part of a .twbx or .tdsx file if you're not using a live connection.

Other Useful File Types

While the files above are the ones you'll use day-to-day, a few others are handy for specific situations.

6. Tableau Bookmark (.tbm)

A Tableau Bookmark (.tbm) file allows you to save and share a single worksheet from your workbook. It’s a great way to quickly pass a cool chart you built to a colleague so they can easily drop it into their own workbook. It saves the worksheet, its data connection, and any filters or custom settings.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

7. Tableau Flow (.tfl or .tflx)

These files are associated with Tableau Prep Builder, a separate application for cleaning, shaping, and combining your data. A .tfl is like a recipe for your data preparation process, detailing all the steps and logic. A .tflx is the packaged version, containing the flow plus any local data files used in the prep process.

8. Tableau Preferences (.tps)

This is a handy little file that lets you customize your Tableau environment. Its most popular use is for creating custom color palettes. By editing this file (found in your My Tableau Repository folder), you can add your company's brand colors to Tableau, making them easily accessible in any workbook you build.

For example, to add a simple custom palette, you would add the following XML to your .tps file:

<?xml version='1.0'?>
<workbook>
    <preferences>
        <color-palette name="My Brand Colors" type="regular">
            <color>#1A3A54</color> 
            <color>#66C2A5</color>
            <color>#FC8D62</color>
            <color>#8DA0CB</color>      
        </color-palette>
    </preferences>
</workbook>

Final Thoughts

Understanding these different file formats unlocks a new level of efficiency in Tableau. It makes collaboration easier, streamlines workflows, and avoids the frustrating "can't connect to data" errors that happen when sharing the wrong file type. At its core, remember that .twb is the instruction sheet while .twbx is the complete, shippable product.

If memorizing file types, setting up data connections, and working through a steep learning curve feels like a hassle, we created a faster path to insights. Our AI-powered tool, Graphed, connects to your marketing and sales data sources in seconds and lets you build real-time dashboards just by asking questions. You can create a Facebook Ads performance report or analyze your sales pipeline by describing what you want to see, without ever having to think about which file extension to use.