How to Copy a Tableau Workbook

Duplicating a Tableau workbook seems simple, but knowing the right way to do it can save you from broken data connections and lost work. Whether you're creating a template for future reports, versioning your analysis, or simply making a backup, this guide covers the most effective methods. We’ll look at how to copy workbooks locally using Tableau Desktop and directly within Tableau Server or Cloud.

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 Copy a Tableau Workbook?

Before jumping into the "how," it helps to understand the "why." You’ll typically find yourself needing to copy a workbook for one of these reasons:

• Creating a Template: If you've spent hours formatting a dashboard with your company's branding, custom color palettes, and standard calculations, copying it allows you to reuse that work as a template for new projects. Just connect a new data source and you're halfway done.
• Versioning and Archiving: You might want to create a static copy of a report at a specific point in time, like an "End of Q1 Sales Report." Copying the original allows you to preserve that snapshot before updating it with Q2 data.
• Experimenting Safely: Want to try a complex new chart type or completely restructure a dashboard? Duplicating the workbook gives you a safe sandbox to make changes without risking the integrity of your original, production-ready report.
• Backing Up: The simplest reason of all. Creating a copy before making significant changes is a smart and easy way to protect your work.

First, Understand Tableau's File Types

The correct copy method often depends on the type of Tableau file you're working with. There are two primary types, and the difference is all about the data.

• Tableau Workbook (.twb): This is an XML file that contains all your hard work: the layout of your worksheets, dashboards, stories, formatting, calculated fields, and field hierarchies. What it doesn't contain is the actual data. Instead, it holds the connection information that tells Tableau where to find the data, whether it's on a local network drive or a cloud server.
• Tableau Packaged Workbook (.twbx): Think of this as a zip file. It includes everything the .twb file has, plus a copy of the data. This could be a Tableau data extract (.hyper) file or a local copy of a flat file like an Excel or CSV document. Because it's a self-contained package, it's the perfect format for sharing with colleagues who don't have access to the original data source.

Understanding this distinction is fundamental. Copying a .twb file is very different from copying a .twbx file because of how each one handles its data connection.

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: The Simple File Explorer Copy (for .twbx files)

The quickest way to duplicate a self-contained workbook is directly in your computer's file system.

This method is best for: Creating an identical clone of a Packaged Workbook (.twbx) that you want to store, share, or use as a starting point for a new project.

Step-by-Step Instructions

1. Find the .twbx file you want to copy in Windows Explorer or macOS Finder.
2. Right-click on the file and select "Copy."
3. Navigate to the folder where you want to place the duplicate (this can be the same folder or a different one).
4. Right-click in an empty space within the folder and select "Paste."
5. Your operating system will likely name the new file something like "My Workbook - Copy.twbx." It’s a best practice to immediately rename the file to something more descriptive, such as "Sales Dashboard Q2 2024.twbx," to avoid confusion.

That's it. Since all the data is packaged within the .twbx file, the new workbook is completely independent and ready to go. You can open it and make changes without affecting the original in any way.

Method 2: Using "Save As" in Tableau Desktop

The most reliable and flexible method for copying any workbook is the "Save As" function within Tableau Desktop itself. This gives you full control over the file name, location, and type.

This method is best for: A universally safe way to create a copy, especially if you need to switch between file types (e.g., saving a .twb file as a .twbx to bundle the data).

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

1. Open the workbook (either .twb or .twbx) you want to copy in Tableau Desktop.
2. Go to the top menu and click File > Save As....
3. A dialog box will appear. First, navigate to the folder where you’d like to store your new copy.
4. In the "File name" field, type a new name for your workbook. This is the most important step! Giving it a unique name prevents you from accidentally overwriting your original file.
5. Look for the "Save as type" dropdown menu. Here you can choose what kind of file to create:
6. Click "Save." You have now created a perfect duplicate and are actively working in the new file, leaving your original untouched.

Method 3: Copying a Workbook on Tableau Server or Cloud

If your workbooks are published to an enterprise environment like Tableau Server or Tableau Cloud (formerly Tableau Online), you can duplicate them without ever downloading anything to your desktop.

This method is best for: Collaborators who need to create test versions of production dashboards, adapt an existing report for a new project, or share a modified view with another team, all within the shared server environment.

Step-by-Step Instructions

1. Log in to your Tableau Server or Tableau Cloud site.
2. Navigate to the folder (or "Project") containing the workbook you wish to copy.
3. Hover over the workbook and click the three-dot ("...") menu that appears.
4. From the actions menu, select "Save As..." (some older versions may label this "Copy").
5. A dialog will pop up, asking you to configure the new copy:
6. Click "Save." Tableau will create a copy of the workbook on the server. The new version will retain the same data connections, including any embedded credentials or live connection details, that the original had.

Common Pitfalls & Best Practices

Copying workbooks is usually straightforward, but a few common issues can trip you up. Here’s what to look out for:

• Problem: Broken Data Connections with .twb Files. If you simply copy and paste a .twb file in your file explorer, remember that the new copy still points to the exact same file path for the data source. If you move either the workbook or the data source file (like an Excel file), the connection will break. Solution: Use the “Save As” method to create copies or, even better, save your file as a .twbx to package the data and avoid the issue entirely.
• Problem: Accidental Overwrites. It’s easy to open an original report, intend to make a copy, get distracted making changes, and then instinctively hit Ctrl+S (or Cmd+S), overwriting the original. Solution: Get into the habit of using "Save As" to create your new version before you make any changes. A clear naming convention (e.g., Report_v1, Report_v2, Report_Archive_2024-03-31) can also prevent this.
• Problem: Server Permissions Don't Match. When you copy a workbook on Tableau Server/Cloud to a new Project, it will likely inherit the default permissions of that new Project, not the specific permissions you set on the original. Solution: After copying a workbook on the server, always double-check its permissions to make sure the right people (and only the right people) can access it.

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

Mastering these simple copy methods - whether it's a file drag-and-drop for packaged workbooks, using "Save As" in Tableau Desktop for maximum control, or duplicating directly on a server - will make your data visualization workflow much smoother. By understanding the key differences between .twb and .twbx files, you can easily avoid broken data links and keep your projects organized.

Juggling versions of files manually or through complex server setups can be time-consuming. While powerful, traditional BI tools often add friction to the simple act of getting insights. At Graphed, we streamline this process entirely. You can connect your marketing and sales data sources in seconds and use simple, natural language to create and share dynamic, real-time dashboards automatically. Instead of saving and managing files, your insights are always live and you can ask questions to get answers instantly, giving you back time to focus on strategy, not file management.