How to Create a Tableau Packaged Workbook
Sharing your Tableau dashboards can feel like you're trying to send someone a bowl of soup in the mail - messy, unreliable, and half the ingredients get left behind. You finish a great analysis, send the file to a colleague, and they can't open it because they don't have the data file, access to the server, or the custom images you used. This guide will walk you through creating a Tableau Packaged Workbook (.TWBX), an all-in-one file that solves this exact problem, making sharing your work simple and professional.
First Things First: What Exactly is a Tableau Packaged Workbook (.twbx)?
To understand a Packaged Workbook, you first need to know what a standard Tableau Workbook (.twb) is. Think of a .twb file as a recipe. It contains all your instructions – your worksheets, dashboards, formatting, labels, and all the calculations you’ve built. However, it doesn't contain the actual ingredients (your data).
When you open a standard .twb file, Tableau reads the instructions and goes looking for the data source on your computer or network - like an Excel file on your desktop or a SQL database on a server. If that path is broken or inaccessible, the workbook fails to load.
A Tableau Packaged Workbook (.twbx) is like a complete meal-prep kit. It bundles everything into one neat package:
- The Workbook (.twb) file: Your blueprint, containing all your sheets, dashboards, and brilliant designs.
- The Data Source(s): It includes a copy of any file-based data sources (like Excel or CSV files) or a Tableau data extract (.hyper file) from a server-based connection.
- Custom Assets: Any background images, custom shapes, or non-standard geocoding information you've used in your visualizations are also included.
This self-contained structure is the key. You can send a single .twbx file to anyone who has Tableau Desktop, Tableau Reader (which is free), or Tableau Public, and they can open it and see your work exactly as you intended - no broken connections, no missing data, no drama.
Why Bother with a Packaged Workbook?
Creating a packaged workbook might sound like an extra step, but it quickly becomes an essential part of any workflow once you realize its benefits. It’s the difference between looking like a pro and looking like someone who can’t get their files to work.
Free PDF · the crash course
AI Agents for Marketing Crash Course
Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.
1. Hassle-Free Sharing with Colleagues or Clients
This is the number one reason. Forget emailing a workbook and an Excel file separately and hoping your recipient knows what to do with them. A .twbx streamlines the process. Just attach the one file to an email or drop it in Slack. Your colleagues can open it immediately and start exploring the insights without having to ask, "Hey, where's the spreadsheet that goes with this?"
2. Airtight Presentations
Have you ever had that stomach-drop moment when you plug your laptop into a projector for a big presentation, open your Tableau dashboard, and get hit with a wall of connection errors? A live connection to a file on your local machine will break the second you’re on a different computer. By packing everything into a .twbx file beforehand, you ensure your dashboard will load flawlessly, no matter what machine you're presenting from. Everything it needs is right there in the file.
3. Creating a Data Visualization Portfolio
If you're building a portfolio to showcase your data viz skills, .twbx files are the professional standard. Publishing to Tableau Public often works best with packaged workbooks, and sending one to a potential employer demonstrates that you understand how to deliver a finished, usable product, not just a fragile workbook that only works on your own computer.
4. Creating a Point-in-Time Snapshot
Sometimes you need to freeze a report in time. For example, you might want to preserve a monthly or quarterly sales report without it changing when new data comes into your live database. Creating a .twbx file generates an extract, which is a snapshot of the data at that specific moment. This gives you a clear, unchangeable record of performance for that period.
How to Create a Tableau Packaged Workbook: A Step-by-Step Guide
Creating a .twbx is incredibly easy once you understand one critical preliminary step: using a data extract. Let's walk through the process.
Step 1: Get Your Data Connection Right (Extract, not Live)
For a packaged workbook to be truly self-contained, any connections to databases (like SQL Server, Redshift, etc.) need to be converted to extracts. For file-based sources like Excel or CSVs, Tableau usually handles this well on its own when exporting, but it’s a best practice to create an extract for them, too.
What’s the difference?
- A Live connection queries your original data source directly every time you make a change in Tableau. If you share a workbook with a live connection, the recipient needs direct access to that same database or file path.
- An Extract connection (.hyper file) takes a snapshot of your data from the source and compresses it into a highly optimized file stored inside your workbook. This is what makes your dashboard portable.
How to switch to an Extract connection:
- On any worksheet or dashboard, find your data source in the "Data" pane on the left-hand side.
- Right-click the data source and select "Extract Data...".
- A dialog box will pop up. You can configure filters or aggregation here if you want to reduce the size of the extract (more on that later). For now, just click the "Extract" button at the bottom.
- Tableau will prompt you to save the
.hyperextract file. Save it somewhere on your computer. Now, if you look at your data source icon in the Data pane, you'll see two overlapping cylinders instead of one, indicating it’s an extract. You are now ready to package.
Pro Tip: You can also manage this from the 'Data Source' tab at the bottom left of your screen. In the top right corner, you’ll see connection options for 'Live' and 'Extract'. Simply select the 'Extract' radio button.
Step 2: The Two-Click Save Process
Once your data connections are set to extract, the rest is simple. There are two primary ways to do this:
Method A: Save As...
This is the most common method, especially when saving for the first time.
- Go to the main menu and click File > Save As...
- In the dialog box that appears, look for the "Save as type" dropdown menu at the bottom.
- Select "Tableau Packaged Workbook (*.twbx)" from the list.
- Give your file a name, choose a location, and click Save.
That's it! Tableau will now gather your workbook, the data extract(s), and any custom images into a single .twbx file, ready for sharing.
Method B: Export Packaged Workbook
This is useful if you already have a .twb file saved and just want to create a packaged version to send to someone without changing your original file.
- Go to the main menu and click File > Export Packaged Workbook...
- A save dialog box will appear.
- Choose a name and location, and click Save.
This method accomplishes the same goal, creating a shareable .twbx file.
Common Issues and How to Fix Them
Even with a simple process, a few things can go wrong. Here are the most common issues users face and how to troubleshoot them.
Problem: Your Colleague Sees a "Cannot Connect to Data Source" Error
This is disheartening, as it’s the exact problem a packaged workbook is meant to solve! 99% of the time, this happens because one of your data sources was missed during the extract step. Even if your workbook has five data sources and you create extracts for four of them, that fifth live connection will still cause an error for the recipient.
The Fix: Re-open your original .twb workbook. Go to the "Data" pane and methodically right-click every single data source listed. Ensure each one is using an extract (again, look for the double-cylinder icon). Once you've confirmed all of them are extracts, save as a new .twbx file and send that version.
Free PDF · the crash course
AI Agents for Marketing Crash Course
Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.
Problem: The .TWBX File is HUGE
A packaged workbook includes a copy of your data, so if you're connected to a massive spreadsheet with millions of rows and dozens of columns, your .twbx file can easily become too large to email. You need to reduce the size of the data being extracted.
The Fix:
- Hide Unused Fields: Before you create your extract, go to the Data Source tab. Do you really need all 150 columns from your table, or are you only using 20 of them in your visualizations? You can select multiple unused columns, right-click, and choose "Hide". Hidden fields are excluded from the extract, which can dramatically shrink the file size.
- Apply Extract Filters: When you generate the extract (by right-clicking the data source > Extract Data), a dialog box gives you the chance to add filters. Is your dashboard only showing data for the current year? Add a date filter to the extract so you’re not packaging 10 years of historical data you don't need.
- Aggregate Data: In that same extract dialog box, you can check the "Aggregate data for visible dimensions" option. This rolls up your data to the level of detail shown in your viz. If your charts only show monthly sales, Tableau will create an extract with summarized monthly data instead of daily transactional data, which is a massive space-saver.
When to use a .TWB vs .TWBX?
Now that you know both, here's a simple rule of thumb:
- Use .twb for your regular work-in-progress, especially if you're connected to a live database that's constantly being updated and you need the latest data. It keeps the file size small since the data isn't stored inside it.
- Use .twbx anytime you need to share, present, or archive your work. It's built for portability and reliability. Moving your file, sending it, or just opening it up months later – the packaged workflow is what ensures your creations will render perfectly, no matter when or where.
Mastering this simple distinction takes you from a casual user to someone who can confidently deliver data analysis to an audience - a critical skill for anyone working with data.
Final Thoughts
Creating a Tableau Packaged Workbook is a fundamental skill that transforms how you share and present your data. By bundling your visuals, data extracts, and custom elements into a single, portable .twbx file, you guarantee that what you see is what your audience gets - no errors, no missing files, no excuses. Mastering this move empowers you to share insights confidently and professionally.
While packaging reports manually is a core part of the traditional BI workflow, sometimes you need to get answers without spending time sorting out connection types and extracts. We built Graphed to streamline this entire process. We help you connect your sources like Shopify, Google Analytics, and Salesforce just once, creating a live connection that never breaks. From there, you build real-time dashboards just by asking questions in plain English, allowing your entire team to get the data they need in seconds, no matter how technical they are. Instead of spending hours preparing files, we allow you to focus purely on the insights.
Related Articles
How to Create Facebook Ads API for Claude Code
Create a Meta Marketing API access token that never expires, using a system user, so Claude Code can pull Facebook ad reports and manage campaigns.
ClickHouse vs Postgres: When to Switch to Columnar
Comparing ClickHouse vs PostgreSQL means matching storage architecture to workload. Row storage wins for transactions. Columnar wins for scan-heavy analytics.
Google Ads for Orthodontists: Get More Booked Consults
Most orthodontic Google Ads campaigns waste money on low-intent searches. The problem is structure, not the platform.