How to Save a Tableau Workbook

Saving your work in Tableau seems straightforward, but choosing the right file type can be the difference between a dashboard that works perfectly and one that sends your colleague an error message. Understanding the different saving options is essential for sharing your analysis, collaborating with your team, and managing your data connections effectively. This guide will walk you through exactly how, where, and when to use each of Tableau’s primary file types.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

First, Understand Tableau's File Types: .twb vs. .twbx

Before you even click "Save," you need to know the fundamental difference between Tableau's two main workbook file formats. This choice impacts who can open your workbook and what they will see.

The Tableau Workbook (.twb)

Think of a .twb file (short for Tableau Workbook) as a blueprint or a recipe for your dashboard. It’s an XML file that stores all the instructions Tableau needs to recreate your visualizations:

• It knows which sheets, dashboards, and stories you’ve created.
• It saves all your formatting choices like colors, fonts, labels, and borders.
• It holds the information on how you’ve arranged your dashboards.
• Most importantly, it contains the connection information to your data source.

What a .twb file does not contain is the actual data itself. It only saves the path and credentials needed to connect to the data, whether that's a locally stored Excel file or a corporate SQL database. If you send a .twb file to a coworker, they will only be able to open it if they also have access to the exact same data source path.

When to use a .twb file:

• When you are working with a live, centralized data source (like a database) that all your report viewers have access to.
• When your dataset is massive and it would be impractical to package it with your workbook.
• When you want the workbook to automatically update with the freshest data every time it's opened and refreshed.

AI Agents for Marketing

Crash Course

Graphed

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.

Download the PDF

The Tableau Packaged Workbook (.twbx)

A .twbx file (short for Tableau Packaged Workbook) is a self-contained "zip" file. It bundles everything needed to view the dashboard into a single, portable file. This package includes:

• The original .twb workbook file (the blueprint).
• A copy of any local data files used (like Excel spreadsheets, CSVs, or text files).
• Tableau Data Extracts (.hyper files), which are high-performance snapshots of your data.
• Any custom background images or custom geocoding information you’ve included.

Because the .twbx file contains a copy of the data, anyone with Tableau Desktop or Tableau Reader can open and view it without needing access to the original data source. It’s the perfect format for sharing.

When to use a .twbx file:

• Anytime you need to email a dashboard or share it with someone who doesn't have direct access to your live data.
• When your data source is a local file on your computer (this is the most common use case).
• When you want to share a specific snapshot of the data from a particular point in time.
• When you are publishing a workbook to Tableau Public.

How to Save a Standard Tableau Workbook (.twb)

Saving a standard workbook is as simple as saving a document in any other program. This format is ideal when you're working off a shared database and just need to save the dashboard structure.

1. Navigate to the top menu and select File > Save As...
2. A dialog box will open, allowing you to choose a location on your computer to save the file.
3. Enter a descriptive name for your workbook.
4. The default "Save as type" is Tableau Workbook (*.twb). Keep this as it is.
5. Click Save.

Remember, if you save in this format and your data source is an Excel file on your desktop, and you then email this .twb to your manager, they won't be able to open it because their computer can't connect to the file path on your desktop.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

How to Save a Packaged Tableau Workbook (.twbx)

This is the most common and safest way to save and share Tableau workbooks, especially for beginners or those working with static files. This process packages your data along with your workbook, ensuring anyone can open it.

1. From the top menu, go to File > Save As...
2. Choose a folder where you want to store your workbook and give it a name.
3. This is the important step: Click on the "Save as type" dropdown menu.
4. From the list, select Tableau Packaged Workbook (*.twbx).
5. Click Save.

Tableau will now bundle your workbook layout and a copy of your data file into a single .twbx file. You can now confidently send this file to a colleague, knowing they'll be able to see exactly what you're seeing.

Pro Tip: You can also use the keyboard shortcut Ctrl + Shift + S to quickly open the "Save As" dialogue. For regular in-progress saves, simply use Ctrl + S.

Saving for Broader Audiences: Tableau Server, Cloud, and Public

Beyond saving files to your computer, Tableau provides robust platforms for publishing and sharing interactive dashboards securely within your organization or openly with the world.

Saving to Tableau Server or Tableau Cloud

Tableau Server and Cloud are designed for internal business use. They provide a centralized, secure location where teams can publish, share, and collaborate on dashboards. When you publish to these platforms, you're not just sharing a file, you're providing access to an interactive dashboard via a web browser.

To do this:

1. Make sure you are signed into your organization's server. Go to Server > Sign In....
2. Once your workbook is ready, go to Server > Publish Workbook....
3. A dialog will appear with several important options:
4. After configuring the options, click Publish.

Your workbook and its data source are now hosted on the server, and users can access it via a shared link without needing Tableau Desktop installed.

AI Agents for Marketing

Crash Course

Graphed

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.

Download the PDF

Saving to Tableau Public

Tableau Public is a free platform used by data enthusiasts and journalists to share their work with the world. It’s an amazing resource for building a portfolio, but remember: anything you publish here is completely public.

IMPORTANT: Never upload sensitive, confidential, or proprietary company data to Tableau Public.

The process is similar to publishing on a private server:

1. Go to Server > Tableau Public > Save to Tableau Public As...
2. You'll be prompted to sign into your Tableau Public account (you can create one for free).
3. Give your workbook a title. Tableau will automatically save it as a packaged workbook with an extract of the data.
4. Click Save.

Tableau will publish the workbook to your public profile, and you can share the link with anyone.

Final Thoughts

Choosing the right way to save your Tableau workbook boils down to one simple question: "Who needs to see this, and do they have access to the data?" If they don’t, use a packaged .twbx file. If it’s for collaborative work within a company that shares a live database, a standard .twb file is often more efficient. Mastering this distinction ensures your hard work is shareable and error-free.

Building dashboards in BI tools can require learning complex software, managing file versions, and configuring data connections. At Graphed, we've automated this process. You can connect all your data sources - like Google Analytics, Salesforce, and Shopify - and build stunning, real-time dashboards just by describing what you want to see in simple English. There are no file types to worry about and no menus to learn, just ask a question and get a live dashboard in seconds. You can try Graphed today and see for yourself.