How to Get Data from Tableau Prep to Desktop

You’ve finished cleaning, pivoting, and joining your data in Tableau Prep, and it’s finally ready for action. The only thing left is to get it into Tableau Desktop so you can start building those beautiful visualizations. This guide will walk you through exactly how to move your data from Prep to Desktop, covering the best output methods and the step-by-step process.

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 Use Two Separate Tools in the First Place?

First, let's quickly touch on why Tableau separates these processes. Think of it like a professional kitchen. Tableau Prep is the prep station where you wash, chop, and combine your ingredients (your data). Tableau Desktop is the plating station where you arrange those prepared ingredients into a masterful dish (your dashboard). Keeping these tasks separate has a few major benefits:

• Performance: Visualizing messy, raw data in Tableau Desktop can be slow. By cleaning the data first in Prep, you send a lean, optimized dataset to Desktop, resulting in faster dashboards.
• Reusability: You can create a cleaning workflow (a "Flow" in Tableau terms) once in Prep and reuse it over and over again. If your source data updates, you just re-run the Flow instead of repeating all the cleaning steps manually.
• Clarity: It keeps your project organized. One tool is dedicated to cleaning logic, the other to visualization logic. This makes it much easier to troubleshoot issues down the line.

The Big Idea: Creating an Output File

Here’s the single most important concept to understand: You don’t directly “send” your data from Tableau Prep to a live session in Tableau Desktop. Instead, you use Tableau Prep to create a clean, final output file. Then, you open Tableau Desktop and connect to that new file as your data source.

The "Output" step in your Prep Flow is the bridge between the two applications. You tell Prep where to save the clean data and in what format, and then you tell Desktop where to find 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

Which Output Format Should You Choose?

Tableau Prep offers several output options, but for connecting to Tableau Desktop, two formats are the most practical and widely used.

1. Tableau Extract (.hyper)

This is, by far, the best and most recommended option for a Tableau-to-Tableau workflow. A .hyper file is a highly compressed and optimized data file designed specifically for fast analysis in Tableau. It’s the Power Bar of data formats in the Tableau ecosystem.

• Best For: Nearly every situation. Large datasets, performance-critical dashboards, and offline analysis.
• Why it’s great: It's incredibly fast because the data is stored in a columnar format that Tableau’s engine is built to read. You get snappy filter responses and load times.

2. Comma-Separated Values (.csv)

A .csv is a universal, plain-text format. Almost every data tool on the planet can read a CSV file, including Excel and Google Sheets.

• Best For: Situations where you need the cleaned data for something other than Tableau, or for very small, simple datasets.
• The Trade-off: It’s not as optimized for performance as a .hyper file. For dashboards with millions of rows, using a CSV file will be noticeably slower than using an extract. Escaping the weekly routine of downloading CSVs and piecing them together is a major reason tools like Prep exist.

What About Publishing to a Server?

You may also see options to publish the output directly to Tableau Server or Tableau Cloud. This is a more advanced option for teams that want to create a centralized, managed data source that everyone can connect to. It’s fantastic for collaboration and automated refreshes, but for getting started, creating a local .hyper file is the most direct method.

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: Creating a .hyper Output in Tableau Prep

Let's walk through the exact clicks to generate your super-fast .hyper file from your finished Flow.

Step 1: Complete Your Cleaning Flow

Make sure you’ve performed all your cleaning, joins, pivots, and calculations. The last step in your Flow should be a "Clean" step that represents the final state of your data.

Step 2: Add an "Output" Step

Select the final "Clean" step in your Flow. Click the small plus (+) icon next to it and choose Output from the dropdown menu.

Step 3: Configure the Output Settings

A new "Output" panel will appear on the left side of your screen. Here you'll configure three main things:

1. Save output to: Leave this set to File for a local output.
2. Name: Click Browse... to choose a location on your computer and give your file a memorable name (e.g., "Cleaned_Sales_Data_Q1-2024.hyper").
3. Output type: This is the key setting. Click the dropdown and select Tableau Data Extract (.hyper).

Step 4: Choose the Write Option

You’ll see a choice between "Create table" and "Append to table."

• Create table: This will overwrite the file completely every time you run the Flow. This is what you want most of the time.
• Append to table: This will add the new data to the end of the existing file. This is useful for incremental updates where you're adding new rows each day without reprocessing old ones.

For your first time, stick with Create table.

Step 5: Run the Flow

Once your output is configured, you'll see a big blue "Run Flow" button at the top of the screen (it looks like a play button). Click it!

Tableau Prep will now execute all the steps in your Flow and generate the clean .hyper file in the location you specified. A success notification will pop up when it's done.

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

Connecting Your .hyper File in Tableau Desktop

With your sparkling clean .hyper file saved and ready, it’s time to switch over to Tableau Desktop and put it to work.

Step 1: Open Tableau Desktop

Launch Tableau Desktop. You will land on the connect screen, which shows you all the different types of data sources you can connect to.

Step 2: Connect to a File

In the "Connect" pane on the left, under the heading "To a File," look for the option that says Tableau Extract. Even though the file extension is .hyper, the connection option is still listed as "Tableau Extract" in some versions. You can also click the "More..." option just below it.

Step 3: Locate and Open Your File

A file browser window will open. Navigate to the folder where you saved your .hyper file. Select it and click Open.

Step 4: Go to Your Worksheet and Start Building!

That's it! Tableau Desktop will immediately connect to your .hyper file. You’ll be taken to the "Data Source" screen, where you can see a preview of your clean data. Click on "Sheet 1" at the bottom, and you can start dragging and dropping fields to build your charts and dashboards, confident that your data is clean, prepped, and ready for analysis.

Final Thoughts

Knowing how to bridge the gap between Tableau Prep and Tableau Desktop is fundamental to an efficient analytics workflow. By using Prep to handle the data wrangling and generating a speedy .hyper file, you free up Tableau Desktop to do what it does best: create insightful and responsive visualizations without getting bogged down by messy data.

Mastering powerful BI tools like Tableau is an incredibly valuable skill. However, the learning curve and time spent on manual setup can still present challenges, especially for busy teams. We created Graphed because we believe getting insights shouldn’t drain your day. It’s much simpler — you just connect your data platforms, like Google Analytics or your CRM, and use plain English to ask for the dashboards and reports you need, getting live, up-to-date visuals in seconds, not hours.