How to Rename a Field in Tableau
Renaming fields in Tableau is one of those simple tasks that has a huge impact on the clarity and usability of your dashboards. Confusing or technical field names like "sls_amt_usd" can instantly make a report feel inaccessible to your audience. This article walks you through the various ways to rename fields in Tableau, from global changes to worksheet-specific labels, helping you turn cryptic data into clear stories.
Why is Renaming Fields So Important in Tableau?
Before diving into the "how," let's quickly touch on the "why." Taking a moment to clean up your field names isn't just about aesthetics, it’s a foundational step in effective data visualization. Thoughtful naming practices deliver several key benefits:
- Improves Readability: The most obvious benefit is clarity. Changing a field name from
rev_Q4toQuarter 4 Revenuemakes the visualization instantly legible for anyone, regardless of their familiarity with the original data source. No one should have to guess what a metric or dimension represents. - Creates Consistency: Data often comes from different systems with varying naming conventions. You might see
CustomerIDin one table andCUST_IDin another. Renaming them both to "Customer ID" creates a single, consistent source of truth within your Tableau workbook, which prevents confusion and builds trust in your data. - Eases Dashboard Maintenance: Six months from now, when you revisit a dashboard, you'll be thankful you renamed
geo_latto "Latitude" andpage_urlto "Page URL." Clear names make it easier for you and your teammates to understand, debug, and update workbooks. - Enhances the User Experience: Ultimately, dashboards are built for others to use. Sales managers, marketing leads, or company executives need to access and understand information quickly. When field names and axis labels are clear and intuitive, stakeholders can self-serve and find the answers they need without having to ask the analyst for a translation.
In short, renaming fields transforms your data pane from a technical reference into a user-friendly menu for building visualizations.
Method 1: Rename Fields Directly on the Data Source Page
The Data Source page is the best place to start your renaming process. Any changes made here are applied across the entire Tableau workbook, ensuring consistency from the very beginning. This method is ideal for the initial cleanup phase right after you connect to your data.
Follow these steps:
Step 1: Navigate to the Data Source Tab
After connecting to your data, you'll land on a worksheet by default. Look at the bottom-left corner of the Tableau window. You'll see two tabs: a 'Data Source' tab and the sheet tab (e.g., 'Sheet 1'). Click on the 'Data Source' tab.
Step 2: Locate the Field to Rename
On this page, you’ll see a preview of your data in a grid format, with columns representing your fields. Scroll horizontally to find the column (field) you want to rename. For example, you might see a column named order_date_utc that you’d rather call "Order Date."
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.
Step 3: Access the Rename Option
You have two simple ways to initiate the renaming process here:
- Right-Click: Right-click on the column header of the field you want to change. A dropdown menu will appear. Select "Rename."
- Dropdown Arrow: Alternatively, hover your mouse over the column header. A small grey dropdown arrow will appear to the right of the field name. Click this arrow to open the same menu, and then select "Rename."
Step 4: Type the New Name and Press Enter
The field name will become an editable text box. Type in your new, more descriptive name (e.g., "Order Date") and press the Enter key on your keyboard. The change is immediate and will be reflected anywhere this field is used in your workbook.
When to use this method: Use the Data Source page method for fundamental, workbook-wide changes right when you connect your data. It's the cleanest way to standardize your fields before you even start building views.
Method 2: Rename Fields in the Data Pane
Sometimes you’re already deep into building a worksheet and realize a field name needs to be changed. Instead of navigating back to the Data Source page, you can perform the same global rename directly from the Data Pane on the left side of your worksheet view.
This is arguably the most common and convenient way to rename fields on the fly.
Step 1: Find the Field in the Data Pane
Look at the Data Pane on the left side of your screen. Your fields are organized into Dimensions and Measures. Scroll through the list to find the field you need to adjust. Let’s say you have a measure called Profit_Ratio.
Step 2: Right-Click and Select "Rename"
Right-click directly on the field name (Profit_Ratio) in the Data Pane. As with the previous method, a context menu will appear. Click on "Rename" from this list.
Step 3: Enter the New Name
The field name will become editable. Enter your preferred name, such as "Profit Margin," and press Enter. Just like the Data Source method, this change is global and will update the field's name throughout your entire workbook, including on any worksheets where it’s already in use.
When to use this method: This is the go-to method for renaming fields while you are actively building visualizations. It achieves the same outcome as Method 1 but saves you a few clicks.
Method 3: Creating Aliases for Field Values
It's crucial to distinguish between renaming a field (the column header) and renaming the values inside that field. If you need to change the values themselves - for example, mapping numerical codes to text descriptions - you should use aliases.
Imagine you have a 'Delivery Status' field containing values like 1, 2, and 3. For your audience, this is meaningless. An alias lets you map these values so that 1 appears as "Processing," 2 as "Shipped," and 3 as "Delivered" in your charts.
Step 1: Find the Dimension in the Data Pane
Locate the dimension whose values you want to alias. This technique only works for discrete dimensions (typically the blue pills), not continuous measures.
Step 2: Right-Click and Select "Aliases"
Right-click the dimension field in the Data Pane and choose "Aliases..." from the menu. This will open the 'Edit Aliases' dialog box.
Step 3: Map Values to New Aliases
In the dialog box, you'll see a list with two columns: 'Value (Member)' and 'Value (Alias)'. The first column shows the original values from your data source. The second column is where you type the new text you want to display.
Click on each cell in the 'Value (Alias)' column and type in your desired alias. For our example, you would replace 1 with "Processing", 2 with "Shipped", and 3 with "Delivered".
Step 4: Click 'OK' to Apply
After you’ve defined all your aliases, click 'OK.' Now, whenever you use this field in a visualization, Tableau will display the friendly alias names instead of the original raw data.
When to use this method: Use aliases when you need to replace codes, abbreviations, or cryptic data entries with human-readable text without altering the source data.
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.
Method 4: Renaming a Field Label Directly in a View
What if you only want to change a field's label on a single chart without affecting its name anywhere else? For instance, your global field is named "Sales," but for one specific worksheet, you want the axis title to read "Total Sales for Q4 2024." This is a local change that only affects the current view.
Step 1: Add the Field to your View
Drag the desired field onto the Columns, Rows, or Marks shelf to create your visualization.
Step 2: Change the Local Title (Label)
You have a couple of options for this:
- Right-Click the Pill: Right-click the field's "pill" on the shelf where you dropped it (e.g., on the Rows shelf). Select "Edit Title…" or "Edit Alias...". Type your desired label for that specific instance. This will change the displayed text on that chart axis or header only.
- Double-Click the Axis: A simpler way for axes is to double-click directly on the axis title within the chart itself. This will open an editor where you can type in a custom name.
The important thing to remember is that this does not change the field’s name in the Data Pane. It's a purely cosmetic change for one specific worksheet.
When to use this method: Use this for one-off situations where you need a more descriptive or context-specific title for a field on a single chart without altering its name globally.
Best Practices for Naming Fields
Creating a consistent and intuitive naming system will make your dashboards far more effective. Here are a few simple rules of thumb:
- Be Human-Readable: Always convert technical jargon or database conventions (e.g., using underscores) to plain language.
cust_first_nshould becomeCustomer First Name. - Stay Consistent: Decide on a naming convention early and stick with it. If you use "Sales Rep," don't also use "Salesperson" or "Account Owner" elsewhere for the same concept.
- Include Units When Helpful: For measures, clarity can be boosted by including units. For example,
Price (USD),Duration (Minutes), orWeight (kg). This removes ambiguity. - Keep it Concise but Clear: Don’t be afraid to be descriptive, but aim for brevity. "Q1 2024 Customer Lifetime Value" is long but much clearer than a vague or coded alternative.
- Document Your Changes: In complex projects that involve many data sources, it can be extremely helpful to maintain a simple data dictionary. This can be a text file or spreadsheet that maps original field names to their new, standardized names in Tableau.
Final Thoughts
Mastering how to rename fields is a fundamental Tableau skill that elevates your work from a technical data exercise to a clear, professional report. By using the right method - global renames for consistency, aliases for clarity, and local titles for context - you make your data accessible and your dashboards significantly more impactful for your audience.
A big part of data analytics is wrestling with messy source data - cleaning it, standardizing it, and getting it ready for reporting. We created Graphed because we believe getting insights shouldn't require so much manual prep work. Instead of spending hours connecting data from Salesforce, Google Ads, or Shopify and manually renaming dozens of cryptic fields, you can just connect your sources and describe the dashboard you need in plain English. Graphed automates the tedious data wrangling behind the scenes, so you can get straight to the answers you need without getting bogged down in the setup.
Related Articles
How to Create Facebook Ads API for Claude Code
Create a Meta Marketing API access token that never expires, using a system user, so Claude Code can pull Facebook ad reports and manage campaigns.
ClickHouse vs Postgres: When to Switch to Columnar
Comparing ClickHouse vs PostgreSQL means matching storage architecture to workload. Row storage wins for transactions. Columnar wins for scan-heavy analytics.
Google Ads for Orthodontists: Get More Booked Consults
Most orthodontic Google Ads campaigns waste money on low-intent searches. The problem is structure, not the platform.