How to Publish Workbook to Tableau Public

Cody Schneider8 min read

Sharing your data visualizations with the world is a fantastic way to build a portfolio, contribute to the data community, and showcase your analytical skills. Tableau Public is the perfect platform for this, and publishing your work is easier than you might think. This guide will walk you through the entire process, from preparing your workbook to sharing your final masterpiece.

GraphedGraphed

Your AI Data Analyst to Create Live Dashboards

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

Watch Graphed demo video

What is Tableau Public (And Why Should You Use It)?

Tableau Public is a free platform provided by Tableau that lets anyone publish interactive data visualizations to the web. Think of it as a social network for data geeks, a portfolio site for analysts, and an incredible learning resource all rolled into one. It's the standard for building a public-facing data visualization portfolio.

Here’s why it's so valuable:

  • Build a Professional Portfolio: Showcase your skills to potential employers and clients. A strong Tableau Public profile with a handful of well-designed dashboards speaks volumes about your capabilities.
  • Learn from an Amazing Community: You can explore countless visualizations, see how they were built, download the workbooks, and reverse-engineer clever techniques.
  • Get Feedback and Recognition: Share your work on social platforms like LinkedIn or Twitter to get feedback from other data professionals. You can even be featured as Tableau's "Viz of the Day."
  • It’s Free: Tableau Public is completely free to use, as is Tableau Desktop Public Edition, the software you use to create and publish your visuals.

Preparing Your Workbook for the Public Eye

Before you hit "publish," a little prep work goes a long way. The key thing to remember is that everything you publish to Tableau Public — both the visualization and the underlying data — is publicly accessible. This isn't a place for sensitive or confidential company data.

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.

Step 1: Get Your Data Ready

The number one rule of Tableau Public is to never, ever use private or proprietary data. Since an extract of your data source gets uploaded with your workbook, anyone can download it and see the raw numbers. Stick to public datasets, personal projects, or properly anonymized information.

Some great places to find free, public datasets include:

  • Kaggle Datasets
  • Data.world
  • Google Dataset Search
  • Your local government's open data portal

Step 2: Create a Data Extract

Tableau Public doesn’t support live data connections. Instead, it requires you to use a Tableau Data Extract (.hyper file). An extract is simply a saved, compressed snapshot of your data that gets packaged with your workbook. This makes your visualization self-contained and improves performance since all the data it needs is bundled right in.

If you’re currently on a live connection, switching to an extract is simple:

  1. Go to the Data Source tab in the bottom-left of your Tableau window.
  2. In the top-right corner, you’ll see the Connection options. Select Extract instead of Live.
  3. You'll notice an "Edit" link appear next to the Extract option. Clicking this allows you to add filters or aggregate the data for the extract, which is handy for making your dataset smaller and faster.
  4. Now, navigate to any sheet in your workbook. Tableau will prompt you to save the extract file. Choose a location on your computer and save it. Your workbook is now running off this .hyper extract.

Moving forward, all your calculations and visualizations will query this local file instead of the original data source.

Step 3: Polish Your Workbook and Dashboards

A little professional polish turns a good viz into a great one. Think of your published workbook as a final product you are presenting to the world.

  • Clean Up Your Sheets: Nobody wants to see “Sheet 1,” “Sheet 27,” and “Sheet 31 (copy).” Hide any worksheets that are not used in a final dashboard to avoid clutter. Right-click the sheet tab and select "Hide."
  • Focus on a Primary Dashboard: Your goal should be to present one or more powerful, well-designed dashboards. This is what viewers will see first. Make sure your dashboards have clear titles, informative tooltips, and are easy to understand.
  • Craft Informative Tooltips: Tooltips are the small pop-up boxes that appear when a user hovers over a data point. Edit them to be clear and informative. Instead of a default list of fields, try writing a sentence like "In <Region>, sales totaled <SUM(Sales)>, in <YEAR(Order Date)>."
  • Check Your Dashboard Layouts: Ensure your dashboard looks good on different screen sizes. Use Tableau's "Device Preview" feature to see how it will appear on a tablet or phone.

How to Publish Your Workbook to Tableau Public

Once your workbook is prepared and polished, the actual publishing process only takes a few clicks. You’ll be publishing from your Tableau Desktop Public Edition application.

GraphedGraphed

Your AI Data Analyst to Create Live Dashboards

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

Watch Graphed demo video

Step 1: Navigate to the Publish Option

With your workbook open, go to the top menu bar and select Server → Tableau Public → Save to Tableau Public As...

Step 2: Sign in to Your Account

A dialog box will pop up prompting you to sign in. Enter the email and password for your Tableau Public account. If you don't have an account yet, there's a link to create one for free. The account is your online gallery where all your published workbooks will live.

Step 3: Name Your Workbook

After signing in, another dialog box will appear. Here, you’ll need to give your project a title. Choose a clear and descriptive name that explains what the visualization is about. This title will be publicly visible on your profile.

You can also choose to uncheck the box that says "Show sheets as tabs." Hiding the tabs gives you more control over the user experience, guiding viewers through a story rather than letting them click through individual worksheets. For portfolio pieces, it’s often best to hide these.

Step 4: Publishing and Uploading

Tableau will now create the data extract, package it with your workbook, and upload it to the Tableau Public servers. A progress bar will show the status. Depending on the size of your data, this may take anywhere from a few seconds to a couple of minutes.

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.

Step 5: View Your Live Visualization!

Once the upload is complete, your default web browser will automatically open a new tab and take you directly to your brand-new, live visualization on your Tableau Public profile. Congratulations, your work is now live for the world to see!

Managing Your Published Workbook

Your job isn't done right after publishing. A few final touches on the Tableau Public website can make your project more professional and discoverable.

  • Edit Details: Scroll down below your visualization. You’ll see an “Edit Details” button. Here you can change the title, add a detailed description (highly recommended!), and set a more user-friendly permalink that’s easier to share. Use the description to explain your data source, methodology, and what insights people should look for.
  • Set the Thumbnail: By default, the thumbnail is a shot of your main dashboard. You can click 'Settings' and choose a different sheet or even a custom image to act as the thumbnail for your viz on your profile page.
  • Share & Embed: At the bottom of your viz, you'll find a "Share" button. This gives you a direct link to share on social media as well as the embed code you can use to display the interactive visualization directly on your personal website, blog, or online portfolio.
  • Control Viewer Options: Below your published viz, in the 'Settings' section, you can control what others can do. A key option is “Allow workbook and its data to be downloaded by others.” Keeping this enabled is great for the community, as it allows others to learn from your work. If you prefer to keep your methodology private, you can disable it here.
  • Update Your Work: Need to make a change? Simply make the edits in your Tableau Desktop file, then go through the publishing process again (Server → Tableau Public → Save to Tableau Public). Tableau will recognize you’re updating an existing file and ask if you want to overwrite it.

Final Thoughts

Publishing your work to Tableau Public is an essential skill for any aspiring data analyst. By carefully preparing your data, polishing your workbook, and following the simple publishing steps, you can create a professional-grade portfolio that showcases your talent to the global data community.

While tools like Tableau offer powerful capabilities, the process of connecting to multiple data sources, cleaning them up, and then building new dashboards for every question still takes time. We built Graphed because we wanted to eliminate that friction. Instead of spending hours wrangling data and configuring dashboards, we let you connect all your marketing and sales platforms (like Google Analytics, Shopify, Facebook Ads, and Salesforce) in one place and simply ask for what you need in plain English. Your dashboards and reports are generated instantly, saving you time for the more important work: acting on your data.

Related Articles