How to Save in Tableau

Saving your work in Tableau seems straightforward, but choosing the right file type can be the difference between sharing a brilliant dashboard and sending a broken file that leaves your colleague scratching their head. This guide will walk you through the various ways to save your Tableau creations, explaining the difference between key file types and showing you when to use each one. You'll learn exactly how to save standard workbooks, packaged workbooks for sharing, and discover best practices to avoid common mistakes.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Understanding the Core Tableau File Types: .twb vs. .twbx

Before you even click "Save," you need to understand the two main file types you'll encounter. Getting this right is the most important part of managing your Tableau projects.

Tableau Workbook (.twb)

Think of a Tableau Workbook (.twb) file as a blueprint or a recipe card. It contains all the instructions for how to build your visualizations:

• Your worksheets and dashboards, including all formatting and layout choices.
• Calculated fields you've created.
• Sets, groups, and parameters you've defined.
• The connection information telling Tableau where to find the original data (e.g., the file path to an Excel file or the server address for a SQL database).

What it doesn't contain is the data itself. A .twb file is incredibly small because it only holds the metadata and your design. If you send a .twb file to someone, they will only be able to open it if they also have access to the exact same data source in the same location. If the data is an Excel file on your desktop, and you email them the .twb file, they won't be able to open it because their computer doesn't have your Excel file.

When to use a .twb file:

• You are working with a live, centralized data source (like a cloud database) that your teammates also have access to.
• You are the only person working on the workbook, and you aren't sharing it.
• Your dataset is massive, and including it in the file would make it too large to manage or email.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Tableau Packaged Workbook (.twbx)

If the .twb file is a recipe card, the Tableau Packaged Workbook (.twbx) file is a complete meal kit. It contains everything in one neat package:

• The entire Tableau Workbook (.twb) with all its sheets, dashboards, and formatting.
• A copy of the data source. This could be a static data file like an Excel sheet, CSV file, or a Tableau Data Extract (.hyper file) you've created from a database.
• Any custom images or custom shapes you used in your visualizations.

This "all-in-one" format makes it completely self-contained. You can send a .twbx file to anyone with Tableau (or the free Tableau Reader), and they will be able to open it and see your full dashboard exactly as you designed it, because the data is included. This is the most common format for sharing your work.

When to use a .twbx file:

• You need to share a workbook with someone who does not have access to the original live data source.
• You want to present your dashboard on another computer.
• You want to email your work to a colleague or client for feedback.
• You are saving a version of your analysis with the data captured at a specific point in time for archiving purposes.

How to Save a Standard Tableau Workbook (.twb)

Saving a standard .twb file is the default option in Tableau. It's perfect when you're connected to a shared database or building a dashboard for your own use. Here are the step-by-step instructions.

Step-by-Step Instructions:

1. With your workbook open in Tableau Desktop, navigate to the top menu bar.
2. Click on File > Save As.... A file dialog box will appear.
3. Navigate to the folder where you want to save your workbook.
4. Enter a descriptive name for your file in the "File name" field.
5. Check the "Save as type" dropdown menu. By default, it should be set to Tableau Workbook (*.twb). If not, select it from the list.
6. Click the Save button.

That's it! Your blueprint is now saved. To save your progress as you continue to work, just press CTRL + S (or Cmd + S on Mac) to quickly save the changes to the same .twb file.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

How to Save a Tableau Packaged Workbook (.twbx)

When it's time to share your insights with the world (or at least your team), the .twbx is your best friend. This ensures that everyone can view your work without any data connection errors.

Step-by-Step Instructions:

1. In Tableau Desktop, click on File > Save As... from the top menu.
2. Choose the destination folder for your saved file.
3. Give your workbook a meaningful name. Since you're likely sharing this, it's a good idea to include a version number or date, something like Q3_Sales_Analysis_v1_102524.twbx.
4. Click on the "Save as type" dropdown menu. This is the crucial step. Select Tableau Packaged Workbook (*.twbx) from the list.
5. Click Save.

Tableau will now bundle your workbook and a copy of the associated data into a single .twbx file, ready to be shared. The file size will be larger than a .twb, but its portability is well worth it.

Publishing Your Work: An Alternative to Saving Locally

Sometimes, "saving" means publishing your dashboard to a shared environment where others can interact with it live. Tableau offers a couple of options for this.

Saving to Tableau Server or Tableau Cloud

Tableau Server and Cloud are organizational platforms designed for secure collaboration. When you "save" here, you're publishing the workbook for internal stakeholders. This keeps a single version of the truth, allows for automatic data refreshes, and lets you manage viewer permissions.

How to Publish:

1. From the top menu, go to Server > Publish Workbook...
2. Sign into your company's Tableau Server or Tableau Cloud account if prompted.
3. In the publishing dialog, you'll choose the project folder, name the workbook, and configure permissions and data refresh schedules.
4. Click Publish.

Saving to Tableau Public

Tableau Public is a free platform for sharing your visualizations with the entire world. It's an excellent place to build a data visualization portfolio. Be extremely careful - as the name implies, anything you publish here is completely public.

IMPORTANT: Never, ever publish a workbook to Tableau Public with sensitive or private data.

How to Save to Tableau Public:

1. Navigate to Server > Tableau Public > Save to Tableau Public...
2. Sign into your free Tableau Public account.
3. Give your workbook a title and click Save. A browser window will open, showing you the new public viz.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Best Practices and Common Mistakes to Avoid

Following these simple guidelines will save you time and prevent frustrating errors when collaborating and sharing your Tableau workbooks.

• The #1 Mistake: Emailing a .twb File. The most common error new users make is emailing a .twb file and thinking the recipient can open it. Unless they have access to your exact live data connection or local file path, it will fail. Always use a .twbx for sharing with users who don't have direct data access.
• Clarify Before You Share: Always ask yourself, "Does the person I'm sending this to have access to the underlying database?" The answer to this question determines which file format you should use.
• When in Doubt, Use .twbx: If you're unsure about someone's data access, the safest bet is always to save and send a .twbx file. You can't go wrong sending a self-contained workbook.
• Use Descriptive File Names: Avoid generic names like Workbook1.twb. Instead, use a clear, convention-based naming system, such as ProjectName_MetricType_Date.twbx. This makes it easier to find what you're looking for later.
• Save Frequently: Just like with any software, Tableau can sometimes crash. Get in the habit of hitting CTRL + S often so you don't lose your hard work.

Final Thoughts

Mastering how to save in Tableau is about more than just clicking a button, it's about understanding what you want to do with your workbook. Choosing between a standard .twb for personal work with live data and a packaged .twbx for sharing and archiving is the foundational skill for collaborating effectively and ensuring your insights reach their audience.

While tools like Tableau are powerful, the learning curve can be steep, often requiring deep knowledge of file types, data extracts, and complex chart builders just to get started. Sometimes, you just need a straightforward answer about your business performance without the technical overhead. At My Company (Graphed), we built Graphed for exactly that. Connect your data sources in a few clicks, then ask questions in plain English like "Create a dashboard comparing our ad spend vs. sales from last month." We instantly build you a live, interactive dashboard, turning hours of manual analysis into a 30-second conversation.