How to Update Tableau Public

You’ve built and published a fantastic visualization to your Tableau Public profile, showcasing your skills and insights. But what happens a week or a month later when the underlying data changes, or you spot a typo you need to fix? Keeping your public-facing work current is essential, and this guide will walk you through exactly how to update your Tableau Public workbooks, from minor tweaks to complete data refreshes.

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

First, Understand How Tableau Public Handles Data

Before jumping into the steps, it’s important to understand a core concept of Tableau Public. When you publish a workbook, Tableau takes a snapshot of your data at that exact moment and packages it into the file. This is called a data extract. Your visualization on the Tableau Public website is not live-linked to the original Excel file, CSV, or database on your computer.

This means if you add a hundred new rows of data to your source spreadsheet, your public viz won't automatically update itself. You have to actively push those changes from the Tableau Desktop application to your Tableau Public profile. The only major exception is for data connected from Google Sheets, which has a special auto-refresh option we'll cover later.

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

Method 1: Making Simple Edits Directly on the Web

Sometimes you don't need to update your data, you just need to fix a small mistake. Maybe you misspelled a word in a title, want to adjust a color scheme, or need to rephrase a tooltip. For these minor cosmetic changes, you don't need to go back to the desktop application.

This is the quickest way to make small adjustments, and here's how to do it:

• Log In: Go to the Tableau Public website and sign in to your account.
• Navigate to Your Viz: Go to your profile and click on the visualization you want to edit.
• Find the "Edit" Button: In the top right corner of the visualization view, you'll see a small "Edit" button. Click it.
• Make Your Changes: This will open Tableau's web authoring interface, which looks very similar to the desktop app. You can now click on titles, legends, tooltips, and other elements to make your edits.
• Save Your Work: Once you're finished, click the "Save" or "Publish" button (the name may vary) in the top right corner. This overwrites the existing viz with your changes instantly.

Use this method for simple text and formatting changes that don’t involve the underlying data structure.

Method 2: Re-publishing from Tableau Desktop (For Data Updates)

This is the standard and most common workflow for updating a workbook, especially when you have new or updated data. This process involves refreshing your data in the desktop application first, and then overwriting the existing workbook on your Tableau Public profile.

Let's use a relatable example: Imagine you have a workbook that visualizes your monthly sales from a local Excel file. It’s now a new month, and you've added the latest sales data to that Excel file.

Step 1: Update Your Original Data Source

This step happens outside of Tableau entirely. Open the source of your data - the Excel file, the CSV, the text file - and add your new information. In our example, you would open your monthly_sales.xlsx file and add the rows for the most recent month.

This is a fundamental step. If the source data isn't updated, Tableau won't have anything new to pull in.

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

Step 2: Refresh the Data in Tableau Desktop

Now it's time to open Tableau. Find the .twbx workbook file saved on your computer and open it with Tableau Desktop (Public Edition).

• Once your workbook is open, go to one of your worksheets.
• In the "Data" pane on the left, find your data source listed at the top.
• Right-click on the name of your data source.
• From the context menu, select Refresh.

Tableau will now connect back to your original source file (the Excel sheet in our example) and pull in all the new data you added. You should see your charts, tables, and KPIs update instantly with the latest information.

Step 3: Save and Re-publish to Overwrite the Old Viz

With your data refreshed, the final step is to push these changes to your public profile. This is where people often make a small but critical mistake.

• In Tableau Desktop, navigate to the menu bar at the top and click Server.
• From the dropdown, select Tableau Public &gt, Save to Tableau Public As...
• A dialog box will appear asking you to give your workbook a name. Here is the most important part: use the exact same name as the workbook you want to update on your profile.
• After you enter the name and click Save, Tableau will recognize that a workbook with this name already exists on your profile. It will show a warning message that says: "A workbook named '[Your Workbook Name]' already exists. Do you want to replace it?"
• Click Yes.

That's it! Tableau will republish your workbook, overwriting the old version with the new one containing the updated data. Your viz URL remains the same, and anyone who has an existing link to it will now see the latest version.

Common mistake alert: If you give the workbook a new or slightly different name in Step 3, you will end up with a duplicate visualization on your profile instead of updating the existing one.

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

Pro Tip: The Magic of Auto-Refreshing Google Sheets Data

Many users host their data in Google Sheets instead of local files. This offers a powerful advantage on Tableau Public: automatic daily refreshes.

When you connect Tableau Public to a Google Sheet, you can authorize it to check for new data once every 24 hours. This is perfect for dashboards that need to stay relatively current without you lifting a finger.

Here’s how to set it up:

• In Tableau Desktop, connect to your data source by selecting Google Sheets.
• Build your visualization as you normally would.
• When you are ready to publish, go to Server > Tableau Public > Save to Tableau Public...
• In the publish dialog box, you'll see a checkbox at the bottom labeled: "Keep my data in sync with Google Sheets."
• Make sure this box is checked. You may be prompted to embed your Google credentials so Tableau Public’s servers can access the sheet on your behalf.

Once you publish, Tableau will automatically refresh the data from that Google Sheet once a day. Now, you can simply update your Google Sheet, and the changes will appear on your public viz the next time the scheduled refresh happens.

If you need an immediate update, you can still use Method 2: open the workbook in Tableau Desktop, refresh the Google Sheets connection manually, and re-publish to overwrite it.

Final Thoughts

Keeping your Tableau Public profile fresh is straightforward once you understand the core workflow. For minor text or color edits, use the online editor. For any data changes, remember the "update source, refresh in desktop, re-publish to overwrite" mantra. And if you're using Google Sheets, take full advantage of the auto-refresh feature to save yourself time.

This process of manually refreshing reports is common with many analytics tools and is often a major time-drain for marketing and sales teams. At Graphed, we built our whole platform to do away with that manual work. Instead of syncing files and republishing, our tool connects directly to your data sources - like Google Analytics, Salesforce, and Shopify - so your dashboards are always live and update in real-time. We believe anyone on your team should be able to get business insights without needing a steep learning curve, so you just describe the dashboard you want in simple terms, and our AI builds it for you in seconds.