How to Create a Table in Tableau Worksheet
Tables might not feel as flashy as a scatter plot or a filled map, but they are the bedrock of data analysis and reporting. They offer precision and detail that other visualizations often summarize, making them an essential tool in your Tableau toolkit. This guide will walk you through exactly how to create, customize, and format different types of tables in a Tableau worksheet to clearly answer your business questions.
Why Start with a Table?
In a world full of complex charts, why is the humble table still so important? The answer comes down to clarity and granularity. While a bar chart quickly shows you which category is performing best, a table tells you the exact revenue down to the last penny. Building a table is often the first step in exploring a new dataset. It helps you:
- Verify Data: See the raw numbers to make sure everything has been imported correctly and is an accurate representation of the source.
- Provide Precision: When stakeholders need exact figures - like specific sales numbers, counts, or profit margins - a table delivers flawlessly.
- Build a Foundation: Many advanced charts in Tableau start life as a simple table. Understanding table structure gives you a solid foundation for building more complex visualizations later.
- Export Raw Data: Tables are the easiest format to export if a colleague needs a slice of your data to use in a spreadsheet or another application.
Think of it this way: charts are for understanding trends at a glance, while tables are for understanding the precise numbers driving those trends.
Prerequisite: Connecting Your Data
Before you can craft a single table, you need data. In Tableau, the first screen you see is the 'Connect' pane. Here, you'll connect to the file or server where your information is stored. This could be a simple Microsoft Excel file, a Google Sheet, a text/CSV file, or a more complex server connection like Microsoft SQL Server or Amazon Redshift. Once you’ve connected to your data source, you’ll see the available tables or sheets. After dragging your desired data into the canvas, click on the "Sheet 1" tab at the bottom of the window to navigate to the worksheet view. This is where you’ll do all of your building. Your screen will be split into a Data pane on the left (with your Dimensions and Measures) and the main canvas on the right.
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.
How to Create a Simple Text Table (Crosstab)
A text table, often called a crosstab or a pivot table, is the most common and fundamental table type. It organizes data in a grid of rows and columns, typically with Dimensions defining the grid and Measures populating the cells. Let’s build a table to see our total Sales for each Product Category. For this example, we’ll use Tableau's sample "Superstore" dataset.
Step 1: Drag a Dimension to the 'Rows' Shelf
In the Data pane on the left, you'll see your fields categorized as Dimensions (qualitative data, like names or dates) and Measures (quantitative, numeric data). Find the dimension you want to use for your rows. In our case, this is 'Category'. Click and drag 'Category' from the Data pane and drop it onto the 'Rows' Shelf at the top of the worksheet canvas. Instantly, you'll see a list of your product categories appear as row headers: a row for Furniture, one for Office Supplies, and one for Technology.
Step 2: Drag a Measure to the Marks Card
Now we need some numbers. Find the 'Sales' measure in the Data pane. Click and drag 'Sales' and drop it onto the Text box in the Marks card on the left side of the canvas. Tableau automatically aggregates the sales data, summing it up for each category. Your view will instantly update to show the total sales figures next to each corresponding product category. Just like that, you've created your first text table!
Step 3: Adding Another Dimension for Granularity
What if you want to break this down further? Easy. You can add another dimension to either the Rows or Columns shelf. Let's add the 'Order Date' dimension to the 'Columns' shelf. Drag 'Order Date' from the Data pane and drop it onto the Columns shelf. Tableau defaults to showing the Year of the order date. Now you have a crosstab showing sales for each category, broken down by year. This matrix view is perfect for comparing performance across both categories and time periods.
How to Create a Highlight Table
A highlight table takes a standard text table and adds a layer of color-coding to the cells. This brings a visual element to your data density, making it much easier to spot high and low values at a glance without losing the precision of the numbers. Let’s turn our sales-by-category-and-year table into a highlight table. Start with the crosstab we built in the previous section (Category on Rows, Year(Order Date) on Columns, and SUM(Sales) on Text).
Step 1: Drag a Measure to the 'Color' Mark
To add the color overlay, find the 'Sales' measure again in the Data pane. This time, click and drag it on top of the Color box in the Marks card. Tableau will automatically apply a color gradient to the background of each cell. By default, lower numbers receive a lighter shade and higher numbers a darker shade. Now your eyes are immediately drawn to an area with dark cells, instantly flagging it as a top performer.
Step 2: Customize the Colors (Optional)
Don't like the default blue? You can customize it. Click on the Color box in the Marks card, then select "Edit Colors." Here, you can choose from dozens of color palettes, including brand-friendly single-color gradients or divergent palettes (like Red-Green) that are great for showing positive and negative values.
Customizing and Formatting Your Tableau Table
A functional table is good, but a well-formatted table is better. Clean formatting makes your table easier to read and more professional for reports and presentations. Here are some of the most common ways to clean up your table.
Adjusting Column and Row Sizes
To resize a column or row, simply hover your mouse over the border line of the header until your cursor changes to a double-arrow icon. Then, click and drag to your desired size. To resize all rows and columns equally, drag the borders of the overall table.
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.
Adding Totals and Subtotals
Showing totals is crucial for many reports. Tableau makes this particularly easy using the Analytics pane.
- Navigate from the Data pane to the Analytics pane (the tab next to the Data pane).
- Under the "Summarize" section, you’ll see an item called Totals.
- Drag Totals from the Analytics pane and hover over the table. A small tooltip will appear, giving you options. You can drop it on Subtotals, Column Grand Totals, or Row Grand Totals.
- Let’s choose Column Grand Totals. A new column appears on the right, providing the total sales for each category across all years. Do the same for Row Grand Totals to get the total yearly sales across all categories.
Formatting Numbers and Headers
Raw numbers are often not as readable as formatted currencies or percentages. To format the numbers in your table:
- In the Data pane, right-click the measure you want to format (e.g., 'Sales').
- Select Default Properties > Number Format.
- A dialog box will appear. Here you can choose from standard formats like Number, Currency, or Percentage, and specify things like decimal places or currency symbols. Let's make this a currency.
To format the look of your headers or the text within the table, right-click anywhere on the table and choose "Format." This brings up the Format pane on the left, where you can control fonts, alignment, shading, and borders for every part of your visualization.
Sorting Data
Sorting helps you instantly bring the most important information to the top. The quickest way to sort in Tableau is by using the quick-sort buttons. Simply hover your cursor over a column header and a small icon will appear. Clicking it will sort the column in ascending or descending order. This makes it super easy to find your best-performing products, regions, or time periods without any complex configuration.
Final Thoughts
Building tables in Tableau is a fundamental skill that puts the power of detailed, granular data analysis at your fingertips. By mastering simple text tables, highlight tables, and formatting options, you can create clear, precise, and professional-grade reports that serve as the foundation for deeper business insights. While building tables in Tableau is a skill worth learning, sometimes you just need answers from your data without dealing with shelves, marks cards, and formatting panes. We built Graphed for exactly that situation. You can securely connect your data sources like Google Analytics, Shopify, and Salesforce, then simply ask for what you need in plain English. Instead of dragging and dropping, you can just type, "Show me a table of sales by product category for each month this year," and get an instant, real-time report that's ready to go.
Related Articles
AI Agents for SEO and Marketing: The Complete 2026 Guide
The complete 2026 guide to AI agents for SEO and marketing — what they are, top use cases, the best platforms, real-world examples, and how to get started.
AI Agents for Marketing Analytics: The Complete 2026 Guide
The complete 2026 guide to AI agents for marketing analytics — what they are, how they differ from automation, 10 use cases, pitfalls, and how to start.
How to Build AI Agents for Marketing: A Practitioner's Guide From Someone Who Actually Ships Them
How to build AI agents for marketing in 2026 — a practitioner guide from someone who has shipped a dozen, with the lessons that actually cost time.