How to Save a File in Tableau Public
You’ve connected your data, dragged and dropped your fields, and crafted a beautiful, insightful visualization in Tableau Public. Now, you’ve reached the final - and most important - step: saving your work. If you're coming from other software, you might look for a simple "Save" button to create a file on your desktop, but Tableau Public works a bit differently. This guide will walk you through exactly how to save your workbook, clarify what saving means in this context, and give you the confidence to share your work with the world.
First, Understand the Key Difference: Tableau Public vs. Tableau Desktop
Before we get into the step-by-step instructions, it’s critical to understand the distinction between Tableau’s two main products. This difference is the reason behind its specific saving process and is the most common point of confusion for new users.
- Tableau Public is a free tool designed for learning, practicing, and sharing data visualizations publicly. Think of it as your online data visualization portfolio. When you "save" here, you are actually publishing your workbook and its underlying data to the public Tableau web server. Anyone with the link can view your visualization and, if you allow it, download your workbook and data.
- Tableau Desktop is the paid, professional version used by analysts and businesses. It allows you to save workbooks privately on your local computer as
.twbor.twbxfiles, connect to a much wider variety of data sources, and work with sensitive, proprietary data without ever exposing it online.
The golden rule is simple: Saving in Tableau Public means publishing online. There is no option to save a file locally to your computer. If your data is confidential or private, you should not use Tableau Public with it.
Your Pre-Publishing Checklist
Because saving publishes your workbook for everyone to see, it’s worth taking a couple of minutes to make sure it's ready for an audience. Running through this quick checklist will make your work look more professional and prevent accidental data leaks.
1. Clean Up Your Worksheets and Dashboards
Your workbook might contain dozens of "scratchpad" worksheets where you experimented with different charts. Before saving, hide any sheets that aren't part of a final dashboard. Give your final worksheets and dashboards clear, descriptive names (e.g., change "Sheet 1" to "Monthly Sales Trend"). This keeps your published workbook tidy and easy for others to navigate.
2. Review Your Data Source for Privacy
This is the most important step. Double-check the data you’ve used. Does it contain personally identifiable information (PII) like names, emails, addresses, or phone numbers? Does it contain sensitive financial or business information? If so, you need to anonymize or aggregate it before publishing. A great way to handle this is to create a data extract and use the "Hide All Unused Fields" option to ensure only the necessary data is uploaded.
3. Write Clear Titles, Captions, and Legends
Give your visualization a strong title that tells viewers what they are looking at. Use captions to provide context, explain your methodology, or point out key insights. Ensure your legends and color keys are easy to understand. Remember, you won’t be there to explain it, so your dashboard needs to speak for itself.
4. Polish Your Tooltips
Tooltips — the little text boxes that appear when you hover over a data point — are one of Tableau’s best features. Don't stick with the default. Customize your tooltips to tell a clearer story. You can rewrite the text, format the numbers, and even add extra fields to provide more context without cluttering the main view.
Step-by-Step Guide: How to Save to Tableau Public
Once you’ve gone through the checklist and your visualization is ready, saving it is straightforward. Follow these steps to publish your workbook.
Step 1: Open the Save Menu
With your workbook open, navigate to the top menu bar in the Tableau Public application. Click on File > Save to Tableau Public As...
Note: The first time you save a new workbook, you must use "Save to Tableau Public As...". We’ll cover the difference between this and "Save to Tableau Public" later.
Step 2: Sign In to Your Tableau Public Account
A dialog box will appear prompting you to sign in to your Tableau Public account. If you don’t have one yet, you can create one for free. Enter your email and password, then click "Sign In."
Step 3: Name Your Workbook
After you sign in, another dialog box will appear. Here, you need to give your workbook a title. This title will be publicly visible and will also form part of the URL, so make it descriptive and unique. For example, instead of naming it "Final Version," a better title would be "US Coffee Sales Analysis 2023." Once you've entered a title, click "Save."
Step 4: Wait for the Workbook to Publish
Tableau will now connect to the server and upload your workbook along with its data extract. This process may take a few seconds to a minute, depending on the size of your dataset and your internet connection speed. A progress bar will show the status of the upload.
Step 5: Your Workbook Opens in Your Web Browser
Once the upload is complete, your default web browser will automatically open a new tab to the unique URL for your new visualization. Congratulations, your work is now live on Tableau Public! This is the link you can share with others.
Managing Your Workbook After It’s Saved
Your work isn't done the moment you hit "save." The Tableau Public website provides several excellent features for managing your published workbooks.
Editing Your Workbook Details
On your workbook's page, you'll see an "Edit Details" button. Clicking this allows you to change the title, add a detailed description, update the permalink, and control other settings. Adding a good description with keywords can help others discover your work on the platform.
Controlling Visibility
Under "Edit Details," you'll find a checkbox labeled "Show workbook on my profile." By default, this is checked. If you uncheck it, the workbook will not appear on your main profile page, but anyone with the direct link can still access it. This is useful for work-in-progress dashboards or visualizations for a specific audience.
Setting Download Permissions
Scroll down a bit further and you’ll find "Settings." The most important option here is "Allow workbook and its data to be downloaded by others."
- If checked, other users can download your workbook as a
.twbxfile. This means they get a full copy of your visualization and the underlying data. It's a great option for community collaboration and learning. - If unchecked, people can view and interact with your dashboard online, but they cannot download the source file or the data. Disable this setting if you want to share the visual without giving away the raw data or your development workbook.
Updating an Existing Workbook
What if you find a mistake or want to add a new chart to a workbook you've already published? You don’t have to create a new one. Just make your changes in the Tableau Public desktop app, then go to File > Save to Tableau Public. Since you’ve already saved it once, Tableau knows which online workbook to update and will overwrite the existing version with your latest changes.
Common Questions & Troubleshooting
Here are answers to a few frequent questions that come up when saving in Tableau Public.
Can I save my Tableau Public file to my local computer like a Word doc? No. This is the #1 limitation of the free Tableau Public application. All work must be saved to the public cloud server owned by Tableau. To save files locally, you need the paid version, Tableau Desktop.
What's the difference between "Save to Tableau Public" and "Save to Tableau Public As..."? "Save to Tableau Public As..." is used for the very first time you save a new project or when you want to create a new, separate copy of an already published workbook online. "Save to Tableau Public" is used to update (overwrite) a workbook that you’ve already published.
My data is sensitive. Are there any workarounds? The best advice is to simply not use Tableau Public for sensitive data. However, if you want to visualize trends without revealing specifics, you can aggregate your data before importing it into Tableau. For instance, instead of employee-level sales figures, you could show aggregated sales by department or region. You can also strip out all personal information to create an anonymized version of the dataset.
Final Thoughts
Saving your work in Tableau Public is more than just creating a file, it’s about publishing your insights to a global community. Understanding that your workbook and data will be public is the key to using the tool properly. By following the checklist and steps above, you can confidently share your visualizations, build a professional portfolio, and contribute to the data community.
Often, the hardest part of analysis isn’t building the chart - it's logging into a dozen different platforms like Google Analytics, your CRM, and your ads manager just to stitch the data together in a spreadsheet. We built Graphed to solve this very problem. Our platform connects all your marketing and sales data sources with a single click. From there, you can ask questions in plain English - like "create a dashboard showing Facebook ad spend vs Shopify revenue this quarter" - and get beautiful, real-time dashboards in seconds. This lets you find the insights you need faster, so you have more time to build incredible vizzes in tools like Tableau.
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.