What is TDS in Tableau?

Ever opened your Tableau repository and stumbled upon a file ending in .tds? It might look unimportant, but this small file is one of Tableau's most powerful productivity tools. This guide will show you exactly what a Tableau Data Source (.tds) file is, how it’s different from other Tableau file types, and why using it can save you and your team a massive amount of repetitive work.

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

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

A .tds file stands for Tableau Data Source. The most important thing to know is that it does not contain any actual data. Think of it not as the library of books, but as the card catalog that tells you where every book is located and a little bit about it.

It's essentially a shortcut or a blueprint for your data connection. A .tds file stores all the configuration and preparation work you’ve done on your data, so you don't have to do it all over again every time you create a new workbook.

What information lives inside a .tds file?

• Connection Information: This is the address of your data. It knows whether the data is in an Excel file on your desktop, a specific SQL Server, a Google Sheet, or a cloud database. It includes details like server name, database name, and sign-in credentials (where applicable).
• Metadata Modifications: All the cleanup you do when you first connect to a dataset. Did you rename a messy field like cust_first_nm to something clean like Customer First Name? Did you change a field from a number to a string? That gets saved.
• Calculated Fields: Every custom calculation you've written, like a Profit Ratio calculation ([Profit] / [Sales]), is stored in the .tds file.
• Groups, Sets, and Hierarchies: If you've grouped various states into sales regions, created a hierarchy of category > subcategory > product, it’s all saved.
• Default Formatting: Ever tell Tableau to always show sales figures as currency or a percentage with two decimal places? The .tds file remembers these default properties for each field.

Essentially, it’s a file that captures all of your data knowledge - the fields you’ve cleaned, the logic you’ve built, and the organization you’ve applied - without having to contain the multi-gigabyte dataset itself.

The "Why": Key Benefits of Using .tds Files

Using .tds files might seem like an extra step, but it streamlines your workflow in an incredibly powerful way. It’s all about working smarter, not harder.

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

Save Time and Stop Repeating Yourself

This is the biggest benefit. Imagine you spend 30 minutes connecting to your company's sales data. You rename 20 cryptic database columns to be human-readable, create ten indispensable calculated fields for KPIs like Year over Year Growth, and group hundreds of products into their respective product lines.

The next day, a colleague asks for a completely different report using the same sales data. Without a .tds file, they would have to repeat that entire 30-minute setup process. If you saved it as a .tds, they could just connect to it, and all of that prep work would be done for them instantly. They can just start dragging and dropping fields and building their visualizations. This multiplies efficiency across an entire team.

Standardize Your Data for Rock-Solid Consistency

Have you ever been in a meeting where two different dashboards show conflicting numbers, and you discover it's because one report used the field revenue and another used sale_price? A lack of standardization creates mistrust in the data.

A TDS file solves this by creating a "single source of truth" for your metadata. When everyone on the team starts their analysis from the same certified .tds file, they are all speaking the same language.

• The field names are the same on every report.
• The logic for key calculations is identical.
• Everyone shares the same hierarchies and groups.

This consistency is fundamental to building a reliable reporting culture. Decisions can be made with confidence, knowing the underlying data definitions are standardized for everyone.

Empower Your Team (Even the Less Technical Ones)

Not everyone on your team is a data wizard. Some people are business experts who need answers, but they might be intimidated by connecting to a raw database with hundreds of unrefined fields. A well-organized .tds file acts as a curated, analysis-ready starting point. You can hide unnecessary fields, rename everything clearly, and pre-load all the essential calculations.

This lowers the barrier to entry significantly. A marketing manager can confidently connect to a Marketing_DataSource.tds file, knowing it's the right data and that complex calculations like Cost Per Acquisition are already built and verified. It promotes true self-service analytics by empowering domain experts to explore data without needing deep technical knowledge.

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

.tds vs. .tdsx: Spot the Difference

One of the most common sources of confusion for Tableau users is the different file types. Let's clear up the difference between .tds and its siblings, especially its close cousin, the .tdsx file.

• .tds (Tableau Data Source): As we've discussed, this is a map to the data. It contains connection information, metadata, calculations, and formatting. It's very small because it contains NO data. You need a live connection to the original data source for it to work.
• .tdsx (Tableau Packaged Data Source): The 'X' stands for "packaged." This is a .tds file plus the actual data, all bundled up into a single zip file. The data is included as a Tableau Data Extract (.hyper or legacy .tde file). This makes it self-contained and portable. You can email a .tdsx file to someone, and they can open it and see the data without needing access to your "live" database.

Here’s a simple cheat sheet:

Use a .tds when:

• Sharing a standardized connection to a live, shared database (like a company SQL server).
• You want to maintain a single source of truth for metadata that everyone can connect to.
• The underlying data updates frequently and users need to see the latest version.

Use a .tdsx when:

• Sharing data with someone who doesn't have access to the original source.
• You need an offline, self-contained data file for analysis (e.g., on a flight with no Wi-Fi).
• You want to send a static snapshot of data along with its metadata.

And for completeness, here’s how they relate to Tableau workbooks:

• .twb (Tableau Workbook): This holds all your worksheets, dashboards, and stories. Critically, it also contains the information from a .tds file (the connection info and metadata setup). Like a .tds, it has no data.
• .twbx (Tableau Packaged Workbook): This is the whole package. It's a .twb (your dashboards) plus a .tdsx (your data and its metadata). It’s a self-contained workbook that anyone with Tableau can open.

How to Create and Use a .tds File: A Quick Walkthrough

Creating and using a .tds file is incredibly straightforward. Here’s a step-by-step guide.

Step 1: Connect to Your Data

Start a new workbook in Tableau Desktop. On the "Connect" screen, choose your data source, whether it's an Excel file, a text file, or a server like Microsoft SQL Server or Amazon Redshift. Connect to it as you normally would.

Step 2: Prepare Your Data Source

This is where you front-load all the valuable work. On either the Data Source tab at the bottom of the screen or in the Data pane on the left side of a worksheet, perform any of the following clean-up and preparation tasks:

• Rename fields from something like SALES_AMT to Sales Amount.
• Change data types (e.g., from Number to Geographic Role → State).
• Hide unused or duplicate fields to reduce clutter.
• Right-click > Create Calculated Field... to build your KPIs.
• Right-click > Create > Hierarchy... to group related fields like Country > State > City.
• Right-click a field > Default Properties to set the default number format, color, or aggregation.

Take the time to make the data source clean, intuitive, and analysis-ready.

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

Step 3: Save the Data Source

Once you are happy with your configuration, saving it is just a right-click away.

1. In the Data pane (top-left of the worksheet view), right-click the name of your data source.
2. From the context menu, select "Add to Saved Data Sources...".

A ‘Save As’ dialog box will open. By default, it will be set to the "Tableau Data Source (.tds)" file type. Name your file something descriptive (e.g., Corporate Sales - Standard.tds) and save it. It's often best to save it in the default "Datasources" folder within your "My Tableau Repository" so it’s easy for Tableau to find.

Step 4: Connect to Your Saved .tds File

The next time you or a teammate want to build a report with this data, the process is simple.

1. Open a new instance of Tableau Desktop.
2. On the connect screen, under "Search for Data," select "Tableau Server".
3. A pane will appear listing your saved data sources. Simply click on the .tds file you just saved.

And just like that, you are connected. You’ll see that the Data pane is already populated with your beautifully renamed fields, custom hierarchies, and pre-built calculations, all ready for analysis.

Final Thoughts

A Tableau Data Source (.tds) file is far more than just another file extension, it’s a discipline that drives efficiency and consistency. By treating your data source setup as a reusable asset, you can save countless hours of rework, ensure everyone on your team is building from a single source of truth, and make data more accessible to everyone.

While data assets like TDS files are a great way to streamline work inside tools like Tableau, we believe getting insights shouldn't require so much manual configuration. At Graphed, our approach is to automate the difficult parts of data connections and preparation for all your marketing and sales sources. We let you securely connect platforms like Shopify, Google Analytics, Salesforce, or Facebook Ads just once. After that, you never have to think about data configuration again. You can simply ask questions in plain English - like "Compare Facebook Ads spend vs. Shopify revenue by campaign for last month" - and instantly get live dashboards and charts, bypassing the manual setup entirely.