What is a TDS File in Tableau?

If you work with Tableau, you've probably spent countless hours connecting to data, cleaning up messy field names, and creating the same calculated fields over and over again. A Tableau Data Source (.tds) file is a simple but powerful feature designed to eliminate that repetitive work for good. This article breaks down exactly what a TDS file is, why it's a game-changer for team collaboration and efficiency, and how you can create one in just a few clicks.

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

So, What Exactly is a Tableau Data Source (.tds) File?

A Tableau Data Source (.tds) file is a shortcut for your data connection. Think of it as a recipe file. It contains all the instructions on how to connect to your data and how to set it up, but it doesn't contain the actual data itself. It's a small, lightweight XML file that saves all your data preparation work.

When you open a .tds file, Tableau reads the instructions and instantly recreates the data connection as you originally configured it. Here’s a look at what’s stored inside:

• Connection Information: This includes the server name, database type, database name, and authentication details. It's the "where to find the ingredients" part of the recipe.
• Data Model Customizations: It saves the specific tables you're using along with any joins, relationships, or unions you've configured.
• Metadata Edits: This is where the real time-saving magic happens. A TDS file stores any changes you've made to the default data source, such as:

The most important thing to remember is that the TDS file does not store a copy of your data. It only stores the connection details and the metadata you've customized. This makes the file incredibly small and easy to share.

Why Should You Use TDS Files? The Biggest Benefits

Using TDS files might seem like an extra step, but it unlocks significant advantages, especially when working in a team. It’s the difference between every team member baking a cake from scratch with vague instructions versus everyone following one perfected recipe.

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

Maintain Consistency (Your Single Source of Truth)

In many organizations, different people end up with slightly different versions of the same metric. The sales team's definition of "Active Customer" might not match the marketing team's. This leads to confusion and mistrust in the data.

A TDS file solves this by creating a standardized, pre-approved data source. When a data analyst or database administrator sets up the connection, creates all the necessary calculated fields (like Customer Lifetime Value or Adjusted Gross Profit), and renames cryptic fields, they can save that configuration as a TDS file. Now, everyone on the team who uses that TDS file will be working from the exact same definitions, calculations, and field names. It ensures everyone is speaking the same data language.

Save Time and Reduce Rework

How much time have you spent connecting to an Excel sheet, performing five joins, creating ten calculated fields, and reorganizing everything just to build one dashboard? Now, imagine your teammate has to do the exact same thing next week for their dashboard. It's a huge waste of duplicated effort.

With a TDS file, you do the work once. Set up the complex connection, perform the data cleanup, build the calculations, and save it. From that point on, anyone (including your future self) can connect to that perfectly prepared data source in seconds by just opening the TDS file. All the setup work is already done, allowing analysts and stakeholders to get straight to building visualizations and finding insights.

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

Empower Non-Technical Users

Connecting to a database can be daunting. You need to know the server address, the database name, login credentials, and table relationships. It's enough to scare away a marketing manager or a sales lead who just wants to see their team's performance data.

A TDS file abstracts all that complexity away. A data expert can set up the connection once and save it with a friendly name like Marketing-Campaign-Performance.tds. A non-technical team member can then double-click that file, and Tableau will open with a ready-to-use data source. They don't need to know anything about the back-end database, they can just start dragging and dropping fields to ask questions of the data.

Enhance Security and Data Governance

Sharing server names and passwords isn't a secure practice. TDS files offer better control over data access. You can configure a data source and embed the database credentials within the file (Tableau encrypts them for security). When you share this TDS, users can access the data without ever seeing the password.

Alternatively, you can set up the TDS file to prompt the user for their own credentials. This practice ensures that users can only access data that they are already authorized to see, providing an extra layer of governance.

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

TDS vs. TWB vs. TWBX vs. TDSX: What's the Difference?

Tableau’s different file types can be confusing, but each serves a specific purpose. Here's a quick cheat sheet to tell them apart:

• .tds (Tableau Data Source): This is just the "recipe." It contains the connection information and metadata changes. No data and no visualizations (worksheets or dashboards).
• .twb (Tableau Workbook): This is the main file for your Tableau projects. It contains all your worksheets, dashboards, stories, and layout formatting. It knows how to connect to the data (like a TDS file), but it does not contain the data itself. If you send someone a TWB file, they also need access to the underlying data source to open it.
• .tdsx (Tableau Packaged Data Source): This is the "recipe plus the ingredients." It’s a TDS file bundled with an actual data extract (a .hyper file). This is useful for sharing a pre-configured data source that works offline, as the data is included in the file itself. It’s a single, portable data source file.
• .twbx (Tableau Packaged Workbook): This is the "all-in-one meal kit." It is a TWB file that includes everything needed to view the workbook: the worksheets and dashboards, the underlying data (as an extract or from a flat file), and any custom images or geocoding. This is the most common format for sharing complete, interactive dashboards with people who don't have direct access to the live database.

How to Create a TDS File in Tableau

Creating a TDS file is straightforward and only takes a minute. Follow these simple steps.

1. Connect to Your Data: Open Tableau Desktop and connect to your data as you normally would (e.g., connect to SQL Server, a Google Sheet, or Salesforce).
2. Prepare Your Data Source: On the Data Source page, set up all your tables, relationships, and joins.
3. Make Your Customizations: Go to a worksheet. In the Data pane on the left, make all your desired metadata changes.
4. Save the Data Source: Once your data source is perfectly configured, right-click its name at the top of the Data pane. From the context menu, select "Add to Saved Data Sources..."
5. Name and Save: A dialog box will appear. Give your file a descriptive name. Make sure the "File of type" dropdown is set to Tableau Data Source (*.tds). By default, Tableau saves it in the Datasource folder within your My Tableau Repository, but you can save it to a shared network location for your team to access.

That's it! You've now created a reusable, shareable data source that contains all your hard work.

Best Practices for Using TDS Files

To get the most out of TDS files, follow a few simple best practices:

• Use Descriptive Naming Conventions: Don't call your file data.tds. Be specific. A good name might be Salesforce_Opportunity_Pipeline_Q1.tds so everyone immediately knows what it contains.
• Establish a Centralized Location: A TDS file is only useful as a "single source of truth" if everyone knows where to find it. Store your TDS files on a shared network drive, a cloud folder like OneDrive or SharePoint, or — even better — publish them directly to Tableau Server or Tableau Cloud for centralized management.
• Document Your Work: If you've created a complex calculated field, add comments to the formula right inside Tableau's calculation editor. This helps future users understand the logic behind your work.

Final Thoughts

Tableau Data Source (.tds) files are a simple yet profoundly effective way to standardize data definitions, save massive amounts of time, and empower everyone in your organization to make data-driven decisions. By treating your data source setups like reusable assets, you can build a more consistent, efficient, and collaborative analytics culture.

We designed Graphed to take this principle of simplification even further. Instead of manually configuring connections and metadata for even the best-prepared TDS files, we allow you to speak directly to your data. Just connect sources like Google Analytics or Salesforce in a few clicks, then ask for what you need in plain English — like "create a report showing our sales pipeline from Salesforce by rep this quarter." We build the dashboards and reports for you in seconds, turning hours of tedious setup into a simple conversation and letting you get to insights faster than ever.