How to Upload to Tableau Public
Ready to share your data visualization masterpiece with the world? Tableau Public is the perfect stage for building a portfolio and sharing your insights. This guide will walk you through everything you need to know about getting your workbook from Tableau Desktop to your public profile, step by step.
What is Tableau Public (and Why Use It?)
Think of Tableau Public as a free online gallery for data visualizations created with Tableau. It’s a vibrant community where data enthusiasts, students, and professionals can publish interactive dashboards for anyone to see. It’s the go-to platform to build a personal portfolio, demonstrate your analytical skills to potential employers, or simply share a compelling data story with a wide audience.
The key thing to remember is in the name: public. Any data you upload is accessible to anyone on the internet. For this reason, you should only publish workbooks using data that is publicly available or anonymized. Never upload sensitive, private, or proprietary company information to Tableau Public.
Before You Publish: A Quick Checklist
Before you hit that "Save to Tableau Public" button, running through a quick pre-flight check will ensure your published visualization is polished, professional, and performs well.
1. Clean Up Your Workbook
A tidy workbook is a happy workbook. Before publishing, do some digital housekeeping. Delete any unused worksheets, dashboards, or data sources. Rename your final dashboard and worksheets to have clear, descriptive titles. This not only makes your work look more professional but also makes it easier for you to manage.
2. Check Your Data Connection: Extract is Key
Tableau Public has a major limitation: it doesn't support live connections to most data sources. If you're connected live to a local Excel file or a private company database, you won't be able to publish it. Instead, you need to create a Tableau Data Extract.
An extract is a saved snapshot of your data that gets packaged with your workbook. This not only makes your workbook self-contained but also significantly improves performance.
To create an extract:
- Go to the Data Source tab in the bottom-left corner of Tableau Desktop.
- At the top right, under "Connection," switch from Live to Extract.
- Go back to a worksheet, and Tableau will prompt you to save the extract file (as a .hyper file).
Once you do this, your workbook is using a portable snapshot of the data, ready for publishing.
3. Optimize Your Tooltips
Tooltips are the little boxes that appear when a user hovers over a mark on your chart. They are a massive part of the user experience. Don't settle for the default ones! Customize them to be clean, informative, and easy to read.
- Click on the Tooltip card on the Marks pane to edit it.
- Use clear labels, rephrase auto-generated text, and remove any unnecessary fields.
- You can even create dynamic, sentence-based tooltips like: "In <Year>, <Country> had a sales total of <SUM(Sales)>."
4. Craft a Great Title and Description
When you publish, your workbook's title and subsequent description are your best chance to grab attention. Give your viz a compelling, simple-to-understand title. In the description (which you can edit after publishing), explain what the dashboard is about, where you got the data, and what story you're trying to tell. This context is invaluable for anyone exploring your work.
5. Set Your Dashboard Dimensions
Dashboards in Tableau Desktop can have their size set to automatically fit the screen, but this can cause things to look strange on different web browser sizes. For more control over how your dashboard appears online, it's best to set a fixed size.
On the left-hand pane of your dashboard view, under "Size," change the dropdown from "Automatic" to "Fixed size." A standard size like "Desktop Browser (1000 x 800)" is a good starting point, but you can adjust it to what looks best for your design.
How to Upload Your Workbook to Tableau Public
Once you’ve gone through the checklist and your workbook is ready, the publishing process itself is very straightforward. Just follow these steps.
Step 1: Open Your Workbook in Tableau Desktop
This may seem obvious, but make sure the final version of the workbook you want to publish is open and that you've saved a local copy first. It's always a good practice to have a backup on your machine.
Step 2: Navigate to the "Save to Tableau Public" Option
In the top menu of Tableau Desktop, click on Server. In the dropdown menu, you'll see a section for Tableau Public. Select Save to Tableau Public As...
Step 3: Sign In to Your Account
A window will pop up asking you to sign in to your Tableau Public account. Enter your email and password. If you don't have an account yet, you can create one for free on the Tableau Public website. You’ll need to have an account before you can proceed.
Step 4: Name Your Workbook and Save
After you sign in, Tableau will present a dialog box asking for a title for your workbook. This is the public-facing title that everyone will see on your profile. Type in your final title and click Save.
Behind the scenes, Tableau will now create the data extract (if you haven't already) and upload the packaged workbook (.twbx) to its servers. This can take a few seconds or a couple of minutes depending on the size of your data.
Step 5: Your Workbook is Live! Edit Final Settings.
Once the upload is complete, your default web browser will automatically open a new tab and take you directly to your new, shiny visualization on your Tableau Public profile. It's now live for the world to see!
Take a moment to review it. At the bottom of your visualization, you’ll see some options. Click the Edit Details button. Here you can:
- Finalize the workbook's title.
- Write a detailed description.
- Add a link to the data source or to an article explaining your work.
- Manage permissions. A key setting here is "Allow workbook and its data to be downloaded by others." Turning this on is great for the community, as it allows others to learn from your work, but be mindful of your data if you choose to disable it.
- Enable or disable the "Show workbook sheets as tabs" option.
Step 6: Hide Worksheets (Optional)
If you don't want viewers to see all of your individual worksheets as tabs at the top of your public viz, you can hide them. Back in Tableau Desktop, right-click on the tab of any sheet you want to hide and select "Hide Sheet". Then, republish the workbook to Tableau Public by choosing Server > Tableau Public > Save to Tableau Public. This will overwrite the previous version.
Common Challenges and Quick Fixes
Even with a perfect checklist, you might run into an issue or two. Here are some of the most common hiccups and how to handle them.
- "Cannot publish to Tableau Public because of a live data connection." This is the most common error. As mentioned, Tableau Public requires a data extract. Just go to your Data Source tab, switch the connection from Live to Extract, and try publishing again.
- "The visualization is loading very slowly." Large datasets with a massive number of marks or complex calculations can bog down performance. Consider aggregating your data before bringing it into Tableau or apply filters at the extract level to only include the data you absolutely need for the viz.
- "My dashboard formatting looks weird online." This is nearly always a result of using automatic dashboard sizing. To get full control over the final look, change the dashboard sizing to Fixed size in Tableau Desktop and republish.
Final Thoughts
Publishing to Tableau Public is a fantastic way to develop your data visualization skills, build a public portfolio, and participate in the vibrant data community. The process is simple once you get the hang of it, especially if you remember to clean up your workbook and create a data extract before you upload.
While Tableau is an incredibly powerful BI tool, the process of extracting, cleaning, and publishing data for dashboards can be time-consuming. At Graphed, we’ve made this process as simple as having a conversation. By connecting your live marketing and sales data sources (like Google Analytics, HubSpot, or Shopify) directly, we let you use natural language to create real-time, shareable dashboards in seconds. This eliminates the manual steps of downloading CSVs or building extracts, so you can explore your data and get answers right away.
Related Articles
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.
How to Create a Photo Album in Meta Business Suite
How to create a photo album in Meta Business Suite — step-by-step guide to organizing Facebook and Instagram photos into albums for your business page.