How to Save Tableau as TWBX
Saving your Tableau workbook might seem like a simple click, but choosing the right file type is essential for sharing your work effectively. Tableau offers two main formats, .twb and .twbx, and understanding the difference is a fundamental skill for anyone working with the platform. This tutorial will walk you through exactly what a Tableau Packaged Workbook (.twbx) is, why it's so important for collaboration, and how to save your files in this format.
Understanding Tableau File Types: .twb vs. .twbx
Before diving into the "how," it's helpful to understand the "what." The distinction between a .twb (Tableau Workbook) and a .twbx (Tableau Packaged Workbook) file comes down to one thing: data.
What is a .twb file (Tableau Workbook)?
Think of a .twb file as a blueprint or a set of instructions. It’s an XML file that contains all the information about how your dashboards, sheets, and stories are constructed.
- It stores the layout of your vizzes, formatting choices, calculated fields, and dashboard actions.
- Critically, it does not contain the actual data. Instead, it holds the connection information that tells Tableau where to find the data, whether that’s a live connection to a SQL server, an Excel file on your C: drive, or a Tableau data extract (.hyper file) saved separately.
If you create a dashboard using a local Excel file and email only the .twb file to a colleague, they won't be able to open it. Their computer will get the "blueprint" but won't know where to find the "building materials" (the data file) because the file path is local to your machine.
What is a .twbx file (Tableau Packaged Workbook)?
A .twbx file solves this problem by bundling everything together into a single, self-contained package. It’s essentially a compressed zip file.
- It includes the original
.twbfile (the blueprint). - It also includes a copy of any local data sources, like data extracts (.hyper files), Excel files, or text files.
- If you've used any custom images, custom geocoding, or non-standard background maps, those are included as well.
When you send a .twbx file to your colleague, they have everything they need to open the workbook and see it exactly as you intended, without needing access to your local files or network drives. It "just works."
Why You Should Almost Always Save as a TWBX
For most day-to-day use, especially when sharing or collaborating, the .twbx format is the superior choice. Here are the key benefits.
1. Seamless Sharing and Portability
This is the number one reason to use .twbx. You can confidently email it, upload it to a shared drive, or send it via Slack, knowing the recipient will be able to open it with Tableau Desktop or the free Tableau Reader. There’s no risk of broken data connections or missing images. This eliminates frustrating back-and-forth emails trying to locate the right data source.
2. Archiving a Point-in-Time Snapshot
Data sources, especially live databases, are constantly changing. A .twbx file captures a snapshot of your analysis with the data as it existed at the time of creation. This is perfect for archiving monthly reports or documenting a specific analysis. You can always go back to that .twbx file and see the exact data and visualizations that led to a particular decision.
3. Working Offline
Because the data source (usually as an extract) is packaged inside the file, you can continue to work on your visualizations and analysis without an active internet connection or access to your corporate network. This is ideal for traveling, commuting, or working on a confidential project where a live connection isn't always available or desired.
4. A Complete Package for Support
If you're asking for help on the Tableau Community forums or from your internal data team, providing a .twbx is standard practice. It gives others all the context they need - the workbook structure, calculations, and the data - to effectively troubleshoot your problem and offer solutions.
How to Save a Tableau Workbook as a TWBX File: A Step-by-Step Guide
The process is straightforward and only takes a few clicks. Follow these steps to save your work as a packaged workbook.
Step 1: Open Your Workbook in Tableau Desktop
Begin by opening the Tableau workbook (.twb file) you want to save. You can either be starting from scratch or working with an existing project.
Step 2: Navigate to the “File” Menu
In the top-left corner of the Tableau application window, click on the File menu option.
Step 3: Select “Save As...”
From the dropdown menu that appears, choose Save As.... This will trigger a file dialog box to pop up, allowing you to choose a new name and location for your file.
Step 4: Choose the Correct File Type
This is the most important step. In the save dialog box, look for the dropdown menu labeled “Save as type” (on Windows) or "Format" (on Mac). Click it to reveal the different file types available.
Step 5: Select "Tableau Packaged Workbook (*.twbx)"
From the list, select Tableau Packaged Workbook (*.twbx). You’ll notice Tableau automatically selects this format if your data source is an imported file like an Excel sheet, but it's always good practice to check.
Step 6: Name Your File and Click Save
Choose a descriptive name for your workbook, select the location you want to save it to, and click the Save button. That's it! Tableau will now gather your workbook, data source, and any other assets, and package them all into a single .twbx file, ready for sharing.
Alternative Method: Export Packaged Workbook
Tableau also provides a dedicated option for this function. You can go to File > Export Packaged Workbook... This achieves the exact same result as the "Save As" method and is just a matter of personal preference.
Tips for Managing TWBX Files
Now that you know how to create a .twbx, here are a few extra tips for working with them effectively.
Managing File Size
Because .twbx files contain your data, they can become quite large. If you're struggling with a massive file size, try these techniques:
- Hide Unused Fields: Before creating your final extract, right-click on your data source and select "Hide All Unused Fields." This removes columns you aren't using in any visualization, which can significantly reduce the extract's size.
- Use Extract Filters: Create a filter on your data extract to only include relevant data. For example, if you're only analyzing data from the last two years, add a date filter to the extract to exclude older records.
- Aggregate Your Data: If you don't need transactional-level detail, you can aggregate the data before creating the extract. Selecting "Aggregate data for visible dimensions" tells Tableau to roll up the data to the level of detail displayed in your views, which is often much smaller.
When to Use a .twb File Instead
While .twbx is the default for sharing, the classic .twb still has its place. You should use a .twb when:
- You are connecting to a regularly updated, high-performance database (like Redshift, Snowflake, or SQL Server).
- Everyone who will use the workbook has direct access and the correct credentials for that live database.
- You want the workbook to always display the most up-to-the-minute data without needing to be re-packaged and re-sent.
In a collaborative enterprise environment where a central database is the "single source of truth," using .twb files to point to that source can be more efficient.
Version Compatibility
Remember that packaging a workbook doesn't solve version compatibility issues. Someone with Tableau Desktop 2022.1 cannot open a .twbx file created by someone using Tableau Desktop 2023.3. The recipient must have a version of Tableau that is the same or newer than the one used to create the workbook. It's always a good idea to confirm versions before sending your impressive dashboard!
Final Thoughts
Mastering the difference between a .twb and a .twbx is a small but critical step in becoming a proficient Tableau user. By saving your work as a Tableau Packaged Workbook, you ensure that your dashboards are portable, self-contained, and can be shared effortlessly. It’s the key to making collaboration simple and reliable.
This process of downloading, packaging, and sharing files is a common routine for teams everywhere, but it also highlights a bigger challenge in data analytics: keeping everyone on the same page with the latest data. With Graphed, we aim to eliminate this friction entirely. Instead of saving and emailing static files, we allow you to connect your data sources once and use natural language to create real-time dashboards that update automatically. You can share dashboards with a secure link, ensuring everyone sees the latest insights without worrying about which TWBX version is the most recent.
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.