Renaming Fields and Data Sources in Tableau

Renaming fields and data sources is an important data preparation task in Tableau. Clear and meaningful names make datasets easier to understand, help users identify the correct information, and improve the readability of worksheets, dashboards, and reports. Tableau allows users to rename individual fields as well as the data sources connected to a workbook.

Learn more: JustAcademy Tableau Training | Register for a Tableau Course Demo

1. What Is Renaming in Tableau?

Renaming in Tableau means changing the displayed name of a field or data source to make it more descriptive and easier to recognize. It helps users understand the purpose of the data without needing to remember technical column names or original file names.

For example, a database column named Cust_Nm can be renamed to Customer Name, and a data source named Book1 can be renamed to Sales Data.

Types of renaming in Tableau

• Renaming fields: Changing the displayed name of an individual column or field.
• Renaming data sources: Changing the name used to identify a connected data source within a workbook.
• Renaming table names: Changing the displayed name of a table in the data model where supported.
• Renaming aliases: Changing how individual member values appear in a visualization, without changing the underlying values.

2. What Are Fields in Tableau?

A field represents a column or attribute in a dataset. When Tableau connects to a data source, its columns generally become fields that can be used to create visualizations and calculations.

Examples of fields

Renaming these fields makes their meaning clearer to analysts and business users who work with the Tableau workbook.

3. Why Is Renaming Fields Important?

• Improves readability: Descriptive names are easier to understand than abbreviations.
• Reduces confusion: Users can distinguish similar fields more easily.
• Supports collaboration: Team members can understand the dataset without additional explanations.
• Improves dashboard usability: Clear names make field labels and analytical views more meaningful.
• Supports business terminology: Technical names can be replaced with familiar business terms.
• Makes maintenance easier: Consistent naming helps users manage large datasets.

4. Renaming Fields on the Data Source Page

The Data Source page allows you to review the fields in your connected dataset and rename them before or during analysis.

Method 1: Double-click the field name

1. Open Tableau Desktop.
2. Connect to an Excel file, CSV file, or supported database.
3. Open the Data Source page.
4. Locate the field you want to rename in the data grid or metadata grid.
5. Double-click the current field name.
6. Enter the new descriptive name.
7. Press Enter or click outside the field to apply the change.
8. Review the field to confirm that the new name appears correctly.

Method 2: Use the field menu

1. Open the Data Source page.
2. Locate the required field.
3. Open the field's drop-down or context menu.
4. Select the rename option if available.
5. Enter the new name.
6. Press Enter to save the change.

The exact controls may vary depending on the data source and Tableau version.

Example

Suppose your dataset contains a field named Sales_Amt. Rename it to Sales Amount. Tableau will display the more descriptive name when you work with that field in supported areas of the workbook.

5. Renaming Fields in the Data Pane

The Data pane appears on the left side of a worksheet and contains dimensions, measures, and other available fields. You can rename fields from this pane as well.

Steps

1. Open a worksheet in Tableau Desktop.
2. Locate the field in the Data pane.
3. Right-click the field or open its context menu.
4. Select Rename, or double-click the field name where supported.
5. Enter the new name.
6. Press Enter to apply the change.

Example: Rename Cust_ID to Customer ID. The field becomes easier to recognize when building filters, tables, and dashboards.

6. Understanding the Original Name and Display Name

Tableau can display a field name that differs from the original column name in the underlying data source. This allows users to improve field readability without necessarily changing the original database column or spreadsheet header.

Depending on the connection and editing method, Tableau may retain the original remote field name while displaying the renamed field within Tableau. Renaming a field in Tableau should not be assumed to change the column name in the source database or file.

7. Resetting a Renamed Field

If you rename a field and later want to restore its original name, Tableau provides a reset option for supported fields.

Steps to reset a field name

1. Locate the renamed field in the Data Source page or Data pane.
2. Open its context menu.
3. Select Reset Name if the option is available.
4. Check that the field returns to the original name supplied by the underlying data source.

Example: If Sales_Amt was renamed to Sales Amount, resetting the name can restore Sales_Amt.

Note: Reset options and naming behavior depend on the field and connection type. Some automatic naming changes may have a separate Revert option.

8. What Is a Data Source in Tableau?

A data source is the connection through which Tableau accesses information from a file, database, server, or other supported source. A Tableau workbook can contain multiple data sources.

Examples of data sources

• Excel workbook containing sales records.
• CSV file containing customer details.
• Microsoft SQL Server database.
• MySQL database.
• Cloud-based data source supported by Tableau.

Each data source appears in Tableau's interface with a name that helps users identify which data connection they are using.

9. Why Rename a Data Source?

• Easy identification: Quickly recognize the purpose of a connection.
• Better organization: Manage multiple data sources within one workbook.
• Improved collaboration: Help colleagues understand the origin or subject of the data.
• Reduced confusion: Avoid relying on generic names such as Sheet1 or Book1.
• Consistent naming: Apply a naming convention across related workbooks.

Example

10. How to Rename a Data Source in Tableau Desktop

Tableau Desktop provides a Rename command for changing the name used to identify a data source in a workbook.

Steps

1. Open your Tableau workbook.
2. Go to the Data menu at the top of Tableau Desktop.
3. Select the data source you want to rename, if required.
4. Choose Rename from the available menu options.
5. Enter a meaningful name for the data source.
6. Press Enter to confirm the change.
7. Check the Data pane to ensure the new name appears correctly.

You can also right-click a data source in the Data pane and use the Rename command where available.

Example

Suppose Tableau connects to an Excel workbook named Sales_Report_2026.xlsx. You can rename its Tableau data source to Annual Sales Data so the purpose of the connection is immediately clear.

Important: Renaming the data source inside Tableau does not necessarily rename the original Excel file, CSV file, database, or server.

11. Difference Between Renaming a Field and Renaming a Data Source

12. Renaming Table Names in Tableau

When a data source contains multiple tables, clear table names can help users understand the data model. For supported connections, you may rename a table's displayed name in the data model without changing the original table name in the database.

Steps

1. Open the Data Source page.
2. Locate the table on the canvas.
3. Open the table's context menu or edit its displayed name where supported.
4. Enter a meaningful name.
5. Review the data model to ensure the table is still easy to identify.

Example: A table called tbl_sales_2026 could be displayed as 2026 Sales in Tableau.

The available table-renaming options depend on the connector and data model. A displayed table name change should not be assumed to rename the actual database table.

13. Understanding Aliases and Renaming

An alias changes how a member value is displayed in a view. Unlike renaming a field, which changes the field's displayed name, an alias changes the label used for a particular value within that field.

Example

Suppose the Region field contains the values N, S, and W. You can use aliases to display them as North, South, and West in a visualization.

General steps to edit aliases

1. Locate the relevant dimension in the Data pane.
2. Open its context menu.
3. Select Aliases when the option is available.
4. Enter the desired display label for each applicable value.
5. Confirm the changes and review the visualization.

Aliases are useful for improving labels, but they do not necessarily correct inconsistent or incorrect values in the underlying data.

14. Naming Best Practices in Tableau

• Use clear, descriptive names that explain the purpose of a field or data source.
• Prefer consistent terminology across related datasets.
• Avoid unexplained abbreviations such as CustNm or SalesAmt.
• Use consistent capitalization and spacing.
• Include a subject or time period in a data source name when it improves identification.
• Keep names reasonably short so they remain readable in the Data pane.
• Avoid ambiguous names such as Value, Data, or Field1 when more meaningful names are possible.
• Use a consistent naming convention across workbooks.
• Document important naming changes when multiple team members maintain the workbook.
• Review dependent worksheets and calculations after making significant data-model changes.

15. Common Naming Problems and Solutions

16. Practical Exercise: Rename Fields and a Data Source

Objective: Practice renaming fields and a data source to make a Tableau workbook easier to understand.

Sample dataset

Tasks

1. Save the sample dataset in an Excel or CSV file.
2. Open Tableau Desktop and connect to the file.
3. Rename Ord_ID to Order ID.
4. Rename Cust_Nm to Customer Name.
5. Rename Ord_Dt to Order Date.
6. Rename Reg to Region.
7. Rename Sales_Amt to Sales Amount.
8. Rename Prof to Profit.
9. Rename the Tableau data source to Sales Analysis Data.
10. Optionally create aliases for N, S, and W if these values are intended to represent North, South, and West.
11. Open a worksheet and build a bar chart using Region and Sales Amount.
12. Confirm that the field names and labels are understandable.

Expected outcome

After completing the exercise, you should be able to rename fields, rename a Tableau data source, distinguish aliases from field names, and prepare a workbook with clearer labels.

17. Interview Questions and Answers

Q1. What does renaming mean in Tableau?

Renaming means changing the displayed name of a field, data source, or supported table so that users can identify it more easily.

Q2. Why should fields be renamed?

Renaming fields improves readability, reduces confusion, supports consistent terminology, and makes reports easier to maintain.

Q3. How can you rename a field?

Locate the field in the Data Source page or Data pane, open its name for editing or use the Rename command, enter the new name, and confirm the change.

Q4. How can you rename a data source?

In Tableau Desktop, select the data source from the Data menu or its context menu and choose Rename where available.

Q5. Does renaming a Tableau data source rename the original Excel file?

No. Renaming the data source in Tableau changes its displayed connection name, not the original file name.

Q6. What is the difference between a field name and an alias?

A field name identifies a column or attribute, while an alias changes how a particular member value is displayed in a view.

Q7. Can a renamed field be restored to its original name?

For supported fields, use the Reset Name option from the field's menu.

Q8. What happens if a field name differs in a replacement data source?

The field may become invalid in existing views. You may need to use Replace References to map it to the corresponding field in the new data source.

Q9. What are good naming conventions?

Use descriptive, consistent, readable names that reflect the meaning of the data and avoid unexplained abbreviations.

Q10. Why is naming important in shared workbooks?

Clear names help colleagues understand the data model, maintain worksheets, and interpret dashboards with less confusion.

18. Revision Checklist

• Understand the meaning of fields and data sources.
• Know why renaming is useful.
• Rename fields from the Data Source page.
• Rename fields from the Data pane.
• Understand original field names and displayed names.
• Know how to reset a renamed field.
• Rename a data source in Tableau Desktop.
• Understand table renaming and aliases.
• Distinguish Tableau connection names from original file names.
• Follow consistent naming conventions.
• Review worksheets and field references after significant changes.

19. Useful Learning Resources

• JustAcademy Tableau Training — Explore Tableau training topics and course details.
• Register for a Tableau Course Demo — Register for a course demonstration.
• Tableau Official Guide: Edit Data Sources — Learn about renaming fields, resetting names, and renaming data sources.
• Tableau Official Guide: Navigate Data Sources — Learn how to identify and manage multiple data sources in the Data pane.
• Tableau Official Guide: Replace Data Sources — Understand how field references behave when replacing a data source.

Conclusion

Renaming fields and data sources helps make Tableau workbooks clearer, more organized, and easier to maintain. By using descriptive field names, meaningful data source names, and appropriate aliases, you can improve the usability of your data model and make analysis easier for other users. Always distinguish between renaming an item inside Tableau and changing the original file or database, and check your worksheets after significant changes.

Continue learning with JustAcademy Tableau Training or Register for a Tableau Course Demo.