Graphed LogoGraphed
Graphed LogoGraphed
How It WorksAgentsIntegrationsPricing

How to Duplicate a Tableau Workbook

Cody Schneider••9 min read

Duplicating a Tableau workbook seems simple, but knowing why and how to do it effectively can save you from a world of headaches. Whether you want to experiment with a new design, create a team template, or simply back up your work before a major update, this guide will walk you through the different methods available in Tableau. We'll cover everything from a basic "Save As" to creating official templates and managing copies on Tableau Server.

GraphedGraphed

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.

Watch Graphed demo video

Why Duplicate a Tableau Workbook?

Before jumping into the "how," it's helpful to understand the common scenarios where duplicating a workbook is the right move. It’s not just about creating a copy, it’s a strategic step in a good analytics workflow.

  • Version Control and Archiving: This is the most common reason. Before you make significant changes - like swapping out a data source, overhauling your calculations, or completely redesigning a dashboard - it's wise to save a stable version. This gives you a safe retreat point if your new ideas don't pan out. Think of it as Sales_Dashboard_v1 and Sales_Dashboard_v2.
  • Experimentation and A/B Testing: Have a great idea for a new chart type or a different dashboard layout? Duplicate your workbook and build your new ideas in the copy. This allows you to freely experiment without any risk to your original, production-ready dashboard. You can even place them side-by-side to see which version performs better.
  • Creating Templates for Standardization: If your team produces similar reports regularly (e.g., weekly performance dashboards for different clients or departments), you can create a master workbook to serve as a template. You duplicate it for each new instance, connect the relevant data source, and maintain consistent branding, formatting, and calculations across all reports.
  • Tailoring for Different Audiences: An executive team might need a high-level overview with key KPIs, while a marketing team needs granular detail on campaign performance. Instead of building two separate workbooks from scratch, you can duplicate the core workbook and customize the copy for each audience, hiding or adding sheets as needed.

First, Understand Tableau File Types: .twb vs. .twbx

The single most important concept to grasp before duplicating is the difference between Tableau's primary file types. The wrong choice can lead to broken data connections and a lot of frustration.

Tableau Workbook (.twb)

A .twb file is an XML document that holds the instructions for a visualization. It stores all your design choices: which sheets and dashboards you've built, how your fields are formatted, the colors you used, and the layout of your dashboards. However, a .twb file does not contain the actual data. Instead, it contains the connection information that tells Tableau where to find the data, whether it's a live connection to a database or a separate Tableau data extract (.hyper file).

  • Best for: Work you’re doing on your own machine when you have constant access to the underlying data source.
  • Duplicate it when: You want to create a new version of a report that connects to the same live data source.

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.

Tableau Packaged Workbook (.twbx)

A .twbx file is a self-contained "zip" file. It packages the .twb workbook file along with all the local data it depends on. This includes any data extracts (.hyper files), Excel spreadsheets, text files, and even custom images or background maps used in the dashboard. The data is contained within the file itself.

  • Best for: Sharing your work with others who do not have access to your live data source or file path.
  • Duplicate it when: You need an entirely independent, portable copy or a snapshot of the dashboard with the data as it existed at that moment.

Knowing this difference is crucial because duplicating a .twb means the copy will still point to your original data source. Duplicating a .twbx creates a completely separate entity with its own embedded copy of the data.

Method 1: Plain and Simple "Save As"

The most common and straightforward way to duplicate a workbook is using the "Save As" function in Tableau Desktop. This is perfect for versioning or creating a starting point for a new line of analysis.

Step-by-Step Instructions:

  1. Open Your Workbook: Launch Tableau Desktop and open the workbook you wish to duplicate.
  2. Go to File Menu: In the top navigation menu, click File.
  3. Select "Save As...": From the dropdown menu, choose Save As....
  4. Choose a New Name and Location: A dialog box will appear. Navigate to the folder where you want to save the copy. Give the workbook a distinct and descriptive name. This is where a clear naming convention comes in handy, like Q3_Marketing_Performance_v2.twb or Sales_Dashboard_for_Exec_Team.twb.
  5. Select the File Type: In the "Save as type" dropdown at the bottom of the dialog box, you can choose to save the duplicate as either a Tableau Workbook (.twb) or a Tableau Packaged Workbook (.twbx).
  6. Click Save: Once you've set the name and type, click the Save button.

You now have a separate, independent workbook file. The original file remains untouched, and you can freely edit the new copy.

Method 2: Copy and Paste in Your File Explorer or Finder

This method achieves the same outcome as "Save As" but happens outside of the Tableau Desktop application. Some people prefer this workflow if they are organizing files and just want to quickly make a copy.

GraphedGraphed

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.

Watch Graphed demo video

Step-by-Step Instructions:

  1. Locate Your File: Close Tableau Desktop or at least the workbook you intend to copy to avoid any file locking issues. Navigate to the workbook file (.twb or .twbx) in your computer's file system (Windows Explorer or macOS Finder).
  2. Copy the File: Right-click on the file and select "Copy," or use the keyboard shortcut Ctrl+C (Windows) or Cmd+C (Mac).
  3. Paste the File: Navigate to the location where you want the duplicate to live (it can be the same folder) and right-click and select "Paste," or use Ctrl+V (Windows) or Cmd+V (Mac).
  4. Rename the Copy: Your operating system will likely name the file something like MyWorkbook - Copy.twb. Right-click this new file and select "Rename." Give it a clear, meaningful name according to your naming convention.

After renaming, you can open this new file in Tableau Desktop. Just remember the crucial distinction: if you copied a .twb, it’s still getting its data from the original source. If you copied a .twbx, you have a completely separate package.

Method 3: Creating a Reusable Template (.twt)

If you find yourself constantly creating reports that share the same branding, corporate logos, color palettes, and data source structures, then making a Tableau Template (.twt) is the most efficient approach.

A .twt file saves all the formatting, styles, and dashboard layouts but does not save the data connection's content — it only prompts the user to connect to a new data source that has a similar structure. When you open a .twt file, Tableau automatically creates a new, unsaved .twb file, leaving your original template intact.

How to Create a Tableau Template:

  1. Design Your Master Workbook: Open or create a Tableau workbook with all the standardized formatting you need. Set up your custom color palettes (File > Repository Location), add your company logo using Dashboard Image objects, define standard calculation formats, and build out the dashboard and worksheet layouts.
  2. Clear Data-Specific Elements (Optional): For a cleaner template, you can even remove the existing data source. Any worksheets using it will show errors, but the formatting will remain. When a new user opens the template, they will immediately be prompted to connect to their own data.
  3. Go to File > Save As: Navigate to the File menu and select Save As....
  4. Change "Save as type" to Template: In the dialog box, click the "Save as type" dropdown and select Tableau Template (.twt). Tableau will automatically shift the save location to the "My Tableau Repository" folder — it's best to keep it there.
  5. Name and Save: Give your template a logical name like Monthly_Client_Report_Template.twt and click Save.

How to Use Your New Template:

Simply navigate to your .twt file and double-click to open it. Tableau will launch a brand-new, untitled workbook that is an exact replica of your template. From there, you just need to connect your data, and the pre-defined formatting will be applied automatically, saving you tons of repetitive setup work.

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.

Bonus Method: Duplicating on Tableau Server or Tableau Cloud

The concept of duplication also exists in collaborative environments like Tableau Server and Tableau Cloud. Here, the process allows team members to build upon existing work without altering the original, published report.

Step-by-Step Instructions:

  1. Log in to Your Tableau Site: Open your web browser and navigate to your company's Tableau Server or Tableau Cloud URL.
  2. Find the Workbook: Navigate to the Project folder that contains the workbook you want to copy.
  3. Use the "Actions" Menu: Hover over the workbook thumbnail and click the three-dot "Actions" (...) menu that appears.
  4. Select "Save a Copy...": From the menu options, choose "Save a Copy...".
  5. Rename and Relocate: A dialog will pop up, prompting you for a new name for the workbook and asking which Project you'd like to save it in. This is a great way to copy an official report into your personal "sandbox" project for experimentation.
  6. Save Your Copy: After naming it, click Save. The server will create a duplicate version of the workbook that you can now edit directly in the web editing interface or download to Tableau Desktop.

This is extremely useful. It empowers team members to ask "what if?" questions with the data and visuals without fear of "breaking" the official report that executives might be viewing.

Final Thoughts

Duplicating a Tableau workbook is a fundamental skill for maintaining an organized and effective analytics workflow. Choosing the right method - whether a simple "Save As" for versioning, copying a .twbx for sharing, or creating a .twt template for standardization - depends entirely on your goal. Mastering these options will help you work faster, reduce errors, and collaborate more efficiently.

While tools like Tableau offer immense power, the initial setup, learning curve, and manual effort of managing workbooks can still become a bottleneck. At Graphed, we're focused on removing that friction. Our platform allows you to connect all your marketing and sales data sources and then use simple, natural language to build real-time dashboards instantly. Instead of spending hours learning interfaces or duplicating files, you can just ask questions like "Show me a comparison of Facebook Ads spend versus Shopify revenue by campaign" and get a live, interactive dashboard back in seconds.

Related Articles