How to Copy Dashboard from One Workbook to Another in Tableau

Moving a perfectly crafted dashboard from one Tableau workbook to another seems like it should be simple, but it can quickly become a frustrating process. Whether you're trying to reuse a great design, merge reports, or share work with a colleague, a simple copy-paste doesn't always work as expected. This guide will walk you through the reliable ways to move dashboards between workbooks and handle the common data source issues that pop up along the 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

Why Would You Need to Copy a Tableau Dashboard?

Before jumping into the "how," it's helpful to understand the common scenarios where you might need to do this. You're not alone if you've found yourself wanting to:

• Reuse a template: Your company might have a standard dashboard template with specific branding, layouts, and logos. Copying this template is faster than starting from scratch for every new project.
• Combine analyses: You might have two separate workbooks, one analyzing marketing data and another analyzing sales data, and you want to bring a key dashboard from each into a single, comprehensive workbook.
• Share a specific view: A colleague might need just one of your dashboards from a large, complex workbook. Copying it into a new, clean workbook is an easy way to share it without the extra clutter.
• Migrate to a new data source: You might need to rebuild an existing dashboard on top of a new, updated data source, and copying the structure over is the first step.

Whatever your reason, the goal is the same: to move the dashboard and all its components without breaking anything.

Method 1: The Direct Right-Click and Copy

This is the most straightforward method and the first one everyone tries. When it works, it's wonderfully efficient. It's best used when the source and destination workbooks use the exact same data source.

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-by-Step Instructions

1. Open both the source workbook (where the dashboard lives now) and the destination workbook (where you want to move it) in the same instance of Tableau Desktop. If you open two separate Tableau applications, copy and paste will not work.
2. In the source workbook, navigate to the tab for the dashboard you want to copy.
3. Right-click on the dashboard's tab and select Copy.
4. Switch over to your destination workbook.
5. Right-click anywhere in the sheet tab area at the bottom and select Paste.

Tableau will now copy the dashboard, all the underlying worksheets that power its visuals, and the corresponding data source into your destination workbook. You should see the dashboard tab and several new worksheet tabs appear.

Why This Method Can Fail

This simple copy-paste often runs into trouble due to a few common culprits:

• Data Source Mismatches: If the destination workbook already has a data source that is different from - or even just named differently than - the one in the source workbook, Tableau will bring in a second, duplicated data source. This can create confusion and requires clean-up.
• Version Incompatibility: You cannot copy a dashboard from a newer version of Tableau into a workbook created with an older version.
• Missing Dependencies: A dashboard is more than what you see. It relies on specific worksheets, calculated fields, parameters, and sets. If any of these are structured in a complex way, a direct copy might miss something and result in a broken view.

If you run into issues, or if you know you'll be dealing with different data sources, the next method is far more reliable.

Method 2: Export and Import (The Bulletproof Approach)

This method involves an intermediate step, but it’s the most robust way to ensure everything moves over correctly, especially for complex dashboards or when you need to switch data sources. You're essentially isolating the dashboard and its parts before moving them.

Step-by-Step Instructions

1. Open your source workbook (the one containing the dashboard you want to move).
2. On the main dashboard view, look at the Layout pane on the left side. Here, Tableau conveniently lists all the worksheets being used to build the dashboard. Take note of them.
3. Now, look at the tabs at the bottom of your screen. Hold down the Ctrl key (or Cmd on Mac) and click to select the dashboard tab plus all the worksheet tabs you noted in the previous step. You can identify them by the small grid icon.
4. Once they're all selected, right-click on any one of the highlighted tabs and choose Export....
5. Save this selection as a new Tableau Packaged Workbook (.twbx). A .twbx is usually safer because it bundles any necessary data with it. Name it something logical, like "Dashboard For Export."
6. Now, open your main destination workbook and this new TWBX file you just created. Make sure they are both open in the same instance of Tableau Desktop.
7. In the newly created "Dashboard For Export" workbook, right-click the dashboard tab, and select Copy.
8. Switch to your main destination workbook, right-click in the sheet tab area, and select Paste.

By exporting the dashboard and its specific worksheets first, you create a perfect, self-contained copy. When you paste this into your final workbook, you minimize the chances of version conflicts or missing components. However, you'll still need to deal with the data source.

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

Cleaning Up Data Sources After Copying

Once you've pasted your dashboard, it's very likely you now have at least two data sources in your destination workbook: the original one (if any) and the one that came along with the dashboard you just pasted. The next critical step is to merge them, telling Tableau to use your primary data source for the newly imported sheets.

How to Replace a Data Source

1. In your destination workbook, go to the menu bar at the top and click Data > Replace Data Source...
2. A dialog box will appear. In the "Current" field, select the old data source that your copied dashboard is using. In the "Replacement" field, select the main data source you want it to use instead.
3. Click OK.

Tableau will now attempt to remap all the fields from the old source to the new one. If the field names are identical between both sources, this process is usually seamless.

Fixing Broken Fields

If field names are different (e.g., cust_id vs. Customer ID), your worksheets will show errors. Don't panic! You can fix this manually.

In the "Data" pane on the left, you will see fields with a red exclamation point next to them. This indicates a field that Tableau couldn't map automatically. Right-click on the broken field and select Replace References... then choose the correct corresponding field from your new data source.

Once everything looks right and you've confirmed your dashboard works, you can clean up the workbook by right-clicking the old data source in the list and selecting Close.

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

Final Thoughts

Copying dashboards in Tableau effectively comes down to managing dependencies. While you can often get away with a direct copy-and-paste, the most reliable method is to first export the dashboard and its required worksheets into a separate workbook, then copy that into your final destination. Always remember to complete the process by replacing and cleaning up your data sources to keep your final workbook tidy and efficient.

Manually moving reports and consolidating data sources is a major time-sink for any team. At Graphed, we built our platform to eliminate this exact kind of friction. Instead of wrestling with workbooks, you can connect tools like Google Analytics, HubSpot, or Shopify in a few clicks, then create live dashboards using simple, natural language. It allows us to automate the tedious parts of reporting so you can focus on getting answers, not getting your data in the right place.