What is a TWBX File in Tableau?
If you've worked with Tableau, you've definitely come across a file ending in .twbx. Sending that file to a colleague is often the easiest way to share a complete, interactive dashboard. This article breaks down exactly what a .twbx file is, how it differs from a standard .twb file, and when you should use each one.
The Core Difference: Tableau Workbook (.twb) vs. Packaged Workbook (.twbx)
Understanding the difference between Tableau’s two main workbook file types is the first step to mastering how you build and share your analyses. Think of them as a recipe versus a complete meal kit.
What is a .twb (Tableau Workbook) File?
A Tableau Workbook (.twb) file is an XML document that contains all the structural information about your dashboard. It’s the blueprint, holding all your design choices, formatting preferences, and analytical configurations.
A .twb file includes:
- The layout of your sheets, dashboards, and stories.
- Formatting details like colors, fonts, and sizes.
- All your calculated fields, parameters, sets, and groups.
- The connection information for your data sources.
The last point is the most important one. A .twb file does not contain the actual data. It only knows where to find the data, whether that’s a local Excel file on your C: drive or a connection to a cloud database like Snowflake or Amazon Redshift.
The Analogy: A .twb file is like a recipe. It gives you detailed instructions - what ingredients to use (your data sources) and how to prepare them (your charts and calculations) - but it doesn't give you the actual ingredients. If you email a .twb file to a coworker, they will be able to open it only if they also have direct access to the exact same data source you used.
What is a .twbx (Tableau Packaged Workbook) File?
A Tableau Packaged Workbook (.twbx) is a more complete, all-in-one file. It is essentially a special type of zip file that bundles your Tableau Workbook (.twb) together with copies of all the local data sources and other files used in your dashboard.
A .twbx file includes everything from a .twb file, plus:
- Local data files: A copy of any Excel files, CSVs, or text files you connected to.
- Tableau Data Extracts: If you created a
.hyperor.tdeextract, a copy of that extract is included. - Background images and custom shapes: Any local images or custom shapes used in your visuals are packaged up too.
The Analogy: A .twbx file is like a meal kit. It comes with the recipe card (.twb) and all the perfectly portioned ingredients (your data files, images, etc.). You can send this kit to anyone, and they can open it up and immediately see the finished masterpiece without having to go find the ingredients themselves. This makes .twbx files the standard for sharing and presenting.
When to Use a Tableau Packaged Workbook (.twbx)
Using a .twbx is the default for sharing your work because of its portability. Here are the most common scenarios where a .twbx file is your best option.
Sharing Dashboards with Others
This is the number one reason to use a .twbx. If you want to show your dashboard to a manager, a client, or a teammate who doesn’t have access to your live database, a .twbx is perfect. It bundles everything they need into one self-contained file, so it just works.
Presenting an Analysis Offline
Taking your laptop to a conference room or a presentation where you might not have a reliable internet connection or access to the company network? Save your workbook as a .twbx. Because the data is stored locally inside the file, you can open and interact with your dashboard without needing any network access.
Creating a Point-in-Time Snapshot
Data in production databases changes constantly. If you need to archive a report for a specific period - like an end-of-quarter performance review - saving it as a .twbx creates a permanent record. The data inside the package is frozen at the moment you saved it, so you can always refer back to that specific snapshot, even years later.
Submitting Dashboards to Tableau Public
Tableau Public, the free platform for sharing data visualizations with the world, requires you to upload your work as a .twbx. This ensures that everyone who views your visualization has access to the underlying data needed to render the charts and interact with the filters.
Getting Help from Tableau Support
If you encounter a bug or need technical assistance, Tableau Support will almost always ask for a packaged workbook. This allows them to see your exact workbook structure and the specific data that is causing the issue, making it much easier to replicate and debug your problem.
When to Stick with a Standard Workbook (.twb)
While .twbx files are great for sharing, there are situations where a simple .twb file is the more logical choice.
Connecting to a Live, Constantly Updating Database
If your analysis relies on real-time data from a live database (like tracking high-frequency trading data or live operational metrics), you should use a .twb. Saving it as a .twbx would take a static snapshot of the data, defeating the entire purpose of a live connection. When you open a .twb connected to a live source, it always queries the database for the very latest information.
Massive Data Volumes
If you're working with a data extract containing hundreds of millions or billions of rows, packaging it into a .twbx file can result in a massive file size - sometimes many gigabytes. These files can be slow to create, a pain to email, and difficult to manage. In these cases, the better workflow is to publish the large data extract to Tableau Cloud or Tableau Server and then connect to it using a .twb file. This keeps the workbook itself small and lightweight.
Collaborating on a Shared Data Source
In a team environment, it's common practice to have a single, certified data source published to Tableau Cloud or Server. Every analyst on the team then connects their individual .twb files to this one shared source. This approach avoids creating multiple copies and versions of the same data, ensuring everyone is working from the same single source of truth.
How to Create, Open, and Unpackage a .twbx File
Working with .twbx files is straightforward once you know the basics.
Creating a Packaged Workbook
In Tableau Desktop, creating a .twbx is a simple save operation:
- Go to the file menu: File > Save As…
- In the "Save as type" dropdown, choose Tableau Packaged Workbook (*.twbx).
- Name your file and click Save.
That's it! Tableau will gather your workbook, data files, and any other assets and zip them into a single .twbx file.
Pro Tip: By default, if Tableau detects that your workbook is connected to a local, file-based data source (like Excel) or a data extract, it will automatically save as a .twbx to make sharing easier. You have to intentionally choose .twb if you want to avoid this.
Opening a Packaged Workbook
To open a .twbx file, you need either Tableau Desktop (the paid software for building visualizations) or Tableau Reader (a free desktop application for viewing and interacting with them). If you have one of them installed, simply double-clicking the .twbx file is all it takes.
How to See What's Inside a .twbx
Want to prove to yourself that a .twbx is really just a zip file? You can! This is a great way to understand what's happening under the hood.
- Find a .twbx file on your computer and make a copy of it first, so you don't corrupt your original.
- Right-click the copied file and rename it, changing the file extension from
.twbxto.zip. Confirm the change if Windows asks. - Now, you can right-click the file and "Extract All..." to unzip it like a standard folder.
Inside, you will find a folder structure containing your original .twb file and associated folders for "Data," "Images," and "Shapes," which hold a copy of all the assets your dashboard needs. Now you can officially say you know what's inside a .twbx!
One Final Thought
Understanding file types like .twb and .twbx is fundamental to becoming proficient with Tableau. Knowing when to use a packaged workbook helps you seamlessly share your hard work with others and ensures your data story is always presented clearly and completely.
But the desire to easily share insights is universal, not just limited to BI tools like Tableau. For many marketing and sales teams, the real challenge is pulling together scattered data from a dozen different apps just to build a cohesive report. We built Graphed to solve this by connecting directly to all your sources - like Google Analytics, Salesforce, and Shopify - and enabling you to build real-time, shareable dashboards by simply describing what you want to see in plain English. It's about getting to the insights without getting stuck on the technical busywork.
Related Articles
How to Enable Data Analysis in Excel
Enable Excel's hidden data analysis tools with our step-by-step guide. Uncover trends, make forecasts, and turn raw numbers into actionable insights today!
What SEO Tools Work with Google Analytics?
Discover which SEO tools integrate seamlessly with Google Analytics to provide a comprehensive view of your site's performance. Optimize your SEO strategy now!
Looker Studio vs Metabase: Which BI Tool Actually Fits Your Team?
Looker Studio and Metabase both help you turn raw data into dashboards, but they take completely different approaches. This guide breaks down where each tool fits, what they are good at, and which one matches your actual workflow.