Where Are the Sheets Saved in Tableau Public?

You’ve just built a brilliant visualization in Tableau Public, complete with multiple worksheets that break down your data beautifully. You hit save, publish your masterpiece, and then a nagging question pops up: where, exactly, are those individual sheets saved? It's a common point of confusion, and the answer isn't what you might expect if you're used to traditional spreadsheets. This article will clarify how Tableau Public organizes and saves your work, explaining the relationship between sheets, dashboards, and the final published workbook.

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

Understanding the Tableau Hierarchy: Workbooks, Dashboards, and Sheets

First, it’s necessary to understand that Tableau doesn’t think in terms of individual files for each sheet. Instead, it uses a container-based structure. Moving away from the "one sheet, one file" mindset of Excel or Google Sheets is the first step to clearing up any confusion.

What is a Tableau Workbook?

Think of a Tableau Workbook as the main project file for everything you create. It’s the highest level of organization. When you save your work in Tableau, you are saving the entire workbook. This single file - which gets published to the cloud when you use Tableau Public - is a self-contained package that holds all the components related to your analysis. It contains your data connections, calculations, sheets, dashboards, and stories.

What are Tableau Sheets?

A sheet (or worksheet) is where you actually build an individual visualization. It's the canvas where you drag and drop data fields onto shelves to create a single chart, graph, map, or table. You might have one sheet for a bar chart showing sales by region, another sheet for a line chart showing sales over time, and a third for a text table with detailed numbers. Each of these sheets lives inside the workbook. They are not saved as standalone files on their own.

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

What are Dashboards and Stories?

Dashboards and stories are also components housed within your workbook. A dashboard is a page where you can arrange multiple sheets together in a single view to present a cohesive set of insights. This allows you to combine your regional sales bar chart and your sales trend line chart on one screen. A story is a guided narrative that walks viewers through a sequence of visualizations and dashboards, helping you tell a compelling story with your data.

The Simple Answer: Your Sheets Are Saved Inside Your Workbook

So, to answer the question directly: your sheets are not saved in a separate location. They are saved as components within the single workbook file you publish to your Tableau Public profile.

When you click File > Save to Tableau Public As..., you are not uploading individual charts. You are uploading the entire workbook, which contains all the sheets you created. Once it's published online, viewers can navigate between the different sheets, dashboards, and stories using tabs that appear at the top of the visualization, assuming you've allowed them to be shown.

Imagine your workbook is a book. The sheets are the pages, the dashboards are chapters that bring certain pages in a specific order, and the whole thing is bound together. You don't save page 12 separately from the book, page 12 is simply part of the book. Tableau works the same way.

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 Your Workbook (and All its Sheets) to Tableau Public

To see how this works in practice, let’s walk through the exact steps for publishing your work. This process bundles all your sheets and dashboards into one final, shareable asset.

Step 1: Open the Tableau Public Desktop Application

Your journey begins in the free Tableau Public desktop tool. This is where you connect to your data sources (like Excel, text files, or Google Sheets) and start building your views.

Step 2: Create Your Visualizations on Multiple Sheets

Design your charts and graphs. Each distinct visualization should ideally be on its own sheet. At the bottom of the interface, you’ll see tabs for "Sheet 1," just like in a spreadsheet program. You can click the icon for "New Worksheet" to add more. It’s a good practice to double-click the tab names and give them descriptive titles (e.g., "Monthly Sales (Bar)" instead of "Sheet 1").

Step 3: Navigate to "Save to Tableau Public As..."

Once you’re satisfied with your work, go to the top menu and click File > Save to Tableau Public As.... If you've never saved it before, this will be your only cloud-saving option. If you've saved it previously, you can use File > Save to Tableau Public to overwrite the existing version.

Step 4: Sign In and Name Your Workbook

A dialog box will appear, prompting you to sign in to your Tableau Public account. After you sign in, you'll be asked to give your workbook a title. Choose a clear, descriptive name so others (and you) can find it later. It’s essential to remember that this title is for the entire workbook, not just a single sheet.

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

Step 5: Click Save

After you click save, Tableau will extract your data, bundle your worksheets and dashboards, and upload the entire workbook package to the Tableau Public servers. Your web browser will automatically open to the URL of your new visualization. Here, at the top, you can see the tabs for each of the sheets and dashboards included in the workbook, allowing anyone to easily navigate through the different components you designed.

Important Distinctions: Tableau Public vs. Tableau Desktop

A lot of the confusion about saving comes from the key differences between Tableau Public and its paid counterpart, Tableau Desktop. Understanding these differences can provide valuable context.

• Local vs. Cloud Saving: This is the biggest difference. With the paid Tableau Desktop, you can save your workbook files (.twb or .twbx) directly to your computer, network, or private server. You can keep your files private without ever uploading them. Tableau Public, on the other hand, only allows you to save your work to the Public gallery. You cannot save a private working file locally. This "always public" model is the tradeoff for being a free tool.
• Data Publicity: Because you can only save to the Public service, any visualization - and its dataset - will be visible to everyone. Never publish sensitive data on Tableau Public.
• Data Connectors: Tableau Desktop offers a massive array of connectors to databases and servers, allowing for extensive data integration. Tableau Public, however, supports a more limited range of connectors, including Excel, text files, and Google sheets.

Tips for Organizing Your Work in Tableau Public

Now that you know everything lives inside the workbook, staying organized is vital for creating a clear and easy-to-navigate viewing experience for your audience.

• Use Descriptive Names: "Sheet 1" tells your audience nothing. Rename your sheets and dashboards to be self-explanatory. For example, "YoY Sales Growth," "Product Category by Revenue," and "Customer Distribution Map."
• Hide Unused Sheets: Once you incorporate sheets into a dashboard, there's typically no need for users to see the individual sheet tabs. Right-click on a sheet tab and select "Hide Sheet." This will keep it from public view while still being available for your dashboards.
• Curate with Dashboards: Don't just publish a collection of 15 messy sheets. The best Tableau Public profiles use dashboards to combine a few related worksheets into a professional, composed story.
• Control Workbook Interaction: When you publish, there's always a "Show sheets as tabs" box on the bottom right of the screen. Making sure this box is checked will allow viewers to navigate through sheets if needed. Sometimes guiding your audience through a tailored journey is more effective than offering them complete freedom.

Final Thoughts

In short, your individual Tableau Public sheets aren’t living in some hidden folder, they exist as part of the unified workbook that you publish to your online profile. Remembering that you are always working with and saving a single, containerized workbook is the key to mastering the Tableau workflow.

While mastering Tableau is a rewarding skill, sometimes you just need to get quick answers from your data without a big learning curve. We created Graphed for exactly that situation. Instead of wrestling with sheets and dashboard layouts, you can connect your marketing and sales data sources in seconds and then use simple, plain English to ask for the charts and dashboards you need. This turns hours of manual reporting into a quick, conversational process, giving you back time to focus on strategy instead of struggling with complex tools.