Analistable

How to merge Tableau workbooks

By the Analistable team · Updated · 5 min read

In Tableau Desktop, open the workbook you want to keep and use File → Import Workbook to bring in the sheets, dashboards and data sources from another. Alternatively, copy sheets in one workbook (right-click the tab → Copy) and paste them into the other. Afterwards, reconcile duplicate data sources with Replace Data Source so every sheet uses one connection, and check calculated fields and filters.

Part of our guide: How to merge data in Power BI, Power Query and Tableau

Two ways to bring sheets across

Import Workbook vs copy and paste
File → Import WorkbookCopy / paste sheets
BringsAll sheets, dashboards, stories and data sourcesThe sheets you select, plus the data sources they use
Best forMerging most of a workbookPicking a few views
Name clashesRenamed on import (for example “Sales (2)”)Renamed on paste

Both are Tableau Desktop features; Tableau's web authoring has more limited options, so do the merge in Desktop. Exact menu wording can vary slightly between versions.

Using Import Workbook

  1. Save copies of both workbooks first. Merging is easy to get wrong and hard to undo.
  2. Open the workbook you want to keep (the target).
  3. Choose File → Import Workbook and select the other .twb or .twbx.
  4. Tableau adds the imported sheets and dashboards as new tabs. Items whose names already exist are renamed.
  5. Open each imported sheet to confirm it renders.

To copy only some views, right-click a sheet or dashboard tab in the source workbook, choose Copy, then right-click a tab in the target and choose Paste. Copying a dashboard brings its sheets with it.

Reconcile duplicate data sources

If both workbooks connected to the same data, you now have two copies in the Data pane, for example “Orders” and “Orders (2)”. Sheets are split between them, so filters and actions won't work across all sheets, and calculated fields exist twice. Point everything at one source:

  1. Open a sheet that uses the duplicate source.
  2. Choose Data → Replace Data Source, set Current to the duplicate and Replacement to the original, and click OK. Every sheet using the duplicate in the workbook moves over.
  3. Check fields that show a red exclamation mark: their name differs in the replacement source. Right-click and choose Replace References to map them.
  4. Once no sheet uses the duplicate, close it (right-click → Close).

Calculated fields, groups and sets defined on the duplicate source are copied to the replacement when you replace the source, which can create near-duplicate fields such as “Profit Ratio” and “Profit Ratio (copy)”. Review and delete what you no longer need.

When the two workbooks use different data

If the sources are genuinely different, such as orders from a database and targets from a spreadsheet, they can stay separate data sources in the merged workbook. To show them in one view you need to relate them. Relationships, joins and blends are explained in joining data sources in Tableau.

Worked example: merging a sales workbook and a targets workbook
ItemSales.twbxTargets.twbxMerged
Worksheets639
Dashboards213
Data sources122
Calculated fields8310

The Targets workbook also contained its own copy of the Orders extract. After Replace Data Source it was closed, leaving two sources, and one duplicated calculation (Margin %) was removed, giving 10 calculated fields rather than 11.

Clean up after the merge

  • Check dashboard filter actions and highlight actions: they reference sheets and fields by name and may still point at the old source.
  • Re-check global filters (applied to all using this data source), as they now apply to more sheets.
  • Recreate any workbook-level formatting, such as default fonts, that differed between the files.
  • If you publish to Tableau Server or Cloud, decide whether the merged workbook should use a published data source so other workbooks share it.
  • Compare a few headline numbers against the original workbooks before sharing.

If you're merging workbooks only to compare their underlying spreadsheets, Analistable may be quicker: load the source files and ask questions across them in your browser. It doesn't open or edit Tableau files. For merging the data itself, see the Power BI, Power Query and Tableau guide and combining fields in Tableau.

Combining the data instead of the workbooks

Sometimes two workbooks exist only because each analyst connected to a different extract of the same data, such as one per year. Merging the workbooks then leaves two sources that should really be one table. In that case it is cleaner to combine the data first: use a union in the data source (drag the second table or file onto the first in the Data Source page and choose union), or prepare a single combined file in Tableau Prep, then point all sheets at it with Replace Data Source.

Two yearly extracts unioned into one source
SourceRowsSum of Sales
Orders 202541200£2.48m
Orders 202618350£1.12m
Union59550£3.60m

After a union, Tableau adds a Table Name field showing which file each row came from, which is handy for checking the counts above. Calculations that filtered on year to separate the two sources can then be simplified.

  • Field names must match for a union to stack them into one column; mismatched names appear as separate columns that you can merge from the Data Source page.
  • Data types should match too, or values may appear as null.

Finally, decide which workbook is the master from now on and archive the other, with a note in its description pointing to the merged file. Two live copies of the same dashboards drift apart quickly, and users end up comparing numbers that were calculated in slightly different ways. If the workbooks are published, update any subscriptions, favourites and embedded links to the merged version and retire the old one once nobody uses it.

Frequently asked questions

Can I merge two Tableau workbooks?
Yes, in Tableau Desktop. Use File → Import Workbook to bring in everything, or copy and paste individual sheets and dashboards.
Why do I have duplicate data sources after merging?
Each workbook brought its own connection. Use Data → Replace Data Source to move sheets onto one source, then close the duplicate.
Do dashboard actions survive the merge?
Usually, but actions that refer to a replaced data source or renamed sheet may need editing. Test every action after merging.

Related guides