How to Recover a Tableau Workbook

Nothing sinks your heart faster than when Tableau crashes or a file goes missing after hours of work. That pristine workbook you’ve spent all morning perfecting seems to have vanished. Before you panic, take a deep breath. There are several ways to recover your unsaved, deleted, or corrupted Tableau workbook. This guide will walk you through the most effective methods to get your work back, from the simplest checks to more advanced recovery techniques.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Start with the Basics: Your First Response

Often, the simplest solution works. Before digging into Tableau's more complex recovery features, run through these quick checks. You'd be surprised how often a file isn't truly lost, but just misplaced.

1. Check the Obvious Places: Recycle Bin & Folders

It sounds almost too simple, but it happens to everyone. The first place you should always look is your computer's Recycle Bin (on Windows) or Trash (on Mac).

• Open your Recycle Bin or Trash folder.
• Sort by "Date Deleted" to see the most recently removed files first.
• If you find your workbook, simply right-click it and choose "Restore."

If it’s not there, the file may have been moved accidentally. Use your computer’s search function (Windows Key + S or Command + Spacebar) to search for your workbook file by name. Be sure to expand your search to include external drives or cloud sync folders like Dropbox, Google Drive, or OneDrive if you use them.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

2. Look in Tableau's Recent Workbooks

If you've saved the workbook at least once before, Tableau likely remembers it. Open Tableau Desktop, and on the start screen, look at the list of recent workbooks. Even if you can't find the file on your computer, Tableau might have a direct link to its last known location.

If clicking the link gives you an error saying the file cannot be found, hover over the thumbnail. Tableau will display the full file path where it last saw the workbook. This information can give you a clue as to where the file might have been saved or moved.

How to Recover Unsaved Workbooks with Autosave

Tableau Desktop includes an automatic save feature, designed for crashes and unexpected shutdowns. By default, Tableau saves a recovery version of your open workbooks every few minutes. If Tableau closes unexpectedly, it should prompt you to open the recovered version next time you launch the application. However, if that prompt doesn't appear, you can find these files manually.

Recovered workbooks are saved with a .twbr extension and will have names like "Book1-[AutoViz].twbr" or "MyGreatDashboard-[Recovery].twbr".

Finding the Tableau Autosave Folder

The location of the autosaved files is within your "My Tableau Repository" folder. Here’s how to get there:

For Windows users:

Navigate to the following directory in your File Explorer. Replace <your_username> with your actual Windows username.

C:\Users\<your_username>\Documents\My Tableau Repository\Workbooks

For Mac users:

Open Finder, click Go in the menu bar, select "Go to Folder...", and enter the following path:

~/Documents/My Tableau Repository/Workbooks

Once inside the Workbooks folder, look for any files ending in .twbr. Double-click to open one in Tableau. If it contains your lost work, immediately save it as a regular Tableau Workbook (.twb or .twbx) under a new name to secure your progress.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

How to Fix a Corrupted Tableau Workbook

Sometimes the file is still there, but it won’t open, giving you a cryptic error message. Workbooks can become corrupted due to a software freeze, a bad save, or a system glitch. The good news is that because of how Tableau files are structured, you can often "do surgery" on the workbook to retrieve your dashboards.

First, it's important to understand the two main types of Tableau files:

• .twb (Tableau Workbook): This is an XML file that contains all your worksheets, dashboards, formatting, calculations, and connections. It does not contain the actual data.
• .twbx (Packaged Tableau Workbook): This is a ZIP archive. It "packages" the .twb file along with any local data sources (like Excel or CSV files), images, and custom shapes into a single file.

This difference is key to your recovery strategy.

Method 1: Unpack Your Packaged Workbook (.twbx)

If you have a corrupted packaged workbook (.twbx), your best bet is to manually extract its contents. Since it's just a zip file with a different extension, you can treat it as one.

1. Create a copy: Always work on a copy of your corrupted file to avoid making things worse. Right-click the .twbx file, copy it, and paste it somewhere safe.
2. Change the extension: Right-click your copied file and rename it, changing the extension from .twbx to .zip. For example, "Monthly-Sales.twbx" becomes "Monthly-Sales.zip". Your operating system will probably warn you about changing the file extension, go ahead and confirm the change.
3. Unzip the file: Right-click the newly renamed .zip file and select "Extract All..." or "Unzip." This will create a folder containing the components of your workbook.
4. Locate the .twb file: Inside the new folder, you'll find the Tableau Workbook (.twb) file and a "Data" folder that contains your local data sources.

Try opening the .twb file directly in Tableau. In many cases, the corruption was in the packaging process or with one of the data files, while the underlying workbook structure (your dashboards and worksheets) remains intact. If it opens, you can then re-package it by saving it as a .twbx file.

Method 2: Inspect the Workbook's XML (.twb)

This is a last-resort, advanced method, but it can be a lifesaver. Since a .twb file is just XML, you can open it in a text editor to see if there's any obvious corruption.

1. Make a copy of the .twb file you want to inspect.
2. Right-click the copy and choose "Open With." Select a plain text editor like Notepad++, Sublime Text, or VS Code (Notepad on Windows works, but can struggle with larger files).
3. Look for anything that seems obviously wrong. Corruption from failed saves often occurs at the very end of the file. Scroll to the bottom and see if there are jumbled characters or an incomplete XML tag.
4. If you're familiar with XML, you can try to identify and delete the broken section or malformed tag. Save a version with your changes and then try to open it in Tableau. Proceed with caution here - a wrong edit can make things worse, which is why you work on a copy.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Using Tableau Server or Tableau Cloud Revision History

If you published your workbook to Tableau Server or Tableau Cloud, you are in luck. Both platforms maintain a version history of your content, allowing you to roll back to a previously saved version. This is by far the most reliable way to recover from an error or corruption if the workbook has been published.

Here’s how to do it:

1. Log in to your Tableau Server or Tableau Cloud account.
2. Navigate to the workbook you want to restore.
3. Click the three dots ("...") next to the workbook's name to open the "Actions" menu.
4. Select Revision History.
5. You’ll see a list of all previously published versions with timestamps and publishing user information.
6. Find a stable version from before the issue occurred. You can click on a version to preview it.
7. Once you've identified the version you want, you can either click the "Actions" (...) menu next to that version and choose Restore to make it the current version on the server, or choose Download to save a local .twbx copy to your machine.

Best Practices to Avoid Losing Your Work Again

Recovering files is stressful. The best strategy is to adopt habits that prevent data loss in the first place.

• Save often and create iterations. Use CTRL+S or CMD+S obsessively. For big projects, save iterative copies like Dashboard_v1.twbx, Dashboard_v2.twbx so you can easily roll back if an entire design direction doesn't work out.
• Publish regularly. If you use Tableau Server or Cloud, publish your work at the end of each significant work session. This creates a secure, versioned backup outside of your local machine.
• Back up your repository. Periodically make a copy of your entire My Tableau Repository folder and store it on an external drive or cloud service. This folder contains your saved data sources, custom shapes, logs, and workbooks.
• Keep Tableau updated. Ensure you're running the latest stable version of Tableau Desktop. Updates often include bug fixes that reduce the risk of crashes and corruption.

Final Thoughts

Losing progress on a workbook is a major headache, but usually not a complete disaster. By working through these steps - from checking your recycle bin and autorecover folder to unpacking corrupted files or using Tableau Server’s revision history - you have a great chance of getting your valuable work back. Be methodical, work on copies, and you can turn a moment of panic into a successful recovery.

While mastering complex tools like Tableau is a powerful skill, the process comes with friction like managing files, worrying about version control, and recovering lost work. Often, the goal isn't to build a perfect workbook file, but to get quick answers from your data. At Graphed we remove the busywork by letting you create reports and dashboards just by describing what you want to see. Since we connect directly to your data sources for real-time updates, you never have to hit "save" or worry about losing a file - your dashboards are always live and secure, ready for your entire team to act on.