What Are the File Extensions in Tableau?

Jumping into Tableau for the first time, you quickly run into a whole alphabet of file extensions: .twb, .twbx, .tds, .hyper, and more. It can feel like learning a new language just to save or share your work. This guide clears up the confusion by explaining each Tableau file type, what it contains, and exactly when you should use it.

Graphed

Still Building Reports Manually?

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

Watch the Demo

The Two Most Important Files: Workbooks

Most of your time in Tableau will be spent working with two core file types. Understanding the difference between them is the single most important concept for successfully collaborating with others.

1. Tableau Workbook (.twb)

Think of a .twb file as the master blueprint for your analysis. It’s a very small file that contains all the instructions Tableau needs to recreate your visualizations.

• What's inside: It has all your sheets, dashboards, and stories. It knows how you’ve arranged fields, what colors you’ve used, which filters are applied, and the information needed to connect to your data source (like a server name and login credentials).
• What’s not inside: The actual data itself.

A .twb file is essentially just a set of instructions. When you open it, Tableau reads the blueprint and then goes to the source data (whether that's a database, an Excel file, or Google Sheets) to fetch the numbers and populate your charts.

When to use a .twb file:

• When you and your collaborators all have access to the same, live data source.
• When you save work to your own computer and the original data file (like a CSV or Excel sheet) is stored in the same place.
• For version control, since the file size is very small, making it easy to track changes in systems like Git.

If you email a .twb file to someone who doesn't have access to your data source, they'll be met with an error. The blueprint is there, but the building materials are missing.

Graphed

Still Building Reports Manually?

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

Watch the Demo

2. Tableau Packaged Workbook (.twbx)

This is the file type you'll use most often for sharing your work. A .twbx is a self-contained "package" that includes everything needed to view your dashboard.

• What's inside: It contains the .twb file (the blueprint) plus a local copy of the data. This data is either a data extract (.hyper file) or a local copy of a file-based data source like an Excel sheet. It also packages any custom images or geocoding you’ve used.
• What this means: Anyone with Tableau Desktop or a subscription to Tableau Public can open and interact with your dashboard, no live data connection needed.

Technically, a .twbx is just a zip file. If you rename it to .zip, you can even open it up and see all the component parts inside: the .twb file, the data folder, and the image folder.

When to use a .twbx file:

• When sharing your dashboard with colleagues who don't have access to the original data source. This is the #1 use case.
• When posting your work to Tableau Public.
• When you want to work on your dashboard offline, like on a plane, without needing to connect to your company’s server.

The Data Connection Files

While workbooks are about visualizing your data, these next files are all about how you connect, clean, and organize your data before you even start building charts. They save you a ton of time and help standardize your team's analytics.

3. Tableau Data Source (.tds)

A .tds file is a "shortcut" for your data source configuration. Imagine you've connected to a messy CRM database, joined several tables, created a bunch of custom calculations (like a marketing-qualified lead definition), grouped certain states into sales regions, and set default number formats for your key metrics. You’ve done a lot of work to prepare the data for analysis.

A .tds file saves all of that metadata without saving the actual data itself.

• What's inside: Data source connection information, custom calculations, groups, sets, binning rules, default formatting for fields (e.g., always show "Sales" as currency), and any hidden fields.
• What’s not inside: The data.

When to use a .tds file:

• To give your team a standardized starting point for analysis. Instead of ten different people creating their own [Revenue] / [Spend] calculation for ROI, everyone can connect to the same .tds file and use the pre-built, sanctioned [Campaign ROI] field.
• When you want to maintain a live connection to a database but also save all your data setup work.

Graphed

Still Building Reports Manually?

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

Watch the Demo

4. Tableau Packaged Data Source (.tdsx)

You can probably guess what this one is. Just as a .twbx is the packaged version of a .twb, a .tdsx is the packaged version of a .tds. It's a zip file containing the data blueprint and the data itself.

• What's inside: The .tds file discussed above (the shortcut and all the configuration) plus a data extract (.hyper file) or local copy of the data.
• What this means: You're not just sharing a connection, you're sharing a pre-configured, self-contained, portable dataset that anyone on your team can connect to and start building with immediately.

When to use a .tdsx file:

• To provide your team with a clean, high-performance "single source of truth" for analysis without giving them access to the live, messy production database.
• When you need to share a processed slice of data that can be used across multiple different workbooks.

5. Tableau Data Extract File (.hyper or .tde)

This is the engine behind Tableau's speed. A .hyper file is a highly compressed and optimized snapshot of your data, stored in a proprietary column-based format. When you choose to "Extract" your data, Tableau takes a copy of your dataset from its live source and reorganizes it into a .hyper file.

Querying this file is often orders of magnitude faster than querying a live transactional database, which is why your dashboards suddenly become lightning-fast after you create an extract.

Note: You might still see the older .tde (Tableau Data Extract) file extension, but since Tableau 10.5, the more powerful Hyper engine produces .hyper files. The principle is the same.

How to use a .hyper file:

• You generally don't interact with .hyper files directly. Tableau creates and manages them for you.
• When you create an extract, Tableau generates the .hyper file and it's then embedded inside your .twbx or .tdsx files.
• The primary benefits are performance improvements, reduced load on your databases, and the ability to work offline.

Specialty File Types for Power Users

These files are less common, but knowing they exist can solve some very specific problems.

6. Tableau Bookmark (.tbm)

A Tableau Bookmark file saves a single worksheet. It allows you to quickly share a specific chart or building block with a colleague so they can easily import it into their own workbook. Think of it as copying and pasting a single slide from one PowerPoint presentation to another.

Graphed

Still Building Reports Manually?

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

Watch the Demo

7. Tableau Preferences File (.tps)

This is a fun one for customization. Tableau comes with a default set of color palettes. You can edit the Preferences.tps file in your "My Tableau Repository" folder to add your own custom color palettes, like your company's brand colors. It's a simple XML file you can open in a text editor to specify the hex codes for your colors. The next time you open Tableau, your new palette will be available in the color shelf.

Tableau File Extensions: Quick Cheat Sheet

Here’s a simple way to remember the most important file types:

• .twb (Workbook): Blueprint ONLY. It needs a 'live' data connection to work.
• .twbx (Packaged Workbook): Blueprint + Data. The all-in-one package for sharing anytime.
• .tds (Data Source): Data configuration ONLY. A shareable shortcut to a 'live' data connection.
• .tdsx (Packaged Data Source): Data configuration + Data. A shareable, offline dataset that others can use.
• .hyper (Data Extract): Compressed data snapshot. This is what makes your dashboards fast.

Final Thoughts

Understanding these different extensions transforms Tableau from a frustrating puzzle into a powerful and collaborative analytics platform. Knowing whether to save a .twb or a .twbx is the key to working effectively with a team and avoiding the dreaded "can't open this file" error.

Learning the language of folders and files is just one barrier to analytics. Many teams still spend hours grappling with complicated tools or manually downloading CSV files when they just want quick answers. This frustration is why we built Graphed. We connect directly to your data sources and let you build entire dashboards and get real-time insights simply by asking questions in plain English, turning an afternoon of report-building into a thirty-second conversation.