What is TWB and TWBX in Tableau?

If you’ve spent any time working with Tableau, you’ve undoubtedly come across two distinct file types: .twb and .twbx. At a glance, they might seem almost identical, but the small 'x' at the end signifies a critical difference that can make or break your ability to share and collaborate on your data visualizations. Understanding when to use each file type is essential for a smooth workflow.

Graphed

Still Building Reports Manually?

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

Watch the Demo

This article breaks down exactly what .twb and .twbx files are, highlights the key differences between them, and gives you a practical guide on when to use each one to avoid common sharing pitfalls.

What is a Tableau Workbook (.twb) File?

Think of a Tableau Workbook (.twb) file as a blueprint or a recipe. It contains all the instructions for how your visualization should look and behave, but it doesn't contain the actual ingredients - the data itself.

A .twb file is an XML document that stores the specifics of your workbook's sheets, dashboards, and stories. Here’s a breakdown of what’s inside:

• The Layout: It remembers how you've arranged your dashboards, the size of your charts, and the organization of your worksheets.
• Formatting and Styling: All your design choices - colors, fonts, labels, tooltips, and axis formatting - are saved in the .twb file.
• Data Connection Information: This is the most important part. The .twb file holds the connection details for your data source. It knows whether to connect to an Excel file on your C: drive, a specific table in a SQL server, or a Google Sheet. It does not store a copy of the data.
• Calculated Fields and Metadata: Any calculations, parameters, sets, groups, and hierarchies you've created are stored here. It's the logic layer of your analysis.

Graphed

Still Building Reports Manually?

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

Watch the Demo

When to Use a .twb File

Because a .twb file only contains a live connection to a data source, its use cases are specific:

• Working with Live Data: If your dashboard is connected to a database that is constantly being updated (like a company's sales SQL database), a .twb file ensures you are always looking at the most current information. Every time you open the workbook, Tableau refreshes the view with the latest data.
• Large Datasets: When your dataset is massive (millions or billions of rows), it’s impractical to package it into a single file. A .twb file keeps your workbook file size incredibly small and lightweight, as it only contains instructions.
• Personal and Internal Work: When you are the primary creator and have reliable access to the data source, using a .twb file is fast and efficient. Team members with the same database credentials can also use the .twb file seamlessly.

The Big "Gotcha" with TWB Files

The limitation of a .twb file becomes obvious the moment you try to share it. If you email a .twb file to a colleague who doesn't have access to the exact same data source path (e.g., they don't have access to your local machine or the company server), they won't be able to open it. Tableau will throw an error because it can’t find the "ingredients" to build the "recipe." This is the single most common cause of confusion for new Tableau users.

What is a Tableau Packaged Workbook (.twbx) File?

Following our analogy, if a .twb is the recipe, a Tableau Packaged Workbook (.twbx) is the complete meal kit delivered to your door. It includes the recipe (the .twb file) and all the necessary ingredients (a copy of the data) bundled together in one neat package.

A .twbx file is essentially a zip file. It contains the .twb file plus any and all associated local files. Here’s what’s inside:

• The Tableau Workbook (.twb): The original blueprint with all your sheets, dashboards, formatting, and calculations is included.
• A Data Extract (.hyper or .tde): This is a static snapshot or a copy of your data, pulled from the original source at the time the .twbx was created. For file-based data sources like Excel or CSVs, it includes a copy of the actual file.
• Custom Assets: Any background images, custom shapes, or non-standard geocoding files you’ve used in your workbook are also included in the package.

Graphed

Still Building Reports Manually?

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

Watch the Demo

When to Use a .twbx File

The .twbx format is all about portability and self-containment, making it the ideal choice for sharing.

• Sharing with Others: This is the primary reason to use a .twbx. You can confidently send a .twbx file to a colleague, a client, or a manager knowing they will be able to open it and see exactly what you see, without needing access to your original data source.
• Presentations and Static Reports: If you need to present your findings or archive a report based on data from a specific point in time, a .twbx is perfect. It freezes the data, so your numbers won't change unexpectedly right before a big presentation.
• Working Offline: Since the data is stored locally within the file, you can continue to work on your dashboard even when you're not connected to the internet or the corporate network.
• Posting to Tableau Public: Tableau Public, the platform for sharing visualizations with the world, requires you to upload your work as a .twbx file.

TWB vs. TWBX: A Side-by-Side Comparison

Let's summarize the key distinctions in a straightforward way.

Data Source

• TWB: Contains only a link or connection to the original data source. Data is not included.
• TWBX: Contains a packaged copy of the data source (like an extract or the source file itself). It's self-contained.

File Size

• TWB: Very small, typically measured in kilobytes (KB).
• TWBX: Can be very large, often measured in megabytes (MB) or even gigabytes (GB), depending on the size of the included data extract.

Portability and Sharing

• TWB: Low portability. The recipient must have the exact same access path to the live data source to open it.
• TWBX: High portability. Anyone with Tableau Reader or Tableau Desktop can open and interact with the file without needing any external data connections.

Typical Use Case

• TWB: Building dashboards on a live, frequently updated, or very large enterprise database.
• TWBX: Sharing dashboards with audiences, submitting work for review, presenting findings, or working offline.

How to Choose and Save the Right File Type in Tableau

Switching between file types in Tableau is simple. It all happens in the "Save" dialog.

1. Navigate to File > Save As...
2. In the "Save as type" dropdown menu at the bottom of the window, you will see two primary options:
3. Select your desired format and click Save.

A Quick Checklist: Which File Do I Need?

Ask yourself these questions to decide which format to save your file in:

• Am I sharing this file with someone who doesn't have access to my database or local files? If yes, use .twbx.
• Does this dashboard need to show real-time, up-to-the-second data from a live source? If yes, use .twb and ensure all users have the correct permissions.
• Is my dataset too large to reasonably package into a single file? If yes, use .twb.
• Am I uploading this workbook to Tableau Public or sending it to a manager for a quarterly review? *If yes, use .twbx.
• Am I working on my laptop on a plane? If yes, you'll need the data packaged in a .twbx to work offline.

Common Sticking Points and Best Practices

To avoid frustration, keep these points in mind:

• Embrace TWBX for Sharing: As a general rule, get into the habit of saving as a .twbx file right before you send a workbook to someone else. Make it your "final send-off" step. This will save you countless emails explaining why your workbook won't open.
• Watch Your File Size: A .twbx file can become enormous if your data extract is not optimized. Before you package your workbook, consider hiding unused fields, aggregating your data to a higher level, or applying filters to the extract to only include the necessary data. This can drastically reduce the file size and make it easier to share.
• Data Privacy is Crucial: Remember that a .twbx file contains an actual copy of your data. Be extremely cautious about what you share. If your workbook contains sensitive or confidential information, ensure you are only sending it to authorized individuals and are aware of your company's data governance policies. Do not upload sensitive data to a public forum like Tableau Public.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Final Thoughts

Choosing between .twb and .twbx files comes down to a single question: does your file need to stand on its own? A .twb file is the lean blueprint that requires a live data connection to function, while a .twbx is the complete, self-contained package ready for sharing. Understanding this simple distinction is fundamental to working efficiently and collaborating effectively in Tableau.

Knowing which data connections to use and how to package reports are common hurdles in business intelligence. At Graphed you, we aim to eliminate that friction by rethinking the entire process. Rather than toggling between live connections and packaged files, we integrate your marketing and sales data sources (like Google Analytics, Shopify, and Salesforce) once. From there, you can use plain English to build live, shareable dashboards in seconds. This removes the steep learning curve of tools like Tableau and automates the manual work of sharing reports, freeing up your team to focus on insights, not file types.