How to Save Multiple Sheets in Tableau Public

Saving your work in Tableau Public can feel surprisingly restrictive if you’re used to the full-featured Tableau Desktop. You meticulously build several worksheets, each showing a different, valuable insight, but when you go to save, you discover you can only publish one sheet at a time. This article will show you exactly how to get around that limitation by using dashboards and stories to combine and share multiple worksheets under a single, interactive view.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Understanding the "One Sheet" Rule in Tableau Public

Tableau Public is a fantastic free platform for sharing data visualizations with the world, but it comes with a key limitation: it’s designed to publish and share a single view. That "view" can be a worksheet, a dashboard, or a story. So, while you can't save a workbook with ten separate, clickable worksheet tabs like you can in Tableau Desktop, you can package all ten of those worksheets into a single dashboard or a story and then publish that one item.

Once you understand this concept, the solution becomes clear. The goal is not to save multiple individual sheets but to create a single container - a dashboard or a story - that holds them all. Viewers can then interact with all your worksheets within that single, published link.

Method 1: Using a Dashboard to Combine Multiple Worksheets

The most common and flexible way to present multiple sheets is by arranging them on a dashboard. A dashboard is like a canvas where you can place different worksheets, allow them to interact with each other, and present a comprehensive view of your data.

Let's walk through an example. Imagine you've created three separate worksheets using Superstore sample data:

• Sales by State: A map visualization showing sales totals for each state.
• Sales Over Time: A line chart showing monthly sales trends.
• Sales by Category: A bar chart breaking down sales by product category.

You want to show all three together. Here’s how you do it.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 1: Create Your Individual Worksheets

First, create each worksheet as you normally would. Focus on getting each visualization perfect on its own. Give them clear, descriptive names like "Sales Map," "Monthly Sales Trend," and "Category Sales." Clear naming makes the next steps much easier.

Step 2: Create a New Dashboard

At the bottom of your Tableau Public window, next to your worksheet tabs, you'll find an icon with a plus symbol inside a grid. This is the "New Dashboard" button. Click it to create a blank dashboard canvas.

Step 3: Add Your Worksheets to the Dashboard

On the left-hand side of the dashboard view, you’ll see a "Sheets" pane listing all the worksheets you've created. To add one to your dashboard, simply click and drag it onto the canvas.

• Drag your "Sales Map" worksheet onto the empty "Drop sheets here" space. It will take up the entire canvas.
• Now, drag your "Monthly Sales Trend" worksheet. As you hover over the canvas, Tableau will show you gray shaded areas where you can place the new sheet - to the top, bottom, left, or right of the map. Drop it where you want it.
• Finally, drag the "Category Sales" bar chart and place it in an available spot.

Tableau will automatically tile these on your dashboard. You can resize each view by clicking and dragging the borders between them until the layout looks right.

Step 4: Add Interactivity With a Filter Action

Here’s where a dashboard really shows its power. You can make it so that clicking on one worksheet filters the others. For example, what if clicking on the "West" region on your map automatically updated the line and bar charts to show data for only the West region?

1. Click on the map worksheet within your dashboard to select it. A gray border will appear.
2. In the upper-right corner of the selected worksheet, you’ll see several small icons. Click the "Use as Filter" icon, which looks like a funnel.

That's it! Now, when you (or anyone viewing your published dashboard) click on a state or region on the map, the sales trend line chart and category bar chart will instantly update to reflect the selection. This simple action turns three static charts into one dynamic, explorable analytical tool.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Method 2: Using a Story to Guide Viewers Through Your Analysis

If you want to tell a more guided, narrative-driven story with your data, then Tableau Stories is the perfect tool. Instead of presenting everything at once on a dashboard, a story allows you to walk viewers through your insights one step at a time, with captions and annotations to explain what they're seeing.

Step 1: Make Your Worksheets (or a Dashboard)

Just like with the dashboard method, your first step is to create the individual visual elements - your worksheets. You can also add entire dashboards to a story point if you've already combined some charts.

Step 2: Create a New Story

At the bottom of your workspace, click the icon of a book with a plus sign, "New Story." This brings up the Story canvas.

Step 3: Add Your First Story Point

Similar to the dashboard view, you'll see a list of your available sheets and dashboards on the left. Drag your first visualization, like the "Sales Map," onto the story canvas.

Above the canvas, a space appears for you to add a caption. Write something descriptive, like: "Our sales are coast-to-coast, with major hubs in California and New York." This becomes your first "story point."

Step 4: Build Out Your Narrative with More Story Points

To add the next point in your narrative, you can click "Blank" to drop a new sheet onto a blank canvas or "Duplicate" to create a new story point based on the current one. Drag your "Monthly Sales Trend" chart onto a new, blank story point. Write your next caption: "Looking at sales over time, we see a significant seasonal spike at the end of each year."

Continue this process, adding each worksheet or dashboard as a new point in your story. You can create a flow that zooms in on certain data points, introduces new aspects of the analysis sequentially, and guides your audience to a specific conclusion.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 5: Customize Your Story Navigator

At the top of the story, you’ll see the navigation box for your story points. You can select different styles for it - caption boxes, numbers, or dots - and edit your descriptive text to guide the viewer through each step.

The Final Step: How to Save to Tableau Public Correctly

Whether you've built a dashboard or a story, the saving process is the same. This is where people often make a mistake, so pay close attention.

1. Go to the menu bar and click File > Save to Tableau Public As…. Do not click "Save" or "Save As," as those are for local files, which is a feature not fully available in the Public version.
2. A dialog box will pop up asking you to sign in to your Tableau Public account. Enter your credentials.
3. Next, you'll be prompted to give your workbook a title.
4. After entering a title and clicking "Save," Tableau will automatically publish the sheet you are currently viewing. This is the crucial part: if you are viewing a single worksheet, it will only publish that one worksheet. You must be on your dashboard or your story tab when you initiate the save. Before you click File > Save to Tableau Public As..., make sure you have your fully assembled dashboard or story open and active on your screen.
5. Tableau Public will then upload the workbook. When it's finished, it will automatically open in your web browser. You will see your interactive dashboard or story in all its glory, complete with all its component sheets working together.

Best Practices Before You Publish

To make your published visualization as professional and user-friendly as possible, follow these quick tips:

• Provide Context: Use text boxes on your dashboard to add a title, a short description of the data, or instructions on how to use any filters or interactive elements. Don't assume your audience will know what they're looking at.
• Hide Unused Sheets: Your public workbook often allows users to see the component parts. If you have extra "helper" worksheets that aren’t needed for the final view, you can hide them. Just right-click on the sheet tab at the bottom and select "Hide Sheet." This keeps things clean.
• Set the Size: In the dashboard pane on the left, you can set the "Size." A fixed size (like Desktop Browser - 1000 x 800) is often best, as it ensures your dashboard looks exactly how you designed it. "Automatic" can sometimes cause elements to rearrange or overlap on different screen sizes.

Final Thoughts

While Tableau Public's one-sheet saving rule can feel like a roadblock, it's really directing you toward better-designed visualizations. By using dashboards and stories, you can bundle multiple sheets into a single, cohesive, and interactive view that presents a much richer analysis than a series of disconnected worksheets.

We know that building reports - even in amazing tools like Tableau - can take a lot of time. At Graphed, we've focused on automating that entire process. If you want to connect your data sources (like Google Analytics, Salesforce, or Shopify) and generate dashboards simply by describing what you need in plain English, that’s exactly why we built Graphed. It's like having an AI data analyst who can build what you need in seconds, not hours.